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

Line 58: IF dbms_sql.IS_OPEN(i_select_cursor)

54: ec_utils.g_file_tbl := m_file_tbl_empty;
55:
56: close_inbound;
57:
58: IF dbms_sql.IS_OPEN(i_select_cursor)
59: then
60: dbms_sql.close_cursor(i_select_cursor);
61: end if;
62: if ec_debug.G_debug_level >= 2 then

Line 60: dbms_sql.close_cursor(i_select_cursor);

56: close_inbound;
57:
58: IF dbms_sql.IS_OPEN(i_select_cursor)
59: then
60: dbms_sql.close_cursor(i_select_cursor);
61: end if;
62: if ec_debug.G_debug_level >= 2 then
63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
64: end if;

Line 148: IF dbms_sql.IS_OPEN(i_select_cursor)

144: Close the Cursors and print the information.
145: **/
146: close_inbound;
147:
148: IF dbms_sql.IS_OPEN(i_select_cursor)
149: then
150: dbms_sql.close_cursor(i_select_cursor);
151: end if;
152: if ec_debug.G_debug_level >= 2 then

Line 150: dbms_sql.close_cursor(i_select_cursor);

146: close_inbound;
147:
148: IF dbms_sql.IS_OPEN(i_select_cursor)
149: then
150: dbms_sql.close_cursor(i_select_cursor);
151: end if;
152: if ec_debug.G_debug_level >= 2 then
153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
154: end if;

Line 311: IF dbms_sql.IS_OPEN(i_select_cursor)

307: Close the Cursors and print the information.
308: **/
309: close_inbound;
310:
311: IF dbms_sql.IS_OPEN(i_select_cursor)
312: then
313: dbms_sql.close_cursor(i_select_cursor);
314: end if;
315: if ec_debug.G_debug_level >= 2 then

Line 313: dbms_sql.close_cursor(i_select_cursor);

309: close_inbound;
310:
311: IF dbms_sql.IS_OPEN(i_select_cursor)
312: then
313: dbms_sql.close_cursor(i_select_cursor);
314: end if;
315: if ec_debug.G_debug_level >= 2 then
316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');
317: end if;

Line 399: IF dbms_sql.IS_OPEN(i_select_cursor)

395: Close the Cursors and print the information.
396: **/
397: close_inbound;
398:
399: IF dbms_sql.IS_OPEN(i_select_cursor)
400: then
401: dbms_sql.close_cursor(i_select_cursor);
402: end if;
403: if ec_debug.G_debug_level >= 2 then

Line 401: dbms_sql.close_cursor(i_select_cursor);

397: close_inbound;
398:
399: IF dbms_sql.IS_OPEN(i_select_cursor)
400: then
401: dbms_sql.close_cursor(i_select_cursor);
402: end if;
403: if ec_debug.G_debug_level >= 2 then
404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
405: end if;

Line 485: IF dbms_sql.IS_OPEN(i_select_cursor)

481: Close the Cursors and print the information.
482: **/
483: close_inbound;
484:
485: IF dbms_sql.IS_OPEN(i_select_cursor)
486: then
487: dbms_sql.close_cursor(i_select_cursor);
488: end if;
489: if ec_debug.G_debug_level >= 2 then

Line 487: dbms_sql.close_cursor(i_select_cursor);

483: close_inbound;
484:
485: IF dbms_sql.IS_OPEN(i_select_cursor)
486: then
487: dbms_sql.close_cursor(i_select_cursor);
488: end if;
489: if ec_debug.G_debug_level >= 2 then
490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
491: end if;

Line 635: IF dbms_sql.IS_OPEN(i_select_cursor)

631: Close the Cursors and print the information.
632: **/
633: close_inbound;
634:
635: IF dbms_sql.IS_OPEN(i_select_cursor)
636: then
637: dbms_sql.close_cursor(i_select_cursor);
638: end if;
639: if ec_debug.G_debug_level >= 2 then

