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_POO_TRANSACTION dependencies on ECE_EXTRACT_UTILS_PUB

Line 615: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary

611: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
612:
613: -- ****************************************************************************
614: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic SQL
615: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary
616: -- for the build.
617: -- ****************************************************************************
618:
619: BEGIN

Line 629: ece_extract_utils_pub.select_clause(cTransaction_Type,

625: WHEN OTHERS THEN
626: NULL;
627: END;
628: xProgress := 'POOB-10-1050';
629: ece_extract_utils_pub.select_clause(cTransaction_Type,
630: cCommunication_Method,
631: cHeader_Interface,
632: l_header_tbl,
633: cHeader_select,

Line 649: ece_extract_utils_pub.select_clause(cTransaction_Type,

645: NULL;
646: END;
647:
648: xProgress := 'POOB-10-1060';
649: ece_extract_utils_pub.select_clause(cTransaction_Type,
650: cCommunication_Method,
651: cLine_Interface,
652: l_line_tbl,
653: cLine_select,

Line 669: ece_extract_utils_pub.select_clause(cTransaction_Type,

665: NULL;
666: END;
667:
668: xProgress := 'POOB-10-1070';
669: ece_extract_utils_pub.select_clause(cTransaction_Type,
670: cCommunication_Method,
671: cShipment_Interface,
672: l_shipment_tbl,
673: cShipment_select,

Line 918: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);

914: -- However, for simplicity, we will convert
915: -- everything to varchar2.
916: -- ******************************************************
917: xProgress := 'POOB-10-1290';
918: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
919:
920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:

Line 921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);

917: xProgress := 'POOB-10-1290';
918: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
919:
920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:
923: xProgress := 'POOB-10-1310';
924: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
925:

Line 924: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);

920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:
923: xProgress := 'POOB-10-1310';
924: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
925:
926: -- **************************************************************
927: -- *** The following is custom tailored for this transaction
928: -- *** It finds the values and use them in the WHERE clause to

Line 937: ece_extract_utils_pub.find_pos(l_header_tbl,ece_extract_utils_pub.G_TRANSACTION_DATE,n_trx_date_pos);

933: -- we will need values for the join condition.
934: -- ***************************************************
935: -- Header Level Positions
936: xProgress := 'POOB-10-1320';
937: ece_extract_utils_pub.find_pos(l_header_tbl,ece_extract_utils_pub.G_TRANSACTION_DATE,n_trx_date_pos);
938:
939: xProgress := 'POOB-10-1330';
940: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);
941:

Line 940: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);

936: xProgress := 'POOB-10-1320';
937: ece_extract_utils_pub.find_pos(l_header_tbl,ece_extract_utils_pub.G_TRANSACTION_DATE,n_trx_date_pos);
938:
939: xProgress := 'POOB-10-1330';
940: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);
941:
942: xProgress := 'POOB-10-1340';
943: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
944:

Line 943: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);

939: xProgress := 'POOB-10-1330';
940: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);
941:
942: xProgress := 'POOB-10-1340';
943: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
944:
945: xProgress := 'POOB-10-1350';
946: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
947:

Line 946: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);

942: xProgress := 'POOB-10-1340';
943: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
944:
945: xProgress := 'POOB-10-1350';
946: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
947:
948: xProgress := 'POOB-10-1360';
949: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
950:

Line 949: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);

945: xProgress := 'POOB-10-1350';
946: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
947:
948: xProgress := 'POOB-10-1360';
949: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
950:
951: xProgress := 'POOB-10-1370';
952: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
953:

Line 952: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);

948: xProgress := 'POOB-10-1360';
949: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
950:
951: xProgress := 'POOB-10-1370';
952: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
953:
954: xProgress := 'POOB-10-1380';
955: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
956:

Line 955: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);

951: xProgress := 'POOB-10-1370';
952: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
953:
954: xProgress := 'POOB-10-1380';
955: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
956:
957: xProgress := 'POOB-10-1381';
958: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
959:

Line 958: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);

954: xProgress := 'POOB-10-1380';
955: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
956:
957: xProgress := 'POOB-10-1381';
958: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
959:
960: xProgress := 'POOB-10-1382';
961: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
962:

Line 965: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);

961: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
962:
963: -- Line Level Positions
964: xProgress := 'POOB-10-1390';
965: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
966:
967: xProgress := 'POOB-10-1400';
968: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
969:

Line 968: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);

964: xProgress := 'POOB-10-1390';
965: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
966:
967: xProgress := 'POOB-10-1400';
968: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
969:
970: xProgress := 'POOB-10-1402';
971: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
972:

Line 971: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);

967: xProgress := 'POOB-10-1400';
968: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
969:
970: xProgress := 'POOB-10-1402';
971: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
972:
973: xProgress := 'POOB-10-1404';
974: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
975:

Line 974: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);

970: xProgress := 'POOB-10-1402';
971: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
972:
973: xProgress := 'POOB-10-1404';
974: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
975:
976: xProgress := 'POOB-10-1405';
977: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
978: -- 2823215

Line 977: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);

973: xProgress := 'POOB-10-1404';
974: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
975:
976: xProgress := 'POOB-10-1405';
977: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
978: -- 2823215
979: xProgress := 'POOB-10-1406';
980: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
981:

Line 980: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);

976: xProgress := 'POOB-10-1405';
977: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
978: -- 2823215
979: xProgress := 'POOB-10-1406';
980: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
981:
982: xProgress := 'POOB-10-1407';
983: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
984:

Line 983: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);

979: xProgress := 'POOB-10-1406';
980: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
981:
982: xProgress := 'POOB-10-1407';
983: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
984:
985: xProgress := 'POOB-10-1408';
986: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
987:

Line 986: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);

982: xProgress := 'POOB-10-1407';
983: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
984:
985: xProgress := 'POOB-10-1408';
986: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
987:
988: xProgress := 'POOB-10-1409';
989: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
990:

Line 989: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);

985: xProgress := 'POOB-10-1408';
986: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
987:
988: xProgress := 'POOB-10-1409';
989: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
990:
991: xProgress := 'POOB-10-1410';
992: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
993:

Line 992: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);

988: xProgress := 'POOB-10-1409';
989: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
990:
991: xProgress := 'POOB-10-1410';
992: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
993:
994: xProgress := 'POOB-10-1411';
995: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
996:

Line 995: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);

991: xProgress := 'POOB-10-1410';
992: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
993:
994: xProgress := 'POOB-10-1411';
995: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
996:
997: xProgress := 'POOB-10-1412';
998: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
999:

Line 998: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);

994: xProgress := 'POOB-10-1411';
995: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
996:
997: xProgress := 'POOB-10-1412';
998: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
999:
1000: xProgress := 'POOB-10-1413';
1001: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1002:

Line 1001: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);

997: xProgress := 'POOB-10-1412';
998: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
999:
1000: xProgress := 'POOB-10-1413';
1001: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1002:
1003: xProgress := 'POOB-10-1414';
1004: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1005:

Line 1004: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);

1000: xProgress := 'POOB-10-1413';
1001: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1002:
1003: xProgress := 'POOB-10-1414';
1004: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1005:
1006: xProgress := 'POOB-10-1415';
1007: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1008:

Line 1007: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);

1003: xProgress := 'POOB-10-1414';
1004: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1005:
1006: xProgress := 'POOB-10-1415';
1007: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1008:
1009: xProgress := 'POOB-10-1416';
1010: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1011:

Line 1010: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);

1006: xProgress := 'POOB-10-1415';
1007: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1008:
1009: xProgress := 'POOB-10-1416';
1010: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1011:
1012: xProgress := 'POOB-10-1417';
1013: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1014:

Line 1013: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);

1009: xProgress := 'POOB-10-1416';
1010: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1011:
1012: xProgress := 'POOB-10-1417';
1013: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1014:
1015: xProgress := 'POOB-10-1418';
1016: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1017:

Line 1016: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);

1012: xProgress := 'POOB-10-1417';
1013: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1014:
1015: xProgress := 'POOB-10-1418';
1016: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1017:
1018: xProgress := 'POOB-10-1419';
1019: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1020:

Line 1019: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);

1015: xProgress := 'POOB-10-1418';
1016: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1017:
1018: xProgress := 'POOB-10-1419';
1019: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1020:
1021: xProgress := 'POOB-10-1420';
1022: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1023:

Line 1022: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);

1018: xProgress := 'POOB-10-1419';
1019: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1020:
1021: xProgress := 'POOB-10-1420';
1022: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1023:
1024: xProgress := 'POOB-10-1421';
1025: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1026:

Line 1025: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);

1021: xProgress := 'POOB-10-1420';
1022: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1023:
1024: xProgress := 'POOB-10-1421';
1025: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1026:
1027: xProgress := 'POOB-10-1422';
1028: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos); -- 2823215
1029:

Line 1028: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos); -- 2823215

1024: xProgress := 'POOB-10-1421';
1025: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1026:
1027: xProgress := 'POOB-10-1422';
1028: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos); -- 2823215
1029:
1030:
1031: -- Shipment Level Positions
1032: xProgress := 'POOB-10-1423';

Line 1033: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);

1029:
1030:
1031: -- Shipment Level Positions
1032: xProgress := 'POOB-10-1423';
1033: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
1034:
1035: xProgress := 'POOB-10-1424';
1036: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1037:

Line 1036: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);

1032: xProgress := 'POOB-10-1423';
1033: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
1034:
1035: xProgress := 'POOB-10-1424';
1036: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1037:
1038: xProgress := 'POOB-10-1025';
1039: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1040:

Line 1039: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);

1035: xProgress := 'POOB-10-1424';
1036: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1037:
1038: xProgress := 'POOB-10-1025';
1039: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1040:
1041: xProgress := 'POOB-10-1026';
1042: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1043:

Line 1042: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);

1038: xProgress := 'POOB-10-1025';
1039: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1040:
1041: xProgress := 'POOB-10-1026';
1042: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1043:
1044: xProgress := 'POOB-10-1427';
1045: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1046:

Line 1045: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);

1041: xProgress := 'POOB-10-1026';
1042: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1043:
1044: xProgress := 'POOB-10-1427';
1045: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1046:
1047: xProgress := 'POOB-10-1428';
1048: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1049:

Line 1479: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

1475:
1476: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1477:
1478:
1479: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,
1480: cTransaction_Type,
1481: cCommunication_Method,
1482: cHeader_Interface,
1483: l_header_tbl,

Line 1733: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cLine_Interface,l_line_tbl,l_line_fkey); */

1729:
1730: --2823215
1731: -- Insert into Interface Table
1732: /* xProgress := 'POOB-10-1600';
1733: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cLine_Interface,l_line_tbl,l_line_fkey); */
1734:
1735:
1736:
1737: /***************************

Line 1971: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cShipment_Interface,l_shipment_tbl,l_shipment_fkey); */

1967: p_tbl => l_shipment_tbl);
1968:
1969: /* xProgress := 'POOB-10-1690';
1970:
1971: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cShipment_Interface,l_shipment_tbl,l_shipment_fkey); */
1972:
1973: xProgress := 'POOB-10-1690';
1974: c_file_common_key := RPAD(SUBSTRB(NVL(l_header_tbl(nTrans_code_pos).value ,' '),1,25),25) ||
1975: RPAD(SUBSTRB(NVL(l_header_tbl(n_header_common_key_pos).value ,' '),1,22),22) ||

Line 3618: ece_extract_utils_pub.select_clause(cTransaction_Type,

3614: END if;
3615: ece_flatfile_pvt.init_table(cTransaction_Type,cDistribution_Interface,iProject_output_level,TRUE,l_project_tbl,l_key_tbl);
3616:
3617: xProgress := 'POOB-40-1010';
3618: ece_extract_utils_pub.select_clause(cTransaction_Type,
3619: cCommunication_Method,
3620: cDistribution_Interface,
3621: l_project_tbl,
3622: cProject_select,

Line 3681: ece_flatfile_pvt.define_interface_column_type(project_sel_c,cProject_select,ece_extract_utils_PUB.G_MaxColWidth,l_project_tbl);

3677: --ec_debug.pl(3,'iKey_count: ',iKey_count);
3678:
3679: -- Define Column Types
3680: xProgress := 'POOB-40-1090';
3681: ece_flatfile_pvt.define_interface_column_type(project_sel_c,cProject_select,ece_extract_utils_PUB.G_MaxColWidth,l_project_tbl);
3682:
3683: -- Project Level Positions
3684:
3685: end if; --Bug 2490109

Line 3764: ece_extract_utils_pub.insert_into_interface_tbl(

3760: end if;
3761:
3762: -- Insert into Interface Table
3763: /* xProgress := 'POOB-40-1230';
3764: ece_extract_utils_pub.insert_into_interface_tbl(
3765: iRun_id,
3766: cTransaction_Type,
3767: cCommunication_Method,
3768: cDistribution_Interface,

Line 4254: ece_extract_utils_pub.select_clause(cTransaction_Type,

4250: end if;
4251:
4252: xProgress := 'POOB-60-1005';
4253: -- Build the SELECT Clause.
4254: ece_extract_utils_pub.select_clause(cTransaction_Type,
4255: cCommunication_Method,
4256: cAtt_Header_Interface,
4257: l_att_header_tbl,
4258: v_att_header_select,

Line 4379: ece_extract_utils_pub.find_pos(l_att_header_tbl,'DATATYPE_ID',n_datatype_id_pos);

4375: ec_debug.pl(3,'v_att_header_select: ',v_att_header_select);
4376: end if;
4377:
4378: xProgress := 'POOB-60-1092';
4379: ece_extract_utils_pub.find_pos(l_att_header_tbl,'DATATYPE_ID',n_datatype_id_pos);
4380:
4381: xProgress := 'POOB-60-1094';
4382: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATT_SEQ_NUM',n_att_seq_num_pos);
4383: if ec_debug.G_debug_level = 3 then

Line 4382: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATT_SEQ_NUM',n_att_seq_num_pos);

4378: xProgress := 'POOB-60-1092';
4379: ece_extract_utils_pub.find_pos(l_att_header_tbl,'DATATYPE_ID',n_datatype_id_pos);
4380:
4381: xProgress := 'POOB-60-1094';
4382: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATT_SEQ_NUM',n_att_seq_num_pos);
4383: if ec_debug.G_debug_level = 3 then
4384: ec_debug.pl(3,'n_datatype_id_pos: ',n_datatype_id_pos);
4385: ec_debug.pl(3,'n_att_seq_num_pos: ',n_att_seq_num_pos);
4386: end if;

Line 4389: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATTACHED_DOCUMENT_ID',n_att_doc_id_pos); --Bug 2187958

4385: ec_debug.pl(3,'n_att_seq_num_pos: ',n_att_seq_num_pos);
4386: end if;
4387:
4388: xProgress := 'POOB-60-1096';
4389: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATTACHED_DOCUMENT_ID',n_att_doc_id_pos); --Bug 2187958
4390: if ec_debug.G_debug_level = 3 then
4391: ec_debug.pl(3,'n_att_doc_id_pos: ',n_att_doc_id_pos);
4392: end if;
4393:

Line 4420: ece_extract_utils_pub.G_MAXCOLWIDTH,

4416:
4417: xProgress := 'POOB-60-1130';
4418: ece_flatfile_pvt.define_interface_column_type(n_att_header_sel_c,
4419: v_att_header_select,
4420: ece_extract_utils_pub.G_MAXCOLWIDTH,
4421: l_att_header_tbl);
4422:
4423: -- Bind Variables
4424: xProgress := 'POOB-60-1132';

Line 4478: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

4474: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');
4475: END; */
4476:
4477: xProgress := 'POOB-60-1180';
4478: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,
4479: cTransaction_Type,
4480: cCommunication_Method,
4481: cAtt_Header_Interface,
4482: l_att_header_tbl,

Line 4651: ece_extract_utils_pub.select_clause(cTransaction_Type,

4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4649: xProgress := 'POOB-70-1020';
4650: -- Build the SELECT Clause.
4651: ece_extract_utils_pub.select_clause(cTransaction_Type,
4652: cCommunication_Method,
4653: cAtt_Detail_Interface ,
4654: l_att_detail_tbl,
4655: v_att_detail_select,

Line 4873: ece_extract_utils_pub.G_MAXCOLWIDTH,

4869: -- Define Columns
4870: xProgress := 'POOB-70-1320';
4871: ece_flatfile_pvt.define_interface_column_type(n_att_detail_sel_c,
4872: v_att_detail_select,
4873: ece_extract_utils_pub.G_MAXCOLWIDTH,
4874: l_att_detail_tbl);
4875:
4876: IF cData_Type_ID = 1 THEN -- Short Text
4877: xProgress := 'POOB-70-1330';

Line 4878: /* dbms_sql.define_column(n_att_detail_sel_c,n_detail_count + 1,v_att_detail_select,ece_extract_utils_pub.G_MAXCOLWIDTH);*/

4874: l_att_detail_tbl);
4875:
4876: IF cData_Type_ID = 1 THEN -- Short Text
4877: xProgress := 'POOB-70-1330';
4878: /* dbms_sql.define_column(n_att_detail_sel_c,n_detail_count + 1,v_att_detail_select,ece_extract_utils_pub.G_MAXCOLWIDTH);*/
4879: /*Bug 2153310.
4880: Increased the size to 2000 since the short text attachment can have
4881: 2000 characters */
4882: dbms_sql.define_column(n_att_detail_sel_c,n_detail_count + 1,v_att_detail_select,2000);

Line 5220: /* ece_extract_utils_pub.insert_into_interface_tbl(

5216: l_att_detail_tbl(n_run_id_pos).value := iRun_id;
5217: l_att_detail_tbl(n_att_doc_id_pos).value := cAtt_doc_id; --Bug 2187958
5218: xProgress := 'POOB-70-1630';
5219: ec_debug.pl(3,'xProgress: ',xProgress);
5220: /* ece_extract_utils_pub.insert_into_interface_tbl(
5221: iRun_id,
5222: cTransaction_Type,
5223: cCommunication_Method,
5224: cAtt_Detail_Interface,