72 lines
7.7 KiB
SQL
72 lines
7.7 KiB
SQL
prompt PL/SQL Developer import file
|
|
prompt Created on Wednesday, 29.September.2010 by Eric
|
|
set feedback off
|
|
set define off
|
|
prompt Loading PRM_APPS
|
|
insert into PRM_APPS (KD_APPS, NAMA_APPS, HOST_NAME, CONNECT_STR, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('DWH', 'Data Warehouse', '10.0.10.68:90', '', 'SYSTEM', SYSDATE, 'O', 'SYSTEM', SYSDATE);
|
|
commit;
|
|
prompt 1 record loaded
|
|
prompt Loading PRM_MENU...
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01014', '01010', 'Kredit', '01', 5, 'posting_kredit.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01023', '01020', 'Kredit', '01', 4, 'ods_kredit.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01052', '01050', 'Synchronize Staging GL', '01', 2, 'post_staging_lbu_gl.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01000', '00000', 'Proses', '01', 1, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01010', '01000', 'External to Staging', '01', 1, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01020', '01000', 'ODS MIS', '01', 2, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01030', '01000', 'Statement Rekening', '01', 3, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01011', '01010', 'AB2', '01', 2, 'posting_ab2.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01013', '01010', 'Treasury', '01', 4, 'posting_treasury.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01021', '01020', 'CIF Retail Deposito', '01', 2, 'ods_retail.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01022', '01020', 'GL', '01', 3, 'ods_gl.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('07000', '00000', 'Parameter', '07', 1, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('07010', '07000', 'Parameter Aplikasi', '07', 2, 'prm_system.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('09000', '00000', 'Change Password', '09', 1, 'change_password.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('02000', '00000', 'Log', '02', 1, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('02010', '02000', 'Log Proses', '02', 2, 'log_proses.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('02020', '02000', 'Audit Trail', '02', 3, 'audit_trail.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01031', '01030', 'Create Periode', '01', 2, 'periode_statement.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01032', '01030', 'Create Statement', '01', 3, 'post_statement.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01040', '01000', 'Purging', '01', 5, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('06000', '00000', 'Upload Data', '06', 1, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('06010', '06000', 'Data Treasury', '06', 1, 'upload_treasury.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('06020', '06000', 'Laporan Posisi Harian', '06', 2, 'upload_lph.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01041', '01040', 'Purging Data Warehouse', '04', 1, 'purging_dwh.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01042', '01040', 'Purging Statement Rekening', '04', 2, 'purging_statement.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01012', '01010', 'GL AB2', '01', 3, 'posting_gl.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01050', '01000', 'LBU Sigma', '01', 4, '#', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
insert into PRM_MENU (KD_MENU, PARENT_KD_MENU, KET_MENU, KEL_MENU, NO_URUT, LINK, USER_UPDATE, TGL_UPDATE, KD_APPS, FLAG_OTO, USER_OTO, TGL_OTO)
|
|
values ('01051', '01050', 'Synchronize Staging DPK', '01', 1, 'post_staging_lbu.php', 'SYSTEM', SYSDATE, 'DWH', 'O', 'SYSTEM', SYSDATE);
|
|
commit;
|
|
prompt 28 records loaded
|
|
set feedback on
|
|
set define on
|
|
prompt Done.
|