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

Line 222: IF dbms_sql.IS_OPEN(i_level_info(i).Select_Cursor)

218: Cursors for the all Levels are closed using these Cursor handles.
219: **/
220: FOR i in 1..i_level_info.COUNT
221: LOOP
222: IF dbms_sql.IS_OPEN(i_level_info(i).Select_Cursor)
223: THEN
224: dbms_sql.Close_cursor(i_level_info(i).Select_Cursor);
225: END IF;
226: END LOOP;

Line 224: dbms_sql.Close_cursor(i_level_info(i).Select_Cursor);

220: FOR i in 1..i_level_info.COUNT
221: LOOP
222: IF dbms_sql.IS_OPEN(i_level_info(i).Select_Cursor)
223: THEN
224: dbms_sql.Close_cursor(i_level_info(i).Select_Cursor);
225: END IF;
226: END LOOP;
227:
228: /**

Line 386: --i_stage_cursor := dbms_sql.Open_Cursor;

382: /**
383: Open the cursor and parse the SQL Statement. Trap any parsing error and report
384: the Error Position in the SQL Statement
385: **/
386: --i_stage_cursor := dbms_sql.Open_Cursor;
387: -- BEGIN
388: -- dbms_sql.parse(i_stage_cursor,cSelect_stmt,dbms_sql.native);
389: -- EXCEPTION
390: -- WHEN OTHERS THEN

Line 388: -- dbms_sql.parse(i_stage_cursor,cSelect_stmt,dbms_sql.native);

384: the Error Position in the SQL Statement
385: **/
386: --i_stage_cursor := dbms_sql.Open_Cursor;
387: -- BEGIN
388: -- dbms_sql.parse(i_stage_cursor,cSelect_stmt,dbms_sql.native);
389: -- EXCEPTION
390: -- WHEN OTHERS THEN
391: -- error_position := dbms_sql.last_error_position;
392: -- ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

Line 391: -- error_position := dbms_sql.last_error_position;

387: -- BEGIN
388: -- dbms_sql.parse(i_stage_cursor,cSelect_stmt,dbms_sql.native);
389: -- EXCEPTION
390: -- WHEN OTHERS THEN
391: -- error_position := dbms_sql.last_error_position;
392: -- ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
393: -- ece_error_handling_pvt.print_parse_error (error_position,cSelect_stmt);
394: -- EC_UTILS.i_ret_code :=2;
395: -- raise EC_UTILS.PROGRAM_EXIT;

Line 401: --dbms_sql.bind_variable(i_stage_cursor,'a1',i_transaction_type);

397:
398: /**
399: Bind values
400: **/
401: --dbms_sql.bind_variable(i_stage_cursor,'a1',i_transaction_type);
402: --dbms_sql.bind_variable(i_stage_cursor,'a2',i_run_id);
403: --dbms_sql.bind_variable(i_stage_cursor,'a3',i_parent_stage_id);
404:
405: /**

Line 402: --dbms_sql.bind_variable(i_stage_cursor,'a2',i_run_id);

398: /**
399: Bind values
400: **/
401: --dbms_sql.bind_variable(i_stage_cursor,'a1',i_transaction_type);
402: --dbms_sql.bind_variable(i_stage_cursor,'a2',i_run_id);
403: --dbms_sql.bind_variable(i_stage_cursor,'a3',i_parent_stage_id);
404:
405: /**
406: Define the column for return string

Line 403: --dbms_sql.bind_variable(i_stage_cursor,'a3',i_parent_stage_id);

399: Bind values
400: **/
401: --dbms_sql.bind_variable(i_stage_cursor,'a1',i_transaction_type);
402: --dbms_sql.bind_variable(i_stage_cursor,'a2',i_run_id);
403: --dbms_sql.bind_variable(i_stage_cursor,'a3',i_parent_stage_id);
404:
405: /**
406: Define the column for return string
407: **/

Line 408: /** dbms_sql.define_column(i_stage_cursor,1,v_stage_id);

404:
405: /**
406: Define the column for return string
407: **/
408: /** dbms_sql.define_column(i_stage_cursor,1,v_stage_id);
409: dbms_sql.define_column(i_stage_cursor,2,v_parent_stage_id);
410: dbms_sql.define_column(i_stage_cursor,3,v_transaction_level);
411: **/
412: /**

Line 409: dbms_sql.define_column(i_stage_cursor,2,v_parent_stage_id);

405: /**
406: Define the column for return string
407: **/
408: /** dbms_sql.define_column(i_stage_cursor,1,v_stage_id);
409: dbms_sql.define_column(i_stage_cursor,2,v_parent_stage_id);
410: dbms_sql.define_column(i_stage_cursor,3,v_transaction_level);
411: **/
412: /**
413: Execute the cursor; debug on the number of rows returned

Line 410: dbms_sql.define_column(i_stage_cursor,3,v_transaction_level);

406: Define the column for return string
407: **/
408: /** dbms_sql.define_column(i_stage_cursor,1,v_stage_id);
409: dbms_sql.define_column(i_stage_cursor,2,v_parent_stage_id);
410: dbms_sql.define_column(i_stage_cursor,3,v_transaction_level);
411: **/
412: /**
413: Execute the cursor; debug on the number of rows returned
414: **/

Line 416: dummy := dbms_sql.execute(i_stage_cursor);

412: /**
413: Execute the cursor; debug on the number of rows returned
414: **/
415: /** BEGIN
416: dummy := dbms_sql.execute(i_stage_cursor);
417: if ec_debug.G_debug_level = 3 then
418: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);
419: ec_debug.pl(3,'i_stage_cursor', i_stage_cursor);
420: ec_debug.pl(3,cSelect_stmt);

Line 434: WHILE dbms_sql.fetch_rows(i_stage_cursor) > 0

430: raise EC_UTILS.PROGRAM_EXIT;
431: END; **/
432:
433: /** BEGIN
434: WHILE dbms_sql.fetch_rows(i_stage_cursor) > 0
435: LOOP
436: dbms_sql.column_value(i_stage_cursor,1,v_stage_id);
437: dbms_sql.column_value(i_stage_cursor,2,v_parent_stage_id);
438: dbms_sql.column_value(i_stage_cursor,3,v_transaction_level);

Line 436: dbms_sql.column_value(i_stage_cursor,1,v_stage_id);

432:
433: /** BEGIN
434: WHILE dbms_sql.fetch_rows(i_stage_cursor) > 0
435: LOOP
436: dbms_sql.column_value(i_stage_cursor,1,v_stage_id);
437: dbms_sql.column_value(i_stage_cursor,2,v_parent_stage_id);
438: dbms_sql.column_value(i_stage_cursor,3,v_transaction_level);
439: if ec_debug.G_debug_level = 3 then
440: ec_debug.pl(3,'v_stage_id',v_stage_id);

Line 437: dbms_sql.column_value(i_stage_cursor,2,v_parent_stage_id);

433: /** BEGIN
434: WHILE dbms_sql.fetch_rows(i_stage_cursor) > 0
435: LOOP
436: dbms_sql.column_value(i_stage_cursor,1,v_stage_id);
437: dbms_sql.column_value(i_stage_cursor,2,v_parent_stage_id);
438: dbms_sql.column_value(i_stage_cursor,3,v_transaction_level);
439: if ec_debug.G_debug_level = 3 then
440: ec_debug.pl(3,'v_stage_id',v_stage_id);
441: ec_debug.pl(3,'v_parent_stage_id',v_parent_stage_id);

Line 438: dbms_sql.column_value(i_stage_cursor,3,v_transaction_level);

434: WHILE dbms_sql.fetch_rows(i_stage_cursor) > 0
435: LOOP
436: dbms_sql.column_value(i_stage_cursor,1,v_stage_id);
437: dbms_sql.column_value(i_stage_cursor,2,v_parent_stage_id);
438: dbms_sql.column_value(i_stage_cursor,3,v_transaction_level);
439: if ec_debug.G_debug_level = 3 then
440: ec_debug.pl(3,'v_stage_id',v_stage_id);
441: ec_debug.pl(3,'v_parent_stage_id',v_parent_stage_id);
442: ec_debug.pl(3,'v_transaction_level',v_transaction_level);

Line 475: -- dbms_sql.close_cursor(i_stage_cursor);

471: **/
472: /**
473: Close Cursor
474: **/
475: -- dbms_sql.close_cursor(i_stage_cursor);
476: if ec_debug.G_debug_level >= 2 then
477: ec_debug.pop('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
478: end if;
479:

Line 803: i_select_cursor := dbms_sql.Open_Cursor;

799: Open the cursor and parse the SQL Statement. Trap any parsing error and report
800: the Error Position in the SQL Statement. Store cursor handle in PL/SQL table for
801: later use.
802: **/
803: i_select_cursor := dbms_sql.Open_Cursor;
804: BEGIN
805: dbms_sql.parse(i_select_cursor,cSelect_stmt,dbms_sql.native);
806: i_level_info(i_level).select_cursor := i_select_cursor;
807: i_level_info(i_level).total_records := i_select_count;

Line 805: dbms_sql.parse(i_select_cursor,cSelect_stmt,dbms_sql.native);

801: later use.
802: **/
803: i_select_cursor := dbms_sql.Open_Cursor;
804: BEGIN
805: dbms_sql.parse(i_select_cursor,cSelect_stmt,dbms_sql.native);
806: i_level_info(i_level).select_cursor := i_select_cursor;
807: i_level_info(i_level).total_records := i_select_count;
808: EXCEPTION
809: WHEN OTHERS THEN

Line 810: error_position := dbms_sql.last_error_position;

806: i_level_info(i_level).select_cursor := i_select_cursor;
807: i_level_info(i_level).total_records := i_select_count;
808: EXCEPTION
809: WHEN OTHERS THEN
810: error_position := dbms_sql.last_error_position;
811: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
812: ece_error_handling_pvt.print_parse_error (error_position,cSelect_stmt);
813: EC_UTILS.i_ret_code :=2;
814: raise EC_UTILS.PROGRAM_EXIT;

Line 827: dbms_sql.bind_variable(i_select_cursor,'a1',i_stage_id);

823:
824: /**
825: Bind values for Primary Key
826: **/
827: dbms_sql.bind_variable(i_select_cursor,'a1',i_stage_id);
828: if ec_debug.G_debug_level = 3 then
829: ec_debug.pl(3,'STAGE_ID',i_stage_id);
830: end if;
831: /**

Line 834: dbms_sql.define_column(i_select_cursor,1,v_dummy_tp_code,2000);

830: end if;
831: /**
832: Define the columns for return string
833: **/
834: dbms_sql.define_column(i_select_cursor,1,v_dummy_tp_code,2000);
835: dbms_sql.define_column(i_select_cursor,2,v_dummy_key_staging,2000);
836: FOR n IN 3..i_level_info(i_level).total_records + 2
837: LOOP
838: v_dummy(n) := '';

Line 835: dbms_sql.define_column(i_select_cursor,2,v_dummy_key_staging,2000);

831: /**
832: Define the columns for return string
833: **/
834: dbms_sql.define_column(i_select_cursor,1,v_dummy_tp_code,2000);
835: dbms_sql.define_column(i_select_cursor,2,v_dummy_key_staging,2000);
836: FOR n IN 3..i_level_info(i_level).total_records + 2
837: LOOP
838: v_dummy(n) := '';
839: dbms_sql.define_column(i_select_cursor,n,v_dummy(n),2000);

Line 839: dbms_sql.define_column(i_select_cursor,n,v_dummy(n),2000);

835: dbms_sql.define_column(i_select_cursor,2,v_dummy_key_staging,2000);
836: FOR n IN 3..i_level_info(i_level).total_records + 2
837: LOOP
838: v_dummy(n) := '';
839: dbms_sql.define_column(i_select_cursor,n,v_dummy(n),2000);
840: END LOOP;
841:
842: /**
843: Execute the cursor; debug on the number of rows returned

Line 846: dummy := dbms_sql.execute(i_select_cursor);

842: /**
843: Execute the cursor; debug on the number of rows returned
844: **/
845: BEGIN
846: dummy := dbms_sql.execute(i_select_cursor);
847: if ec_debug.G_debug_level = 3 then
848: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);
849: ec_debug.pl(3,'i_select_cursor', i_select_cursor);
850: end if;

Line 862: WHILE dbms_sql.fetch_rows(i_select_cursor) > 0

858: raise EC_UTILS.PROGRAM_EXIT;
859: END;
860:
861: BEGIN
862: WHILE dbms_sql.fetch_rows(i_select_cursor) > 0
863: LOOP
864:
865: /** You can comment out this call if you don't want the Common Key to be formatted on the flat file.
866: This is provides a performance boost due to the slow PL/SQL string operations required for the common key

Line 868: dbms_sql.column_value(i_select_cursor,1,v_dummy_tp_code);

864:
865: /** You can comment out this call if you don't want the Common Key to be formatted on the flat file.
866: This is provides a performance boost due to the slow PL/SQL string operations required for the common key
867: **/
868: dbms_sql.column_value(i_select_cursor,1,v_dummy_tp_code);
869: dbms_sql.column_value(i_select_cursor,2,v_dummy_key_staging);
870: Select_Common_key(
871: i_level,
872: v_dummy_tp_code,

Line 869: dbms_sql.column_value(i_select_cursor,2,v_dummy_key_staging);

865: /** You can comment out this call if you don't want the Common Key to be formatted on the flat file.
866: This is provides a performance boost due to the slow PL/SQL string operations required for the common key
867: **/
868: dbms_sql.column_value(i_select_cursor,1,v_dummy_tp_code);
869: dbms_sql.column_value(i_select_cursor,2,v_dummy_key_staging);
870: Select_Common_key(
871: i_level,
872: v_dummy_tp_code,
873: v_dummy_key_staging,

Line 882: dbms_sql.column_value(i_select_cursor,m,v_dummy(m));

878: end if;
879:
880: FOR m IN 3..i_level_info(i_level).total_records + 2
881: LOOP
882: dbms_sql.column_value(i_select_cursor,m,v_dummy(m));
883: UTL_FILE.PUT_LINE(u_file_handle,i_common_key||v_dummy(m));
884: END LOOP;
885: END LOOP;
886: EXCEPTION

Line 904: IF dbms_sql.IS_OPEN(i_select_cursor)

900: EXCEPTION
901: WHEN EC_UTILS.PROGRAM_EXIT THEN
902: raise;
903: WHEN OTHERS THEN
904: IF dbms_sql.IS_OPEN(i_select_cursor)
905: then
906: dbms_sql.close_cursor(i_select_cursor);
907: end if;
908: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

Line 906: dbms_sql.close_cursor(i_select_cursor);

902: raise;
903: WHEN OTHERS THEN
904: IF dbms_sql.IS_OPEN(i_select_cursor)
905: then
906: dbms_sql.close_cursor(i_select_cursor);
907: end if;
908: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
909: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
910: EC_UTILS.i_ret_code:=2;