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 1974: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl

1970: log( 'ARP_XLA_EVENTS.define_arrays()+' );
1971:
1972: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
1973:
1974: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1975: , MAX_ARRAY_SIZE, STARTING_INDEX );
1976: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1977: , MAX_ARRAY_SIZE, STARTING_INDEX );
1978: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status

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

1972: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
1973:
1974: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1975: , MAX_ARRAY_SIZE, STARTING_INDEX );
1976: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1977: , MAX_ARRAY_SIZE, STARTING_INDEX );
1978: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1979: , MAX_ARRAY_SIZE, STARTING_INDEX );
1980: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id

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

1974: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl
1975: , MAX_ARRAY_SIZE, STARTING_INDEX );
1976: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1977: , MAX_ARRAY_SIZE, STARTING_INDEX );
1978: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1979: , MAX_ARRAY_SIZE, STARTING_INDEX );
1980: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1981: , MAX_ARRAY_SIZE, STARTING_INDEX );
1982: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number

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

1976: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.trx_type
1977: , MAX_ARRAY_SIZE, STARTING_INDEX );
1978: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1979: , MAX_ARRAY_SIZE, STARTING_INDEX );
1980: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1981: , MAX_ARRAY_SIZE, STARTING_INDEX );
1982: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1983: , MAX_ARRAY_SIZE, STARTING_INDEX );
1984: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id

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

1978: dbms_sql.define_array(p_select_c, 3 , p_ev_rec.trx_status
1979: , MAX_ARRAY_SIZE, STARTING_INDEX );
1980: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1981: , MAX_ARRAY_SIZE, STARTING_INDEX );
1982: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1983: , MAX_ARRAY_SIZE, STARTING_INDEX );
1984: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event

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

1980: dbms_sql.define_array(p_select_c, 4 , p_ev_rec.trx_id
1981: , MAX_ARRAY_SIZE, STARTING_INDEX );
1982: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1983: , MAX_ARRAY_SIZE, STARTING_INDEX );
1984: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid

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

1982: dbms_sql.define_array(p_select_c, 5 , p_ev_rec.trx_number
1983: , MAX_ARRAY_SIZE, STARTING_INDEX );
1984: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date

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

1984: dbms_sql.define_array(p_select_c, 6 , p_ev_rec.org_id
1985: , MAX_ARRAY_SIZE, STARTING_INDEX );
1986: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id

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

1986: dbms_sql.define_array(p_select_c, 7 , p_ev_rec.override_event
1987: , MAX_ARRAY_SIZE, STARTING_INDEX );
1988: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id

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

1988: dbms_sql.define_array(p_select_c, 8 , p_ev_rec.pstid
1989: , MAX_ARRAY_SIZE, STARTING_INDEX );
1990: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date

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

1990: dbms_sql.define_array(p_select_c, 9 , p_ev_rec.dist_gl_date
1991: , MAX_ARRAY_SIZE, STARTING_INDEX );
1992: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type

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

1992: dbms_sql.define_array(p_select_c, 10, p_ev_rec.ev_match_event_id
1993: , MAX_ARRAY_SIZE, STARTING_INDEX );
1994: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status

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

1994: dbms_sql.define_array(p_select_c, 11 , p_ev_rec.dist_event_id
1995: , MAX_ARRAY_SIZE, STARTING_INDEX );
1996: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: --{HYU transaction_date,legal_entity_id

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

1996: dbms_sql.define_array(p_select_c, 12, p_ev_rec.ev_match_gl_date
1997: , MAX_ARRAY_SIZE, STARTING_INDEX );
1998: dbms_sql.define_array(p_select_c, 13, p_ev_rec.ev_match_type
1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: --{HYU transaction_date,legal_entity_id
2003: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2004: , MAX_ARRAY_SIZE, STARTING_INDEX );

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

1999: , MAX_ARRAY_SIZE, STARTING_INDEX );
2000: dbms_sql.define_array(p_select_c, 14, p_ev_rec.ev_match_status
2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: --{HYU transaction_date,legal_entity_id
2003: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2004: , MAX_ARRAY_SIZE, STARTING_INDEX );
2005: dbms_sql.define_array(p_select_c, 16, p_ev_rec.legal_entity_id
2006: , MAX_ARRAY_SIZE, STARTING_INDEX );
2007: --}

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

2001: , MAX_ARRAY_SIZE, STARTING_INDEX );
2002: --{HYU transaction_date,legal_entity_id
2003: dbms_sql.define_array(p_select_c, 15, p_ev_rec.transaction_date
2004: , MAX_ARRAY_SIZE, STARTING_INDEX );
2005: dbms_sql.define_array(p_select_c, 16, p_ev_rec.legal_entity_id
2006: , MAX_ARRAY_SIZE, STARTING_INDEX );
2007: --}
2008:
2009: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN

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

2006: , MAX_ARRAY_SIZE, STARTING_INDEX );
2007: --}
2008:
2009: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2010: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.dist_row_id
2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id
2013: , MAX_ARRAY_SIZE, STARTING_INDEX );
2014: END IF;

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

2008:
2009: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2010: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.dist_row_id
2011: , MAX_ARRAY_SIZE, STARTING_INDEX );
2012: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id
2013: , MAX_ARRAY_SIZE, STARTING_INDEX );
2014: END IF;
2015:
2016: log( 'ARP_XLA_EVENTS.define_arrays()-' );

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

2053: BEGIN
2054: log('ARP_XLA_EVENTS.get_column_values (+)');
2055:
2056: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);

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

2054: log('ARP_XLA_EVENTS.get_column_values (+)');
2055:
2056: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);

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

2055:
2056: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);

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

2056: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);

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

2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);

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

2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);
2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);

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

2059: dbms_sql.column_value(p_select_c, 3 , p_ev_rec.trx_status);
2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);

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

2060: dbms_sql.column_value(p_select_c, 4 , p_ev_rec.trx_id);
2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);

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

2061: dbms_sql.column_value(p_select_c, 5 , p_ev_rec.trx_number);
2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);

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

2062: dbms_sql.column_value(p_select_c, 6 , p_ev_rec.org_id);
2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);

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

2063: dbms_sql.column_value(p_select_c, 7 , p_ev_rec.override_event);
2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id

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

2064: dbms_sql.column_value(p_select_c, 8 , p_ev_rec.pstid);
2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id
2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);

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

2065: dbms_sql.column_value(p_select_c, 9 , p_ev_rec.dist_gl_date);
2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id
2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);

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

2066: dbms_sql.column_value(p_select_c, 10 , p_ev_rec.dist_event_id);
2067: dbms_sql.column_value(p_select_c, 11, p_ev_rec.ev_match_event_id);
2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id
2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2074: --}

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

2068: dbms_sql.column_value(p_select_c, 12, p_ev_rec.ev_match_gl_date);
2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id
2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2074: --}
2075: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2076: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);

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

2069: dbms_sql.column_value(p_select_c, 13, p_ev_rec.ev_match_type);
2070: dbms_sql.column_value(p_select_c, 14, p_ev_rec.ev_match_status);
2071: --{HYU transaction_date,legal_entity_id
2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2074: --}
2075: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2076: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2077: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);

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

2072: dbms_sql.column_value(p_select_c, 15, p_ev_rec.transaction_date);
2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2074: --}
2075: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2076: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2077: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);
2078: END IF;
2079:
2080: log('ARP_XLA_EVENTS.get_column_values (-)');

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

2073: dbms_sql.column_value(p_select_c, 16, p_ev_rec.legal_entity_id);
2074: --}
2075: ELSIF p_xla_ev_rec.xla_call IN ('D','B') AND p_call_point = 2 THEN
2076: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2077: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);
2078: END IF;
2079:
2080: log('ARP_XLA_EVENTS.get_column_values (-)');
2081:

Line 2123: l_select_c := dbms_sql.open_cursor;

2119: p_call_point => p_call_point);
2120:
2121: log('Opening cursor, to give cursor handle');
2122:
2123: l_select_c := dbms_sql.open_cursor;
2124:
2125: log('Parsing select stmt');
2126:
2127: dbms_sql.parse(l_select_c, l_stmt, dbms_sql.v7);

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

2123: l_select_c := dbms_sql.open_cursor;
2124:
2125: log('Parsing select stmt');
2126:
2127: dbms_sql.parse(l_select_c, l_stmt, dbms_sql.v7);
2128:
2129: ------------------------------------------------------------
2130: -- Define Column Arrays
2131: ------------------------------------------------------------

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

2139: -- Bind Variables
2140: ------------------------------------------------------------
2141: IF p_call_point = 1 THEN
2142: log('p_xla_ev_rec.xla_mode ' || p_xla_ev_rec.xla_mode);
2143: dbms_sql.bind_variable(l_select_c, ':b_xla_mode', p_xla_ev_rec.xla_mode);
2144: END IF;
2145:
2146: IF p_xla_ev_rec.xla_from_doc_id IS NOT NULL THEN
2147: log('p_xla_ev_rec.xla_from_doc_id ' || p_xla_ev_rec.xla_from_doc_id);

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

2144: END IF;
2145:
2146: IF p_xla_ev_rec.xla_from_doc_id IS NOT NULL THEN
2147: log('p_xla_ev_rec.xla_from_doc_id ' || p_xla_ev_rec.xla_from_doc_id);
2148: dbms_sql.bind_variable(l_select_c, ':b_xla_from_doc_id', p_xla_ev_rec.xla_from_doc_id);
2149: END IF;
2150:
2151: IF p_xla_ev_rec.xla_to_doc_id IS NOT NULL THEN
2152: log('p_xla_ev_rec.xla_to_doc_id ' || p_xla_ev_rec.xla_to_doc_id);

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

2149: END IF;
2150:
2151: IF p_xla_ev_rec.xla_to_doc_id IS NOT NULL THEN
2152: log('p_xla_ev_rec.xla_to_doc_id ' || p_xla_ev_rec.xla_to_doc_id);
2153: dbms_sql.bind_variable(l_select_c, ':b_xla_to_doc_id', p_xla_ev_rec.xla_to_doc_id);
2154: END IF;
2155:
2156: IF p_xla_ev_rec.xla_req_id IS NOT NULL THEN
2157: log('p_xla_ev_rec.xla_req_id ' || p_xla_ev_rec.xla_req_id);

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

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

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

2159: END IF;
2160:
2161: IF p_xla_ev_rec.xla_dist_id IS NOT NULL THEN
2162: log('p_xla_ev_rec.xla_dist_id ' || p_xla_ev_rec.xla_dist_id);
2163: dbms_sql.bind_variable(l_select_c, ':b_xla_dist_id', p_xla_ev_rec.xla_dist_id);
2164: END IF;
2165:
2166: log('ARP_XLA_EVENTS.Get_Select_Cursor (-)');
2167:

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

2305: ------------------------------------------------------------
2306: l_select_c := Get_Select_Cursor(p_xla_ev_rec => p_xla_ev_rec,
2307: p_call_point => 1);
2308:
2309: l_ignore := dbms_sql.execute( l_select_c );
2310:
2311: log( 'Fetching select stmt');
2312:
2313: LOOP -- Main Cursor Loop

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

2338: ev_rec.legal_entity_id := empty_ev_rec.legal_entity_id;
2339: --}
2340: j := 0;
2341:
2342: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);
2343:
2344: log('Rows Fetched are ' || l_rows_fetched);
2345:
2346: l_low := l_high + 1;

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

2360: -- no more rows to fetch
2361: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
2362: log('Done fetching 1');
2363:
2364: IF( dbms_sql.is_open( l_select_c) ) THEN
2365: dbms_sql.close_cursor( l_select_c );
2366: END IF;
2367:
2368: END IF; --no more rows to fetch

Line 2365: dbms_sql.close_cursor( l_select_c );

2361: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
2362: log('Done fetching 1');
2363:
2364: IF( dbms_sql.is_open( l_select_c) ) THEN
2365: dbms_sql.close_cursor( l_select_c );
2366: END IF;
2367:
2368: END IF; --no more rows to fetch
2369:

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

2369:
2370: ELSE --if rows fetched = 0
2371: log('Done fetching 2');
2372:
2373: IF( dbms_sql.is_open( l_select_c ) ) THEN
2374: dbms_sql.close_cursor( l_select_c );
2375: END IF;
2376:
2377: EXIT;

Line 2374: dbms_sql.close_cursor( l_select_c );

2370: ELSE --if rows fetched = 0
2371: log('Done fetching 2');
2372:
2373: IF( dbms_sql.is_open( l_select_c ) ) THEN
2374: dbms_sql.close_cursor( l_select_c );
2375: END IF;
2376:
2377: EXIT;
2378:

Line 3473: ltab DBMS_SQL.VARCHAR2_TABLE;

3469: WHERE ctl.customer_trx_id = p_invoice_id
3470: AND ctl.line_type = 'LINE'
3471: AND NVL(ctl.autorule_complete_flag,'Y') <> 'N';
3472:
3473: ltab DBMS_SQL.VARCHAR2_TABLE;
3474: lres VARCHAR2(1);
3475:
3476: BEGIN
3477: IF p_posting_entity <> 'CTLGD' THEN

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

3553:
3554: l_select_c := Get_Select_Cursor(p_xla_ev_rec => p_xla_ev_rec,
3555: p_call_point => 2);
3556:
3557: l_ignore := dbms_sql.execute(l_select_c);
3558:
3559: log( 'Fetching select stmt');
3560:
3561: LOOP -- Main Cursor Loop

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

3562:
3563: ev_rec.dist_row_id := empty_ev_rec.dist_row_id;
3564: ev_rec.dist_event_id := empty_ev_rec.dist_event_id;
3565:
3566: l_rows_fetched := dbms_sql.fetch_rows(l_select_c);
3567:
3568: log('Rows Fetched are ' || l_rows_fetched);
3569:
3570: l_low := l_high + 1;

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

3584: -- no more rows to fetch
3585: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
3586: log('Done fetching 3');
3587:
3588: IF( dbms_sql.is_open( l_select_c) ) THEN
3589: dbms_sql.close_cursor( l_select_c );
3590: END IF;
3591:
3592: END IF; --no more rows to fetch

Line 3589: dbms_sql.close_cursor( l_select_c );

3585: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
3586: log('Done fetching 3');
3587:
3588: IF( dbms_sql.is_open( l_select_c) ) THEN
3589: dbms_sql.close_cursor( l_select_c );
3590: END IF;
3591:
3592: END IF; --no more rows to fetch
3593:

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

3593:
3594: ELSE --if rows fetched = 0
3595: log('Done fetching 4');
3596:
3597: IF( dbms_sql.is_open( l_select_c ) ) THEN
3598: dbms_sql.close_cursor( l_select_c );
3599: END IF;
3600:
3601: EXIT;

Line 3598: dbms_sql.close_cursor( l_select_c );

3594: ELSE --if rows fetched = 0
3595: log('Done fetching 4');
3596:
3597: IF( dbms_sql.is_open( l_select_c ) ) THEN
3598: dbms_sql.close_cursor( l_select_c );
3599: END IF;
3600:
3601: EXIT;
3602: