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

Line 71: i_Insert_Cursor := dbms_sql.Open_Cursor;

67: /**
68: Open the cursor and parse the SQL Statement. Trap any parsing error and report
69: the Error Position in the SQL Statement
70: **/
71: i_Insert_Cursor := dbms_sql.Open_Cursor;
72:
73: if ec_debug.G_debug_level = 3 then
74: ec_debug.pl(3,'i_insert_cursor',i_insert_cursor);
75: end if;

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

76:
77: ec_utils.g_ext_levels(i_level).cursor_handle := i_insert_cursor;
78:
79: begin
80: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
81: exception
82: when others then
83: error_position := dbms_sql.last_error_position;
84: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');

Line 83: error_position := dbms_sql.last_error_position;

79: begin
80: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
81: exception
82: when others then
83: error_position := dbms_sql.last_error_position;
84: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');
85: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
86: ec_utils.i_ret_code :=2;
87: raise EC_UTILS.PROGRAM_EXIT;

Line 203: ec_utils.g_int_levels(i).Cursor_handle := dbms_sql.open_cursor;

199: );
200:
201:
202: -- Open Cursor For Each level and store the handles in the PL/SQL table.
203: ec_utils.g_int_levels(i).Cursor_handle := dbms_sql.open_cursor;
204: if ec_debug.G_debug_level = 3 then
205: ec_debug.pl(3,'Cursor handle',ec_utils.g_int_levels(i).Cursor_handle);
206: end if;
207:

Line 210: dbms_sql.parse (

206: end if;
207:
208: -- Parse the Select Statement for Each level
209: BEGIN
210: dbms_sql.parse (
211: ec_utils.g_int_levels(i).cursor_handle,
212: ec_utils.g_int_levels(i).sql_stmt,
213: dbms_sql.native
214: );

Line 213: dbms_sql.native

209: BEGIN
210: dbms_sql.parse (
211: ec_utils.g_int_levels(i).cursor_handle,
212: ec_utils.g_int_levels(i).sql_stmt,
213: dbms_sql.native
214: );
215: EXCEPTION
216: WHEN OTHERS THEN
217: ece_error_handling_pvt.print_parse_error

Line 219: dbms_sql.last_error_position,

215: EXCEPTION
216: WHEN OTHERS THEN
217: ece_error_handling_pvt.print_parse_error
218: (
219: dbms_sql.last_error_position,
220: ec_utils.g_int_levels(i).sql_stmt
221: );
222: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.LOAD_OBJECTS');
223: ec_debug.pl(0,'EC','ECE_PARSE_VIEW_ERROR','LEVEL',i);

Line 232: dbms_sql.define_column

228: -- Define Columns for Each Level
229: FOR k in ec_utils.g_int_levels(i).file_start_pos..ec_utils.g_int_levels(i).file_end_pos
230: LOOP
231: i_counter := i_counter + 1;
232: dbms_sql.define_column
233: (
234: ec_utils.g_int_levels(i).Cursor_Handle,
235: i_counter,
236: ec_utils.g_int_levels(i).sql_stmt,

Line 289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));

285: end if;
286:
287: begin
288: -- Bind values for Mandatory Columns
289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));
290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));

Line 290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));

286:
287: begin
288: -- Bind values for Mandatory Columns
289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));
290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);

Line 291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);

287: begin
288: -- Bind values for Mandatory Columns
289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));
290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);

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

288: -- Bind values for Mandatory Columns
289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));
290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);

Line 293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));

289: dbms_sql.bind_variable (i_Insert_Cursor,'a1',to_number(ec_utils.g_ext_levels(i_level).Stage_Id));
290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);

Line 294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);

290: dbms_sql.bind_variable (i_Insert_Cursor,'a2',to_number(ec_utils.g_ext_levels(i_level).Document_Id));
291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:

Line 295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);

291: dbms_sql.bind_variable (i_Insert_Cursor,'a3',ec_utils.g_transaction_type);
292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns

Line 296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);

292: dbms_sql.bind_variable (i_Insert_Cursor,'a4',to_number(i_level));
293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);

Line 297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);

293: dbms_sql.bind_variable (i_Insert_Cursor,'a5',to_number(ec_utils.g_ext_levels(i_level).Line_Number));
294: dbms_sql.bind_variable (i_Insert_Cursor,'a6',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
295: dbms_sql.bind_variable (i_Insert_Cursor,'a7',ec_utils.g_run_id);
296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);

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

296: dbms_sql.bind_variable (i_Insert_Cursor,'a8',ec_utils.g_ext_levels(i_level).Document_Number);
297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:

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

297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:
305: if ec_debug.G_debug_level = 3 then

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

298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:
305: if ec_debug.G_debug_level = 3 then
306: ec_debug.pl(3,'STAGE_ID',ec_utils.g_ext_levels(i_level).Stage_Id);

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

299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:
305: if ec_debug.G_debug_level = 3 then
306: ec_debug.pl(3,'STAGE_ID',ec_utils.g_ext_levels(i_level).Stage_Id);
307: ec_debug.pl(3,'DOCUMENT_ID',ec_utils.g_ext_levels(i_level).Document_Id);

Line 326: dbms_sql.bind_variable (

322: loop
323: if ( ec_utils.g_file_tbl(k).staging_column is not null)
324: then
325: ins_value := replace(replace(replace(ec_utils.g_file_tbl(k).value,c_local_chr_10,''),c_local_chr_9,''),c_local_chr_13,'');
326: dbms_sql.bind_variable (
327: i_Insert_Cursor,
328: 'b'||k,ins_value,
329: 500
330: );

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

335: end if;
336: end if;
337: end loop;
338:
339: dummy := dbms_sql.execute(i_Insert_Cursor);
340: if dummy = 1 then
341: if ec_debug.G_debug_level = 3 then
342: ec_debug.pl(3,'EC','ECE_STAGE_INSERTED',null);
343: end if;

Line 530: i_rows_processed := dbms_sql.execute (ec_utils.g_int_levels(i).Cursor_Handle);

526: 20,
527: i
528: );
529:
530: i_rows_processed := dbms_sql.execute (ec_utils.g_int_levels(i).Cursor_Handle);
531: if ec_debug.G_debug_level = 3 then
532: ec_debug.pl(3,'Cursor Handle',ec_utils.g_int_levels(i).Cursor_handle);
533: end if;
534: while dbms_sql.fetch_rows( ec_utils.g_int_levels(i).Cursor_handle) > 0

Line 534: while dbms_sql.fetch_rows( ec_utils.g_int_levels(i).Cursor_handle) > 0

530: i_rows_processed := dbms_sql.execute (ec_utils.g_int_levels(i).Cursor_Handle);
531: if ec_debug.G_debug_level = 3 then
532: ec_debug.pl(3,'Cursor Handle',ec_utils.g_int_levels(i).Cursor_handle);
533: end if;
534: while dbms_sql.fetch_rows( ec_utils.g_int_levels(i).Cursor_handle) > 0
535: LOOP
536: if ec_debug.G_debug_level = 3 then
537: ec_debug.pl(3,'Processing Row: '||dbms_sql.last_row_count||' for Level '||
538: ec_utils.g_int_levels(i).interface_level);

Line 537: ec_debug.pl(3,'Processing Row: '||dbms_sql.last_row_count||' for Level '||

533: end if;
534: while dbms_sql.fetch_rows( ec_utils.g_int_levels(i).Cursor_handle) > 0
535: LOOP
536: if ec_debug.G_debug_level = 3 then
537: ec_debug.pl(3,'Processing Row: '||dbms_sql.last_row_count||' for Level '||
538: ec_utils.g_int_levels(i).interface_level);
539: end if;
540: -- Get Values from the View
541: -- Initialize the Column Counter

Line 547: dbms_sql.column_value

543: for j in ec_utils.g_int_levels(i).file_start_pos..ec_utils.g_int_levels(i).file_end_pos
544: loop
545: i_column_counter := i_column_counter + 1;
546:
547: dbms_sql.column_value
548: (
549: ec_utils.g_int_levels(i).Cursor_handle,
550: i_column_counter,
551: ec_utils.g_file_tbl(j).value

Line 701: ec_utils.g_int_levels(i).rows_processed := dbms_sql.last_row_count;

697:
698: END LOOP;
699: if i = 1
700: then
701: ec_utils.g_int_levels(i).rows_processed := dbms_sql.last_row_count;
702: else
703: ec_utils.g_int_levels(i).rows_processed :=
704: ec_utils.g_int_levels(i).rows_processed + dbms_sql.last_row_count;
705: end if;

Line 704: ec_utils.g_int_levels(i).rows_processed + dbms_sql.last_row_count;

700: then
701: ec_utils.g_int_levels(i).rows_processed := dbms_sql.last_row_count;
702: else
703: ec_utils.g_int_levels(i).rows_processed :=
704: ec_utils.g_int_levels(i).rows_processed + dbms_sql.last_row_count;
705: end if;
706:
707: END IF;
708: end loop;

Line 739: if dbms_sql.IS_OPEN(ec_utils.g_procedure_stack(i).Cursor_Handle)

735: **/
736:
737: for i in 1..ec_utils.g_procedure_stack.COUNT
738: loop
739: if dbms_sql.IS_OPEN(ec_utils.g_procedure_stack(i).Cursor_Handle)
740: then
741: dbms_sql.close_cursor(ec_utils.g_procedure_stack(i).Cursor_Handle);
742: end if;
743: end loop;

Line 741: dbms_sql.close_cursor(ec_utils.g_procedure_stack(i).Cursor_Handle);

737: for i in 1..ec_utils.g_procedure_stack.COUNT
738: loop
739: if dbms_sql.IS_OPEN(ec_utils.g_procedure_stack(i).Cursor_Handle)
740: then
741: dbms_sql.close_cursor(ec_utils.g_procedure_stack(i).Cursor_Handle);
742: end if;
743: end loop;
744:
745: for i in 1..ec_utils.g_int_levels.COUNT

Line 747: if dbms_sql.IS_OPEN(ec_utils.g_int_levels(i).Cursor_Handle)

743: end loop;
744:
745: for i in 1..ec_utils.g_int_levels.COUNT
746: loop
747: if dbms_sql.IS_OPEN(ec_utils.g_int_levels(i).Cursor_Handle)
748: then
749: dbms_sql.close_cursor(ec_utils.g_int_levels(i).Cursor_Handle);
750: end if;
751: end loop;

Line 749: dbms_sql.close_cursor(ec_utils.g_int_levels(i).Cursor_Handle);

745: for i in 1..ec_utils.g_int_levels.COUNT
746: loop
747: if dbms_sql.IS_OPEN(ec_utils.g_int_levels(i).Cursor_Handle)
748: then
749: dbms_sql.close_cursor(ec_utils.g_int_levels(i).Cursor_Handle);
750: end if;
751: end loop;
752:
753: for i in 1..ec_utils.g_ext_levels.COUNT

Line 756: if dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).cursor_handle)

752:
753: for i in 1..ec_utils.g_ext_levels.COUNT
754: loop
755:
756: if dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).cursor_handle)
757: then
758: dbms_sql.close_cursor(ec_utils.g_ext_levels(i).cursor_handle);
759: end if;
760: end loop;

Line 758: dbms_sql.close_cursor(ec_utils.g_ext_levels(i).cursor_handle);

754: loop
755:
756: if dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).cursor_handle)
757: then
758: dbms_sql.close_cursor(ec_utils.g_ext_levels(i).cursor_handle);
759: end if;
760: end loop;
761: if ec_debug.G_debug_level >= 2 then
762: ec_debug.pop('EC_OUTBOUND.CLOSE_OUTBOUND');

Line 887: expense parsing of dbms_sql package. The RUN_ID parameter is the only required parameter.

883: end process_outbound_documents;
884:
885: /**
886: This file will delete all records in a staging table without using the
887: expense parsing of dbms_sql package. The RUN_ID parameter is the only required parameter.
888: The DOCUMENT_ID parameter can be optionally used to delete one document from the staging table
889: at a time.
890: **/
891: procedure delete_stage_data