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

Line 693: -- dbms_sql (Native Oracle db functions that come with every Oracle Apps)

689: -- :po_header_id is a place holder for foreign key value.
690: -- A PL/SQL table (list of values) will be used to store data.
691: -- Procedure ece_flatfile.Find_pos will be used to locate the specific
692: -- data value in the PL/SQL table.
693: -- dbms_sql (Native Oracle db functions that come with every Oracle Apps)
694: -- dbms_sql.bind_variable will be used to assign data value to :transaction_id.
695: --
696: -- Let's use the above example:
697: --

Line 694: -- dbms_sql.bind_variable will be used to assign data value to :transaction_id.

690: -- A PL/SQL table (list of values) will be used to store data.
691: -- Procedure ece_flatfile.Find_pos will be used to locate the specific
692: -- data value in the PL/SQL table.
693: -- dbms_sql (Native Oracle db functions that come with every Oracle Apps)
694: -- dbms_sql.bind_variable will be used to assign data value to :transaction_id.
695: --
696: -- Let's use the above example:
697: --
698: -- 1. Execute dynamic SQL 1 for headers (A) data

Line 803: header_sel_c := dbms_sql.open_cursor;

799: -- *** This tells the database to reserve spaces
800: -- *** for the data returned by the SQL statement
801: -- ***************************************************
802: xProgress := 'POCOB-10-1200';
803: header_sel_c := dbms_sql.open_cursor;
804:
805: xProgress := 'POCOB-10-1210';
806: line_sel_c := dbms_sql.open_cursor;
807:

Line 806: line_sel_c := dbms_sql.open_cursor;

802: xProgress := 'POCOB-10-1200';
803: header_sel_c := dbms_sql.open_cursor;
804:
805: xProgress := 'POCOB-10-1210';
806: line_sel_c := dbms_sql.open_cursor;
807:
808: xProgress := 'POCOB-10-1220';
809: shipment_sel_c := dbms_sql.open_cursor;
810:

Line 809: shipment_sel_c := dbms_sql.open_cursor;

805: xProgress := 'POCOB-10-1210';
806: line_sel_c := dbms_sql.open_cursor;
807:
808: xProgress := 'POCOB-10-1220';
809: shipment_sel_c := dbms_sql.open_cursor;
810:
811: -- ***************************************************
812: -- Parse each of the SELECT statement
813: -- so the database understands the command

Line 817: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);

813: -- so the database understands the command
814: -- ***************************************************
815: xProgress := 'POCOB-10-1230';
816: BEGIN
817: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);
818:
819: EXCEPTION
820: WHEN OTHERS THEN
821: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);

Line 821: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);

817: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);
818:
819: EXCEPTION
820: WHEN OTHERS THEN
821: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);
822: app_exception.raise_exception;
823: END;
824:
825: xProgress := 'POCOB-10-1240';

Line 827: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);

823: END;
824:
825: xProgress := 'POCOB-10-1240';
826: BEGIN
827: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);
828:
829: EXCEPTION
830: WHEN OTHERS THEN
831: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);

Line 831: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);

827: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);
828:
829: EXCEPTION
830: WHEN OTHERS THEN
831: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);
832: app_exception.raise_exception;
833: END;
834:
835: xProgress := 'POCOB-10-1250';

Line 837: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);

833: END;
834:
835: xProgress := 'POCOB-10-1250';
836: BEGIN
837: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);
838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);

Line 841: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);

837: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);
838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);
842: app_exception.raise_exception;
843: END;
844:
845: -- ************

Line 1240: dbms_sql.bind_variable(header_sel_c,'cComm_Method',cCommunication_Method);

1236: xProgress := 'POCOB-09-1402';
1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1238:
1239: xProgress := 'POCOB-10-1413';
1240: dbms_sql.bind_variable(header_sel_c,'cComm_Method',cCommunication_Method);
1241: IF cRevised_Date_From IS NOT NULL THEN
1242: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_From',cRevised_Date_From);
1243: END IF;
1244:

Line 1242: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_From',cRevised_Date_From);

1238:
1239: xProgress := 'POCOB-10-1413';
1240: dbms_sql.bind_variable(header_sel_c,'cComm_Method',cCommunication_Method);
1241: IF cRevised_Date_From IS NOT NULL THEN
1242: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_From',cRevised_Date_From);
1243: END IF;
1244:
1245: IF cRevised_Date_To IS NOT NULL THEN
1246: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_To',cRevised_Date_To);

Line 1246: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_To',cRevised_Date_To);

1242: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_From',cRevised_Date_From);
1243: END IF;
1244:
1245: IF cRevised_Date_To IS NOT NULL THEN
1246: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_To',cRevised_Date_To);
1247: END IF;
1248:
1249: IF cSupplier_Name IS NOT NULL THEN
1250: dbms_sql.bind_variable(header_sel_c,'cSuppl_Name',cSupplier_Name);

Line 1250: dbms_sql.bind_variable(header_sel_c,'cSuppl_Name',cSupplier_Name);

1246: dbms_sql.bind_variable(header_sel_c,'cRevised_Dt_To',cRevised_Date_To);
1247: END IF;
1248:
1249: IF cSupplier_Name IS NOT NULL THEN
1250: dbms_sql.bind_variable(header_sel_c,'cSuppl_Name',cSupplier_Name);
1251: END IF;
1252:
1253: IF cSupplier_Site IS NOT NULL THEN
1254: dbms_sql.bind_variable(header_sel_c,'cSuppl_Site',cSupplier_Site);

Line 1254: dbms_sql.bind_variable(header_sel_c,'cSuppl_Site',cSupplier_Site);

1250: dbms_sql.bind_variable(header_sel_c,'cSuppl_Name',cSupplier_Name);
1251: END IF;
1252:
1253: IF cSupplier_Site IS NOT NULL THEN
1254: dbms_sql.bind_variable(header_sel_c,'cSuppl_Site',cSupplier_Site);
1255: END IF;
1256:
1257: IF cDocument_Type IS NOT NULL THEN
1258: dbms_sql.bind_variable(header_sel_c,'cDoc_Type',cDocument_Type);

Line 1258: dbms_sql.bind_variable(header_sel_c,'cDoc_Type',cDocument_Type);

1254: dbms_sql.bind_variable(header_sel_c,'cSuppl_Site',cSupplier_Site);
1255: END IF;
1256:
1257: IF cDocument_Type IS NOT NULL THEN
1258: dbms_sql.bind_variable(header_sel_c,'cDoc_Type',cDocument_Type);
1259: END IF;
1260:
1261: IF cPO_Number_From IS NOT NULL THEN
1262: dbms_sql.bind_variable(header_sel_c,'cPO_Num_From',cPO_Number_From);

Line 1262: dbms_sql.bind_variable(header_sel_c,'cPO_Num_From',cPO_Number_From);

1258: dbms_sql.bind_variable(header_sel_c,'cDoc_Type',cDocument_Type);
1259: END IF;
1260:
1261: IF cPO_Number_From IS NOT NULL THEN
1262: dbms_sql.bind_variable(header_sel_c,'cPO_Num_From',cPO_Number_From);
1263: END IF;
1264:
1265: IF cPO_Number_To IS NOT NULL THEN
1266: dbms_sql.bind_variable(header_sel_c,'cPO_Num_To',cPO_Number_To);

Line 1266: dbms_sql.bind_variable(header_sel_c,'cPO_Num_To',cPO_Number_To);

1262: dbms_sql.bind_variable(header_sel_c,'cPO_Num_From',cPO_Number_From);
1263: END IF;
1264:
1265: IF cPO_Number_To IS NOT NULL THEN
1266: dbms_sql.bind_variable(header_sel_c,'cPO_Num_To',cPO_Number_To);
1267: END IF;
1268:
1269: -- EXECUTE the SELECT statement
1270: xProgress := 'POCOB-10-1414';

Line 1271: dummy := dbms_sql.execute(header_sel_c);

1267: END IF;
1268:
1269: -- EXECUTE the SELECT statement
1270: xProgress := 'POCOB-10-1414';
1271: dummy := dbms_sql.execute(header_sel_c);
1272:
1273: -- ***************************************************
1274: -- The model is:
1275: -- HEADER - LINE - SHIPMENT ...

Line 1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header

1278: -- to the HEADER. Then get all
1279: -- SHIPMENTS that belongs to the LINE.
1280: -- ***************************************************
1281: xProgress := 'POCOB-10-1410';
1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
1283:
1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1286: end if;

Line 1510: dbms_sql.bind_variable(line_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);

1506: -- ***************************************************
1507:
1508: -- use the following bind_variable feature as you see fit.
1509: xProgress := 'POCOB-10-1510';
1510: dbms_sql.bind_variable(line_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);
1511:
1512: xProgress := 'POCOB-10-1515';
1513: dbms_sql.bind_variable(line_sel_c,'por_release_num',l_header_tbl(nRelease_num_pos).value);
1514:

Line 1513: dbms_sql.bind_variable(line_sel_c,'por_release_num',l_header_tbl(nRelease_num_pos).value);

1509: xProgress := 'POCOB-10-1510';
1510: dbms_sql.bind_variable(line_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);
1511:
1512: xProgress := 'POCOB-10-1515';
1513: dbms_sql.bind_variable(line_sel_c,'por_release_num',l_header_tbl(nRelease_num_pos).value);
1514:
1515: xProgress := 'POCOB-10-1520';
1516: dbms_sql.bind_variable(Shipment_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);
1517:

Line 1516: dbms_sql.bind_variable(Shipment_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);

1512: xProgress := 'POCOB-10-1515';
1513: dbms_sql.bind_variable(line_sel_c,'por_release_num',l_header_tbl(nRelease_num_pos).value);
1514:
1515: xProgress := 'POCOB-10-1520';
1516: dbms_sql.bind_variable(Shipment_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);
1517:
1518: xProgress := 'POOB-10-1525';
1519: dbms_sql.bind_variable(Shipment_sel_c,'por_release_id',l_header_tbl(nRelease_id_pos).value); --2823215
1520:

Line 1519: dbms_sql.bind_variable(Shipment_sel_c,'por_release_id',l_header_tbl(nRelease_id_pos).value); --2823215

1515: xProgress := 'POCOB-10-1520';
1516: dbms_sql.bind_variable(Shipment_sel_c,'po_header_id',l_header_tbl(nHeader_key_pos).value);
1517:
1518: xProgress := 'POOB-10-1525';
1519: dbms_sql.bind_variable(Shipment_sel_c,'por_release_id',l_header_tbl(nRelease_id_pos).value); --2823215
1520:
1521: xProgress := 'POCOB-10-1530';
1522: dummy := dbms_sql.execute(line_sel_c);
1523:

Line 1522: dummy := dbms_sql.execute(line_sel_c);

1518: xProgress := 'POOB-10-1525';
1519: dbms_sql.bind_variable(Shipment_sel_c,'por_release_id',l_header_tbl(nRelease_id_pos).value); --2823215
1520:
1521: xProgress := 'POCOB-10-1530';
1522: dummy := dbms_sql.execute(line_sel_c);
1523:
1524: -- *********************
1525: -- Line Level Loop Starts Here
1526: -- *********************

Line 1528: WHILE dbms_sql.fetch_rows(line_sel_c) > 0 LOOP --- Line

1524: -- *********************
1525: -- Line Level Loop Starts Here
1526: -- *********************
1527: xProgress := 'POCOB-10-1540';
1528: WHILE dbms_sql.fetch_rows(line_sel_c) > 0 LOOP --- Line
1529:
1530: -- ****************************
1531: -- store values in pl/sql table
1532: -- ****************************

Line 1883: -- dbms_sql.bind_variable(shipment_sel_c,'shipment_number',l_line_tbl(nLine_num_pos).value);

1879: -- set LINE_NUMBER values
1880: -- **********************
1881: -- Removed based on bug:3957851
1882: -- xProgress := 'POOB-10-1627';
1883: -- dbms_sql.bind_variable(shipment_sel_c,'shipment_number',l_line_tbl(nLine_num_pos).value);
1884:
1885: xProgress := 'POCOB-10-1630';
1886: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',l_line_tbl(nLine_key_pos).value);
1887:

Line 1886: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',l_line_tbl(nLine_key_pos).value);

1882: -- xProgress := 'POOB-10-1627';
1883: -- dbms_sql.bind_variable(shipment_sel_c,'shipment_number',l_line_tbl(nLine_num_pos).value);
1884:
1885: xProgress := 'POCOB-10-1630';
1886: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',l_line_tbl(nLine_key_pos).value);
1887:
1888: xProgress := 'POCOB-10-1640';
1889: dummy := dbms_sql.execute(shipment_sel_c);
1890:

Line 1889: dummy := dbms_sql.execute(shipment_sel_c);

1885: xProgress := 'POCOB-10-1630';
1886: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',l_line_tbl(nLine_key_pos).value);
1887:
1888: xProgress := 'POCOB-10-1640';
1889: dummy := dbms_sql.execute(shipment_sel_c);
1890:
1891: -- *************************
1892: -- Shipment loop starts here
1893: -- *************************

Line 1895: WHILE dbms_sql.fetch_rows(shipment_sel_c) > 0 LOOP --- Shipment

1891: -- *************************
1892: -- Shipment loop starts here
1893: -- *************************
1894: xProgress := 'POCOB-10-1650';
1895: WHILE dbms_sql.fetch_rows(shipment_sel_c) > 0 LOOP --- Shipment
1896:
1897: -- ****************************
1898: -- store values in pl/sql table
1899: -- ****************************

Line 2159: IF dbms_sql.last_row_count = 0 THEN

2155:
2156: END LOOP; -- SHIPMENT Level Loop
2157:
2158: xProgress := 'POCOB-10-1740';
2159: IF dbms_sql.last_row_count = 0 THEN
2160: v_LevelProcessed := 'SHIPMENT';
2161: ec_debug.pl(0,'EC','ECE_NO_DB_ROW_PROCESSED','PROGRESS_LEVEL',xProgress,'LEVEL_PROCESSED',v_LevelProcessed,'TRANSACTION_TYPE',cTransaction_Type);
2162: END IF;
2163:

Line 2167: IF dbms_sql.last_row_count = 0 THEN

2163:
2164: END LOOP; -- LINE Level Loop
2165:
2166: xProgress := 'POCOB-10-1750';
2167: IF dbms_sql.last_row_count = 0 THEN
2168: v_LevelProcessed := 'LINE';
2169: ec_debug.pl(0,'EC','ECE_NO_DB_ROW_PROCESSED','PROGRESS_LEVEL',xProgress,'LEVEL_PROCESSED',v_LevelProcessed,'TRANSACTION_TYPE',cTransaction_Type);
2170: END IF;
2171:

Line 2175: IF dbms_sql.last_row_count = 0 THEN

2171:
2172: END LOOP; -- HEADER Level Loop
2173:
2174: xProgress := 'POCOB-10-1760';
2175: IF dbms_sql.last_row_count = 0 THEN
2176: v_LevelProcessed := 'HEADER';
2177: ec_debug.pl(0,'EC','ECE_NO_DB_ROW_PROCESSED','LEVEL_PROCESSED',v_LevelProcessed,'PROGRESS_LEVEL',xProgress,'TRANSACTION_TYPE',cTransaction_Type);
2178: END IF;
2179:

Line 2184: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109

2180: xProgress := 'POCOB-10-1770';
2181:
2182: if (ece_poo_transaction.project_sel_c >0) then --Bug 2819176
2183:
2184: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2185: end if;
2186: xProgress := 'POCOB-10-1780';
2187:
2188: dbms_sql.close_cursor(shipment_sel_c);

Line 2188: dbms_sql.close_cursor(shipment_sel_c);

2184: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2185: end if;
2186: xProgress := 'POCOB-10-1780';
2187:
2188: dbms_sql.close_cursor(shipment_sel_c);
2189:
2190: xProgress := 'POCOB-10-1790';
2191: dbms_sql.close_cursor(line_sel_c);
2192:

Line 2191: dbms_sql.close_cursor(line_sel_c);

2187:
2188: dbms_sql.close_cursor(shipment_sel_c);
2189:
2190: xProgress := 'POCOB-10-1790';
2191: dbms_sql.close_cursor(line_sel_c);
2192:
2193: xProgress := 'POCOB-10-1800';
2194: dbms_sql.close_cursor(header_sel_c);
2195:

Line 2194: dbms_sql.close_cursor(header_sel_c);

2190: xProgress := 'POCOB-10-1790';
2191: dbms_sql.close_cursor(line_sel_c);
2192:
2193: xProgress := 'POCOB-10-1800';
2194: dbms_sql.close_cursor(header_sel_c);
2195:
2196: ec_debug.pop('ECE_POCO_TRANSACTION.POPULATE_POCO_TRX');
2197:
2198: EXCEPTION

Line 2574: header_sel_c := dbms_sql.open_cursor;

2570: -- *** This tells the database to reserve spaces
2571: -- *** for the data returned by the SQL statement
2572: -- ***************************************************
2573: xProgress := 'POCOB-20-1080';
2574: header_sel_c := dbms_sql.open_cursor;
2575:
2576: xProgress := 'POCOB-20-1090';
2577: line_sel_c := dbms_sql.open_cursor;
2578:

Line 2577: line_sel_c := dbms_sql.open_cursor;

2573: xProgress := 'POCOB-20-1080';
2574: header_sel_c := dbms_sql.open_cursor;
2575:
2576: xProgress := 'POCOB-20-1090';
2577: line_sel_c := dbms_sql.open_cursor;
2578:
2579: xProgress := 'POCOB-20-1100';
2580: shipment_sel_c := dbms_sql.open_cursor;
2581:

Line 2580: shipment_sel_c := dbms_sql.open_cursor;

2576: xProgress := 'POCOB-20-1090';
2577: line_sel_c := dbms_sql.open_cursor;
2578:
2579: xProgress := 'POCOB-20-1100';
2580: shipment_sel_c := dbms_sql.open_cursor;
2581:
2582: xProgress := 'POCOB-20-1110';
2583: header_del_c1 := dbms_sql.open_cursor;
2584:

Line 2583: header_del_c1 := dbms_sql.open_cursor;

2579: xProgress := 'POCOB-20-1100';
2580: shipment_sel_c := dbms_sql.open_cursor;
2581:
2582: xProgress := 'POCOB-20-1110';
2583: header_del_c1 := dbms_sql.open_cursor;
2584:
2585: xProgress := 'POCOB-20-1120';
2586: line_del_c1 := dbms_sql.open_cursor;
2587:

Line 2586: line_del_c1 := dbms_sql.open_cursor;

2582: xProgress := 'POCOB-20-1110';
2583: header_del_c1 := dbms_sql.open_cursor;
2584:
2585: xProgress := 'POCOB-20-1120';
2586: line_del_c1 := dbms_sql.open_cursor;
2587:
2588: xProgress := 'POCOB-20-1130';
2589: shipment_del_c1 := dbms_sql.open_cursor;
2590:

Line 2589: shipment_del_c1 := dbms_sql.open_cursor;

2585: xProgress := 'POCOB-20-1120';
2586: line_del_c1 := dbms_sql.open_cursor;
2587:
2588: xProgress := 'POCOB-20-1130';
2589: shipment_del_c1 := dbms_sql.open_cursor;
2590:
2591: xProgress := 'POCOB-20-1140';
2592: header_del_c2 := dbms_sql.open_cursor;
2593:

Line 2592: header_del_c2 := dbms_sql.open_cursor;

2588: xProgress := 'POCOB-20-1130';
2589: shipment_del_c1 := dbms_sql.open_cursor;
2590:
2591: xProgress := 'POCOB-20-1140';
2592: header_del_c2 := dbms_sql.open_cursor;
2593:
2594: xProgress := 'POCOB-20-1150';
2595: line_del_c2 := dbms_sql.open_cursor;
2596:

Line 2595: line_del_c2 := dbms_sql.open_cursor;

2591: xProgress := 'POCOB-20-1140';
2592: header_del_c2 := dbms_sql.open_cursor;
2593:
2594: xProgress := 'POCOB-20-1150';
2595: line_del_c2 := dbms_sql.open_cursor;
2596:
2597: xProgress := 'POCOB-20-1160';
2598: shipment_del_c2 := dbms_sql.open_cursor;
2599:

Line 2598: shipment_del_c2 := dbms_sql.open_cursor;

2594: xProgress := 'POCOB-20-1150';
2595: line_del_c2 := dbms_sql.open_cursor;
2596:
2597: xProgress := 'POCOB-20-1160';
2598: shipment_del_c2 := dbms_sql.open_cursor;
2599:
2600: -- *****************************************
2601: -- Parse each of the SELECT statement
2602: -- so the database understands the command

Line 2606: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);

2602: -- so the database understands the command
2603: -- *****************************************
2604: xProgress := 'POCOB-20-1170';
2605: BEGIN
2606: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);
2607:
2608: EXCEPTION
2609: WHEN OTHERS THEN
2610: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);

Line 2610: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);

2606: dbms_sql.parse(header_sel_c,cHeader_select,dbms_sql.native);
2607:
2608: EXCEPTION
2609: WHEN OTHERS THEN
2610: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);
2611: app_exception.raise_exception;
2612:
2613: END;
2614:

Line 2617: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);

2613: END;
2614:
2615: xProgress := 'POCOB-20-1180';
2616: BEGIN
2617: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);
2618:
2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);

Line 2621: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);

2617: dbms_sql.parse(line_sel_c,cLine_select,dbms_sql.native);
2618:
2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);
2622: app_exception.raise_exception;
2623:
2624: END;
2625:

Line 2628: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);

2624: END;
2625:
2626: xProgress := 'POCOB-20-1190';
2627: BEGIN
2628: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);
2629:
2630: EXCEPTION
2631: WHEN OTHERS THEN
2632: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);

Line 2632: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);

2628: dbms_sql.parse(shipment_sel_c,cShipment_select,dbms_sql.native);
2629:
2630: EXCEPTION
2631: WHEN OTHERS THEN
2632: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);
2633: app_exception.raise_exception;
2634:
2635: END;
2636:

Line 2639: dbms_sql.parse(Header_del_c1,cHeader_delete1,dbms_sql.native);

2635: END;
2636:
2637: xProgress := 'POCOB-20-1200';
2638: BEGIN
2639: dbms_sql.parse(Header_del_c1,cHeader_delete1,dbms_sql.native);
2640:
2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);

Line 2643: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);

2639: dbms_sql.parse(Header_del_c1,cHeader_delete1,dbms_sql.native);
2640:
2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);
2644: app_exception.raise_exception;
2645:
2646: END;
2647:

Line 2650: dbms_sql.parse(Line_del_c1,cLine_delete1,dbms_sql.native);

2646: END;
2647:
2648: xProgress := 'POCOB-20-1210';
2649: BEGIN
2650: dbms_sql.parse(Line_del_c1,cLine_delete1,dbms_sql.native);
2651:
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete1);

Line 2654: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete1);

2650: dbms_sql.parse(Line_del_c1,cLine_delete1,dbms_sql.native);
2651:
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete1);
2655: app_exception.raise_exception;
2656:
2657: END;
2658:

Line 2661: dbms_sql.parse(shipment_del_c1,cShipment_delete1,dbms_sql.native);

2657: END;
2658:
2659: xProgress := 'POCOB-20-1220';
2660: BEGIN
2661: dbms_sql.parse(shipment_del_c1,cShipment_delete1,dbms_sql.native);
2662:
2663: EXCEPTION
2664: WHEN OTHERS THEN
2665: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete1);

Line 2665: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete1);

2661: dbms_sql.parse(shipment_del_c1,cShipment_delete1,dbms_sql.native);
2662:
2663: EXCEPTION
2664: WHEN OTHERS THEN
2665: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete1);
2666: app_exception.raise_exception;
2667:
2668: END;
2669:

Line 2672: dbms_sql.parse(header_del_c2,cHeader_delete2,dbms_sql.native);

2668: END;
2669:
2670: xProgress := 'POCOB-20-1230';
2671: BEGIN
2672: dbms_sql.parse(header_del_c2,cHeader_delete2,dbms_sql.native);
2673:
2674: EXCEPTION
2675: WHEN OTHERS THEN
2676: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);

Line 2676: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);

2672: dbms_sql.parse(header_del_c2,cHeader_delete2,dbms_sql.native);
2673:
2674: EXCEPTION
2675: WHEN OTHERS THEN
2676: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);
2677: app_exception.raise_exception;
2678:
2679: END;
2680:

Line 2683: dbms_sql.parse(line_del_c2,cLine_delete2,dbms_sql.native);

2679: END;
2680:
2681: xProgress := 'POCOB-20-1240';
2682: BEGIN
2683: dbms_sql.parse(line_del_c2,cLine_delete2,dbms_sql.native);
2684:
2685: EXCEPTION
2686: WHEN OTHERS THEN
2687: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete2);

Line 2687: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete2);

2683: dbms_sql.parse(line_del_c2,cLine_delete2,dbms_sql.native);
2684:
2685: EXCEPTION
2686: WHEN OTHERS THEN
2687: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete2);
2688: app_exception.raise_exception;
2689:
2690: END;
2691:

Line 2694: dbms_sql.parse(shipment_del_c2,cShipment_delete2,dbms_sql.native);

2690: END;
2691:
2692: xProgress := 'POCOB-20-1250';
2693: BEGIN
2694: dbms_sql.parse(shipment_del_c2,cShipment_delete2,dbms_sql.native);
2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete2);

Line 2698: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete2);

2694: dbms_sql.parse(shipment_del_c2,cShipment_delete2,dbms_sql.native);
2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete2);
2699: app_exception.raise_exception;
2700:
2701: END;
2702:

Line 2733: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 1,rHeader_rowid);

2729: -- ***************************************************
2730: -- Need rowid for delete (Header Level)
2731: -- ***************************************************
2732: xProgress := 'POCOB-20-1280';
2733: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 1,rHeader_rowid);
2734:
2735: xProgress := 'POCOB-20-1290';
2736: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2737:

Line 2736: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 2,rHeader_X_rowid);

2732: xProgress := 'POCOB-20-1280';
2733: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 1,rHeader_rowid);
2734:
2735: xProgress := 'POCOB-20-1290';
2736: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2737:
2738: xProgress := 'POCOB-20-1300';
2739: dbms_sql.define_column(header_sel_c,iHeader_count + 3,n_po_header_id);
2740:

Line 2739: dbms_sql.define_column(header_sel_c,iHeader_count + 3,n_po_header_id);

2735: xProgress := 'POCOB-20-1290';
2736: dbms_sql.define_column_rowid(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2737:
2738: xProgress := 'POCOB-20-1300';
2739: dbms_sql.define_column(header_sel_c,iHeader_count + 3,n_po_header_id);
2740:
2741: xProgress := 'POCOB-20-1310';
2742: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_flatfile_pvt.G_MaxColWidth,l_line_tbl);
2743:

Line 2748: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 1,rLine_rowid);

2744: -- ***************************************************
2745: -- Need rowid for delete (Line Level)
2746: -- ***************************************************
2747: xProgress := 'POCOB-20-1320';
2748: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 1,rLine_rowid);
2749:
2750: xProgress := 'POCOB-20-1330';
2751: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 2,rLine_X_rowid);
2752:

Line 2751: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 2,rLine_X_rowid);

2747: xProgress := 'POCOB-20-1320';
2748: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 1,rLine_rowid);
2749:
2750: xProgress := 'POCOB-20-1330';
2751: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 2,rLine_X_rowid);
2752:
2753: xProgress := 'POCOB-20-1340';
2754: dbms_sql.define_column(line_sel_c,iLine_count + 3,n_po_line_id);
2755:

Line 2754: dbms_sql.define_column(line_sel_c,iLine_count + 3,n_po_line_id);

2750: xProgress := 'POCOB-20-1330';
2751: dbms_sql.define_column_rowid(line_sel_c,iLine_count + 2,rLine_X_rowid);
2752:
2753: xProgress := 'POCOB-20-1340';
2754: dbms_sql.define_column(line_sel_c,iLine_count + 3,n_po_line_id);
2755:
2756: xProgress := 'POCOB-20-1350';
2757: ece_flatfile_pvt.define_interface_column_type(Shipment_sel_c,cShipment_select,ece_flatfile_pvt.G_MaxColWidth,l_Shipment_tbl);
2758:

Line 2763: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 1,rShipment_rowid);

2759: -- ***************************************************
2760: -- Need rowid for delete (Shipment Level)
2761: -- ***************************************************
2762: xProgress := 'POCOB-20-1360';
2763: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 1,rShipment_rowid);
2764:
2765: xProgress := 'POCOB-20-1370';
2766: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
2767:

Line 2766: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);

2762: xProgress := 'POCOB-20-1360';
2763: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 1,rShipment_rowid);
2764:
2765: xProgress := 'POCOB-20-1370';
2766: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
2767:
2768: xProgress := 'POCOB-20-1375';
2769: dbms_sql.bind_variable(header_sel_c,'Run_id',iRun_id);
2770: dbms_sql.bind_variable(line_sel_c,'Run_id',iRun_id);

Line 2769: dbms_sql.bind_variable(header_sel_c,'Run_id',iRun_id);

2765: xProgress := 'POCOB-20-1370';
2766: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
2767:
2768: xProgress := 'POCOB-20-1375';
2769: dbms_sql.bind_variable(header_sel_c,'Run_id',iRun_id);
2770: dbms_sql.bind_variable(line_sel_c,'Run_id',iRun_id);
2771: dbms_sql.bind_variable(shipment_sel_c,'Run_id',iRun_id);
2772:
2773:

Line 2770: dbms_sql.bind_variable(line_sel_c,'Run_id',iRun_id);

2766: dbms_sql.define_column_rowid(Shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
2767:
2768: xProgress := 'POCOB-20-1375';
2769: dbms_sql.bind_variable(header_sel_c,'Run_id',iRun_id);
2770: dbms_sql.bind_variable(line_sel_c,'Run_id',iRun_id);
2771: dbms_sql.bind_variable(shipment_sel_c,'Run_id',iRun_id);
2772:
2773:
2774: --- EXECUTE the SELECT statement

Line 2771: dbms_sql.bind_variable(shipment_sel_c,'Run_id',iRun_id);

2767:
2768: xProgress := 'POCOB-20-1375';
2769: dbms_sql.bind_variable(header_sel_c,'Run_id',iRun_id);
2770: dbms_sql.bind_variable(line_sel_c,'Run_id',iRun_id);
2771: dbms_sql.bind_variable(shipment_sel_c,'Run_id',iRun_id);
2772:
2773:
2774: --- EXECUTE the SELECT statement
2775: xProgress := 'POCOB-20-1380';

Line 2776: dummy := dbms_sql.execute(header_sel_c);

2772:
2773:
2774: --- EXECUTE the SELECT statement
2775: xProgress := 'POCOB-20-1380';
2776: dummy := dbms_sql.execute(header_sel_c);
2777:
2778: -- ********************************************************************
2779: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2780: -- *** then populate ECE_OUTPUT with data from all LINES that belongs

Line 2787: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header

2783: -- ********************************************************************
2784:
2785: -- HEADER - LINE - SHIPMENT ...
2786: xProgress := 'POCOB-20-1390';
2787: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
2788: -- ******************************
2789: -- store values in pl/sql table
2790: -- ******************************
2791: xProgress := 'POCOB-20-1400';

Line 2795: dbms_sql.column_value(header_sel_c,iHeader_count + 1,rHeader_rowid);

2791: xProgress := 'POCOB-20-1400';
2792: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,l_header_tbl);
2793:
2794: xProgress := 'POCOB-20-1410';
2795: dbms_sql.column_value(header_sel_c,iHeader_count + 1,rHeader_rowid);
2796:
2797: xProgress := 'POCOB-20-1420';
2798: dbms_sql.column_value(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2799:

Line 2798: dbms_sql.column_value(header_sel_c,iHeader_count + 2,rHeader_X_rowid);

2794: xProgress := 'POCOB-20-1410';
2795: dbms_sql.column_value(header_sel_c,iHeader_count + 1,rHeader_rowid);
2796:
2797: xProgress := 'POCOB-20-1420';
2798: dbms_sql.column_value(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2799:
2800: xProgress := 'POCOB-20-1430';
2801: dbms_sql.column_value(header_sel_c,iHeader_count + 3,n_po_header_id);
2802:

Line 2801: dbms_sql.column_value(header_sel_c,iHeader_count + 3,n_po_header_id);

2797: xProgress := 'POCOB-20-1420';
2798: dbms_sql.column_value(header_sel_c,iHeader_count + 2,rHeader_X_rowid);
2799:
2800: xProgress := 'POCOB-20-1430';
2801: dbms_sql.column_value(header_sel_c,iHeader_count + 3,n_po_header_id);
2802:
2803: xProgress := 'POCOB-20-1440';
2804: nRelease_num := l_header_tbl(nRelease_num_pos).value;
2805: ec_debug.pl(3,'nRelease_num: ',nRelease_num);

Line 2896: dbms_sql.bind_variable(line_sel_c,'po_header_id',n_po_header_id);

2892: -- ******************************************
2893: -- set values into binding variables
2894: -- ******************************************
2895: xProgress := 'POCOB-20-1490';
2896: dbms_sql.bind_variable(line_sel_c,'po_header_id',n_po_header_id);
2897:
2898: xProgress := 'POCOB-20-1500';
2899: dbms_sql.bind_variable(shipment_sel_c,'po_header_id',n_po_header_id);
2900:

Line 2899: dbms_sql.bind_variable(shipment_sel_c,'po_header_id',n_po_header_id);

2895: xProgress := 'POCOB-20-1490';
2896: dbms_sql.bind_variable(line_sel_c,'po_header_id',n_po_header_id);
2897:
2898: xProgress := 'POCOB-20-1500';
2899: dbms_sql.bind_variable(shipment_sel_c,'po_header_id',n_po_header_id);
2900:
2901: xProgress := 'POCOB-20-1505';
2902: dbms_sql.bind_variable(line_sel_c,'por_release_num',nRelease_num);
2903:

Line 2902: dbms_sql.bind_variable(line_sel_c,'por_release_num',nRelease_num);

2898: xProgress := 'POCOB-20-1500';
2899: dbms_sql.bind_variable(shipment_sel_c,'po_header_id',n_po_header_id);
2900:
2901: xProgress := 'POCOB-20-1505';
2902: dbms_sql.bind_variable(line_sel_c,'por_release_num',nRelease_num);
2903:
2904: xProgress := 'POCOB-20-1506';
2905: dbms_sql.bind_variable(shipment_sel_c,'por_release_num',nRelease_num);
2906:

Line 2905: dbms_sql.bind_variable(shipment_sel_c,'por_release_num',nRelease_num);

2901: xProgress := 'POCOB-20-1505';
2902: dbms_sql.bind_variable(line_sel_c,'por_release_num',nRelease_num);
2903:
2904: xProgress := 'POCOB-20-1506';
2905: dbms_sql.bind_variable(shipment_sel_c,'por_release_num',nRelease_num);
2906:
2907: xProgress := 'POCOB-10-1510';
2908: dummy := dbms_sql.execute(line_sel_c);
2909:

Line 2908: dummy := dbms_sql.execute(line_sel_c);

2904: xProgress := 'POCOB-20-1506';
2905: dbms_sql.bind_variable(shipment_sel_c,'por_release_num',nRelease_num);
2906:
2907: xProgress := 'POCOB-10-1510';
2908: dummy := dbms_sql.execute(line_sel_c);
2909:
2910: -- ***************************************************
2911: -- line loop starts here
2912: -- ***************************************************

Line 2914: WHILE dbms_sql.fetch_rows(line_sel_c) > 0 LOOP --- Line

2910: -- ***************************************************
2911: -- line loop starts here
2912: -- ***************************************************
2913: xProgress := 'POCOB-20-1520';
2914: WHILE dbms_sql.fetch_rows(line_sel_c) > 0 LOOP --- Line
2915:
2916: -- ***************************************************
2917: -- store values in pl/sql table
2918: -- ***************************************************

Line 2923: dbms_sql.column_value(line_sel_c,iLine_count + 1,rLine_rowid);

2919: xProgress := 'POCOB-20-1530';
2920: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,l_line_tbl);
2921:
2922: xProgress := 'POCOB-20-1533';
2923: dbms_sql.column_value(line_sel_c,iLine_count + 1,rLine_rowid);
2924:
2925: xProgress := 'POCOB-20-1535';
2926: dbms_sql.column_value(line_sel_c,iLine_count + 2,rLine_X_rowid);
2927:

Line 2926: dbms_sql.column_value(line_sel_c,iLine_count + 2,rLine_X_rowid);

2922: xProgress := 'POCOB-20-1533';
2923: dbms_sql.column_value(line_sel_c,iLine_count + 1,rLine_rowid);
2924:
2925: xProgress := 'POCOB-20-1535';
2926: dbms_sql.column_value(line_sel_c,iLine_count + 2,rLine_X_rowid);
2927:
2928: xProgress := 'POCOB-20-1537';
2929: dbms_sql.column_value(line_sel_c,iLine_count + 3,n_po_line_id);
2930: ec_debug.pl(3,'n_po_line_id: ',n_po_line_id);

Line 2929: dbms_sql.column_value(line_sel_c,iLine_count + 3,n_po_line_id);

2925: xProgress := 'POCOB-20-1535';
2926: dbms_sql.column_value(line_sel_c,iLine_count + 2,rLine_X_rowid);
2927:
2928: xProgress := 'POCOB-20-1537';
2929: dbms_sql.column_value(line_sel_c,iLine_count + 3,n_po_line_id);
2930: ec_debug.pl(3,'n_po_line_id: ',n_po_line_id);
2931:
2932: xProgress := 'POCOB-20-1540';
2933: nLine_num := l_line_tbl(nLine_num_pos).value;

Line 3048: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',n_po_line_id);

3044: -- **************************
3045: -- set LINE_NUMBER values
3046: -- **************************
3047: xProgress := 'POCOB-20-1560';
3048: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',n_po_line_id);
3049:
3050: xProgress := 'POCOB-20-1575';
3051: dbms_sql.bind_variable(shipment_sel_c,'shipment_number',nLine_num);
3052:

Line 3051: dbms_sql.bind_variable(shipment_sel_c,'shipment_number',nLine_num);

3047: xProgress := 'POCOB-20-1560';
3048: dbms_sql.bind_variable(shipment_sel_c,'po_line_id',n_po_line_id);
3049:
3050: xProgress := 'POCOB-20-1575';
3051: dbms_sql.bind_variable(shipment_sel_c,'shipment_number',nLine_num);
3052:
3053: xProgress := 'POCOB-20-1580';
3054: dummy := dbms_sql.execute(shipment_sel_c);
3055:

Line 3054: dummy := dbms_sql.execute(shipment_sel_c);

3050: xProgress := 'POCOB-20-1575';
3051: dbms_sql.bind_variable(shipment_sel_c,'shipment_number',nLine_num);
3052:
3053: xProgress := 'POCOB-20-1580';
3054: dummy := dbms_sql.execute(shipment_sel_c);
3055:
3056: -- ****************************
3057: -- Shipment loop starts here
3058: -- ****************************

Line 3060: WHILE dbms_sql.fetch_rows(shipment_sel_c) > 0 LOOP --- Shipments

3056: -- ****************************
3057: -- Shipment loop starts here
3058: -- ****************************
3059: xProgress := 'POCOB-20-1590';
3060: WHILE dbms_sql.fetch_rows(shipment_sel_c) > 0 LOOP --- Shipments
3061:
3062: -- *********************************
3063: -- store values in pl/sql table
3064: -- *********************************

Line 3069: dbms_sql.column_value(shipment_sel_c,iShipment_count + 1,rShipment_rowid);

3065: xProgress := 'POCOB-20-1600';
3066: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,l_shipment_tbl);
3067:
3068: xProgress := 'POCOB-20-1603';
3069: dbms_sql.column_value(shipment_sel_c,iShipment_count + 1,rShipment_rowid);
3070:
3071: xProgress := 'POCOB-20-1606';
3072: dbms_sql.column_value(shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
3073:

Line 3072: dbms_sql.column_value(shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);

3068: xProgress := 'POCOB-20-1603';
3069: dbms_sql.column_value(shipment_sel_c,iShipment_count + 1,rShipment_rowid);
3070:
3071: xProgress := 'POCOB-20-1606';
3072: dbms_sql.column_value(shipment_sel_c,iShipment_count + 2,rShipment_X_rowid);
3073:
3074: xProgress := 'POCOB-20-1610';
3075: nLine_Location_ID := l_shipment_tbl(nLine_Location_ID_pos).value;
3076: ec_debug.pl(3,'Ship Level Line Location ID: ',nLine_Location_ID);

Line 3134: dbms_sql.bind_variable(shipment_del_c1,'col_rowid',rShipment_rowid);

3130: c_file_common_key);
3131: -- END IF;
3132:
3133: xProgress := 'POCOB-20-1640';
3134: dbms_sql.bind_variable(shipment_del_c1,'col_rowid',rShipment_rowid);
3135:
3136: xProgress := 'POCOB-20-1650';
3137: dbms_sql.bind_variable(shipment_del_c2,'col_rowid',rShipment_X_rowid);
3138:

Line 3137: dbms_sql.bind_variable(shipment_del_c2,'col_rowid',rShipment_X_rowid);

3133: xProgress := 'POCOB-20-1640';
3134: dbms_sql.bind_variable(shipment_del_c1,'col_rowid',rShipment_rowid);
3135:
3136: xProgress := 'POCOB-20-1650';
3137: dbms_sql.bind_variable(shipment_del_c2,'col_rowid',rShipment_X_rowid);
3138:
3139: xProgress := 'POCOB-20-1660';
3140: dummy := dbms_sql.execute(shipment_del_c1);
3141:

Line 3140: dummy := dbms_sql.execute(shipment_del_c1);

3136: xProgress := 'POCOB-20-1650';
3137: dbms_sql.bind_variable(shipment_del_c2,'col_rowid',rShipment_X_rowid);
3138:
3139: xProgress := 'POCOB-20-1660';
3140: dummy := dbms_sql.execute(shipment_del_c1);
3141:
3142: xProgress := 'POCOB-20-1670';
3143: dummy := dbms_sql.execute(shipment_del_c2);
3144:

Line 3143: dummy := dbms_sql.execute(shipment_del_c2);

3139: xProgress := 'POCOB-20-1660';
3140: dummy := dbms_sql.execute(shipment_del_c1);
3141:
3142: xProgress := 'POCOB-20-1670';
3143: dummy := dbms_sql.execute(shipment_del_c2);
3144:
3145: END LOOP; -- Shipment Level
3146:
3147: xProgress := 'POCOB-20-1674';

Line 3148: IF dbms_sql.last_row_count = 0 THEN

3144:
3145: END LOOP; -- Shipment Level
3146:
3147: xProgress := 'POCOB-20-1674';
3148: IF dbms_sql.last_row_count = 0 THEN
3149: v_LevelProcessed := 'SHIPMENT';
3150: ec_debug.pl(0,
3151: 'EC',
3152: 'ECE_NO_DB_ROW_PROCESSED',

Line 3165: dbms_sql.bind_variable(line_del_c1,'col_rowid',rLine_rowid);

3161: -- *********************
3162: -- Use rowid for delete
3163: -- *********************
3164: xProgress := 'POCOB-20-1680';
3165: dbms_sql.bind_variable(line_del_c1,'col_rowid',rLine_rowid);
3166:
3167: xProgress := 'POCOB-20-1690';
3168: dbms_sql.bind_variable(line_del_c2,'col_rowid',rLine_X_rowid);
3169:

Line 3168: dbms_sql.bind_variable(line_del_c2,'col_rowid',rLine_X_rowid);

3164: xProgress := 'POCOB-20-1680';
3165: dbms_sql.bind_variable(line_del_c1,'col_rowid',rLine_rowid);
3166:
3167: xProgress := 'POCOB-20-1690';
3168: dbms_sql.bind_variable(line_del_c2,'col_rowid',rLine_X_rowid);
3169:
3170: xProgress := 'POCOB-20-1700';
3171: dummy := dbms_sql.execute(line_del_c1);
3172:

Line 3171: dummy := dbms_sql.execute(line_del_c1);

3167: xProgress := 'POCOB-20-1690';
3168: dbms_sql.bind_variable(line_del_c2,'col_rowid',rLine_X_rowid);
3169:
3170: xProgress := 'POCOB-20-1700';
3171: dummy := dbms_sql.execute(line_del_c1);
3172:
3173: xProgress := 'POCOB-20-1710';
3174: dummy := dbms_sql.execute(line_del_c2);
3175:

Line 3174: dummy := dbms_sql.execute(line_del_c2);

3170: xProgress := 'POCOB-20-1700';
3171: dummy := dbms_sql.execute(line_del_c1);
3172:
3173: xProgress := 'POCOB-20-1710';
3174: dummy := dbms_sql.execute(line_del_c2);
3175:
3176: END LOOP; -- Line Level
3177:
3178: xProgress := 'POCOB-20-1714';

Line 3179: IF dbms_sql.last_row_count = 0 THEN

3175:
3176: END LOOP; -- Line Level
3177:
3178: xProgress := 'POCOB-20-1714';
3179: IF dbms_sql.last_row_count = 0 THEN
3180: v_LevelProcessed := 'LINE';
3181: ec_debug.pl(0,
3182: 'EC',
3183: 'ECE_NO_DB_ROW_PROCESSED',

Line 3193: dbms_sql.bind_variable(header_del_c1,'col_rowid',rHeader_rowid);

3189: cTransaction_Type);
3190: END IF;
3191:
3192: xProgress := 'POCOB-20-1720';
3193: dbms_sql.bind_variable(header_del_c1,'col_rowid',rHeader_rowid);
3194:
3195: xProgress := 'POCOB-20-1730';
3196: dbms_sql.bind_variable(header_del_c2,'col_rowid',rHeader_X_rowid);
3197:

Line 3196: dbms_sql.bind_variable(header_del_c2,'col_rowid',rHeader_X_rowid);

3192: xProgress := 'POCOB-20-1720';
3193: dbms_sql.bind_variable(header_del_c1,'col_rowid',rHeader_rowid);
3194:
3195: xProgress := 'POCOB-20-1730';
3196: dbms_sql.bind_variable(header_del_c2,'col_rowid',rHeader_X_rowid);
3197:
3198: xProgress := 'POCOB-20-1740';
3199: dummy := dbms_sql.execute(header_del_c1);
3200:

Line 3199: dummy := dbms_sql.execute(header_del_c1);

3195: xProgress := 'POCOB-20-1730';
3196: dbms_sql.bind_variable(header_del_c2,'col_rowid',rHeader_X_rowid);
3197:
3198: xProgress := 'POCOB-20-1740';
3199: dummy := dbms_sql.execute(header_del_c1);
3200:
3201: xProgress := 'POCOB-20-1750';
3202: dummy := dbms_sql.execute(header_del_c2);
3203:

Line 3202: dummy := dbms_sql.execute(header_del_c2);

3198: xProgress := 'POCOB-20-1740';
3199: dummy := dbms_sql.execute(header_del_c1);
3200:
3201: xProgress := 'POCOB-20-1750';
3202: dummy := dbms_sql.execute(header_del_c2);
3203:
3204: END LOOP; -- Header Level
3205:
3206: xProgress := 'POCOB-20-1754';

Line 3207: IF dbms_sql.last_row_count = 0 THEN

3203:
3204: END LOOP; -- Header Level
3205:
3206: xProgress := 'POCOB-20-1754';
3207: IF dbms_sql.last_row_count = 0 THEN
3208: v_LevelProcessed := 'HEADER';
3209: ec_debug.pl(0,
3210: 'EC',
3211: 'ECE_NO_DB_ROW_PROCESSED',

Line 3221: dbms_sql.close_cursor(header_sel_c);

3217: cTransaction_Type);
3218: END IF;
3219:
3220: xProgress := 'POCOB-20-1760';
3221: dbms_sql.close_cursor(header_sel_c);
3222:
3223: xProgress := 'POCOB-20-1770';
3224: dbms_sql.close_cursor(line_sel_c);
3225:

Line 3224: dbms_sql.close_cursor(line_sel_c);

3220: xProgress := 'POCOB-20-1760';
3221: dbms_sql.close_cursor(header_sel_c);
3222:
3223: xProgress := 'POCOB-20-1770';
3224: dbms_sql.close_cursor(line_sel_c);
3225:
3226: xProgress := 'POCOB-20-1780';
3227: dbms_sql.close_cursor(shipment_sel_c);
3228:

Line 3227: dbms_sql.close_cursor(shipment_sel_c);

3223: xProgress := 'POCOB-20-1770';
3224: dbms_sql.close_cursor(line_sel_c);
3225:
3226: xProgress := 'POCOB-20-1780';
3227: dbms_sql.close_cursor(shipment_sel_c);
3228:
3229: xProgress := 'POCOB-20-1790';
3230: dbms_sql.close_cursor(header_del_c1);
3231:

Line 3230: dbms_sql.close_cursor(header_del_c1);

3226: xProgress := 'POCOB-20-1780';
3227: dbms_sql.close_cursor(shipment_sel_c);
3228:
3229: xProgress := 'POCOB-20-1790';
3230: dbms_sql.close_cursor(header_del_c1);
3231:
3232: xProgress := 'POCOB-20-1800';
3233: dbms_sql.close_cursor(line_del_c1);
3234:

Line 3233: dbms_sql.close_cursor(line_del_c1);

3229: xProgress := 'POCOB-20-1790';
3230: dbms_sql.close_cursor(header_del_c1);
3231:
3232: xProgress := 'POCOB-20-1800';
3233: dbms_sql.close_cursor(line_del_c1);
3234:
3235: xProgress := 'POCOB-20-1812';
3236: dbms_sql.close_cursor(shipment_del_c1);
3237:

Line 3236: dbms_sql.close_cursor(shipment_del_c1);

3232: xProgress := 'POCOB-20-1800';
3233: dbms_sql.close_cursor(line_del_c1);
3234:
3235: xProgress := 'POCOB-20-1812';
3236: dbms_sql.close_cursor(shipment_del_c1);
3237:
3238: xProgress := 'POCOB-20-1814';
3239: dbms_sql.close_cursor(header_del_c2);
3240:

Line 3239: dbms_sql.close_cursor(header_del_c2);

3235: xProgress := 'POCOB-20-1812';
3236: dbms_sql.close_cursor(shipment_del_c1);
3237:
3238: xProgress := 'POCOB-20-1814';
3239: dbms_sql.close_cursor(header_del_c2);
3240:
3241: xProgress := 'POCOB-20-1816';
3242: dbms_sql.close_cursor(line_del_c2);
3243:

Line 3242: dbms_sql.close_cursor(line_del_c2);

3238: xProgress := 'POCOB-20-1814';
3239: dbms_sql.close_cursor(header_del_c2);
3240:
3241: xProgress := 'POCOB-20-1816';
3242: dbms_sql.close_cursor(line_del_c2);
3243:
3244: xProgress := 'POCOB-20-1818';
3245: dbms_sql.close_cursor(shipment_del_c2);
3246:

Line 3245: dbms_sql.close_cursor(shipment_del_c2);

3241: xProgress := 'POCOB-20-1816';
3242: dbms_sql.close_cursor(line_del_c2);
3243:
3244: xProgress := 'POCOB-20-1818';
3245: dbms_sql.close_cursor(shipment_del_c2);
3246:
3247: -- Bug 2490109 Closing the distribution cursors.
3248: xProgress := 'POCOB-50-1819';
3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176

Line 3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);

3246:
3247: -- Bug 2490109 Closing the distribution cursors.
3248: xProgress := 'POCOB-50-1819';
3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3251:
3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:

Line 3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);

3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3251:
3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:
3255: xProgress := 'POCOB-50-1821';
3256: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3257: end if;

Line 3256: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);

3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:
3255: xProgress := 'POCOB-50-1821';
3256: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3257: end if;
3258:
3259: xProgress := 'POCOB-20-1820';
3260: ec_debug.pop('ECE_POCO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');