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

Line 16: bld_dml_flag DBMS_SQL.VARCHAR2_TABLE,--insert,update,delete

12: /*-----------------------------------------------------------------------+
13: | Built Event structure |
14: +-----------------------------------------------------------------------*/
15: TYPE bld_ev_type IS RECORD (
16: bld_dml_flag DBMS_SQL.VARCHAR2_TABLE,--insert,update,delete
17: bld_temp_event_id DBMS_SQL.VARCHAR2_TABLE
18: );
19:
20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE

Line 17: bld_temp_event_id DBMS_SQL.VARCHAR2_TABLE

13: | Built Event structure |
14: +-----------------------------------------------------------------------*/
15: TYPE bld_ev_type IS RECORD (
16: bld_dml_flag DBMS_SQL.VARCHAR2_TABLE,--insert,update,delete
17: bld_temp_event_id DBMS_SQL.VARCHAR2_TABLE
18: );
19:
20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE
21: INDEX BY BINARY_INTEGER;

Line 160: l_c := DBMS_SQL.OPEN_CURSOR;

156: AND ae.application_id = 222';
157:
158: log(' l_stmt :'||l_stmt);
159:
160: l_c := DBMS_SQL.OPEN_CURSOR;
161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);

Line 161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);

157:
158: log(' l_stmt :'||l_stmt);
159:
160: l_c := DBMS_SQL.OPEN_CURSOR;
161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);

Line 162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);

158: log(' l_stmt :'||l_stmt);
159:
160: l_c := DBMS_SQL.OPEN_CURSOR;
161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);

Line 163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);

159:
160: l_c := DBMS_SQL.OPEN_CURSOR;
161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);

Line 164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);

160: l_c := DBMS_SQL.OPEN_CURSOR;
161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

Line 165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);

161: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);

Line 166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);

162: DBMS_SQL.BIND_VARIABLE(l_c,':dist_event_id',p_event_id);
163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);

Line 167: l_exec := DBMS_SQL.EXECUTE(l_c);

163: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_event_id);
164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);

Line 168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

164: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_event_date);
165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);

Line 169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);

165: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_event_status_code,30);
166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);
173: DBMS_SQL.CLOSE_CURSOR(l_c);

Line 170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);

166: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_event_type_code,30);
167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);
173: DBMS_SQL.CLOSE_CURSOR(l_c);
174:

Line 171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);

167: l_exec := DBMS_SQL.EXECUTE(l_c);
168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);
173: DBMS_SQL.CLOSE_CURSOR(l_c);
174:
175:

Line 172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);

168: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);
173: DBMS_SQL.CLOSE_CURSOR(l_c);
174:
175:
176: log('x_event_id:'||x_event_id);

Line 173: DBMS_SQL.CLOSE_CURSOR(l_c);

169: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_event_id);
170: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_event_date);
171: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_event_status_code);
172: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_event_type_code);
173: DBMS_SQL.CLOSE_CURSOR(l_c);
174:
175:
176: log('x_event_id:'||x_event_id);
177: log('x_event_date:'||x_event_date);

Line 220: l_c := DBMS_SQL.OPEN_CURSOR;

216: and xt.application_id = 222';
217:
218: log('l_stmt :'||l_stmt);
219:
220: l_c := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);

Line 221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);

217:
218: log('l_stmt :'||l_stmt);
219:
220: l_c := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:

Line 222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);

218: log('l_stmt :'||l_stmt);
219:
220: l_c := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);

Line 223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);

219:
220: l_c := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);

Line 224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);

220: l_c := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);

Line 226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);

222: DBMS_SQL.BIND_VARIABLE(l_c,':trx_id',p_trx_id);
223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);

Line 227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);

223: DBMS_SQL.BIND_VARIABLE(l_c,':dist_gl_date',p_gl_date);
224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

Line 228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);

224: DBMS_SQL.BIND_VARIABLE(l_c,':override_event',p_override_event);
225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);

Line 229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);

225:
226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);

Line 230: l_exec := DBMS_SQL.EXECUTE(l_c);

226: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_match_event_id);
227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);

Line 231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

227: DBMS_SQL.DEFINE_COLUMN(l_c,2,x_match_gl_date);
228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);

Line 232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);

228: DBMS_SQL.DEFINE_COLUMN(l_c,3,x_match_status,30);
229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);
236: DBMS_SQL.CLOSE_CURSOR(l_c);

Line 233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);

229: DBMS_SQL.DEFINE_COLUMN(l_c,4,x_match_type,30);
230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);
236: DBMS_SQL.CLOSE_CURSOR(l_c);
237:

Line 234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);

230: l_exec := DBMS_SQL.EXECUTE(l_c);
231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);
236: DBMS_SQL.CLOSE_CURSOR(l_c);
237:
238: IF x_match_gl_date IS NULL THEN x_match_gl_date := TO_DATE('01-01-1900','DD-MM-YYYY'); END IF;

Line 235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);

231: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);
236: DBMS_SQL.CLOSE_CURSOR(l_c);
237:
238: IF x_match_gl_date IS NULL THEN x_match_gl_date := TO_DATE('01-01-1900','DD-MM-YYYY'); END IF;
239: IF x_match_status IS NULL THEN x_match_status := 'X'; END IF;

Line 236: DBMS_SQL.CLOSE_CURSOR(l_c);

232: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_match_event_id);
233: DBMS_SQL.COLUMN_VALUE(l_c, 2, x_match_gl_date);
234: DBMS_SQL.COLUMN_VALUE(l_c, 3, x_match_status);
235: DBMS_SQL.COLUMN_VALUE(l_c, 4, x_match_type);
236: DBMS_SQL.CLOSE_CURSOR(l_c);
237:
238: IF x_match_gl_date IS NULL THEN x_match_gl_date := TO_DATE('01-01-1900','DD-MM-YYYY'); END IF;
239: IF x_match_status IS NULL THEN x_match_status := 'X'; END IF;
240:

Line 1984: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl

1980: log( 'ARP_XLA_EVENTS.define_arrays()+' );
1981:
1982: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
1983:
1984: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status

Line 1986: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type

1982: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
1983:
1984: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id

Line 1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status

1984: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number

Line 1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id

1986: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id

Line 1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number

1988: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event

Line 1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id

1990: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid

Line 1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event

1992: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date

Line 1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid

1994: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id

Line 2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date

1996: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
2003: , MAX_ARRAY_SIZE, STARTING_INDEX );
2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id

Line 2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id

1998: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
2003: , MAX_ARRAY_SIZE, STARTING_INDEX );
2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
2005: , MAX_ARRAY_SIZE, STARTING_INDEX );
2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date

Line 2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id

2000: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
2003: , MAX_ARRAY_SIZE, STARTING_INDEX );
2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
2005: , MAX_ARRAY_SIZE, STARTING_INDEX );
2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
2007: , MAX_ARRAY_SIZE, STARTING_INDEX );
2008: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type

Line 2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date

2002: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
2003: , MAX_ARRAY_SIZE, STARTING_INDEX );
2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
2005: , MAX_ARRAY_SIZE, STARTING_INDEX );
2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
2007: , MAX_ARRAY_SIZE, STARTING_INDEX );
2008: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
2009: , MAX_ARRAY_SIZE, STARTING_INDEX );
2010: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status

Line 2008: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type

2004: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
2005: , MAX_ARRAY_SIZE, STARTING_INDEX );
2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
2007: , MAX_ARRAY_SIZE, STARTING_INDEX );
2008: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
2009: , MAX_ARRAY_SIZE, STARTING_INDEX );
2010: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: --{HYU transaction_date,legal_entity_id

Line 2010: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status

2006: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
2007: , MAX_ARRAY_SIZE, STARTING_INDEX );
2008: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
2009: , MAX_ARRAY_SIZE, STARTING_INDEX );
2010: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: --{HYU transaction_date,legal_entity_id
2013: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2014: , MAX_ARRAY_SIZE, STARTING_INDEX );

Line 2013: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date

