[Home] [Help]
265:
266: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
267: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
268:
269: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
270: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
266: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
267: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
268:
269: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
270: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
267: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
268:
269: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
270: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
268:
269: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
270: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
270: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
271: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
272: l_key_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
273:
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
274: l_hdr_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
275: l_hdr_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
283: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
276: l_ln_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
283: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
284:
277: l_ln_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
283: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
284:
285: iAtt_hdr_pos NUMBER := 0;
278: l_mi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
283: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
284:
285: iAtt_hdr_pos NUMBER := 0;
286: iAtt_ln_pos NUMBER := 0;
279: l_mi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
280: l_msi_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
281: l_msi_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
282: l_shp_att_hdr_tbl ece_flatfile_pvt.Interface_tbl_type;
283: l_shp_att_dtl_tbl ece_flatfile_pvt.Interface_tbl_type;
284:
285: iAtt_hdr_pos NUMBER := 0;
286: iAtt_ln_pos NUMBER := 0;
287: iAtt_mi_pos NUMBER := 0;
594: ec_debug.pl(3,'n_att_seg_size: ' ,n_att_seg_size);
595: end if;
596:
597: xProgress := 'POOB-10-1010';
598: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);
599:
600: xProgress := 'POOB-10-1020';
601: l_key_tbl := l_header_tbl;
602:
604: --iKey_count := l_header_tbl.COUNT;
605: --ec_debug.pl(3,'iKey_count: ',iKey_count );
606:
607: xProgress := 'POOB-10-1030';
608: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
609:
610: xProgress := 'POOB-10-1040';
611: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
612:
607: xProgress := 'POOB-10-1030';
608: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
609:
610: xProgress := 'POOB-10-1040';
611: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
612:
613: -- ****************************************************************************
614: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic SQL
615: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary
914: -- However, for simplicity, we will convert
915: -- everything to varchar2.
916: -- ******************************************************
917: xProgress := 'POOB-10-1290';
918: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
919:
920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:
917: xProgress := 'POOB-10-1290';
918: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
919:
920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:
923: xProgress := 'POOB-10-1310';
924: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
925:
920: xProgress := 'POOB-10-1300';
921: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
922:
923: xProgress := 'POOB-10-1310';
924: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
925:
926: -- **************************************************************
927: -- *** The following is custom tailored for this transaction
928: -- *** It finds the values and use them in the WHERE clause to
957: xProgress := 'POOB-10-1381';
958: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
959:
960: xProgress := 'POOB-10-1382';
961: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
962:
963: -- Line Level Positions
964: xProgress := 'POOB-10-1390';
965: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
1044: xProgress := 'POOB-10-1427';
1045: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1046:
1047: xProgress := 'POOB-10-1428';
1048: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1049:
1050: xProgress := 'POOB-10-1429';
1051: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1052:
1047: xProgress := 'POOB-10-1428';
1048: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1049:
1050: xProgress := 'POOB-10-1429';
1051: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1052:
1053: xProgress := 'POOB-10-1430';
1054: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1055:
1050: xProgress := 'POOB-10-1429';
1051: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1052:
1053: xProgress := 'POOB-10-1430';
1054: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1055:
1056: xProgress := 'POOB-10-1431';
1057: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1058:
1053: xProgress := 'POOB-10-1430';
1054: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1055:
1056: xProgress := 'POOB-10-1431';
1057: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1058:
1059: xProgress := 'POOB-10-1432';
1060: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1061:
1056: xProgress := 'POOB-10-1431';
1057: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1058:
1059: xProgress := 'POOB-10-1432';
1060: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1061:
1062: xProgress := 'POOB-10-1433';
1063: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1064:
1059: xProgress := 'POOB-10-1432';
1060: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1061:
1062: xProgress := 'POOB-10-1433';
1063: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1064:
1065: xProgress := 'POOB-10-1434';
1066: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1067:
1062: xProgress := 'POOB-10-1433';
1063: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1064:
1065: xProgress := 'POOB-10-1434';
1066: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1067:
1068: xProgress := 'POOB-10-1435';
1069: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1070:
1065: xProgress := 'POOB-10-1434';
1066: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1067:
1068: xProgress := 'POOB-10-1435';
1069: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1070:
1071: xProgress := 'POOB-10-1437';
1072: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1073:
1068: xProgress := 'POOB-10-1435';
1069: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1070:
1071: xProgress := 'POOB-10-1437';
1072: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1073:
1074: xProgress := 'POOB-10-1438';
1075: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1076:
1071: xProgress := 'POOB-10-1437';
1072: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1073:
1074: xProgress := 'POOB-10-1438';
1075: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1076:
1077: xProgress := 'POOB-10-1439';
1078: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1079:
1074: xProgress := 'POOB-10-1438';
1075: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1076:
1077: xProgress := 'POOB-10-1439';
1078: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1079:
1080: xProgress := 'POOB-10-1440';
1081: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1082:
1077: xProgress := 'POOB-10-1439';
1078: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1079:
1080: xProgress := 'POOB-10-1440';
1081: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1082:
1083: xProgress := 'POOB-10-1441';
1084: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1085:
1080: xProgress := 'POOB-10-1440';
1081: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1082:
1083: xProgress := 'POOB-10-1441';
1084: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1085:
1086: xProgress := 'POOB-10-1442';
1087: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1088:
1083: xProgress := 'POOB-10-1441';
1084: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1085:
1086: xProgress := 'POOB-10-1442';
1087: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1088:
1089: xProgress := 'POOB-10-1443';
1090: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1091:
1086: xProgress := 'POOB-10-1442';
1087: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1088:
1089: xProgress := 'POOB-10-1443';
1090: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1091:
1092: xProgress := 'POOB-10-1444';
1093: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1094:
1089: xProgress := 'POOB-10-1443';
1090: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1091:
1092: xProgress := 'POOB-10-1444';
1093: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1094:
1095: xProgress := 'POOB-10-1445';
1096: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1097:
1092: xProgress := 'POOB-10-1444';
1093: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1094:
1095: xProgress := 'POOB-10-1445';
1096: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1097:
1098: xProgress := 'POOB-10-1446';
1099: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1100:
1095: xProgress := 'POOB-10-1445';
1096: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1097:
1098: xProgress := 'POOB-10-1446';
1099: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1100:
1101: xProgress := 'POOB-10-1447';
1102: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1103:
1098: xProgress := 'POOB-10-1446';
1099: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1100:
1101: xProgress := 'POOB-10-1447';
1102: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1103:
1104: -- 2823215
1105: xProgress := 'POOB-10-1448';
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1102: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1103:
1104: -- 2823215
1105: xProgress := 'POOB-10-1448';
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1107:
1108: xProgress := 'POOB-10-1449';
1109: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1110:
1105: xProgress := 'POOB-10-1448';
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1107:
1108: xProgress := 'POOB-10-1449';
1109: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1110:
1111: if ec_debug.G_debug_level = 3 then
1112: ec_debug.pl(3,'n_trx_date_pos: ',n_trx_date_pos);
1113: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
1124: end if;
1125:
1126: -- Timezone enhancement
1127: xProgress := 'POOB-TZ-1000';
1128: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1129:
1130: xProgress := 'POOB-TZ-1001';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1132:
1127: xProgress := 'POOB-TZ-1000';
1128: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1129:
1130: xProgress := 'POOB-TZ-1001';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1132:
1133: xProgress := 'POOB-TZ-1002';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1135:
1130: xProgress := 'POOB-TZ-1001';
1131: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1132:
1133: xProgress := 'POOB-TZ-1002';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1135:
1136: xProgress := 'POOB-TZ-1003';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1138:
1133: xProgress := 'POOB-TZ-1002';
1134: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1135:
1136: xProgress := 'POOB-TZ-1003';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1138:
1139: xProgress := 'POOB-TZ-1004';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1141:
1136: xProgress := 'POOB-TZ-1003';
1137: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1138:
1139: xProgress := 'POOB-TZ-1004';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1141:
1142: xProgress := 'POOB-TZ-1005';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1144:
1139: xProgress := 'POOB-TZ-1004';
1140: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1141:
1142: xProgress := 'POOB-TZ-1005';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1144:
1145: xProgress := 'POOB-TZ-1006';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1147:
1142: xProgress := 'POOB-TZ-1005';
1143: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1144:
1145: xProgress := 'POOB-TZ-1006';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1147:
1148: xProgress := 'POOB-TZ-1007';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1150:
1145: xProgress := 'POOB-TZ-1006';
1146: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1147:
1148: xProgress := 'POOB-TZ-1007';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1150:
1151: xProgress := 'POOB-TZ-1008';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1153:
1148: xProgress := 'POOB-TZ-1007';
1149: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1150:
1151: xProgress := 'POOB-TZ-1008';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1153:
1154: xProgress := 'POOB-TZ-1009';
1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1156:
1151: xProgress := 'POOB-TZ-1008';
1152: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1153:
1154: xProgress := 'POOB-TZ-1009';
1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1156:
1157: xProgress := 'POOB-TZ-1010';
1158: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1159:
1154: xProgress := 'POOB-TZ-1009';
1155: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1156:
1157: xProgress := 'POOB-TZ-1010';
1158: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1159:
1160: xProgress := 'POOB-TZ-1011';
1161: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1162:
1157: xProgress := 'POOB-TZ-1010';
1158: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1159:
1160: xProgress := 'POOB-TZ-1011';
1161: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1162:
1163: xProgress := 'POOB-TZ-1012';
1164: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1165:
1160: xProgress := 'POOB-TZ-1011';
1161: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1162:
1163: xProgress := 'POOB-TZ-1012';
1164: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1165:
1166: xProgress := 'POOB-TZ-1013';
1167: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1168:
1163: xProgress := 'POOB-TZ-1012';
1164: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1165:
1166: xProgress := 'POOB-TZ-1013';
1167: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1168:
1169: xProgress := 'POOB-TZ-1014';
1170: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1171:
1166: xProgress := 'POOB-TZ-1013';
1167: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1168:
1169: xProgress := 'POOB-TZ-1014';
1170: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1171:
1172: xProgress := 'POOB-TZ-1015';
1173: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1174:
1169: xProgress := 'POOB-TZ-1014';
1170: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1171:
1172: xProgress := 'POOB-TZ-1015';
1173: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1174:
1175: xProgress := 'POOB-TZ-1016';
1176: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1177:
1172: xProgress := 'POOB-TZ-1015';
1173: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1174:
1175: xProgress := 'POOB-TZ-1016';
1176: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1177:
1178: xProgress := 'POOB-TZ-1017';
1179: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1180:
1175: xProgress := 'POOB-TZ-1016';
1176: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1177:
1178: xProgress := 'POOB-TZ-1017';
1179: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1180:
1181: xProgress := 'POOB-TZ-1018';
1182: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1183:
1178: xProgress := 'POOB-TZ-1017';
1179: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1180:
1181: xProgress := 'POOB-TZ-1018';
1182: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1183:
1184: xProgress := 'POOB-TZ-1019';
1185: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1186:
1181: xProgress := 'POOB-TZ-1018';
1182: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1183:
1184: xProgress := 'POOB-TZ-1019';
1185: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1186:
1187: xProgress := 'POOB-TZ-1020';
1188: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1189:
1184: xProgress := 'POOB-TZ-1019';
1185: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1186:
1187: xProgress := 'POOB-TZ-1020';
1188: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1189:
1190:
1191: xProgress := 'POOB-TZ-1021';
1192: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1188: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1189:
1190:
1191: xProgress := 'POOB-TZ-1021';
1192: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1193:
1194: xProgress := 'POOB-TZ-1022';
1195: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1196:
1191: xProgress := 'POOB-TZ-1021';
1192: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1193:
1194: xProgress := 'POOB-TZ-1022';
1195: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1196:
1197: xProgress := 'POOB-TZ-1023';
1198: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1199:
1194: xProgress := 'POOB-TZ-1022';
1195: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1196:
1197: xProgress := 'POOB-TZ-1023';
1198: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1199:
1200: xProgress := 'POOB-TZ-1024';
1201: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1202:
1197: xProgress := 'POOB-TZ-1023';
1198: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1199:
1200: xProgress := 'POOB-TZ-1024';
1201: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1202:
1203: xProgress := 'POOB-TZ-1025';
1204: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1205:
1200: xProgress := 'POOB-TZ-1024';
1201: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1202:
1203: xProgress := 'POOB-TZ-1025';
1204: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1205:
1206: xProgress := 'POOB-TZ-1026';
1207: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1208:
1203: xProgress := 'POOB-TZ-1025';
1204: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1205:
1206: xProgress := 'POOB-TZ-1026';
1207: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1208:
1209: xProgress := 'POOB-TZ-1027';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1211:
1206: xProgress := 'POOB-TZ-1026';
1207: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1208:
1209: xProgress := 'POOB-TZ-1027';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1211:
1212: xProgress := 'POOB-TZ-1028';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1214:
1209: xProgress := 'POOB-TZ-1027';
1210: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1211:
1212: xProgress := 'POOB-TZ-1028';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1214:
1215: xProgress := 'POOB-TZ-1029';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1217:
1212: xProgress := 'POOB-TZ-1028';
1213: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1214:
1215: xProgress := 'POOB-TZ-1029';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1217:
1218: xProgress := 'POOB-TZ-1030';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1220:
1215: xProgress := 'POOB-TZ-1029';
1216: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1217:
1218: xProgress := 'POOB-TZ-1030';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1220:
1221: xProgress := 'POOB-TZ-1031';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1223:
1218: xProgress := 'POOB-TZ-1030';
1219: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1220:
1221: xProgress := 'POOB-TZ-1031';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1223:
1224: xProgress := 'POOB-TZ-1032';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1226:
1221: xProgress := 'POOB-TZ-1031';
1222: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1223:
1224: xProgress := 'POOB-TZ-1032';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1226:
1227: xProgress := 'POOB-TZ-1033';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1229:
1224: xProgress := 'POOB-TZ-1032';
1225: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1226:
1227: xProgress := 'POOB-TZ-1033';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1229:
1230: xProgress := 'POOB-TZ-1034';
1231: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1232:
1227: xProgress := 'POOB-TZ-1033';
1228: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1229:
1230: xProgress := 'POOB-TZ-1034';
1231: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1232:
1233: xProgress := 'POOB-TZ-1035';
1234: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1235:
1230: xProgress := 'POOB-TZ-1034';
1231: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1232:
1233: xProgress := 'POOB-TZ-1035';
1234: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1235:
1236: xProgress := 'POOB-TZ-1036';
1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1238:
1233: xProgress := 'POOB-TZ-1035';
1234: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1235:
1236: xProgress := 'POOB-TZ-1036';
1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1238:
1239: xProgress := 'POOB-TZ-1037';
1240: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1241:
1236: xProgress := 'POOB-TZ-1036';
1237: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1238:
1239: xProgress := 'POOB-TZ-1037';
1240: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1241:
1242: xProgress := 'POOB-TZ-1038';
1243: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1244:
1239: xProgress := 'POOB-TZ-1037';
1240: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1241:
1242: xProgress := 'POOB-TZ-1038';
1243: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1244:
1245: xProgress := 'POOB-TZ-1039';
1246: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1247:
1242: xProgress := 'POOB-TZ-1038';
1243: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1244:
1245: xProgress := 'POOB-TZ-1039';
1246: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1247:
1248: xProgress := 'POOB-TZ-1040';
1249: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1250:
1245: xProgress := 'POOB-TZ-1039';
1246: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1247:
1248: xProgress := 'POOB-TZ-1040';
1249: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1250:
1251: xProgress := 'POOB-TZ-1041';
1252: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1253:
1248: xProgress := 'POOB-TZ-1040';
1249: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1250:
1251: xProgress := 'POOB-TZ-1041';
1252: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1253:
1254: xProgress := 'POOB-TZ-1042';
1255: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1256:
1251: xProgress := 'POOB-TZ-1041';
1252: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1253:
1254: xProgress := 'POOB-TZ-1042';
1255: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1256:
1257: xProgress := 'POOB-TZ-1043';
1258: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1259:
1254: xProgress := 'POOB-TZ-1042';
1255: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1256:
1257: xProgress := 'POOB-TZ-1043';
1258: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1259:
1260: xProgress := 'POOB-TZ-1044';
1261: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1262: -- Timezone enhancement
1257: xProgress := 'POOB-TZ-1043';
1258: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1259:
1260: xProgress := 'POOB-TZ-1044';
1261: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1262: -- Timezone enhancement
1263: xProgress := 'POOB-09-1400';
1264: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1265:
1260: xProgress := 'POOB-TZ-1044';
1261: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1262: -- Timezone enhancement
1263: xProgress := 'POOB-09-1400';
1264: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1265:
1266: xProgress := 'POOB-09-1401';
1267: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1268:
1263: xProgress := 'POOB-09-1400';
1264: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1265:
1266: xProgress := 'POOB-09-1401';
1267: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1268:
1269: xProgress := 'POOB-09-1402';
1270: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1271:
1266: xProgress := 'POOB-09-1401';
1267: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1268:
1269: xProgress := 'POOB-09-1402';
1270: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1271:
1272: xProgress := 'POOB-10-1407';
1273: -- bind variables
1274: dbms_sql.bind_variable(header_sel_c,'cComm_Method',cCommunication_Method);
1328: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1329: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1330: end if;
1331: xProgress := 'POOB-10-1431';
1332: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);
1333:
1334: -- ***************************************************
1335: -- also need to populate transaction_date and run_id
1336: -- ***************************************************
1577: -- ****************************
1578: -- store values in pl/sql table
1579: -- ****************************
1580: xProgress := 'POOB-10-1550';
1581: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,iHeader_count,l_line_tbl,l_key_tbl);
1582:
1583: -- The following procedure gets the part number for the
1584: -- item ID returned
1585: xProgress := 'POOB-10-1560';
1884: -- ****************************
1885: -- store values in pl/sql table
1886: -- ****************************
1887: xProgress := 'POOB-10-1660';
1888: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,iHeader_count + iLine_count,l_shipment_tbl,l_key_tbl);
1889:
1890: xProgress := 'POOB-10-1670';
1891: BEGIN
1892: SELECT ece_poo_shipment_s.NEXTVAL INTO l_shipment_fkey
2224:
2225: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2226: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2227:
2228: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2229: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2230: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2231:
2232: l_document_type VARCHAR2(30);
2225: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2226: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2227:
2228: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2229: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2230: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2231:
2232: l_document_type VARCHAR2(30);
2233:
2226: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2227:
2228: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2229: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2230: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2231:
2232: l_document_type VARCHAR2(30);
2233:
2234: c_header_common_key_name VARCHAR2(40);
2374: ec_debug.pl(3,'v_project_acct_industry: ',v_project_acct_industry);
2375: ec_debug.pl(3,'v_project_acct_schema: ' ,v_project_acct_schema);
2376: */
2377: xProgress := 'POOB-20-1005';
2378: ece_flatfile_pvt.select_clause(cTransaction_Type,
2379: cCommunication_Method,
2380: cHeader_Interface,
2381: cHeader_X_Interface,
2382: l_header_tbl,
2385: cHeader_from,
2386: cHeader_where);
2387:
2388: xProgress := 'POOB-20-1010';
2389: ece_flatfile_pvt.select_clause(cTransaction_Type,
2390: cCommunication_Method,
2391: cLine_Interface,
2392: cLine_X_Interface,
2393: l_line_tbl,
2396: cLine_from,
2397: cLine_where);
2398:
2399: xProgress := 'POOB-20-1020';
2400: ece_flatfile_pvt.select_clause(cTransaction_Type,
2401: cCommunication_Method,
2402: cShipment_Interface,
2403: cShipment_X_Interface,
2404: l_shipment_tbl,
2408: cShipment_where);
2409:
2410: -- Header Level Find Positions
2411: xProgress := 'POOB-20-1021';
2412: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2413:
2414: xProgress := 'POOB-20-1022';
2415: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2416:
2411: xProgress := 'POOB-20-1021';
2412: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2413:
2414: xProgress := 'POOB-20-1022';
2415: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2416:
2417:
2418: xProgress := 'POOB-20-1023';
2419: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2415: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2416:
2417:
2418: xProgress := 'POOB-20-1023';
2419: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2420:
2421: xProgress := 'POOB-20-1024';
2422: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2423:
2418: xProgress := 'POOB-20-1023';
2419: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2420:
2421: xProgress := 'POOB-20-1024';
2422: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2423:
2424: xProgress := 'POOB-20-1025';
2425: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2426:
2421: xProgress := 'POOB-20-1024';
2422: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2423:
2424: xProgress := 'POOB-20-1025';
2425: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2426:
2427: -- Line Level Find Positions
2428: xProgress := 'POOB-20-1026';
2429: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2425: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2426:
2427: -- Line Level Find Positions
2428: xProgress := 'POOB-20-1026';
2429: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2430:
2431: xProgress := 'POOB-20-1027';
2432: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2433:
2428: xProgress := 'POOB-20-1026';
2429: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2430:
2431: xProgress := 'POOB-20-1027';
2432: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2433:
2434: xProgress := 'POOB-20-1028';
2435: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2436:
2431: xProgress := 'POOB-20-1027';
2432: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2433:
2434: xProgress := 'POOB-20-1028';
2435: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2436:
2437: xProgress := 'POOB-20-1029';
2438: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2439:
2434: xProgress := 'POOB-20-1028';
2435: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2436:
2437: xProgress := 'POOB-20-1029';
2438: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2439:
2440: -- Shipment Level Find Positions
2441: xProgress := 'POOB-20-1030';
2442: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2438: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2439:
2440: -- Shipment Level Find Positions
2441: xProgress := 'POOB-20-1030';
2442: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2443:
2444: xProgress := 'POOB-20-1032';
2445: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);
2446: if ec_debug.G_debug_level = 3 then
2441: xProgress := 'POOB-20-1030';
2442: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2443:
2444: xProgress := 'POOB-20-1032';
2445: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);
2446: if ec_debug.G_debug_level = 3 then
2447: ec_debug.pl(3,'nTrans_code_pos: ',nTrans_code_pos);
2448: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
2449: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
2736: -- However, for simplicity, we will convert
2737: -- everything to varchar2.
2738: -- ******************************************************
2739: xProgress := 'POOB-20-1270';
2740: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
2741: cHeader_select,
2742: ece_flatfile_pvt.G_MaxColWidth,
2743: l_header_tbl);
2744:
2738: -- ******************************************************
2739: xProgress := 'POOB-20-1270';
2740: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
2741: cHeader_select,
2742: ece_flatfile_pvt.G_MaxColWidth,
2743: l_header_tbl);
2744:
2745: -- ***************************************************
2746: -- Need rowid for delete (Header Level)
2754: xProgress := 'POOB-20-1300';
2755: dbms_sql.define_column(Header_sel_c,iHeader_count + 3,n_po_header_ID);
2756:
2757: xProgress := 'POOB-20-1310';
2758: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_flatfile_pvt.G_MaxColWidth,l_line_tbl);
2759:
2760: -- ***************************************************
2761: -- Need rowid for delete (Line Level)
2762: -- ***************************************************
2769: xProgress := 'POOB-20-1340';
2770: dbms_sql.define_column(line_sel_c,iLine_count + 3,n_po_line_ID);
2771:
2772: xProgress := 'POOB-20-1350';
2773: ece_flatfile_pvt.define_interface_column_type(Shipment_sel_c,cShipment_select,ece_flatfile_pvt.G_MaxColWidth,l_shipment_tbl);
2774:
2775: -- ***************************************************
2776: -- Need rowid for delete (Shipment Level)
2777: -- ***************************************************
2812: -- ******************************
2813: -- store values in pl/sql table
2814: -- ******************************
2815: xProgress := 'POOB-20-1400';
2816: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,l_header_tbl);
2817:
2818: xProgress := 'POOB-20-1410';
2819: dbms_sql.column_value(header_sel_c,iHeader_count + 1,rHeader_rowid);
2820:
2946: -- ***************************************************
2947: -- store values in pl/sql table
2948: -- ***************************************************
2949: xProgress := 'POOB-20-1530';
2950: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,l_line_tbl);
2951:
2952: xProgress := 'POOB-20-1533';
2953: dbms_sql.column_value(line_sel_c,iLine_count + 1,rLine_rowid);
2954:
3114: -- *********************************
3115: -- store values in pl/sql table
3116: -- *********************************
3117: xProgress := 'POCOB-10-1600';
3118: ece_flatfile_pvt.assign_column_value_to_tbl(Shipment_sel_c,l_shipment_tbl);
3119:
3120: xProgress := 'POCOB-10-1603';
3121: dbms_sql.column_value(shipment_sel_c,iShipment_count + 1,rShipment_rowid);
3122:
3522: cCommunication_Method IN VARCHAR2,
3523: cTransaction_Type IN VARCHAR2,
3524: iRun_id IN INTEGER,
3525: cDistribution_Interface IN VARCHAR2,
3526: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
3527: cPO_Header_ID IN NUMBER,
3528: cPO_Release_ID IN NUMBER,
3529: cPO_Line_ID IN NUMBER,
3530: cPO_Line_Location_ID IN NUMBER,
3533: xProgress VARCHAR2(80);
3534: v_LevelProcessed VARCHAR(40);
3535:
3536: /* Bug 2490109
3537: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3538: project_sel_c INTEGER;
3539: */
3540: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291
3541:
3611: iKey_count := l_key_tbl.COUNT;
3612: if ec_debug.G_debug_level = 3 then
3613: ec_debug.pl(3,'iKey_count: ',iKey_count);
3614: END if;
3615: ece_flatfile_pvt.init_table(cTransaction_Type,cDistribution_Interface,iProject_output_level,TRUE,l_project_tbl,l_key_tbl);
3616:
3617: xProgress := 'POOB-40-1010';
3618: ece_extract_utils_pub.select_clause(cTransaction_Type,
3619: cCommunication_Method,
3677: --ec_debug.pl(3,'iKey_count: ',iKey_count);
3678:
3679: -- Define Column Types
3680: xProgress := 'POOB-40-1090';
3681: ece_flatfile_pvt.define_interface_column_type(project_sel_c,cProject_select,ece_extract_utils_PUB.G_MaxColWidth,l_project_tbl);
3682:
3683: -- Project Level Positions
3684:
3685: end if; --Bug 2490109
3683: -- Project Level Positions
3684:
3685: end if; --Bug 2490109
3686: --2823215
3687: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3688: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3689: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3690: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3684:
3685: end if; --Bug 2490109
3686: --2823215
3687: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3688: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3689: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3690: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3692:
3685: end if; --Bug 2490109
3686: --2823215
3687: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3688: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3689: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3690: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3692:
3693:
3686: --2823215
3687: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3688: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3689: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3690: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3692:
3693:
3694: --2823215
3687: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3688: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3689: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3690: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3692:
3693:
3694: --2823215
3695: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3691: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3692:
3693:
3694: --2823215
3695: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3696: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3697: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3698:
3699: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3692:
3693:
3694: --2823215
3695: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3696: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3697: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3698:
3699: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3700: -- Bind Variables
3693:
3694: --2823215
3695: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3696: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3697: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3698:
3699: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3700: -- Bind Variables
3701: xProgress := 'POOB-40-1140';
3718: xProgress := 'POOB-40-1190';
3719: WHILE dbms_sql.fetch_rows(project_sel_c) > 0 LOOP -- Project Level Loop
3720: -- Store Internal Values in the PL/SQL Table
3721: xProgress := 'POOB-40-1200';
3722: ece_flatfile_pvt.assign_column_value_to_tbl(project_sel_c,iKey_count,l_project_tbl,l_key_tbl);
3723:
3724: xProgress := 'POOB-TZ-4500';
3725:
3726: ece_timezone_api.get_server_timezone_details
3901:
3902: nProject_key_pos NUMBER;
3903:
3904: /* Bug 2490109
3905: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3906: project_sel_c INTEGER;
3907: project_del_c1 INTEGER;
3908: project_del_c2 INTEGER;
3909: */
3950: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3951:
3952: -- Build the SELECT, FROM, and WHERE Clauses
3953: xProgress := 'POOB-50-1000';
3954: ece_flatfile_pvt.select_clause(cTransaction_Type,
3955: cCommunication_Method,
3956: cDistribution_Interface,
3957: cProject_X_Interface,
3958: l_project_tbl,
4064: end if;
4065:
4066: -- Define Column Types
4067: xProgress := 'POOB-50-1120';
4068: ece_flatfile_pvt.define_interface_column_type(project_sel_c,
4069: cProject_select,
4070: ece_flatfile_pvt.G_MaxColWidth,
4071: l_project_tbl);
4072:
4066: -- Define Column Types
4067: xProgress := 'POOB-50-1120';
4068: ece_flatfile_pvt.define_interface_column_type(project_sel_c,
4069: cProject_select,
4070: ece_flatfile_pvt.G_MaxColWidth,
4071: l_project_tbl);
4072:
4073: -- Define Additional Column Types
4074: xProgress := 'POOB-50-1130';
4101: xProgress := 'POOB-50-1210';
4102: WHILE dbms_sql.fetch_rows(project_sel_c) > 0 LOOP -- Project Level Loop
4103: -- Store the Fetched Data in the PL/SQL Table
4104: xProgress := 'POOB-50-1220';
4105: ece_flatfile_pvt.assign_column_value_to_tbl(project_sel_c,l_project_tbl);
4106:
4107: xProgress := 'POOB-50-1230';
4108: dbms_sql.column_value(project_sel_c,iProject_count + 1,rProject_rowid);
4109:
4196: cPK3_Value IN VARCHAR2,
4197: cPK4_Value IN VARCHAR2,
4198: cPK5_Value IN VARCHAR2,
4199: cSegment_Size IN NUMBER,
4200: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4201: cFile_Common_Key IN VARCHAR2,
4202: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4203: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4204: l_key_count IN OUT NOCOPY NUMBER) IS
4198: cPK5_Value IN VARCHAR2,
4199: cSegment_Size IN NUMBER,
4200: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4201: cFile_Common_Key IN VARCHAR2,
4202: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4203: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4204: l_key_count IN OUT NOCOPY NUMBER) IS
4205:
4206: xProgress VARCHAR2(80);
4199: cSegment_Size IN NUMBER,
4200: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4201: cFile_Common_Key IN VARCHAR2,
4202: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4203: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4204: l_key_count IN OUT NOCOPY NUMBER) IS
4205:
4206: xProgress VARCHAR2(80);
4207:
4204: l_key_count IN OUT NOCOPY NUMBER) IS
4205:
4206: xProgress VARCHAR2(80);
4207:
4208: --l_att_header_tbl ece_flatfile_pvt.Interface_tbl_type;
4209:
4210: v_att_header_select VARCHAR2(32000);
4211: v_att_header_from VARCHAR2(32000);
4212: v_att_header_where VARCHAR2(32000);
4236:
4237: xProgress := 'POOB-60-1000';
4238: if ( l_att_header_tbl.count = 0) then
4239: l_key_count := l_key_tbl.count;
4240: ece_flatfile_pvt.init_table(cTransaction_Type,
4241: cAtt_Header_Interface,
4242: cHeader_Output_Level,
4243: TRUE,
4244: l_att_header_tbl,
4414: ec_debug.pl(3,'n_header_count: ',n_header_count);
4415: end if;
4416:
4417: xProgress := 'POOB-60-1130';
4418: ece_flatfile_pvt.define_interface_column_type(n_att_header_sel_c,
4419: v_att_header_select,
4420: ece_extract_utils_pub.G_MAXCOLWIDTH,
4421: l_att_header_tbl);
4422:
4461:
4462: xProgress := 'POOB-60-1150';
4463: WHILE dbms_sql.fetch_rows(n_att_header_sel_c) > 0 LOOP
4464: xProgress := 'POOB-60-1160';
4465: ece_flatfile_pvt.assign_column_value_to_tbl(n_att_header_sel_c,l_key_count,l_att_header_tbl,l_key_tbl);
4466:
4467: xProgress := 'POOB-60-1170';
4468: /* BEGIN
4469: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey
4548: cPK4_Value IN VARCHAR2,
4549: cPK5_Value IN VARCHAR2,
4550: cData_Type_ID IN NUMBER, -- 1=Short, 2=Long
4551: cSegment_Size IN NUMBER,
4552: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4553: cAtt_doc_id IN NUMBER,
4554: cFile_Common_Key IN VARCHAR2,
4555: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
4556:
4551: cSegment_Size IN NUMBER,
4552: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4553: cAtt_doc_id IN NUMBER,
4554: cFile_Common_Key IN VARCHAR2,
4555: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
4556:
4557: xProgress VARCHAR2(80);
4558:
4559: c_local_chr_10 VARCHAR2(1) := fnd_global.local_chr(10);
4558:
4559: c_local_chr_10 VARCHAR2(1) := fnd_global.local_chr(10);
4560: c_local_chr_13 VARCHAR2(1) := fnd_global.local_chr(13);
4561:
4562: --l_att_detail_tbl ece_flatfile_pvt.Interface_tbl_type;
4563: l_short_text VARCHAR2(32000);
4564: l_data_chunk VARCHAR2(32000);
4565: l_temp_text VARCHAR2(32000);
4566:
4626: ec_debug.pl(3,'v_split_word: ',v_split_word);
4627:
4628: xProgress := 'POOB-70-1000';
4629: if (l_att_detail_tbl.count = 0) then
4630: ece_flatfile_pvt.init_table(cTransaction_Type,cAtt_Detail_Interface,cDetail_Output_Level,TRUE,l_att_detail_tbl,l_key_tbl);
4631:
4632: end if;
4633:
4634: xProgress := 'POOB-70-1010';
4631:
4632: end if;
4633:
4634: xProgress := 'POOB-70-1010';
4635: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4632: end if;
4633:
4634: xProgress := 'POOB-70-1010';
4635: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4633:
4634: xProgress := 'POOB-70-1010';
4635: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4634: xProgress := 'POOB-70-1010';
4635: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4635: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4636: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4637: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4638: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4639: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4640: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4641: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4649: xProgress := 'POOB-70-1020';
4642: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4649: xProgress := 'POOB-70-1020';
4650: -- Build the SELECT Clause.
4643: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4649: xProgress := 'POOB-70-1020';
4650: -- Build the SELECT Clause.
4651: ece_extract_utils_pub.select_clause(cTransaction_Type,
4644: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4645: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4646: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4647: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4648: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4649: xProgress := 'POOB-70-1020';
4650: -- Build the SELECT Clause.
4651: ece_extract_utils_pub.select_clause(cTransaction_Type,
4652: cCommunication_Method,
4867: end if;
4868:
4869: -- Define Columns
4870: xProgress := 'POOB-70-1320';
4871: ece_flatfile_pvt.define_interface_column_type(n_att_detail_sel_c,
4872: v_att_detail_select,
4873: ece_extract_utils_pub.G_MAXCOLWIDTH,
4874: l_att_detail_tbl);
4875:
4893: WHILE dbms_sql.fetch_rows(n_att_detail_sel_c) > 0 LOOP
4894: xProgress := 'POOB-70-1370';
4895: ec_debug.pl(3,'xProgress: ',xProgress);
4896:
4897: ece_flatfile_pvt.assign_column_value_to_tbl(n_att_detail_sel_c,l_att_detail_tbl);
4898:
4899: n_segment_number := 1;
4900: n_cur_pos := 1;
4901: n_new_chunk_size := 0;
5274: cFile_Common_Key IN VARCHAR2) IS
5275:
5276: xProgress VARCHAR2(80);
5277:
5278: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
5279:
5280: c_header_common_key_name VARCHAR2(40);
5281:
5282: nSeq_Num_pos NUMBER;
5314: ec_debug.pl(3,'cPK5_Value: ', cPK5_Value);
5315: end if;
5316:
5317: xProgress := 'POOB-80-1000';
5318: ece_flatfile_pvt.select_clause(cTransaction_Type,
5319: cCommunication_Method,
5320: cHeader_Interface,
5321: cHeader_X_Interface,
5322: l_header_tbl,
5514: ec_debug.pl(3,'iHeader_count: ',iHeader_count);
5515: end if;
5516:
5517: xProgress := 'POOB-80-1160';
5518: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
5519: cHeader_select,
5520: ece_flatfile_pvt.G_MaxColWidth,
5521: l_header_tbl );
5522:
5516:
5517: xProgress := 'POOB-80-1160';
5518: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
5519: cHeader_select,
5520: ece_flatfile_pvt.G_MaxColWidth,
5521: l_header_tbl );
5522:
5523: xProgress := 'POOB-80-1170';
5524: dbms_sql.define_column_rowid(Header_sel_c,iHeader_count + 1,rHeader_rowid);
5549:
5550: xProgress := 'POOB-80-1200';
5551: WHILE dbms_sql.fetch_rows(Header_sel_c) > 0 LOOP
5552: xProgress := 'POOB-80-1210';
5553: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,l_header_tbl);
5554:
5555: xProgress := 'POOB-80-1220';
5556: dbms_sql.column_value(Header_sel_c,iHeader_count + 1,rHeader_rowid);
5557:
5559: dbms_sql.column_value(Header_sel_c,iHeader_count + 2,rHeader_X_rowid);
5560:
5561: -- Find the Position of the Attachemnt Doc ID
5562: xProgress := 'POOB-80-1232';
5563: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_ID',nDoc_ID_pos);
5564: nDoc_ID := l_header_tbl(nDoc_ID_pos).value;
5565:
5566: -- Find the Position of the Attachment Sequence Number
5567: xProgress := 'POOB-80-1240';
5564: nDoc_ID := l_header_tbl(nDoc_ID_pos).value;
5565:
5566: -- Find the Position of the Attachment Sequence Number
5567: xProgress := 'POOB-80-1240';
5568: ece_flatfile_pvt.find_pos(l_header_tbl,'ATT_SEQ_NUM',nSeq_Num_pos);
5569: -- Get the Attachment Sequence Number itself.
5570: nSeq_Num := l_header_tbl(nSeq_Num_pos).value;
5571: -- Bug 2187958
5572: ece_flatfile_pvt.find_pos(l_header_tbl,'ATTACHED_DOCUMENT_ID',nAtt_Doc_ID);
5568: ece_flatfile_pvt.find_pos(l_header_tbl,'ATT_SEQ_NUM',nSeq_Num_pos);
5569: -- Get the Attachment Sequence Number itself.
5570: nSeq_Num := l_header_tbl(nSeq_Num_pos).value;
5571: -- Bug 2187958
5572: ece_flatfile_pvt.find_pos(l_header_tbl,'ATTACHED_DOCUMENT_ID',nAtt_Doc_ID);
5573: -- Get the Attachment Document ID
5574: nAtt_Doc_ID := l_header_tbl(nAtt_Doc_ID).value;
5575:
5576: if ec_debug.G_debug_level = 3 then
5661: cAtt_Doc_ID IN NUMBER) IS
5662:
5663: xProgress VARCHAR2(80);
5664:
5665: l_detail_tbl ece_flatfile_pvt.Interface_tbl_type;
5666:
5667: c_detail_common_key_name VARCHAR2(40);
5668:
5669: Detail_sel_c INTEGER;
5699: ec_debug.pl(3,'cAtt_Doc_ID: ' ,cAtt_Doc_ID);
5700: end if;
5701:
5702: xProgress := 'POOB-90-1000';
5703: ece_flatfile_pvt.select_clause(cTransaction_Type,
5704: cCommunication_Method,
5705: cDetail_Interface,
5706: cDetail_X_Interface,
5707: l_detail_tbl,
5908: ec_debug.pl(3,'iDetail_count: ',iDetail_count);
5909: end if;
5910:
5911: xProgress := 'POOB-90-1180';
5912: ece_flatfile_pvt.define_interface_column_type(Detail_sel_c,
5913: cDetail_select,
5914: ece_flatfile_pvt.G_MaxColWidth,
5915: l_detail_tbl);
5916:
5910:
5911: xProgress := 'POOB-90-1180';
5912: ece_flatfile_pvt.define_interface_column_type(Detail_sel_c,
5913: cDetail_select,
5914: ece_flatfile_pvt.G_MaxColWidth,
5915: l_detail_tbl);
5916:
5917: xProgress := 'POOB-90-1190';
5918: dbms_sql.define_column_rowid(Detail_sel_c,iDetail_count + 1,rDetail_rowid);
5965:
5966: xProgress := 'POOB-90-1220';
5967: WHILE dbms_sql.fetch_rows(Detail_sel_c) > 0 LOOP
5968: xProgress := 'POOB-90-1230';
5969: ece_flatfile_pvt.assign_column_value_to_tbl(Detail_sel_c,l_detail_tbl);
5970:
5971: xProgress := 'POOB-90-1240';
5972: dbms_sql.column_value(Detail_sel_c,iDetail_count + 1,rDetail_rowid);
5973:
6020: PROCEDURE write_to_file(
6021: cTransaction_Type IN VARCHAR2,
6022: cCommunication_Method IN VARCHAR2,
6023: cInterface_Table IN VARCHAR2,
6024: p_Interface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
6025: iOutput_width IN INTEGER,
6026: iRun_id IN INTEGER,
6027: p_common_key IN VARCHAR2,
6028: p_foreign_key IN NUMBER) IS