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 616: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary

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

Line 630: ece_extract_utils_pub.select_clause(cTransaction_Type,

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

Line 650: ece_extract_utils_pub.select_clause(cTransaction_Type,

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

Line 670: ece_extract_utils_pub.select_clause(cTransaction_Type,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

943: xProgress := 'POOB-10-1340';
944: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
945:
946: xProgress := 'POOB-10-1350';
947: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
948:
949: xProgress := 'POOB-10-1351';
950: ece_extract_utils_pub.find_pos(l_header_tbl,'VENDOR_SITE_ID',nVendor_Site_Id_pos); --Added as part of the bug 15880908 fix
951:

Line 950: ece_extract_utils_pub.find_pos(l_header_tbl,'VENDOR_SITE_ID',nVendor_Site_Id_pos); --Added as part of the bug 15880908 fix

946: xProgress := 'POOB-10-1350';
947: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
948:
949: xProgress := 'POOB-10-1351';
950: ece_extract_utils_pub.find_pos(l_header_tbl,'VENDOR_SITE_ID',nVendor_Site_Id_pos); --Added as part of the bug 15880908 fix
951:
952: xProgress := 'POOB-10-1360';
953: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
954:

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

949: xProgress := 'POOB-10-1351';
950: ece_extract_utils_pub.find_pos(l_header_tbl,'VENDOR_SITE_ID',nVendor_Site_Id_pos); --Added as part of the bug 15880908 fix
951:
952: xProgress := 'POOB-10-1360';
953: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
954:
955: xProgress := 'POOB-10-1370';
956: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
957:

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

952: xProgress := 'POOB-10-1360';
953: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
954:
955: xProgress := 'POOB-10-1370';
956: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
957:
958: xProgress := 'POOB-10-1380';
959: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
960:

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

955: xProgress := 'POOB-10-1370';
956: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
957:
958: xProgress := 'POOB-10-1380';
959: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
960:
961: xProgress := 'POOB-10-1381';
962: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
963:

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

958: xProgress := 'POOB-10-1380';
959: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
960:
961: xProgress := 'POOB-10-1381';
962: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
963:
964: xProgress := 'POOB-10-1382';
965: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
966:

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

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

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

968: xProgress := 'POOB-10-1390';
969: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
970:
971: xProgress := 'POOB-10-1400';
972: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
973:
974: xProgress := 'POOB-10-1402';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
976:

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

971: xProgress := 'POOB-10-1400';
972: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
973:
974: xProgress := 'POOB-10-1402';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
976:
977: xProgress := 'POOB-10-1404';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
979:

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

974: xProgress := 'POOB-10-1402';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
976:
977: xProgress := 'POOB-10-1404';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
979:
980: xProgress := 'POOB-10-1405';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
982: -- 2823215

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

977: xProgress := 'POOB-10-1404';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
979:
980: xProgress := 'POOB-10-1405';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
982: -- 2823215
983: xProgress := 'POOB-10-1406';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
985:

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

980: xProgress := 'POOB-10-1405';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
982: -- 2823215
983: xProgress := 'POOB-10-1406';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
985:
986: xProgress := 'POOB-10-1407';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
988:

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

983: xProgress := 'POOB-10-1406';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
985:
986: xProgress := 'POOB-10-1407';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
988:
989: xProgress := 'POOB-10-1408';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
991:

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

986: xProgress := 'POOB-10-1407';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
988:
989: xProgress := 'POOB-10-1408';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
991:
992: xProgress := 'POOB-10-1409';
993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
994:

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

989: xProgress := 'POOB-10-1408';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
991:
992: xProgress := 'POOB-10-1409';
993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
994:
995: xProgress := 'POOB-10-1410';
996: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
997:

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

992: xProgress := 'POOB-10-1409';
993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
994:
995: xProgress := 'POOB-10-1410';
996: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
997:
998: xProgress := 'POOB-10-1411';
999: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
1000:

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

995: xProgress := 'POOB-10-1410';
996: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
997:
998: xProgress := 'POOB-10-1411';
999: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
1000:
1001: xProgress := 'POOB-10-1412';
1002: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
1003:

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

998: xProgress := 'POOB-10-1411';
999: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
1000:
1001: xProgress := 'POOB-10-1412';
1002: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
1003:
1004: xProgress := 'POOB-10-1413';
1005: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1006:

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

1001: xProgress := 'POOB-10-1412';
1002: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
1003:
1004: xProgress := 'POOB-10-1413';
1005: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1006:
1007: xProgress := 'POOB-10-1414';
1008: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1009:

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

1004: xProgress := 'POOB-10-1413';
1005: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
1006:
1007: xProgress := 'POOB-10-1414';
1008: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1009:
1010: xProgress := 'POOB-10-1415';
1011: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1012:

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

1007: xProgress := 'POOB-10-1414';
1008: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
1009:
1010: xProgress := 'POOB-10-1415';
1011: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1012:
1013: xProgress := 'POOB-10-1416';
1014: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1015:

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

1010: xProgress := 'POOB-10-1415';
1011: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
1012:
1013: xProgress := 'POOB-10-1416';
1014: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1015:
1016: xProgress := 'POOB-10-1417';
1017: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1018:

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

1013: xProgress := 'POOB-10-1416';
1014: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
1015:
1016: xProgress := 'POOB-10-1417';
1017: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1018:
1019: xProgress := 'POOB-10-1418';
1020: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1021:

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

1016: xProgress := 'POOB-10-1417';
1017: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
1018:
1019: xProgress := 'POOB-10-1418';
1020: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1021:
1022: xProgress := 'POOB-10-1419';
1023: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1024:

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

1019: xProgress := 'POOB-10-1418';
1020: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
1021:
1022: xProgress := 'POOB-10-1419';
1023: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1024:
1025: xProgress := 'POOB-10-1420';
1026: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1027:

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

1022: xProgress := 'POOB-10-1419';
1023: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
1024:
1025: xProgress := 'POOB-10-1420';
1026: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1027:
1028: xProgress := 'POOB-10-1421';
1029: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1030:

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

1025: xProgress := 'POOB-10-1420';
1026: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
1027:
1028: xProgress := 'POOB-10-1421';
1029: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1030:
1031: xProgress := 'POOB-10-1422';
1032: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos); -- 2823215
1033:

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

1028: xProgress := 'POOB-10-1421';
1029: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
1030:
1031: xProgress := 'POOB-10-1422';
1032: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos); -- 2823215
1033:
1034:
1035: -- Shipment Level Positions
1036: xProgress := 'POOB-10-1423';

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

1033:
1034:
1035: -- Shipment Level Positions
1036: xProgress := 'POOB-10-1423';
1037: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
1038:
1039: xProgress := 'POOB-10-1424';
1040: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1041:

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

1036: xProgress := 'POOB-10-1423';
1037: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
1038:
1039: xProgress := 'POOB-10-1424';
1040: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1041:
1042: xProgress := 'POOB-10-1025';
1043: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1044:

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

1039: xProgress := 'POOB-10-1424';
1040: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1041:
1042: xProgress := 'POOB-10-1025';
1043: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1044:
1045: xProgress := 'POOB-10-1026';
1046: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1047:

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

1042: xProgress := 'POOB-10-1025';
1043: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1044:
1045: xProgress := 'POOB-10-1026';
1046: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1047:
1048: xProgress := 'POOB-10-1427';
1049: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1050:

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

1045: xProgress := 'POOB-10-1026';
1046: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1047:
1048: xProgress := 'POOB-10-1427';
1049: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1050:
1051: xProgress := 'POOB-10-1428';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1053:

Line 1483: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

1479:
1480: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1481:
1482:
1483: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,
1484: cTransaction_Type,
1485: cCommunication_Method,
1486: cHeader_Interface,
1487: l_header_tbl,

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

1762:
1763: --2823215
1764: -- Insert into Interface Table
1765: /* xProgress := 'POOB-10-1600';
1766: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cLine_Interface,l_line_tbl,l_line_fkey); */
1767:
1768:
1769:
1770: /***************************

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

2000: p_tbl => l_shipment_tbl);
2001:
2002: /* xProgress := 'POOB-10-1690';
2003:
2004: ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,cTransaction_Type,cCommunication_Method,cShipment_Interface,l_shipment_tbl,l_shipment_fkey); */
2005:
2006: xProgress := 'POOB-10-1690';
2007: c_file_common_key := RPAD(SUBSTRB(NVL(l_header_tbl(nTrans_code_pos).value ,' '),1,25),25) ||
2008: RPAD(SUBSTRB(NVL(l_header_tbl(n_header_common_key_pos).value ,' '),1,22),22) ||

Line 3651: ece_extract_utils_pub.select_clause(cTransaction_Type,

3647: END if;
3648: ece_flatfile_pvt.init_table(cTransaction_Type,cDistribution_Interface,iProject_output_level,TRUE,l_project_tbl,l_key_tbl);
3649:
3650: xProgress := 'POOB-40-1010';
3651: ece_extract_utils_pub.select_clause(cTransaction_Type,
3652: cCommunication_Method,
3653: cDistribution_Interface,
3654: l_project_tbl,
3655: cProject_select,

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

3710: --ec_debug.pl(3,'iKey_count: ',iKey_count);
3711:
3712: -- Define Column Types
3713: xProgress := 'POOB-40-1090';
3714: ece_flatfile_pvt.define_interface_column_type(project_sel_c,cProject_select,ece_extract_utils_PUB.G_MaxColWidth,l_project_tbl);
3715:
3716: -- Project Level Positions
3717:
3718: end if; --Bug 2490109

Line 3797: ece_extract_utils_pub.insert_into_interface_tbl(

3793: end if;
3794:
3795: -- Insert into Interface Table
3796: /* xProgress := 'POOB-40-1230';
3797: ece_extract_utils_pub.insert_into_interface_tbl(
3798: iRun_id,
3799: cTransaction_Type,
3800: cCommunication_Method,
3801: cDistribution_Interface,

Line 4287: ece_extract_utils_pub.select_clause(cTransaction_Type,

4283: end if;
4284:
4285: xProgress := 'POOB-60-1005';
4286: -- Build the SELECT Clause.
4287: ece_extract_utils_pub.select_clause(cTransaction_Type,
4288: cCommunication_Method,
4289: cAtt_Header_Interface,
4290: l_att_header_tbl,
4291: v_att_header_select,

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

4408: ec_debug.pl(3,'v_att_header_select: ',v_att_header_select);
4409: end if;
4410:
4411: xProgress := 'POOB-60-1092';
4412: ece_extract_utils_pub.find_pos(l_att_header_tbl,'DATATYPE_ID',n_datatype_id_pos);
4413:
4414: xProgress := 'POOB-60-1094';
4415: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATT_SEQ_NUM',n_att_seq_num_pos);
4416: if ec_debug.G_debug_level = 3 then

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

4411: xProgress := 'POOB-60-1092';
4412: ece_extract_utils_pub.find_pos(l_att_header_tbl,'DATATYPE_ID',n_datatype_id_pos);
4413:
4414: xProgress := 'POOB-60-1094';
4415: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATT_SEQ_NUM',n_att_seq_num_pos);
4416: if ec_debug.G_debug_level = 3 then
4417: ec_debug.pl(3,'n_datatype_id_pos: ',n_datatype_id_pos);
4418: ec_debug.pl(3,'n_att_seq_num_pos: ',n_att_seq_num_pos);
4419: end if;

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

4418: ec_debug.pl(3,'n_att_seq_num_pos: ',n_att_seq_num_pos);
4419: end if;
4420:
4421: xProgress := 'POOB-60-1096';
4422: ece_extract_utils_pub.find_pos(l_att_header_tbl,'ATTACHED_DOCUMENT_ID',n_att_doc_id_pos); --Bug 2187958
4423: if ec_debug.G_debug_level = 3 then
4424: ec_debug.pl(3,'n_att_doc_id_pos: ',n_att_doc_id_pos);
4425: end if;
4426:

Line 4453: ece_extract_utils_pub.G_MAXCOLWIDTH,

4449:
4450: xProgress := 'POOB-60-1130';
4451: ece_flatfile_pvt.define_interface_column_type(n_att_header_sel_c,
4452: v_att_header_select,
4453: ece_extract_utils_pub.G_MAXCOLWIDTH,
4454: l_att_header_tbl);
4455:
4456: -- Bind Variables
4457: xProgress := 'POOB-60-1132';

Line 4511: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

4507: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');
4508: END; */
4509:
4510: xProgress := 'POOB-60-1180';
4511: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,
4512: cTransaction_Type,
4513: cCommunication_Method,
4514: cAtt_Header_Interface,
4515: l_att_header_tbl,

Line 4684: ece_extract_utils_pub.select_clause(cTransaction_Type,

4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4682: xProgress := 'POOB-70-1020';
4683: -- Build the SELECT Clause.
4684: ece_extract_utils_pub.select_clause(cTransaction_Type,
4685: cCommunication_Method,
4686: cAtt_Detail_Interface ,
4687: l_att_detail_tbl,
4688: v_att_detail_select,

Line 4906: ece_extract_utils_pub.G_MAXCOLWIDTH,

4902: -- Define Columns
4903: xProgress := 'POOB-70-1320';
4904: ece_flatfile_pvt.define_interface_column_type(n_att_detail_sel_c,
4905: v_att_detail_select,
4906: ece_extract_utils_pub.G_MAXCOLWIDTH,
4907: l_att_detail_tbl);
4908:
4909: IF cData_Type_ID = 1 THEN -- Short Text
4910: xProgress := 'POOB-70-1330';

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

4907: l_att_detail_tbl);
4908:
4909: IF cData_Type_ID = 1 THEN -- Short Text
4910: xProgress := 'POOB-70-1330';
4911: /* dbms_sql.define_column(n_att_detail_sel_c,n_detail_count + 1,v_att_detail_select,ece_extract_utils_pub.G_MAXCOLWIDTH);*/
4912: /*Bug 2153310.
4913: Increased the size to 2000 since the short text attachment can have
4914: 2000 characters */
4915: dbms_sql.define_column(n_att_detail_sel_c,n_detail_count + 1,v_att_detail_select,2000);

Line 5253: /* ece_extract_utils_pub.insert_into_interface_tbl(

5249: l_att_detail_tbl(n_run_id_pos).value := iRun_id;
5250: l_att_detail_tbl(n_att_doc_id_pos).value := cAtt_doc_id; --Bug 2187958
5251: xProgress := 'POOB-70-1630';
5252: ec_debug.pl(3,'xProgress: ',xProgress);
5253: /* ece_extract_utils_pub.insert_into_interface_tbl(
5254: iRun_id,
5255: cTransaction_Type,
5256: cCommunication_Method,
5257: cAtt_Detail_Interface,