Line 637: dbms_sql.close_cursor(i_select_cursor);

633: close_inbound;
634:
635: IF dbms_sql.IS_OPEN(i_select_cursor)
636: then
637: dbms_sql.close_cursor(i_select_cursor);
638: end if;
639: if ec_debug.G_debug_level >= 2 then
640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
641: end if;

Line 721: dbms_sql.bind_variable(i_select_cursor,'i_document_id',i_document_id);

717: g_col_rule_viol_tbl(i_count).interface_col_id := i_ignore_rule.interface_column_id;
718: i_count := i_count + 1;
719: END LOOP;
720:
721: dbms_sql.bind_variable(i_select_cursor,'i_document_id',i_document_id);
722:
723: dummy := dbms_sql.execute(i_select_cursor);
724: while dbms_sql.fetch_rows(i_select_cursor) > 0
725: loop

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

719: END LOOP;
720:
721: dbms_sql.bind_variable(i_select_cursor,'i_document_id',i_document_id);
722:
723: dummy := dbms_sql.execute(i_select_cursor);
724: while dbms_sql.fetch_rows(i_select_cursor) > 0
725: loop
726:
727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);

Line 724: while dbms_sql.fetch_rows(i_select_cursor) > 0

720:
721: dbms_sql.bind_variable(i_select_cursor,'i_document_id',i_document_id);
722:
723: dummy := dbms_sql.execute(i_select_cursor);
724: while dbms_sql.fetch_rows(i_select_cursor) > 0
725: loop
726:
727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);
728:

Line 727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);

723: dummy := dbms_sql.execute(i_select_cursor);
724: while dbms_sql.fetch_rows(i_select_cursor) > 0
725: loop
726:
727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);
728:
729: dbms_sql.column_value(i_select_cursor,2,i_document_number);
730:
731: dbms_sql.column_value(i_select_cursor,3,i_level);

Line 729: dbms_sql.column_value(i_select_cursor,2,i_document_number);

725: loop
726:
727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);
728:
729: dbms_sql.column_value(i_select_cursor,2,i_document_number);
730:
731: dbms_sql.column_value(i_select_cursor,3,i_level);
732:
733: dbms_sql.column_value(i_select_cursor,4,i_line_number);

Line 731: dbms_sql.column_value(i_select_cursor,3,i_level);

727: dbms_sql.column_value(i_select_cursor,1,i_stage_id);
728:
729: dbms_sql.column_value(i_select_cursor,2,i_document_number);
730:
731: dbms_sql.column_value(i_select_cursor,3,i_level);
732:
733: dbms_sql.column_value(i_select_cursor,4,i_line_number);
734:
735: dbms_sql.column_value(i_select_cursor,5,i_status);

Line 733: dbms_sql.column_value(i_select_cursor,4,i_line_number);

729: dbms_sql.column_value(i_select_cursor,2,i_document_number);
730:
731: dbms_sql.column_value(i_select_cursor,3,i_level);
732:
733: dbms_sql.column_value(i_select_cursor,4,i_line_number);
734:
735: dbms_sql.column_value(i_select_cursor,5,i_status);
736:
737: dbms_sql.column_value(i_select_cursor,6,i_map_id);

Line 735: dbms_sql.column_value(i_select_cursor,5,i_status);

731: dbms_sql.column_value(i_select_cursor,3,i_level);
732:
733: dbms_sql.column_value(i_select_cursor,4,i_line_number);
734:
735: dbms_sql.column_value(i_select_cursor,5,i_status);
736:
737: dbms_sql.column_value(i_select_cursor,6,i_map_id);
738:
739: if ec_debug.G_debug_level = 3 then

Line 737: dbms_sql.column_value(i_select_cursor,6,i_map_id);

733: dbms_sql.column_value(i_select_cursor,4,i_line_number);
734:
735: dbms_sql.column_value(i_select_cursor,5,i_status);
736:
737: dbms_sql.column_value(i_select_cursor,6,i_map_id);
738:
739: if ec_debug.G_debug_level = 3 then
740: ec_debug.pl(3,'i_stage_id',i_stage_id);
741: ec_debug.pl(3,'i_document_number',i_document_number);

Line 852: Pass this to the DBMS_SQL call to get the Column Value.

848: select Stage_Id,Document_Number,transaction_level,Line_number,Status,map_id,
849: Field1,Field2,Field3........Field500 from ece_stage;
850: To extract Field3 , first Find out the relative position of the Column
851: in the Select Statement which is 6 + 3 ( 3 for Field3 , 5 for Field5).
852: Pass this to the DBMS_SQL call to get the Column Value.
853: **/
854: if ec_debug.G_debug_level = 3 then
855: ec_debug.pl(3,'EC','ECE_FIELDS_EXTRACTED_STAGING',null);
856: end if;

Line 867: dbms_sql.column_value(

863: ec_utils.g_file_tbl(i).Staging_Column,
864: 6,
865: length(ec_utils.g_file_tbl(i).Staging_Column)-5));
866:
867: dbms_sql.column_value(
868: i_select_cursor,
869: i_field_number+6,
870: ec_utils.g_file_tbl(i).value
871: );

Line 874: dbms_sql.column_value(

870: ec_utils.g_file_tbl(i).value
871: );
872: */
873:
874: dbms_sql.column_value(
875: i_select_cursor,
876: ec_utils.g_file_tbl(i).staging_column_no+6,
877: ec_utils.g_file_tbl(i).value
878: );

Line 1183: i_total_records := dbms_sql.last_row_count;

1179: end if;
1180:
1181: end if;
1182:
1183: i_total_records := dbms_sql.last_row_count;
1184: if ec_debug.G_debug_level >= 1 then
1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);
1186:
1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');

Line 1468: IF dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).Cursor_Handle)

1464: Cursors for the all the Level are closed using these Cursor handles.
1465: **/
1466: For i in 1..ec_utils.g_ext_levels.COUNT
1467: loop
1468: IF dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).Cursor_Handle)
1469: then
1470: dbms_sql.Close_cursor(ec_utils.g_ext_levels(i).Cursor_Handle);
1471: end if;
1472: end loop;

Line 1470: dbms_sql.Close_cursor(ec_utils.g_ext_levels(i).Cursor_Handle);

1466: For i in 1..ec_utils.g_ext_levels.COUNT
1467: loop
1468: IF dbms_sql.IS_OPEN(ec_utils.g_ext_levels(i).Cursor_Handle)
1469: then
1470: dbms_sql.Close_cursor(ec_utils.g_ext_levels(i).Cursor_Handle);
1471: end if;
1472: end loop;
1473:
1474: if ec_debug.G_debug_level >= 2 then

Line 1917: i_Cursor_handle := dbms_sql.Open_Cursor;

1913: Open the cursor and parse the SQL Statement. Trap any parsing error and
1914: report the Error Position in the SQL Statement
1915: **/
1916:
1917: i_Cursor_handle := dbms_sql.Open_Cursor;
1918:
1919: BEGIN
1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);
1921: EXCEPTION

Line 1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);

1916:
1917: i_Cursor_handle := dbms_sql.Open_Cursor;
1918:
1919: BEGIN
1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: error_position := dbms_sql.last_error_position;
1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');

Line 1923: error_position := dbms_sql.last_error_position;

1919: BEGIN
1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: error_position := dbms_sql.last_error_position;
1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1925: ece_error_handling_pvt.print_parse_error (error_position,i_Select_Stmt);
1926: ec_utils.i_ret_code :=2;
1927: raise EC_UTILS.PROGRAM_EXIT;

Line 1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);

1929:
1930: /**
1931: Define Columns used in the Select Clause
1932: **/
1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);
1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);

Line 1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);

1930: /**
1931: Define Columns used in the Select Clause
1932: **/
1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);
1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);

Line 1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);

1931: Define Columns used in the Select Clause
1932: **/
1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);
1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);
1939: for i in 7..506

Line 1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);

1932: **/
1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);
1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);
1939: for i in 7..506
1940: loop

Line 1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);

1933: dbms_sql.define_column(i_Cursor_Handle,1,i_stage_id);
1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);
1939: for i in 7..506
1940: loop
1941: dbms_sql.define_column(i_Cursor_Handle,i,i_columns,500);

Line 1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);

1934: dbms_sql.define_column(i_Cursor_Handle,2,i_document_number,500);
1935: dbms_sql.define_column(i_Cursor_Handle,3,i_level);
1936: dbms_sql.define_column(i_Cursor_Handle,4,i_line_number);
1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);
1939: for i in 7..506
1940: loop
1941: dbms_sql.define_column(i_Cursor_Handle,i,i_columns,500);
1942: end loop;

Line 1941: dbms_sql.define_column(i_Cursor_Handle,i,i_columns,500);

1937: dbms_sql.define_column(i_Cursor_Handle,5,i_status,20);
1938: dbms_sql.define_column(i_Cursor_Handle,6,i_map_id);
1939: for i in 7..506
1940: loop
1941: dbms_sql.define_column(i_Cursor_Handle,i,i_columns,500);
1942: end loop;
1943:
1944: ec_debug.pl(3,'Select Statement',i_select_stmt);
1945:

Line 2015: i_Insert_Cursor := dbms_sql.open_cursor;

2011: if ec_debug.G_debug_level = 3 then
2012: ec_debug.pl(3,'Insert_Statement',cInsert_stmt);
2013: end if;
2014:
2015: i_Insert_Cursor := dbms_sql.open_cursor;
2016:
2017: begin
2018: dbms_sql.parse(i_Insert_Cursor, cInsert_stmt, dbms_sql.native);
2019: exception

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

2014:
2015: i_Insert_Cursor := dbms_sql.open_cursor;
2016:
2017: begin
2018: dbms_sql.parse(i_Insert_Cursor, cInsert_stmt, dbms_sql.native);
2019: exception
2020: when others then
2021: error_position := dbms_sql.last_error_position;
2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

Line 2021: error_position := dbms_sql.last_error_position;

2017: begin
2018: dbms_sql.parse(i_Insert_Cursor, cInsert_stmt, dbms_sql.native);
2019: exception
2020: when others then
2021: error_position := dbms_sql.last_error_position;
2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2024: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
2025: ec_utils.i_ret_code :=2;

Line 2053: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, d_date);

2049: end if;
2050: if ec_debug.G_debug_level = 3 then
2051: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,d_date);
2052: end if;
2053: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, d_date);
2054:
2055: elsif 'NUMBER' = ec_utils.g_file_tbl(k).data_type
2056: then
2057: if ec_utils.g_file_tbl(k).value is not NULL

Line 2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);

2062: end if;
2063: if ec_debug.G_debug_level = 3 then
2064: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,n_number);
2065: end if;
2066: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k, n_number);
2067:
2068: else
2069: if ec_debug.G_debug_level = 3 then
2070: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);

Line 2072: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k,ec_utils.g_file_tbl(k).value);

2068: else
2069: if ec_debug.G_debug_level = 3 then
2070: ec_debug.pl(3,ec_utils.g_file_tbl(k).Base_Column_Name,ec_utils.g_file_tbl(k).value);
2071: end if;
2072: dbms_sql.bind_variable(i_Insert_Cursor, 'b'||k,ec_utils.g_file_tbl(k).value);
2073: end if; -- End If for Data Type
2074:
2075: EXCEPTION
2076: WHEN OTHERS then

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

2082:
2083: end if; -- End if for i_level and Base Table Name
2084:
2085: end loop;
2086: dummy := dbms_sql.execute(i_Insert_Cursor);
2087:
2088: end;
2089:
2090: end if;