eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_DATA_PREP_PKG dependencies on AD_DDL

Line 1201: -- Create PROCESS_DATA procedure using ad_ddl. Returns

1197: END gcs_main_data_prep;
1198: -- create_process
1199: -- CREATE_PROCESS
1200: -- Purpose
1201: -- Create PROCESS_DATA procedure using ad_ddl. Returns
1202: -- Arguments
1203: -- x_retcode
1204: -- x_errbuf
1205: --

Line 1503: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

1499: body_len := LENGTH(l_proc_body);
1500: curr_index := 1;
1501: WHILE curr_index <= body_len LOOP
1502: lines := lines + 1;
1503: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1504: curr_index := curr_index + 200;
1505: END LOOP;
1506: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 1');
1507: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 1506: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 1');

1502: lines := lines + 1;
1503: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1504: curr_index := curr_index + 200;
1505: END LOOP;
1506: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 1');
1507: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
1508: --
1509: -- create procedure init_local_to_master_maps
1510: --

Line 1758: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

1754: curr_index := 1;
1755: body_len := LENGTH(l_proc_body);
1756: WHILE curr_index <= body_len LOOP
1757: lines := lines + 1;
1758: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1759: curr_index := curr_index + 200;
1760: END LOOP;
1761: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 2');
1762: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 1761: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 2');

1757: lines := lines + 1;
1758: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1759: curr_index := curr_index + 200;
1760: END LOOP;
1761: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 2');
1762: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
1763: --
1764: -- create procedure init_local_to_master_maps
1765: --

Line 1895: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

1891: body_len := LENGTH(l_proc_body);
1892: curr_index := 1;
1893: WHILE curr_index <= body_len LOOP
1894: lines := lines + 1;
1895: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1896: curr_index := curr_index + 200;
1897: END LOOP;
1898: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 3');
1899: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 1898: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 3');

1894: lines := lines + 1;
1895: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
1896: curr_index := curr_index + 200;
1897: END LOOP;
1898: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 3');
1899: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
1900: l_insert_statement := l_insert_gt_clause ||
1901: ' SELECT decode(fb.currency_code, ''STAT'', l_stat_entry_id, l_entry_id), ' ||
1902: ' fb.cal_period_id, ' || l_fb_dims ||

Line 2136: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

2132: body_len := LENGTH(l_proc_body);
2133: curr_index := 1;
2134: WHILE curr_index <= body_len LOOP
2135: lines := lines + 1;
2136: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2137: curr_index := curr_index + 200;
2138: END LOOP;
2139: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 4');
2140: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 2139: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 4');

2135: lines := lines + 1;
2136: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2137: curr_index := curr_index + 200;
2138: END LOOP;
2139: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 4');
2140: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
2141:
2142: l_proc_body := '---------------------------------------
2143: -- this is the mapping required case --

Line 2339: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

2335: body_len := LENGTH(l_proc_body);
2336: curr_index := 1;
2337: WHILE curr_index <= body_len LOOP
2338: lines := lines + 1;
2339: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2340: curr_index := curr_index + 200;
2341: END LOOP;
2342: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 5');
2343: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 2342: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 5');

2338: lines := lines + 1;
2339: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2340: curr_index := curr_index + 200;
2341: END LOOP;
2342: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 5');
2343: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
2344: l_proc_body := '
2345:
2346: COMMIT;

Line 2524: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

2520: curr_index := 1;
2521: body_len := LENGTH(l_proc_body);
2522: WHILE curr_index <= body_len LOOP
2523: lines := lines + 1;
2524: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2525: curr_index := curr_index + 200;
2526: END LOOP;
2527: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 6');
2528: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 2527: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 6');

2523: lines := lines + 1;
2524: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2525: curr_index := curr_index + 200;
2526: END LOOP;
2527: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 6');
2528: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
2529: --
2530: -- create procedure init_local_to_master_maps
2531: --

Line 2769: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

2765: curr_index := 1;
2766: body_len := LENGTH(l_proc_body);
2767: WHILE curr_index <= body_len LOOP
2768: lines := lines + 1;
2769: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2770: curr_index := curr_index + 200;
2771: END LOOP;
2772: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 7');
2773: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 2772: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 7');

2768: lines := lines + 1;
2769: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2770: curr_index := curr_index + 200;
2771: END LOOP;
2772: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 7');
2773: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
2774: l_proc_body := '
2775: PROCEDURE process_inc_data (
2776: p_source_currency_code IN VARCHAR2,

Line 2973: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

2969: curr_index := 1;
2970: body_len := LENGTH(l_proc_body);
2971: WHILE curr_index <= body_len LOOP
2972: lines := lines + 1;
2973: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2974: curr_index := curr_index + 200;
2975: END LOOP;
2976: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 8');
2977: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 2976: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 8');

2972: lines := lines + 1;
2973: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
2974: curr_index := curr_index + 200;
2975: END LOOP;
2976: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 8');
2977: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
2978: --
2979: -- create procedure init_local_to_master_maps
2980: --

Line 3151: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

3147: curr_index := 1;
3148: body_len := LENGTH(l_proc_body);
3149: WHILE curr_index <= body_len LOOP
3150: lines := lines + 1;
3151: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
3152: curr_index := curr_index + 200;
3153: END LOOP;
3154: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 9');
3155: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 3154: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 9');

3150: lines := lines + 1;
3151: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
3152: curr_index := curr_index + 200;
3153: END LOOP;
3154: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 9');
3155: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
3156: ---------------------------------------------------------------------------------------------
3157: -- Code inserted by Santosh Matam
3158: --Imapct of Intercompany Mappings

Line 3264: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);

3260: curr_index := 1;
3261: body_len := LENGTH(l_proc_body);
3262: WHILE curr_index <= body_len LOOP
3263: lines := lines + 1;
3264: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
3265: curr_index := curr_index + 200;
3266: END LOOP;
3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');
3268: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);

Line 3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');

3263: lines := lines + 1;
3264: ad_ddl.build_statement(SUBSTR(l_proc_body, curr_index, 200), lines);
3265: curr_index := curr_index + 200;
3266: END LOOP;
3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');
3268: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
3269: fnd_file.put_line(fnd_file.log,
3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');
3271: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

Line 3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');

3266: END LOOP;
3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');
3268: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
3269: fnd_file.put_line(fnd_file.log,
3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');
3271: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
3272: 'GCS',
3273: 'GCS_DP_DYNAMIC_PKG',
3274: 1,

Line 3271: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');
3268: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
3269: fnd_file.put_line(fnd_file.log,
3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');
3271: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
3272: 'GCS',
3273: 'GCS_DP_DYNAMIC_PKG',
3274: 1,
3275: lines,

Line 3279: 'GCS_DATA_PREP_PKG::create_process -- After ad_ddl.create_plsql_object API Call');

3275: lines,
3276: 'FALSE',
3277: err);
3278: fnd_file.put_line(fnd_file.log,
3279: 'GCS_DATA_PREP_PKG::create_process -- After ad_ddl.create_plsql_object API Call');
3280: fnd_file.put_line(fnd_file.log,
3281: 'GCS_DATA_PREP_PKG::create_process -- End');
3282: fnd_file.put_line(fnd_file.log,
3283: '=========================================');