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 ECE_EXTRACT_UTILS_PUB

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

595: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
596:
597: -- ****************************************************************************
598: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic SQL
599: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary
600: -- for the build.
601: -- ****************************************************************************
602: BEGIN
603: SELECT map_id

Line 612: ece_extract_utils_pub.select_clause(cTransaction_Type,

608: WHEN OTHERS THEN
609: NULL;
610: END;
611: xProgress := 'POCOB-10-1050';
612: ece_extract_utils_pub.select_clause(cTransaction_Type,
613: cCommunication_Method,
614: cHeader_Interface,
615: l_header_tbl,
616: cHeader_select,

Line 632: ece_extract_utils_pub.select_clause(cTransaction_Type,

628: NULL;
629: END;
630:
631: xProgress := 'POCOB-10-1060';
632: ece_extract_utils_pub.select_clause(cTransaction_Type,
633: cCommunication_Method,
634: cLine_Interface,
635: l_line_tbl,
636: cLine_select,

Line 653: ece_extract_utils_pub.select_clause(cTransaction_Type,

649: NULL;
650: END;
651:
652: xProgress := 'POCOB-10-1070';
653: ece_extract_utils_pub.select_clause(cTransaction_Type,
654: cCommunication_Method,
655: cShipment_Interface,
656: l_shipment_tbl,
657: cShipment_select,

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

865: -- However, for simplicity, we will convert
866: -- everything to varchar2.
867: -- ******************************************************
868: xProgress := 'POCOB-10-1290';
869: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
870:
871: xProgress := 'POCOB-10-1300';
872: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
873:

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

868: xProgress := 'POCOB-10-1290';
869: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
870:
871: xProgress := 'POCOB-10-1300';
872: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
873:
874: xProgress := 'POCOB-10-1310';
875: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
876:

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

871: xProgress := 'POCOB-10-1300';
872: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
873:
874: xProgress := 'POCOB-10-1310';
875: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
876:
877: -- **************************************************************
878: -- *** The following is custom tailored for this transaction
879: -- *** It finds the values and use them in the WHERE clause to

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

884: -- we will need values for the join condition.
885: -- ***************************************************
886: -- Header Level Positions
887: xProgress := 'POCOB-10-1320';
888: ece_extract_utils_pub.find_pos(l_header_tbl,ece_extract_utils_pub.G_TRANSACTION_DATE,n_trx_date_pos);
889: ec_debug.pl(3,'n_trx_date_pos: ',n_trx_date_pos);
890:
891: xProgress := 'POCOB-10-1330';
892: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);

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

888: ece_extract_utils_pub.find_pos(l_header_tbl,ece_extract_utils_pub.G_TRANSACTION_DATE,n_trx_date_pos);
889: ec_debug.pl(3,'n_trx_date_pos: ',n_trx_date_pos);
890:
891: xProgress := 'POCOB-10-1330';
892: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);
893: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
894:
895: xProgress := 'POCOB-10-1340';
896: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);

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

892: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_HEADER_ID',nHeader_key_pos);
893: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
894:
895: xProgress := 'POCOB-10-1340';
896: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
897: ec_debug.pl(3,'nDocument_type_pos: ',nDocument_type_pos);
898:
899: xProgress := 'POCOB-10-1350';
900: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);

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

896: ece_extract_utils_pub.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
897: ec_debug.pl(3,'nDocument_type_pos: ',nDocument_type_pos);
898:
899: xProgress := 'POCOB-10-1350';
900: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
901: ec_debug.pl(3,'nPO_Number_pos: ',nPO_Number_pos);
902:
903: xProgress := 'POCOB-10-1360';
904: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);

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

900: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_NUMBER',nPO_Number_pos);
901: ec_debug.pl(3,'nPO_Number_pos: ',nPO_Number_pos);
902:
903: xProgress := 'POCOB-10-1360';
904: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
905: ec_debug.pl(3,'nPO_Type_pos: ',nPO_Type_pos);
906:
907: xProgress := 'POCOB-10-1370';
908: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);

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

904: ece_extract_utils_pub.find_pos(l_header_tbl,'PO_TYPE',nPO_Type_pos);
905: ec_debug.pl(3,'nPO_Type_pos: ',nPO_Type_pos);
906:
907: xProgress := 'POCOB-10-1370';
908: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
909: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
910:
911: xProgress := 'POCOB-10-1380';
912: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);

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

908: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_NUM',nRelease_num_pos);
909: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
910:
911: xProgress := 'POCOB-10-1380';
912: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
913: ec_debug.pl(3,'nRelease_id_pos: ',nRelease_id_pos);
914:
915: xProgress := 'POCOB-10-1381';
916: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);

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

912: ece_extract_utils_pub.find_pos(l_header_tbl,'POR_RELEASE_ID',nRelease_id_pos);
913: ec_debug.pl(3,'nRelease_id_pos: ',nRelease_id_pos);
914:
915: xProgress := 'POCOB-10-1381';
916: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
917:
918: xProgress := 'POOB-10-1382';
919: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
920:

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

922: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_CANCELLED_DATE',nHeader_cancel_date_pos); --2823215
923:
924: -- Line Level Positions
925: xProgress := 'POCOB-10-1390';
926: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
927: ec_debug.pl(3,'nLine_Location_ID_pos: ',nLine_Location_ID_pos);
928:
929: xProgress := 'POCOB-10-1400';
930: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);

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

926: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
927: ec_debug.pl(3,'nLine_Location_ID_pos: ',nLine_Location_ID_pos);
928:
929: xProgress := 'POCOB-10-1400';
930: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
931: ec_debug.pl(3,'nLine_num_pos: ',nLine_num_pos);
932:
933: xProgress := 'POCOB-10-1402';
934: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);

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

930: ece_extract_utils_pub.find_pos(l_line_tbl,'LINE_NUM',nLine_num_pos);
931: ec_debug.pl(3,'nLine_num_pos: ',nLine_num_pos);
932:
933: xProgress := 'POCOB-10-1402';
934: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
935: ec_debug.pl(3,'nLine_key_pos: ',nLine_key_pos);
936:
937: xProgress := 'POCOB-10-1404';
938: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);

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

934: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_ID',nLine_key_pos);
935: ec_debug.pl(3,'nLine_key_pos: ',nLine_key_pos);
936:
937: xProgress := 'POCOB-10-1404';
938: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
939: ec_debug.pl(3,'nItem_id_pos: ',nItem_id_pos);
940:
941: xProgress := 'POCOB-10-1405';
942: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);

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

938: ece_extract_utils_pub.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
939: ec_debug.pl(3,'nItem_id_pos: ',nItem_id_pos);
940:
941: xProgress := 'POCOB-10-1405';
942: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
943:
944: xProgress := 'POCOB-10-1406';
945: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
946:

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

941: xProgress := 'POCOB-10-1405';
942: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_FLAG',nLine_Cancel_Flag_pos);
943:
944: xProgress := 'POCOB-10-1406';
945: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
946:
947: xProgress := 'POCOB-10-1407';
948: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
949:

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

944: xProgress := 'POCOB-10-1406';
945: ece_extract_utils_pub.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_code_pos);
946:
947: xProgress := 'POCOB-10-1407';
948: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
949:
950: xProgress := 'POCOB-10-1408';
951: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
952:

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

947: xProgress := 'POCOB-10-1407';
948: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE_CATEGORY',nLp_att_cat_pos);
949:
950: xProgress := 'POCOB-10-1408';
951: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
952:
953: xProgress := 'POCOB-10-1409';
954: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
955:

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

950: xProgress := 'POCOB-10-1408';
951: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE1',nLp_att1_pos);
952:
953: xProgress := 'POCOB-10-1409';
954: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
955:
956: xProgress := 'POCOB-10-1410';
957: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
958:

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

953: xProgress := 'POCOB-10-1409';
954: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE2',nLp_att2_pos);
955:
956: xProgress := 'POCOB-10-1410';
957: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
958:
959: xProgress := 'POCOB-10-1411';
960: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
961:

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

956: xProgress := 'POCOB-10-1410';
957: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE3',nLp_att3_pos);
958:
959: xProgress := 'POCOB-10-1411';
960: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
961:
962: xProgress := 'POCOB-10-1412';
963: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
964:

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

959: xProgress := 'POCOB-10-1411';
960: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE4',nLp_att4_pos);
961:
962: xProgress := 'POCOB-10-1412';
963: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
964:
965: xProgress := 'POCOB-10-1413';
966: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
967:

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

962: xProgress := 'POCOB-10-1412';
963: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE5',nLp_att5_pos);
964:
965: xProgress := 'POCOB-10-1413';
966: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
967:
968: xProgress := 'POCOB-10-1414';
969: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
970:

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

965: xProgress := 'POCOB-10-1413';
966: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE6',nLp_att6_pos);
967:
968: xProgress := 'POCOB-10-1414';
969: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
970:
971: xProgress := 'POCOB-10-1415';
972: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
973:

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

968: xProgress := 'POCOB-10-1414';
969: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE7',nLp_att7_pos);
970:
971: xProgress := 'POCOB-10-1415';
972: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
973:
974: xProgress := 'POCOB-10-1416';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
976:

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

971: xProgress := 'POCOB-10-1415';
972: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE8',nLp_att8_pos);
973:
974: xProgress := 'POCOB-10-1416';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
976:
977: xProgress := 'POCOB-10-1417';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
979:

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

974: xProgress := 'POCOB-10-1416';
975: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE9',nLp_att9_pos);
976:
977: xProgress := 'POCOB-10-1417';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
979:
980: xProgress := 'POCOB-10-1418';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
982:

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

977: xProgress := 'POCOB-10-1417';
978: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE10',nLp_att10_pos);
979:
980: xProgress := 'POCOB-10-1418';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
982:
983: xProgress := 'POCOB-10-1419';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
985:

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

980: xProgress := 'POCOB-10-1418';
981: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE11',nLp_att11_pos);
982:
983: xProgress := 'POCOB-10-1419';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
985:
986: xProgress := 'POCOB-10-1420';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
988:

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

983: xProgress := 'POCOB-10-1419';
984: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE12',nLp_att12_pos);
985:
986: xProgress := 'POCOB-10-1420';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
988:
989: xProgress := 'POCOB-10-1421';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
991:

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

986: xProgress := 'POCOB-10-1420';
987: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE13',nLp_att13_pos);
988:
989: xProgress := 'POCOB-10-1421';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
991:
992: xProgress := 'POCOB-10-1422';
993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos);
994:

Line 993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos);

989: xProgress := 'POCOB-10-1421';
990: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE14',nLp_att14_pos);
991:
992: xProgress := 'POCOB-10-1422';
993: ece_extract_utils_pub.find_pos(l_line_tbl,'LP_ATTRIBUTE15',nLp_att15_pos);
994:
995:
996: -- Shipment Level Positions
997: xProgress := 'POCOB-10-1406';

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

994:
995:
996: -- Shipment Level Positions
997: xProgress := 'POCOB-10-1406';
998: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
999: ec_debug.pl(3,'nShip_Line_Location_ID_pos: ',nShip_Line_Location_ID_pos);
1000:
1001: xProgress := 'POCOB-10-1407';
1002: ece_extract_utils_pub.find_pos(l_Shipment_tbl,'QUANTITY_PENDING',nQuantity_pending_pos);

Line 1002: ece_extract_utils_pub.find_pos(l_Shipment_tbl,'QUANTITY_PENDING',nQuantity_pending_pos);

998: ece_extract_utils_pub.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nShip_Line_Location_ID_pos);
999: ec_debug.pl(3,'nShip_Line_Location_ID_pos: ',nShip_Line_Location_ID_pos);
1000:
1001: xProgress := 'POCOB-10-1407';
1002: ece_extract_utils_pub.find_pos(l_Shipment_tbl,'QUANTITY_PENDING',nQuantity_pending_pos);
1003:
1004: xProgress := 'POCOB-10-1408';
1005: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1006:

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

1001: xProgress := 'POCOB-10-1407';
1002: ece_extract_utils_pub.find_pos(l_Shipment_tbl,'QUANTITY_PENDING',nQuantity_pending_pos);
1003:
1004: xProgress := 'POCOB-10-1408';
1005: ece_extract_utils_pub.find_pos(l_shipment_tbl,'CANCELLED_FLAG',nShipment_Cancel_Flag_pos);
1006:
1007: --2823215
1008:
1009: xProgress := 'POOB-10-1025';

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

1006:
1007: --2823215
1008:
1009: xProgress := 'POOB-10-1025';
1010: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1011:
1012: xProgress := 'POOB-10-1026';
1013: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1014:

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

1009: xProgress := 'POOB-10-1025';
1010: ece_extract_utils_pub.find_pos(l_shipment_tbl,'POR_RELEASE_NUM',nShip_Release_Num_pos);
1011:
1012: xProgress := 'POOB-10-1026';
1013: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1014:
1015: xProgress := 'POOB-10-1427';
1016: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1017:

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

1012: xProgress := 'POOB-10-1026';
1013: ece_extract_utils_pub.find_pos(l_shipment_tbl,'UOM_CODE',nLine_Location_uom_pos);
1014:
1015: xProgress := 'POOB-10-1427';
1016: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1017:
1018: xProgress := 'POOB-10-1428';
1019: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1020:

Line 1084: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_DATE',nCancel_Date_pos);

1080: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1081: -- 2412921 begin
1082:
1083: xProgress := 'POCOB-10-1410';
1084: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_DATE',nCancel_Date_pos);
1085: ec_debug.pl(3,'nCancel_Date_pos -> ', nCancel_Date_pos);
1086:
1087: xProgress := 'POCOB-10-1412';
1088: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_DATE',nCancel_Date_posl);

Line 1088: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_DATE',nCancel_Date_posl);

1084: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_DATE',nCancel_Date_pos);
1085: ec_debug.pl(3,'nCancel_Date_pos -> ', nCancel_Date_pos);
1086:
1087: xProgress := 'POCOB-10-1412';
1088: ece_extract_utils_pub.find_pos(l_line_tbl,'CANCEL_DATE',nCancel_Date_posl);
1089: ec_debug.pl(3,'nCancel_Date_posl -> ', nCancel_Date_posl);
1090: -- 2412921 end
1091:
1092:

Line 1435: /* ece_extract_utils_pub.insert_into_interface_tbl(

1431: c_file_common_key := c_file_common_key ||
1432: RPAD(SUBSTRB(NVL(l_header_tbl(n_header_common_key_pos).value,' '),1,22),22) || RPAD(' ',22) || RPAD(' ',22);
1433:
1434: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1435: /* ece_extract_utils_pub.insert_into_interface_tbl(
1436: iRun_id,
1437: cTransaction_Type,
1438: cCommunication_Method,
1439: cHeader_Interface,

Line 1613: ece_extract_utils_pub.insert_into_interface_tbl(

1609: ec_debug.pl(3,'l_line_fkey: ',l_line_fkey);
1610:
1611: -- Insert into Interface Table
1612: /* xProgress := 'POCOB-10-1600';
1613: ece_extract_utils_pub.insert_into_interface_tbl(
1614: iRun_id,
1615: cTransaction_Type,
1616: cCommunication_Method,
1617: cLine_Interface,

Line 1987: /* ece_extract_utils_pub.insert_into_interface_tbl(

1983: p_key_tbl => l_key_tbl,
1984: p_tbl => l_Shipment_tbl);
1985:
1986: xProgress := 'POCOB-10-1700';
1987: /* ece_extract_utils_pub.insert_into_interface_tbl(
1988: iRun_id,
1989: cTransaction_Type,
1990: cCommunication_Method,
1991: cShipment_Interface,