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

Line 217: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;

213:
214: X_sqlstmt2 := ' WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) AND delete_mark = 0 ORDER BY 1 desc';
215:
216:
217: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
218:
219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
220:
221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);

Line 219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);

215:
216:
217: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
218:
219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
220:
221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);
222: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
223: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);

Line 221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);

217: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
218:
219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
220:
221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);
222: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
223: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
224:
225: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,

Line 222: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

218:
219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
220:
221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);
222: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
223: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
224:
225: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
226: -- Bug 2423983: 22 to 23

Line 223: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);

219: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
220:
221: --DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pspace',x_space);
222: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
223: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
224:
225: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
226: -- Bug 2423983: 22 to 23
227: FOR k IN 2..23 LOOP

Line 228: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);

224:
225: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
226: -- Bug 2423983: 22 to 23
227: FOR k IN 2..23 LOOP
228: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
229: END LOOP;
230: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
231:
232: /* selecting the acct_id in gl_acct_map

Line 230: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);

226: -- Bug 2423983: 22 to 23
227: FOR k IN 2..23 LOOP
228: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
229: END LOOP;
230: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
231:
232: /* selecting the acct_id in gl_acct_map
233: create the order_by based on the priority retrieved above.
234: company is always the first column selected */

Line 244: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN

240: END LOOP;
241:
242: X_my_order_by := 'ORDER BY 1 desc';
243:
244: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
245: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
246: -- Bug 2423983: 22 to 23
247: FOR j IN 2..23 LOOP
248: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);

Line 248: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);

244: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
245: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
246: -- Bug 2423983: 22 to 23
247: FOR j IN 2..23 LOOP
248: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);
249: IF (X_tmp1 > 0) THEN
250: x_tmp1:=x_tmp1 + 1;
251: X_order_by(x_tmp1) := j;
252: END IF;

Line 263: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);

259: IF (X_order_by(z) > 0) THEN
260: X_my_order_by := X_my_order_by||','||to_char(x_order_by(z))||' desc ';
261: END IF;
262: END LOOP;
263: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);
264:
265: /* X_sqlwhere := 'WHERE acct_ttl_type = '||to_char(Cur_subevtacct_ttl.acct_ttl_type)||
266: ' AND gmf_get_mappings.fstrcmp(co_code, ''' || X_co_code || ''')=1' ||
267: ' AND gmf_get_mappings.fstrcmp(whse_code, ''' || v_whse_code || ''')=1'; */

Line 423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;

419: 'acct_id ' ;
420:
421: X_sqlordby:= X_my_order_by;
422:
423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);

Line 425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);

421: X_sqlordby:= X_my_order_by;
422:
423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);

Line 426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

422:
423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);

Line 427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);

423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);

Line 428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);

424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);

Line 429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);

425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);

Line 430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);

426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);

Line 431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);

427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);

Line 432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);

428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);

Line 433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);

429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);
430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);

Line 434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);

430: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);

Line 435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);

431: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);

Line 436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);

432: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);

Line 437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);

433: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);

Line 438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);

434: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);

Line 439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);

435: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);

Line 440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);

436: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);

Line 441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);

437: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);

Line 442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);

438: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);

Line 443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);

439: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);

Line 444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);

440: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);

Line 445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);

441: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);

Line 446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);

442: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
450:

Line 447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);

443: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
450:
451:

Line 448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);

444: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
450:
451:
452: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23

Line 449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);

445: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
446: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pbusiness_class_cat_id',v_business_class_cat_id);
447: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
448: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
449: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
450:
451:
452: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
453: -- Bug 2423983: 23 to 24

Line 454: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);

450:
451:
452: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
453: -- Bug 2423983: 23 to 24
454: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
455: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23

Line 455: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);

451:
452: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
453: -- Bug 2423983: 23 to 24
454: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
455: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
459: -- Bug 2423983: 23 to 24

Line 456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN

452: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
453: -- Bug 2423983: 23 to 24
454: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
455: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
459: -- Bug 2423983: 23 to 24
460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

Line 460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
459: -- Bug 2423983: 23 to 24
460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
461: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
462: END IF;
463: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
464: END LOOP;

Line 463: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);

459: -- Bug 2423983: 23 to 24
460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
461: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
462: END IF;
463: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
464: END LOOP;
465: no_of_rows := i;
466:
467: /* No rows found */

Line 774: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;

770:
771: X_sqlstmt2 := ' WHERE acct_ttl_type = :pacct_ttl_type'||
772: ' AND (co_code = :pco_code OR co_code IS NULL) AND delete_mark = 0 ORDER BY 1 desc';
773:
774: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
775:
776: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
777:
778: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

Line 776: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);

772: ' AND (co_code = :pco_code OR co_code IS NULL) AND delete_mark = 0 ORDER BY 1 desc';
773:
774: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
775:
776: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
777:
778: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
779: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
780:

Line 778: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

774: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
775:
776: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
777:
778: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
779: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
780:
781: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
782: -- Bug 2423983: 22 to 23

Line 779: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);

775:
776: DBMS_SQL.PARSE(X_cursor_handle,X_sqlstmt||X_sqlstmt1||X_sqlstmt2,DBMS_SQL.V7);
777:
778: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
779: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',v_co_code);
780:
781: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
782: -- Bug 2423983: 22 to 23
783: FOR k IN 2..23 LOOP

Line 784: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);

780:
781: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
782: -- Bug 2423983: 22 to 23
783: FOR k IN 2..23 LOOP
784: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
785: END LOOP;
786: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
787: /*selecting the acct_id in gl_acct_map
788: create the order_by based on the priority retrieved above.

Line 786: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);

782: -- Bug 2423983: 22 to 23
783: FOR k IN 2..23 LOOP
784: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
785: END LOOP;
786: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
787: /*selecting the acct_id in gl_acct_map
788: create the order_by based on the priority retrieved above.
789: company is always the first column selected */
790:

Line 799: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN

795: END LOOP;
796:
797: X_my_order_by := 'ORDER BY 1 desc';
798:
799: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
800: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
801: -- Bug 2423983: 22 to 23
802: FOR j IN 2..23 LOOP
803: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);

Line 803: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);

799: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
800: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,
801: -- Bug 2423983: 22 to 23
802: FOR j IN 2..23 LOOP
803: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,j,x_tmp1);
804: IF (X_tmp1 > 0) THEN
805: x_tmp1:=x_tmp1 + 1;
806: X_order_by(x_tmp1) := j;
807: END IF;

Line 818: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);

814: IF (X_order_by(z) > 0) THEN
815: X_my_order_by := X_my_order_by||','||to_char(x_order_by(z))||' desc ';
816: END IF;
817: END LOOP;
818: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);
819:
820: IF (Cur_subevtacct_ttl.map_orgn_ind = 1) THEN
821: X_map_orgn_code := V_orgn_code;
822: X_co_code := X_map_orgn_co;

Line 988: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;

984: 'nvl(ar_trx_type_id,0), ' || -- Bug 2423983 - umoogala
985: 'acct_id ' ;
986:
987: X_sqlordby:= X_my_order_by;
988: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
989:
990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

Line 991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);

987: X_sqlordby:= X_my_order_by;
988: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
989:
990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));

Line 992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);

988: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
989:
990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);

Line 993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));

989:
990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);

Line 994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);

990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);

Line 995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));

991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);

Line 996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);

992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);

Line 997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);

993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);

Line 998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);

994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);

Line 999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);

995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));
996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);

Line 1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);

996: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pitem_id',v_item_id);
997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);

Line 1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);

997: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendor_id',v_vendor_id);
998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);

Line 1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);

998: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcust_id',v_cust_id);
999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);

Line 1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);

999: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':preason_code',v_reason_code);
1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);

Line 1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);

1000: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':picgl_class',v_icgl_class);
1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);

Line 1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);

1001: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pvendgl_class',v_vendgl_class);
1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);

Line 1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);

1002: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcustgl_class',v_custgl_class);
1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);

Line 1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);

1003: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcurrency_code',v_currency_code);
1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);

Line 1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);

1004: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':prouting_id',v_routing_id);
1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);

Line 1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);

1005: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcharge_id',v_charge_id);
1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);

Line 1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);

1006: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':ptaxauth_id',v_taxauth_id);
1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);

Line 1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);

1007: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':paqui_cost_id',v_aqui_cost_id);
1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);

Line 1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);

1008: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':presources',v_resources);
1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
1016:

Line 1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);

1009: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_cmpntcls_id',v_cost_cmpntcls_id);
1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
1016:
1017: -- Bug 2031374 - umoogala: 20 -> 22 , Bug 2468912: 22 to 23

Line 1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);

1010: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pcost_analysis_code',v_cost_analysis_code);
1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
1016:
1017: -- Bug 2031374 - umoogala: 20 -> 22 , Bug 2468912: 22 to 23
1018: -- Bug 2423983 - umoogala: 23 -> 24

Line 1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);

1011: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':porder_type',v_order_type);
1012: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pBusiness_class_cat_id',v_business_class_cat_id);
1013: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pproduct_line_cat_id',v_product_line_cat_id);
1014: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pline_type',v_line_type);
1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
1016:
1017: -- Bug 2031374 - umoogala: 20 -> 22 , Bug 2468912: 22 to 23
1018: -- Bug 2423983 - umoogala: 23 -> 24
1019: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);

Line 1019: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);

1015: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':par_trx_type_id',v_ar_trx_type_id);
1016:
1017: -- Bug 2031374 - umoogala: 20 -> 22 , Bug 2468912: 22 to 23
1018: -- Bug 2423983 - umoogala: 23 -> 24
1019: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
1020:
1021: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
1023: i:= i + 1;

Line 1021: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);

1017: -- Bug 2031374 - umoogala: 20 -> 22 , Bug 2468912: 22 to 23
1018: -- Bug 2423983 - umoogala: 23 -> 24
1019: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
1020:
1021: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
1023: i:= i + 1;
1024: -- Bug 2031374 - umoogala: 20 -> 22, Bug 2468912: 22 to 23
1025: -- Bug 2423983 - umoogala: 23 -> 24

Line 1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN

1018: -- Bug 2423983 - umoogala: 23 -> 24
1019: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,24,x_num_col);
1020:
1021: x_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
1023: i:= i + 1;
1024: -- Bug 2031374 - umoogala: 20 -> 22, Bug 2468912: 22 to 23
1025: -- Bug 2423983 - umoogala: 23 -> 24
1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

Line 1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
1023: i:= i + 1;
1024: -- Bug 2031374 - umoogala: 20 -> 22, Bug 2468912: 22 to 23
1025: -- Bug 2423983 - umoogala: 23 -> 24
1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
1027: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
1028: END IF;
1029: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
1030: END LOOP;

Line 1029: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);

1025: -- Bug 2423983 - umoogala: 23 -> 24
1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
1027: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
1028: END IF;
1029: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
1030: END LOOP;
1031: no_of_rows := i;
1032: END get_account_mappings;
1033: