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.CST_UPD_GIR_MTA_WTA dependencies on DBMS_SQL

Line 33: ccid_tab DBMS_SQL.NUMBER_TABLE;

29: AND gir.je_line_num = jle.je_line_num
30: AND gir.gl_sl_link_table = 'MTA'
31: AND gir.gl_sl_link_id IS NULL;
32:
33: ccid_tab DBMS_SQL.NUMBER_TABLE;
34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;

Line 34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

30: AND gir.gl_sl_link_table = 'MTA'
31: AND gir.gl_sl_link_id IS NULL;
32:
33: ccid_tab DBMS_SQL.NUMBER_TABLE;
34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
38:

Line 35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;

31: AND gir.gl_sl_link_id IS NULL;
32:
33: ccid_tab DBMS_SQL.NUMBER_TABLE;
34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
38:
39:

Line 36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;

32:
33: ccid_tab DBMS_SQL.NUMBER_TABLE;
34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
38:
39:
40: CURSOR cu_xla_line IS

Line 37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;

33: ccid_tab DBMS_SQL.NUMBER_TABLE;
34: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
35: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
36: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
37: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
38:
39:
40: CURSOR cu_xla_line IS
41: SELECT l.rowid,

Line 58: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

54: AND m.transaction_id = c.number_2
55: AND m.inv_sub_ledger_id = c.number_1
56: AND m.reference_account = c.number_3;
57:
58: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
59: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
60:
61: l_last_fetch BOOLEAN := FALSE;
62: bulk_size NUMBER := 10000;

Line 59: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;

55: AND m.inv_sub_ledger_id = c.number_1
56: AND m.reference_account = c.number_3;
57:
58: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
59: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
60:
61: l_last_fetch BOOLEAN := FALSE;
62: bulk_size NUMBER := 10000;
63: l_sql NUMBER := 0;

Line 211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

207: FROM cst_lists_temp
208: WHERE number_1 IS NULL
209: AND list_id = 999;
210:
211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;

Line 212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;

208: WHERE number_1 IS NULL
209: AND list_id = 999;
210:
211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;

Line 213: ccid_tab DBMS_SQL.NUMBER_TABLE;

209: AND list_id = 999;
210:
211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;

Line 214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

210:
211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
218: l_last_fetch BOOLEAN := FALSE;

Line 215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;

211: xline_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
218: l_last_fetch BOOLEAN := FALSE;
219: bulk_size NUMBER := 10000;

Line 216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;

212: xl_link_id_tab DBMS_SQL.NUMBER_TABLE;
213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
218: l_last_fetch BOOLEAN := FALSE;
219: bulk_size NUMBER := 10000;
220: l_sql NUMBER := 0;

Line 217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;

213: ccid_tab DBMS_SQL.NUMBER_TABLE;
214: gir_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
215: gl_batch_id_tab DBMS_SQL.NUMBER_TABLE;
216: gl_sl_link_id_tab DBMS_SQL.NUMBER_TABLE;
217: l_inv_sl_id_tab DBMS_SQL.NUMBER_TABLE;
218: l_last_fetch BOOLEAN := FALSE;
219: bulk_size NUMBER := 10000;
220: l_sql NUMBER := 0;
221: l_check VARCHAR2(1);