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_INBOUND_STAGE dependencies on DBMS_SQL

Line 567: IF dbms_sql.IS_OPEN(i_level_info(i).Insert_Cursor)

563: Cursors for the all the Level are closed using these Cursor handles.
564: **/
565: For i in 1..i_level_info.COUNT
566: loop
567: IF dbms_sql.IS_OPEN(i_level_info(i).Insert_Cursor)
568: then
569: dbms_sql.Close_cursor(i_level_info(i).Insert_Cursor);
570: end if;
571: end loop;

Line 569: dbms_sql.Close_cursor(i_level_info(i).Insert_Cursor);

565: For i in 1..i_level_info.COUNT
566: loop
567: IF dbms_sql.IS_OPEN(i_level_info(i).Insert_Cursor)
568: then
569: dbms_sql.Close_cursor(i_level_info(i).Insert_Cursor);
570: end if;
571: end loop;
572:
573: /**

Line 998: i_Insert_Cursor := dbms_sql.Open_Cursor;

994: /**
995: Open the cursor and parse the SQL Statement. Trap any parsing error and report
996: the Error Position in the SQL Statement
997: **/
998: i_Insert_Cursor := dbms_sql.Open_Cursor;
999: begin
1000: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
1001: exception
1002: when others then

Line 1000: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);

996: the Error Position in the SQL Statement
997: **/
998: i_Insert_Cursor := dbms_sql.Open_Cursor;
999: begin
1000: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
1001: exception
1002: when others then
1003: error_position := dbms_sql.last_error_position;
1004: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

Line 1003: error_position := dbms_sql.last_error_position;

999: begin
1000: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
1001: exception
1002: when others then
1003: error_position := dbms_sql.last_error_position;
1004: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1005: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
1006: EC_UTILS.i_ret_code :=2;
1007: raise EC_UTILS.PROGRAM_EXIT;

Line 1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));

1019: end if;
1020:
1021: -- Bind values for Mandatory Columns
1022:
1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));
1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));

Line 1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);

1020:
1021: -- Bind values for Mandatory Columns
1022:
1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));
1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));

Line 1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));

1021: -- Bind values for Mandatory Columns
1022:
1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));
1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));

Line 1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);

1022:
1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));
1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);

Line 1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));

1023: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(i_level_info(i_level).Stage_Id));
1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);

Line 1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));

1024: dbms_sql.bind_variable (i_Insert_Cursor,'a6',i_level_info(i_level).Parent_Stage_Id);
1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);

Line 1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));

1025: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(i_level_info(i_level).Document_Id));
1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);
1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);

Line 1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);

1026: dbms_sql.bind_variable (i_Insert_Cursor,'a3',i_level_info(i_level).Transaction_Type);
1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);
1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);
1034:

Line 1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);

1027: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);
1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);
1034:
1035: -- Bind values for Mandatory Columns

Line 1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);

1028: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(i_level_info(i_level).Line_Number));
1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);
1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);
1034:
1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898

Line 1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);

1029: dbms_sql.bind_variable (i_Insert_Cursor,'a7',to_number(i_level_info(i_level).Run_Id));
1030: dbms_sql.bind_variable (i_Insert_Cursor,'a8',i_level_info(i_level).Document_Number);
1031: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_level_info(i_level).Status);
1032: dbms_sql.bind_variable (i_Insert_Cursor,'a10',i_level_info(i_level).Tp_Code);
1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);
1034:
1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);

Line 1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);

1033: dbms_sql.bind_variable (i_Insert_Cursor,'a11',i_map_id);
1034:
1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */

Line 1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);

1034:
1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */
1042:

Line 1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);

1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */
1042:
1043: if EC_DEBUG.G_debug_level >= 3 then

Line 1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);

1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */
1042:
1043: if EC_DEBUG.G_debug_level >= 3 then
1044: ec_debug.pl(3,'STAGE_ID',i_level_info(i_level).Stage_Id);

Line 1065: dbms_sql.bind_variable (

1061: for k in 1..i_stage_record_type.COUNT
1062: loop
1063: if i_stage_record_type(k).external_level = i_level
1064: then
1065: dbms_sql.bind_variable (
1066: i_Insert_Cursor,
1067: 'b'||k,
1068: i_stage_record_type(k).value
1069: );

Line 1088: dummy := dbms_sql.execute(i_Insert_Cursor);

1084: end if;
1085: end if;
1086: end loop;
1087:
1088: dummy := dbms_sql.execute(i_Insert_Cursor);
1089: if dummy = 1 then
1090: if EC_DEBUG.G_debug_level = 3 then
1091: ec_debug.pl(3,'EC','ECE_STAGE_INSERTED',null);
1092: end if;

Line 1120: IF dbms_sql.IS_OPEN(i_insert_cursor)

1116: EXCEPTION
1117: WHEN EC_UTILS.PROGRAM_EXIT then
1118: raise;
1119: WHEN OTHERS then
1120: IF dbms_sql.IS_OPEN(i_insert_cursor)
1121: then
1122: dbms_sql.close_cursor(i_insert_cursor);
1123: end if;
1124: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

Line 1122: dbms_sql.close_cursor(i_insert_cursor);

1118: raise;
1119: WHEN OTHERS then
1120: IF dbms_sql.IS_OPEN(i_insert_cursor)
1121: then
1122: dbms_sql.close_cursor(i_insert_cursor);
1123: end if;
1124: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1125: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1126: EC_UTILS.i_ret_code:=2;