APPS.CST_UPD_GIR_MTA_WTA dependencies on CST_LISTS_TEMP

Line 44: cst_lists_temp c,

40: CURSOR cu_xla_line IS
41: SELECT l.rowid,
42: m.gl_sl_link_id
43: FROM mtl_transaction_accounts m,
44: cst_lists_temp c,
45: xla_distribution_links lk,
46: xla_ae_lines l
47: WHERE lk.application_id = 707
48: AND lk.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

Line 67: FROM cst_lists_temp

63: l_sql NUMBER := 0;
64:
65: CURSOR cv IS
66: SELECT NULL
67: FROM cst_lists_temp
68: WHERE number_1 IS NULL
69: AND list_id = 999;
70:
71: l_check VARCHAR2(1);

Line 113: debug(' Insert Cst_Lists_Temp for MTA');

109: SET gl_sl_link_id = gl_sl_link_id_tab(i)
110: WHERE gl_batch_id = gl_batch_id_tab(i)
111: AND reference_account = ccid_tab(i);
112:
113: debug(' Insert Cst_Lists_Temp for MTA');
114:
115: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
116: INSERT INTO cst_lists_temp
117: (list_id ,

Line 116: INSERT INTO cst_lists_temp

112:
113: debug(' Insert Cst_Lists_Temp for MTA');
114:
115: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
116: INSERT INTO cst_lists_temp
117: (list_id ,
118: number_1,
119: number_2,
120: number_3,

Line 149: DELETE FROM cst_lists_temp;

145: WHERE rowid = xline_rowid_tab(i);
146: CLOSE cu_xla_line;
147: END IF;
148: CLOSE cv;
149: DELETE FROM cst_lists_temp;
150:
151:
152: END LOOP;
153: CLOSE cu_gir;

Line 191: cst_lists_temp c,

187: CURSOR cu_xla_line IS
188: SELECT l.rowid,
189: m.gl_sl_link_id
190: FROM wip_transaction_accounts m,
191: cst_lists_temp c,
192: xla_distribution_links lk,
193: xla_ae_lines l
194: WHERE lk.application_id = 707
195: AND lk.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'

Line 207: FROM cst_lists_temp

203: AND m.reference_account = c.number_3;
204:
205: CURSOR cv IS
206: SELECT NULL
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;

Line 263: debug(' Insert Cst_Lists_Temp for WTA');

259: SET gl_sl_link_id = gl_sl_link_id_tab(i)
260: WHERE gl_batch_id = gl_batch_id_tab(i)
261: AND reference_account = ccid_tab(i);
262:
263: debug(' Insert Cst_Lists_Temp for WTA');
264:
265: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
266: INSERT INTO cst_lists_temp
267: (list_id ,

Line 266: INSERT INTO cst_lists_temp

262:
263: debug(' Insert Cst_Lists_Temp for WTA');
264:
265: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
266: INSERT INTO cst_lists_temp
267: (list_id ,
268: number_1,
269: number_2,
270: number_3,

Line 299: DELETE FROM cst_lists_temp;

295: WHERE rowid = xline_rowid_tab(i);
296: CLOSE cu_xla_line;
297: END IF;
298: CLOSE cv;
299: DELETE FROM cst_lists_temp;
300:
301:
302: END LOOP;
303: CLOSE cu_gir;