2009: , MAX_ARRAY_SIZE, STARTING_INDEX );
2010: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: --{HYU transaction_date,legal_entity_id
2013: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2014: , MAX_ARRAY_SIZE, STARTING_INDEX );
2015: dbms_sql.define_array(p_select_c, 16, p_ev_rec.legal_entity_id
2016: , MAX_ARRAY_SIZE, STARTING_INDEX );
2017: --}

Line 2015: dbms_sql.define_array(p_select_c, 16, p_ev_rec.legal_entity_id

2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: --{HYU transaction_date,legal_entity_id
2013: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2014: , MAX_ARRAY_SIZE, STARTING_INDEX );
2015: dbms_sql.define_array(p_select_c, 16, p_ev_rec.legal_entity_id
2016: , MAX_ARRAY_SIZE, STARTING_INDEX );
2017: --}
2018:
2019: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN

Line 2020: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.dist_row_id

2016: , MAX_ARRAY_SIZE, STARTING_INDEX );
2017: --}
2018:
2019: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2020: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.dist_row_id
2021: , MAX_ARRAY_SIZE, STARTING_INDEX );
2022: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id
2023: , MAX_ARRAY_SIZE, STARTING_INDEX );
2024: END IF;

Line 2022: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id

2018:
2019: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2020: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.dist_row_id
2021: , MAX_ARRAY_SIZE, STARTING_INDEX );
2022: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id
2023: , MAX_ARRAY_SIZE, STARTING_INDEX );
2024: END IF;
2025:
2026: log( 'ARP_XLA_EVENTS.define_arrays()-' );

Line 2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);

2063: BEGIN
2064: log('ARP_XLA_EVENTS.get_column_values (+)');
2065:
2066: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);

Line 2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);

2064: log('ARP_XLA_EVENTS.get_column_values (+)');
2065:
2066: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);

Line 2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);

2065:
2066: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);

Line 2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);

2066: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);

Line 2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);

2067: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);

Line 2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);

2068: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);

Line 2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);

2069: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);

Line 2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);

2070: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);

Line 2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);

2071: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);

Line 2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);

2072: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);

Line 2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);

2073: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id

Line 2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);

2074: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id
2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);

Line 2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);

2075: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id
2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);

Line 2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);

2076: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2077: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id
2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2084: --}

Line 2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);

2078: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id
2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2084: --}
2085: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2086: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);

Line 2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);

2079: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2080: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2081: --{HYU transaction_date,legal_entity_id
2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2084: --}
2085: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2086: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2087: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);

Line 2086: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);

2082: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2084: --}
2085: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2086: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2087: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);
2088: END IF;
2089:
2090: log('ARP_XLA_EVENTS.get_column_values (-)');

Line 2087: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);

2083: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2084: --}
2085: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2086: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2087: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);
2088: END IF;
2089:
2090: log('ARP_XLA_EVENTS.get_column_values (-)');
2091:

Line 2133: l_select_c := dbms_sql.open_cursor;

2129: p_call_point => p_call_point);
2130:
2131: log('Opening cursor, to give cursor handle');
2132:
2133: l_select_c := dbms_sql.open_cursor;
2134:
2135: log('Parsing select stmt');
2136:
2137: dbms_sql.parse(l_select_c, l_stmt, dbms_sql.v7);

Line 2137: dbms_sql.parse(l_select_c, l_stmt, dbms_sql.v7);

2133: l_select_c := dbms_sql.open_cursor;
2134:
2135: log('Parsing select stmt');
2136:
2137: dbms_sql.parse(l_select_c, l_stmt, dbms_sql.v7);
2138:
2139: ------------------------------------------------------------
2140: -- Define Column Arrays
2141: ------------------------------------------------------------

Line 2153: dbms_sql.bind_variable(l_select_c, ':b_xla_mode', p_xla_ev_rec.xla_mode);

2149: -- Bind Variables
2150: ------------------------------------------------------------
2151: IF p_call_point = 1 THEN
2152: log('p_xla_ev_rec.xla_mode ' || p_xla_ev_rec.xla_mode);
2153: dbms_sql.bind_variable(l_select_c, ':b_xla_mode', p_xla_ev_rec.xla_mode);
2154: END IF;
2155:
2156: IF p_xla_ev_rec.xla_from_doc_id IS NOT NULL THEN
2157: log('p_xla_ev_rec.xla_from_doc_id ' || p_xla_ev_rec.xla_from_doc_id);

Line 2158: dbms_sql.bind_variable(l_select_c, ':b_xla_from_doc_id', p_xla_ev_rec.xla_from_doc_id);

2154: END IF;
2155:
2156: IF p_xla_ev_rec.xla_from_doc_id IS NOT NULL THEN
2157: log('p_xla_ev_rec.xla_from_doc_id ' || p_xla_ev_rec.xla_from_doc_id);
2158: dbms_sql.bind_variable(l_select_c, ':b_xla_from_doc_id', p_xla_ev_rec.xla_from_doc_id);
2159: END IF;
2160:
2161: IF p_xla_ev_rec.xla_to_doc_id IS NOT NULL THEN
2162: log('p_xla_ev_rec.xla_to_doc_id ' || p_xla_ev_rec.xla_to_doc_id);

Line 2163: dbms_sql.bind_variable(l_select_c, ':b_xla_to_doc_id', p_xla_ev_rec.xla_to_doc_id);

2159: END IF;
2160:
2161: IF p_xla_ev_rec.xla_to_doc_id IS NOT NULL THEN
2162: log('p_xla_ev_rec.xla_to_doc_id ' || p_xla_ev_rec.xla_to_doc_id);
2163: dbms_sql.bind_variable(l_select_c, ':b_xla_to_doc_id', p_xla_ev_rec.xla_to_doc_id);
2164: END IF;
2165:
2166: IF p_xla_ev_rec.xla_req_id IS NOT NULL THEN
2167: log('p_xla_ev_rec.xla_req_id ' || p_xla_ev_rec.xla_req_id);

Line 2168: dbms_sql.bind_variable(l_select_c, ':b_xla_req_id', p_xla_ev_rec.xla_req_id);

2164: END IF;
2165:
2166: IF p_xla_ev_rec.xla_req_id IS NOT NULL THEN
2167: log('p_xla_ev_rec.xla_req_id ' || p_xla_ev_rec.xla_req_id);
2168: dbms_sql.bind_variable(l_select_c, ':b_xla_req_id', p_xla_ev_rec.xla_req_id);
2169: END IF;
2170:
2171: IF p_xla_ev_rec.xla_dist_id IS NOT NULL THEN
2172: log('p_xla_ev_rec.xla_dist_id ' || p_xla_ev_rec.xla_dist_id);

Line 2173: dbms_sql.bind_variable(l_select_c, ':b_xla_dist_id', p_xla_ev_rec.xla_dist_id);

2169: END IF;
2170:
2171: IF p_xla_ev_rec.xla_dist_id IS NOT NULL THEN
2172: log('p_xla_ev_rec.xla_dist_id ' || p_xla_ev_rec.xla_dist_id);
2173: dbms_sql.bind_variable(l_select_c, ':b_xla_dist_id', p_xla_ev_rec.xla_dist_id);
2174: END IF;
2175:
2176: log('ARP_XLA_EVENTS.Get_Select_Cursor (-)');
2177:

Line 2319: l_ignore := dbms_sql.execute( l_select_c );

2315: ------------------------------------------------------------
2316: l_select_c := Get_Select_Cursor(p_xla_ev_rec => p_xla_ev_rec,
2317: p_call_point => 1);
2318:
2319: l_ignore := dbms_sql.execute( l_select_c );
2320:
2321: log( 'Fetching select stmt');
2322:
2323: LOOP -- Main Cursor Loop

Line 2352: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);

2348: ev_rec.legal_entity_id := empty_ev_rec.legal_entity_id;
2349: --}
2350: j := 0;
2351:
2352: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);
2353:
2354: log('Rows Fetched are ' || l_rows_fetched);
2355:
2356: l_low := l_high + 1;

Line 2374: IF( dbms_sql.is_open( l_select_c) ) THEN

2370: -- no more rows to fetch
2371: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
2372: log('Done fetching 1');
2373:
2374: IF( dbms_sql.is_open( l_select_c) ) THEN
2375: dbms_sql.close_cursor( l_select_c );
2376: END IF;
2377:
2378: END IF; --no more rows to fetch

Line 2375: dbms_sql.close_cursor( l_select_c );

2371: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
2372: log('Done fetching 1');
2373:
2374: IF( dbms_sql.is_open( l_select_c) ) THEN
2375: dbms_sql.close_cursor( l_select_c );
2376: END IF;
2377:
2378: END IF; --no more rows to fetch
2379:

Line 2383: IF( dbms_sql.is_open( l_select_c ) ) THEN

2379:
2380: ELSE --if rows fetched = 0
2381: log('Done fetching 2');
2382:
2383: IF( dbms_sql.is_open( l_select_c ) ) THEN
2384: dbms_sql.close_cursor( l_select_c );
2385: END IF;
2386:
2387: EXIT;

Line 2384: dbms_sql.close_cursor( l_select_c );

2380: ELSE --if rows fetched = 0
2381: log('Done fetching 2');
2382:
2383: IF( dbms_sql.is_open( l_select_c ) ) THEN
2384: dbms_sql.close_cursor( l_select_c );
2385: END IF;
2386:
2387: EXIT;
2388:

Line 3485: ltab DBMS_SQL.VARCHAR2_TABLE;

3481: WHERE ctl.customer_trx_id = p_invoice_id
3482: AND ctl.line_type = 'LINE'
3483: AND NVL(ctl.autorule_complete_flag,'Y') <> 'N';
3484:
3485: ltab DBMS_SQL.VARCHAR2_TABLE;
3486: lres VARCHAR2(1);
3487:
3488: BEGIN
3489: IF p_posting_entity <> 'CTLGD' THEN

Line 3569: l_ignore := dbms_sql.execute(l_select_c);

3565:
3566: l_select_c := Get_Select_Cursor(p_xla_ev_rec => p_xla_ev_rec,
3567: p_call_point => 2);
3568:
3569: l_ignore := dbms_sql.execute(l_select_c);
3570:
3571: log( 'Fetching select stmt');
3572:
3573: LOOP -- Main Cursor Loop

Line 3578: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);

3574:
3575: ev_rec.dist_row_id := empty_ev_rec.dist_row_id;
3576: ev_rec.dist_event_id := empty_ev_rec.dist_event_id;
3577:
3578: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);
3579:
3580: log('Rows Fetched are ' || l_rows_fetched);
3581:
3582: l_low := l_high + 1;

Line 3600: IF( dbms_sql.is_open( l_select_c) ) THEN

3596: -- no more rows to fetch
3597: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
3598: log('Done fetching 3');
3599:
3600: IF( dbms_sql.is_open( l_select_c) ) THEN
3601: dbms_sql.close_cursor( l_select_c );
3602: END IF;
3603:
3604: END IF; --no more rows to fetch

Line 3601: dbms_sql.close_cursor( l_select_c );

3597: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
3598: log('Done fetching 3');
3599:
3600: IF( dbms_sql.is_open( l_select_c) ) THEN
3601: dbms_sql.close_cursor( l_select_c );
3602: END IF;
3603:
3604: END IF; --no more rows to fetch
3605:

Line 3609: IF( dbms_sql.is_open( l_select_c ) ) THEN

3605:
3606: ELSE --if rows fetched = 0
3607: log('Done fetching 4');
3608:
3609: IF( dbms_sql.is_open( l_select_c ) ) THEN
3610: dbms_sql.close_cursor( l_select_c );
3611: END IF;
3612:
3613: EXIT;

Line 3610: dbms_sql.close_cursor( l_select_c );

3606: ELSE --if rows fetched = 0
3607: log('Done fetching 4');
3608:
3609: IF( dbms_sql.is_open( l_select_c ) ) THEN
3610: dbms_sql.close_cursor( l_select_c );
3611: END IF;
3612:
3613: EXIT;
3614: