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_FLATFILE_PVT

Line 250: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

246:
247: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
248: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
249:
250: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:

Line 251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;

247: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
248: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
249:
250: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;

248: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
249:
250: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;

249:
250: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

251: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

252: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

253: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

254:
255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

255: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

256: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

Line 261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

257: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
265:

Line 262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

258: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
265:
266: iAtt_hdr_pos NUMBER := 0;

Line 263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;

259: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
265:
266: iAtt_hdr_pos NUMBER := 0;
267: iAtt_ln_pos NUMBER := 0;

Line 264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;

260: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
261: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
262: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
263: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
264: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
265:
266: iAtt_hdr_pos NUMBER := 0;
267: iAtt_ln_pos NUMBER := 0;
268: iAtt_mi_pos NUMBER := 0;

Line 582: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);

578: ec_debug.pl(3,'v_att_enabled: ' ,v_att_enabled);
579: ec_debug.pl(3,'n_att_seg_size: ' ,n_att_seg_size);
580:
581: xProgress := 'POCOB-10-1010';
582: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);
583:
584: xProgress := 'POCOB-10-1020';
585: l_key_tbl := l_header_tbl;
586:

Line 592: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);

588: --iKey_count := l_header_tbl.COUNT;
589: --ec_debug.pl(3,'iKey_count: ',iKey_count );
590:
591: xProgress := 'POCOB-10-1030';
592: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
593:
594: xProgress := 'POCOB-10-1040';
595: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
596:

Line 595: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);

591: xProgress := 'POCOB-10-1030';
592: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
593:
594: xProgress := 'POCOB-10-1040';
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

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 919: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215

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:
921: XProgress := 'POCOB-10-1283';
922: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_CANCELLED_DATE',nHeader_cancel_date_pos); --2823215
923:

Line 922: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_CANCELLED_DATE',nHeader_cancel_date_pos); --2823215

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:
921: XProgress := 'POCOB-10-1283';
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);

Line 1019: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);

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:
1021: xProgress := 'POOB-10-1429';
1022: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1023:

Line 1022: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);

1018: xProgress := 'POOB-10-1428';
1019: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1020:
1021: xProgress := 'POOB-10-1429';
1022: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1023:
1024: xProgress := 'POOB-10-1430';
1025: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1026:

Line 1025: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);

1021: xProgress := 'POOB-10-1429';
1022: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1023:
1024: xProgress := 'POOB-10-1430';
1025: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1026:
1027: xProgress := 'POOB-10-1431';
1028: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1029:

Line 1028: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);

1024: xProgress := 'POOB-10-1430';
1025: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1026:
1027: xProgress := 'POOB-10-1431';
1028: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1029:
1030: xProgress := 'POOB-10-1432';
1031: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1032:

Line 1031: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);

1027: xProgress := 'POOB-10-1431';
1028: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1029:
1030: xProgress := 'POOB-10-1432';
1031: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1032:
1033: xProgress := 'POOB-10-1433';
1034: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1035:

Line 1034: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);

1030: xProgress := 'POOB-10-1432';
1031: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1032:
1033: xProgress := 'POOB-10-1433';
1034: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1035:
1036: xProgress := 'POOB-10-1434';
1037: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1038:

Line 1037: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);

1033: xProgress := 'POOB-10-1433';
1034: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1035:
1036: xProgress := 'POOB-10-1434';
1037: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1038:
1039: xProgress := 'POOB-10-1435';
1040: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1041:

Line 1040: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);

1036: xProgress := 'POOB-10-1434';
1037: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1038:
1039: xProgress := 'POOB-10-1435';
1040: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1041:
1042: xProgress := 'POOB-10-1437';
1043: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1044:

Line 1043: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);

1039: xProgress := 'POOB-10-1435';
1040: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1041:
1042: xProgress := 'POOB-10-1437';
1043: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1044:
1045: xProgress := 'POOB-10-1438';
1046: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1047:

Line 1046: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);

1042: xProgress := 'POOB-10-1437';
1043: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1044:
1045: xProgress := 'POOB-10-1438';
1046: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1047:
1048: xProgress := 'POOB-10-1439';
1049: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1050:

Line 1049: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);

1045: xProgress := 'POOB-10-1438';
1046: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1047:
1048: xProgress := 'POOB-10-1439';
1049: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1050:
1051: xProgress := 'POOB-10-1440';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1053:

Line 1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);

1048: xProgress := 'POOB-10-1439';
1049: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1050:
1051: xProgress := 'POOB-10-1440';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1053:
1054: xProgress := 'POOB-10-1441';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1056:

Line 1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);

1051: xProgress := 'POOB-10-1440';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1053:
1054: xProgress := 'POOB-10-1441';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1056:
1057: xProgress := 'POOB-10-1442';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1059:

Line 1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);

1054: xProgress := 'POOB-10-1441';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1056:
1057: xProgress := 'POOB-10-1442';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1059:
1060: xProgress := 'POOB-10-1443';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1062:

Line 1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);

1057: xProgress := 'POOB-10-1442';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1059:
1060: xProgress := 'POOB-10-1443';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1062:
1063: xProgress := 'POOB-10-1444';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1065:

Line 1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);

1060: xProgress := 'POOB-10-1443';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1062:
1063: xProgress := 'POOB-10-1444';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1065:
1066: xProgress := 'POOB-10-1445';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1068:

Line 1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);

1063: xProgress := 'POOB-10-1444';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1065:
1066: xProgress := 'POOB-10-1445';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1068:
1069: xProgress := 'POOB-10-1446';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1071:

Line 1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);

1066: xProgress := 'POOB-10-1445';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1068:
1069: xProgress := 'POOB-10-1446';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1071:
1072: xProgress := 'POOB-10-1447';
1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1074:

Line 1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);

1069: xProgress := 'POOB-10-1446';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1071:
1072: xProgress := 'POOB-10-1447';
1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1074:
1075: -- 2823215
1076: xProgress := 'POCOB-10-1448';
1077: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);

Line 1077: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);

1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1074:
1075: -- 2823215
1076: xProgress := 'POCOB-10-1448';
1077: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1078:
1079: xProgress := 'POCOB-10-1449';
1080: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1081: -- 2412921 begin

Line 1080: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);

1076: xProgress := 'POCOB-10-1448';
1077: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1078:
1079: xProgress := 'POCOB-10-1449';
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);

Line 1095: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);

1091:
1092:
1093: -- Timezone enhancement
1094: xProgress := 'POCOB-TZ-1000';
1095: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1096:
1097: xProgress := 'POCOB-TZ-1001';
1098: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1099:

Line 1098: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);

1094: xProgress := 'POCOB-TZ-1000';
1095: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1096:
1097: xProgress := 'POCOB-TZ-1001';
1098: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1099:
1100: xProgress := 'POCOB-TZ-1002';
1101: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1102:

Line 1101: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);

1097: xProgress := 'POCOB-TZ-1001';
1098: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1099:
1100: xProgress := 'POCOB-TZ-1002';
1101: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1102:
1103: xProgress := 'POCOB-TZ-1003';
1104: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1105:

Line 1104: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);

1100: xProgress := 'POCOB-TZ-1002';
1101: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1102:
1103: xProgress := 'POCOB-TZ-1003';
1104: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1105:
1106: xProgress := 'POCOB-TZ-1004';
1107: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1108:

Line 1107: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);

1103: xProgress := 'POCOB-TZ-1003';
1104: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1105:
1106: xProgress := 'POCOB-TZ-1004';
1107: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1108:
1109: xProgress := 'POCOB-TZ-1005';
1110: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1111:

Line 1110: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);

1106: xProgress := 'POCOB-TZ-1004';
1107: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1108:
1109: xProgress := 'POCOB-TZ-1005';
1110: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1111:
1112: xProgress := 'POCOB-TZ-1006';
1113: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1114:

Line 1113: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);

1109: xProgress := 'POCOB-TZ-1005';
1110: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1111:
1112: xProgress := 'POCOB-TZ-1006';
1113: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1114:
1115: xProgress := 'POCOB-TZ-1007';
1116: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1117:

Line 1116: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);

1112: xProgress := 'POCOB-TZ-1006';
1113: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1114:
1115: xProgress := 'POCOB-TZ-1007';
1116: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1117:
1118: xProgress := 'POCOB-TZ-1008';
1119: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1120:

Line 1119: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);

1115: xProgress := 'POCOB-TZ-1007';
1116: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1117:
1118: xProgress := 'POCOB-TZ-1008';
1119: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1120:
1121: xProgress := 'POCOB-TZ-1009';
1122: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1123:

Line 1122: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);

1118: xProgress := 'POCOB-TZ-1008';
1119: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1120:
1121: xProgress := 'POCOB-TZ-1009';
1122: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1123:
1124: xProgress := 'POCOB-TZ-1010';
1125: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1126:

Line 1125: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);

1121: xProgress := 'POCOB-TZ-1009';
1122: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1123:
1124: xProgress := 'POCOB-TZ-1010';
1125: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1126:
1127: xProgress := 'POCOB-TZ-1011';
1128: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1129:

Line 1128: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);

1124: xProgress := 'POCOB-TZ-1010';
1125: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1126:
1127: xProgress := 'POCOB-TZ-1011';
1128: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1129:
1130: xProgress := 'POCOB-TZ-1012';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1132:

Line 1131: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);

1127: xProgress := 'POCOB-TZ-1011';
1128: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1129:
1130: xProgress := 'POCOB-TZ-1012';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1132:
1133: xProgress := 'POCOB-TZ-1013';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1135:

Line 1134: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);

1130: xProgress := 'POCOB-TZ-1012';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1132:
1133: xProgress := 'POCOB-TZ-1013';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1135:
1136: xProgress := 'POCOB-TZ-1014';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1138:

Line 1137: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);

1133: xProgress := 'POCOB-TZ-1013';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1135:
1136: xProgress := 'POCOB-TZ-1014';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1138:
1139: xProgress := 'POCOB-TZ-1015';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1141:

Line 1140: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);

1136: xProgress := 'POCOB-TZ-1014';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1138:
1139: xProgress := 'POCOB-TZ-1015';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1141:
1142: xProgress := 'POCOB-TZ-1016';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1144:

Line 1143: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);

1139: xProgress := 'POCOB-TZ-1015';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1141:
1142: xProgress := 'POCOB-TZ-1016';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1144:
1145: xProgress := 'POCOB-TZ-1017';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1147:

Line 1146: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);

1142: xProgress := 'POCOB-TZ-1016';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1144:
1145: xProgress := 'POCOB-TZ-1017';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1147:
1148: xProgress := 'POCOB-TZ-1018';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1150:

Line 1149: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);

1145: xProgress := 'POCOB-TZ-1017';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1147:
1148: xProgress := 'POCOB-TZ-1018';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1150:
1151: xProgress := 'POCOB-TZ-1019';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1153:

Line 1152: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);

1148: xProgress := 'POCOB-TZ-1018';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1150:
1151: xProgress := 'POCOB-TZ-1019';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1153:
1154: xProgress := 'POCOB-TZ-1020';
1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1156:

Line 1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);

1151: xProgress := 'POCOB-TZ-1019';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1153:
1154: xProgress := 'POCOB-TZ-1020';
1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1156:
1157:
1158: xProgress := 'POCOB-TZ-1021';
1159: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);

Line 1159: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);

1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1156:
1157:
1158: xProgress := 'POCOB-TZ-1021';
1159: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1160:
1161: xProgress := 'POCOB-TZ-1022';
1162: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1163:

Line 1162: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);

1158: xProgress := 'POCOB-TZ-1021';
1159: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1160:
1161: xProgress := 'POCOB-TZ-1022';
1162: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1163:
1164: xProgress := 'POCOB-TZ-1023';
1165: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1166:

Line 1165: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);

1161: xProgress := 'POCOB-TZ-1022';
1162: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1163:
1164: xProgress := 'POCOB-TZ-1023';
1165: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1166:
1167: xProgress := 'POCOB-TZ-1024';
1168: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1169:

Line 1168: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);

1164: xProgress := 'POCOB-TZ-1023';
1165: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1166:
1167: xProgress := 'POCOB-TZ-1024';
1168: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1169:
1170: xProgress := 'POCOB-TZ-1025';
1171: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1172:

Line 1171: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);

1167: xProgress := 'POCOB-TZ-1024';
1168: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1169:
1170: xProgress := 'POCOB-TZ-1025';
1171: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1172:
1173: xProgress := 'POCOB-TZ-1026';
1174: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1175:

Line 1174: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);

1170: xProgress := 'POCOB-TZ-1025';
1171: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1172:
1173: xProgress := 'POCOB-TZ-1026';
1174: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1175:
1176: xProgress := 'POCOB-TZ-1027';
1177: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1178:

Line 1177: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);

1173: xProgress := 'POCOB-TZ-1026';
1174: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1175:
1176: xProgress := 'POCOB-TZ-1027';
1177: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1178:
1179: xProgress := 'POCOB-TZ-1028';
1180: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1181:

Line 1180: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);

1176: xProgress := 'POCOB-TZ-1027';
1177: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1178:
1179: xProgress := 'POCOB-TZ-1028';
1180: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1181:
1182: xProgress := 'POCOB-TZ-1029';
1183: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1184:

Line 1183: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);

1179: xProgress := 'POCOB-TZ-1028';
1180: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1181:
1182: xProgress := 'POCOB-TZ-1029';
1183: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1184:
1185: xProgress := 'POCOB-TZ-1030';
1186: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1187:

Line 1186: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);

1182: xProgress := 'POCOB-TZ-1029';
1183: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1184:
1185: xProgress := 'POCOB-TZ-1030';
1186: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1187:
1188: xProgress := 'POCOB-TZ-1031';
1189: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1190:

Line 1189: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);

1185: xProgress := 'POCOB-TZ-1030';
1186: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1187:
1188: xProgress := 'POCOB-TZ-1031';
1189: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1190:
1191: xProgress := 'POCOB-TZ-1032';
1192: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1193:

Line 1192: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);

1188: xProgress := 'POCOB-TZ-1031';
1189: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1190:
1191: xProgress := 'POCOB-TZ-1032';
1192: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1193:
1194: xProgress := 'POCOB-TZ-1033';
1195: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1196:

Line 1195: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);

1191: xProgress := 'POCOB-TZ-1032';
1192: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1193:
1194: xProgress := 'POCOB-TZ-1033';
1195: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1196:
1197: xProgress := 'POCOB-TZ-1034';
1198: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1199:

Line 1198: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);

1194: xProgress := 'POCOB-TZ-1033';
1195: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1196:
1197: xProgress := 'POCOB-TZ-1034';
1198: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1199:
1200: xProgress := 'POCOB-TZ-1035';
1201: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1202:

Line 1201: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);

1197: xProgress := 'POCOB-TZ-1034';
1198: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1199:
1200: xProgress := 'POCOB-TZ-1035';
1201: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1202:
1203: xProgress := 'POCOB-TZ-1036';
1204: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1205:

Line 1204: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);

1200: xProgress := 'POCOB-TZ-1035';
1201: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1202:
1203: xProgress := 'POCOB-TZ-1036';
1204: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1205:
1206: xProgress := 'POCOB-TZ-1037';
1207: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1208:

Line 1207: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);

1203: xProgress := 'POCOB-TZ-1036';
1204: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1205:
1206: xProgress := 'POCOB-TZ-1037';
1207: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1208:
1209: xProgress := 'POCOB-TZ-1038';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1211:

Line 1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);

1206: xProgress := 'POCOB-TZ-1037';
1207: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1208:
1209: xProgress := 'POCOB-TZ-1038';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1211:
1212: xProgress := 'POCOB-TZ-1039';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1214:

Line 1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);

1209: xProgress := 'POCOB-TZ-1038';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1211:
1212: xProgress := 'POCOB-TZ-1039';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1214:
1215: xProgress := 'POCOB-TZ-1040';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1217:

Line 1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);

1212: xProgress := 'POCOB-TZ-1039';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1214:
1215: xProgress := 'POCOB-TZ-1040';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1217:
1218: xProgress := 'POCOB-TZ-1041';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1220:

Line 1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);

1215: xProgress := 'POCOB-TZ-1040';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1217:
1218: xProgress := 'POCOB-TZ-1041';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1220:
1221: xProgress := 'POCOB-TZ-1042';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1223:

Line 1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);

1218: xProgress := 'POCOB-TZ-1041';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1220:
1221: xProgress := 'POCOB-TZ-1042';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1223:
1224: xProgress := 'POCOB-TZ-1043';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1226:

Line 1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);

1221: xProgress := 'POCOB-TZ-1042';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1223:
1224: xProgress := 'POCOB-TZ-1043';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1226:
1227: xProgress := 'POCOB-TZ-1044';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1229: -- Timezone enhancement

Line 1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);

1224: xProgress := 'POCOB-TZ-1043';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1226:
1227: xProgress := 'POCOB-TZ-1044';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1229: -- Timezone enhancement
1230: xProgress := 'POCOB-09-1400';
1231: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1232:

Line 1231: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);

1227: xProgress := 'POCOB-TZ-1044';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1229: -- Timezone enhancement
1230: xProgress := 'POCOB-09-1400';
1231: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1232:
1233: xProgress := 'POCOB-09-1401';
1234: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1235:

Line 1234: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);

1230: xProgress := 'POCOB-09-1400';
1231: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1232:
1233: xProgress := 'POCOB-09-1401';
1234: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1235:
1236: xProgress := 'POCOB-09-1402';
1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1238:

Line 1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);

1233: xProgress := 'POCOB-09-1401';
1234: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1235:
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

Line 1292: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,0,l_header_tbl,l_key_tbl);

1288: -- **************************************
1289: -- store internal values in pl/sql table
1290: -- **************************************
1291: xProgress := 'POCOB-10-1420';
1292: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,0,l_header_tbl,l_key_tbl);
1293:
1294: -- ***************************************************
1295: -- also need to populate transaction_date and run_id
1296: -- ***************************************************

Line 1534: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,iHeader_count,l_line_tbl,l_key_tbl);

1530: -- ****************************
1531: -- store values in pl/sql table
1532: -- ****************************
1533: xProgress := 'POCOB-10-1550';
1534: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,iHeader_count,l_line_tbl,l_key_tbl);
1535:
1536: -- The following procedure gets the part number for the
1537: -- item ID returned
1538: xProgress := 'POCOB-10-1640';

Line 1901: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,iHeader_count + iLine_count,l_Shipment_tbl,l_key_tbl);

1897: -- ****************************
1898: -- store values in pl/sql table
1899: -- ****************************
1900: xProgress := 'POCOB-10-1660';
1901: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,iHeader_count + iLine_count,l_Shipment_tbl,l_key_tbl);
1902:
1903: -- Calculate Pending Quantity
1904: xProgress := 'POCOB-10-1665';
1905: l_shipment_tbl(nQuantity_pending_pos).value := NVL(rcv_quantities_s.get_pending_qty(l_shipment_tbl(nShip_Line_location_id_pos).value),0);

Line 2222: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;

2218:
2219: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2220: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2221:
2222: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2223: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2224: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2225:
2226: l_document_type VARCHAR2(30);

Line 2223: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;

2219: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2220: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2221:
2222: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2223: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2224: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2225:
2226: l_document_type VARCHAR2(30);
2227:

Line 2224: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;

2220: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2221:
2222: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2223: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2224: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2225:
2226: l_document_type VARCHAR2(30);
2227:
2228: c_header_common_key_name VARCHAR2(40);

Line 2368: ece_flatfile_pvt.select_clause(cTransaction_Type,

2364: ec_debug.pl(3,'v_project_acct_industry: ',v_project_acct_industry);
2365: ec_debug.pl(3,'v_project_acct_schema: ' ,v_project_acct_schema);
2366:
2367: xProgress := 'POCOB-20-1005';
2368: ece_flatfile_pvt.select_clause(cTransaction_Type,
2369: cCommunication_Method,
2370: cHeader_Interface,
2371: cHeader_X_Interface,
2372: l_header_tbl,

Line 2379: ece_flatfile_pvt.select_clause(cTransaction_Type,

2375: cHeader_from,
2376: cHeader_where);
2377:
2378: xProgress := 'POCOB-20-1010';
2379: ece_flatfile_pvt.select_clause(cTransaction_Type,
2380: cCommunication_Method,
2381: cLine_Interface,
2382: cLine_X_Interface,
2383: l_line_tbl,

Line 2390: ece_flatfile_pvt.select_clause(cTransaction_Type,

2386: cLine_from,
2387: cLine_where);
2388:
2389: xProgress := 'POCOB-20-1020';
2390: ece_flatfile_pvt.select_clause(cTransaction_Type,
2391: cCommunication_Method,
2392: cShipment_Interface,
2393: cShipment_X_Interface,
2394: l_shipment_tbl,

Line 2402: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);

2398: cShipment_where);
2399:
2400: -- Header Level Find Positions
2401: xProgress := 'POCOB-20-1021';
2402: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2403: ec_debug.pl(3,'nTrans_code_pos: ',nTrans_code_pos);
2404:
2405: xProgress := 'POCOB-20-1022';
2406: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);

Line 2406: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);

2402: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2403: ec_debug.pl(3,'nTrans_code_pos: ',nTrans_code_pos);
2404:
2405: xProgress := 'POCOB-20-1022';
2406: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2407: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
2408:
2409: xProgress := 'POCOB-20-1023';
2410: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);

Line 2410: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);

2406: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2407: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
2408:
2409: xProgress := 'POCOB-20-1023';
2410: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2411: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
2412:
2413: xProgress := 'POCOB-20-1024';
2414: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_id_pos);

Line 2414: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_id_pos);

2410: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2411: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
2412:
2413: xProgress := 'POCOB-20-1024';
2414: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_id_pos);
2415: ec_debug.pl(3,'nRelease_id_pos: ',nRelease_id_pos);
2416:
2417: xProgress := 'POCOB-20-1025';
2418: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);

Line 2418: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);

2414: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_id_pos);
2415: ec_debug.pl(3,'nRelease_id_pos: ',nRelease_id_pos);
2416:
2417: xProgress := 'POCOB-20-1025';
2418: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2419: ec_debug.pl(3,'nDocument_type_pos: ',nDocument_type_pos);
2420:
2421: -- Line Level Find Positions
2422: xProgress := 'POCOB-20-1026';

Line 2423: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);

2419: ec_debug.pl(3,'nDocument_type_pos: ',nDocument_type_pos);
2420:
2421: -- Line Level Find Positions
2422: xProgress := 'POCOB-20-1026';
2423: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2424: ec_debug.pl(3,'nLine_key_pos: ',nLine_key_pos);
2425:
2426: xProgress := 'POCOB-20-1027';
2427: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);

Line 2427: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);

2423: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2424: ec_debug.pl(3,'nLine_key_pos: ',nLine_key_pos);
2425:
2426: xProgress := 'POCOB-20-1027';
2427: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2428: ec_debug.pl(3,'nLine_num_pos: ',nLine_num_pos);
2429:
2430: xProgress := 'POCOB-20-1028';
2431: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);

Line 2431: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);

2427: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2428: ec_debug.pl(3,'nLine_num_pos: ',nLine_num_pos);
2429:
2430: xProgress := 'POCOB-20-1028';
2431: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2432: ec_debug.pl(3,'nPO_Line_Location_ID_pos: ',nPO_Line_Location_ID_pos);
2433:
2434: xProgress := 'POCOB-20-1029';
2435: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);

Line 2435: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);

2431: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2432: ec_debug.pl(3,'nPO_Line_Location_ID_pos: ',nPO_Line_Location_ID_pos);
2433:
2434: xProgress := 'POCOB-20-1029';
2435: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_id_pos);
2436: ec_debug.pl(3,'nItem_id_pos: ',nItem_id_pos);
2437:
2438: -- Shipment Level Find Positions
2439: xProgress := 'POCOB-20-1030';

Line 2440: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);

2436: ec_debug.pl(3,'nItem_id_pos: ',nItem_id_pos);
2437:
2438: -- Shipment Level Find Positions
2439: xProgress := 'POCOB-20-1030';
2440: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2441: ec_debug.pl(3,'nLine_Location_ID_pos: ',nLine_Location_ID_pos);
2442:
2443: xProgress := 'POCOB-20-1032';
2444: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);

Line 2444: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);

2440: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2441: ec_debug.pl(3,'nLine_Location_ID_pos: ',nLine_Location_ID_pos);
2442:
2443: xProgress := 'POCOB-20-1032';
2444: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);
2445: ec_debug.pl(3,'nShipment_key_pos: ',nShipment_key_pos);
2446:
2447: -- Build SELECT Statement
2448: xProgress := 'POCOB-20-1035';

Line 2724: ece_flatfile_pvt.define_interface_column_type(header_sel_c,

2720: -- However, for simplicity, we will convert
2721: -- everything to varchar2.
2722: -- ******************************************************
2723: xProgress := 'POCOB-20-1270';
2724: ece_flatfile_pvt.define_interface_column_type(header_sel_c,
2725: cHeader_select,
2726: ece_flatfile_pvt.G_MaxColWidth,
2727: l_header_tbl);
2728:

Line 2726: ece_flatfile_pvt.G_MaxColWidth,

2722: -- ******************************************************
2723: xProgress := 'POCOB-20-1270';
2724: ece_flatfile_pvt.define_interface_column_type(header_sel_c,
2725: cHeader_select,
2726: ece_flatfile_pvt.G_MaxColWidth,
2727: l_header_tbl);
2728:
2729: -- ***************************************************
2730: -- Need rowid for delete (Header Level)

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

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:
2744: -- ***************************************************
2745: -- Need rowid for delete (Line Level)
2746: -- ***************************************************

Line 2757: ece_flatfile_pvt.define_interface_column_type(Shipment_sel_c,cShipment_select,ece_flatfile_pvt.G_MaxColWidth,l_Shipment_tbl);

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:
2759: -- ***************************************************
2760: -- Need rowid for delete (Shipment Level)
2761: -- ***************************************************

Line 2792: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,l_header_tbl);

2788: -- ******************************
2789: -- store values in pl/sql table
2790: -- ******************************
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:

Line 2920: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,l_line_tbl);

2916: -- ***************************************************
2917: -- store values in pl/sql table
2918: -- ***************************************************
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:

Line 3066: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,l_shipment_tbl);

3062: -- *********************************
3063: -- store values in pl/sql table
3064: -- *********************************
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: