[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;
595: ec_debug.pl(3,'n_att_seg_size: ' ,n_att_seg_size);
596: end if;
597:
598: xProgress := 'POOB-10-1010';
599: ece_flatfile_pvt.init_table(cTransaction_Type,cHeader_Interface,NULL,FALSE,l_header_tbl,l_key_tbl);
600:
601: xProgress := 'POOB-10-1020';
602: l_key_tbl := l_header_tbl;
603:
605: --iKey_count := l_header_tbl.COUNT;
606: --ec_debug.pl(3,'iKey_count: ',iKey_count );
607:
608: xProgress := 'POOB-10-1030';
609: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
610:
611: xProgress := 'POOB-10-1040';
612: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
613:
608: xProgress := 'POOB-10-1030';
609: ece_flatfile_pvt.init_table(cTransaction_Type,cLine_Interface,NULL,TRUE,l_line_tbl,l_key_tbl);
610:
611: xProgress := 'POOB-10-1040';
612: ece_flatfile_pvt.init_table(cTransaction_Type,cShipment_Interface,NULL,TRUE,l_shipment_tbl,l_key_tbl);
613:
614: -- ****************************************************************************
615: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic SQL
616: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary
915: -- However, for simplicity, we will convert
916: -- everything to varchar2.
917: -- ******************************************************
918: xProgress := 'POOB-10-1290';
919: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
920:
921: xProgress := 'POOB-10-1300';
922: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
923:
918: xProgress := 'POOB-10-1290';
919: ece_flatfile_pvt.define_interface_column_type(header_sel_c,cHeader_select,ece_extract_utils_PUB.G_MaxColWidth,l_header_tbl);
920:
921: xProgress := 'POOB-10-1300';
922: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
923:
924: xProgress := 'POOB-10-1310';
925: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
926:
921: xProgress := 'POOB-10-1300';
922: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_extract_utils_PUB.G_MaxColWidth,l_line_tbl);
923:
924: xProgress := 'POOB-10-1310';
925: ece_flatfile_pvt.define_interface_column_type(shipment_sel_c,cShipment_select,ece_extract_utils_PUB.G_MaxColWidth,l_shipment_tbl);
926:
927: -- **************************************************************
928: -- *** The following is custom tailored for this transaction
929: -- *** It finds the values and use them in the WHERE clause to
961: xProgress := 'POOB-10-1381';
962: ece_extract_utils_pub.find_pos(l_header_tbl,'CANCEL_FLAG',nHeader_Cancel_Flag_pos);
963:
964: xProgress := 'POOB-10-1382';
965: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos); --2823215
966:
967: -- Line Level Positions
968: xProgress := 'POOB-10-1390';
969: ece_extract_utils_pub.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nLine_Location_ID_pos);
1048: xProgress := 'POOB-10-1427';
1049: ece_extract_utils_pub.find_pos(l_shipment_tbl,'SHIPMENT_NUMBER',nShipment_key_pos);
1050:
1051: xProgress := 'POOB-10-1428';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1053:
1054: xProgress := 'POOB-10-1429';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1056:
1051: xProgress := 'POOB-10-1428';
1052: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CUSTOMER_NAME',nSt_cust_name_pos);
1053:
1054: xProgress := 'POOB-10-1429';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1056:
1057: xProgress := 'POOB-10-1430';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1059:
1054: xProgress := 'POOB-10-1429';
1055: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_NAME',nSt_cont_name_pos);
1056:
1057: xProgress := 'POOB-10-1430';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1059:
1060: xProgress := 'POOB-10-1431';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1062:
1057: xProgress := 'POOB-10-1430';
1058: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_PHONE',nSt_cont_phone_pos);
1059:
1060: xProgress := 'POOB-10-1431';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1062:
1063: xProgress := 'POOB-10-1432';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1065:
1060: xProgress := 'POOB-10-1431';
1061: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_FAX',nSt_cont_fax_pos);
1062:
1063: xProgress := 'POOB-10-1432';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1065:
1066: xProgress := 'POOB-10-1433';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1068:
1063: xProgress := 'POOB-10-1432';
1064: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIP_TO_CONTACT_EMAIL',nSt_cont_email_pos);
1065:
1066: xProgress := 'POOB-10-1433';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1068:
1069: xProgress := 'POOB-10-1434';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1071:
1066: xProgress := 'POOB-10-1433';
1067: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_INSTRUCTIONS',nShipping_Instruct_pos);
1068:
1069: xProgress := 'POOB-10-1434';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1071:
1072: xProgress := 'POOB-10-1435';
1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1074:
1069: xProgress := 'POOB-10-1434';
1070: ece_flatfile_pvt.find_pos(l_shipment_tbl,'PACKING_INSTRUCTIONS',nPacking_Instruct_pos);
1071:
1072: xProgress := 'POOB-10-1435';
1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1074:
1075: xProgress := 'POOB-10-1437';
1076: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1077:
1072: xProgress := 'POOB-10-1435';
1073: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPPING_METHOD',nShipping_method_pos);
1074:
1075: xProgress := 'POOB-10-1437';
1076: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1077:
1078: xProgress := 'POOB-10-1438';
1079: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1080:
1075: xProgress := 'POOB-10-1437';
1076: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_NUMBER',nCust_po_num_pos);
1077:
1078: xProgress := 'POOB-10-1438';
1079: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1080:
1081: xProgress := 'POOB-10-1439';
1082: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1083:
1078: xProgress := 'POOB-10-1438';
1079: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_LINE_NUM',nCust_po_line_num_pos);
1080:
1081: xProgress := 'POOB-10-1439';
1082: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1083:
1084: xProgress := 'POOB-10-1440';
1085: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1086:
1081: xProgress := 'POOB-10-1439';
1082: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_PO_SHIPMENT_NUM',nCust_po_ship_num_pos);
1083:
1084: xProgress := 'POOB-10-1440';
1085: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1086:
1087: xProgress := 'POOB-10-1441';
1088: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1089:
1084: xProgress := 'POOB-10-1440';
1085: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CUSTOMER_ITEM_DESCRIPTION',nCust_prod_desc_pos);
1086:
1087: xProgress := 'POOB-10-1441';
1088: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1089:
1090: xProgress := 'POOB-10-1442';
1091: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1092:
1087: xProgress := 'POOB-10-1441';
1088: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_LOCATION',nDeliv_cust_loc_pos);
1089:
1090: xProgress := 'POOB-10-1442';
1091: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1092:
1093: xProgress := 'POOB-10-1443';
1094: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1095:
1090: xProgress := 'POOB-10-1442';
1091: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_NAME',nDeliv_cust_name_pos);
1092:
1093: xProgress := 'POOB-10-1443';
1094: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1095:
1096: xProgress := 'POOB-10-1444';
1097: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1098:
1093: xProgress := 'POOB-10-1443';
1094: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_NAME',nDeliv_cont_name_pos);
1095:
1096: xProgress := 'POOB-10-1444';
1097: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1098:
1099: xProgress := 'POOB-10-1445';
1100: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1101:
1096: xProgress := 'POOB-10-1444';
1097: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_PHONE',nDeliv_cont_phone_pos);
1098:
1099: xProgress := 'POOB-10-1445';
1100: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1101:
1102: xProgress := 'POOB-10-1446';
1103: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1104:
1099: xProgress := 'POOB-10-1445';
1100: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_FAX',nDeliv_cont_fax_pos);
1101:
1102: xProgress := 'POOB-10-1446';
1103: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1104:
1105: xProgress := 'POOB-10-1447';
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1107:
1102: xProgress := 'POOB-10-1446';
1103: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CUSTOMER_ADDRESS',nDeliv_cust_addr_pos);
1104:
1105: xProgress := 'POOB-10-1447';
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1107:
1108: -- 2823215
1109: xProgress := 'POOB-10-1448';
1110: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1106: ece_flatfile_pvt.find_pos(l_shipment_tbl,'DELIVER_TO_CONTACT_EMAIL',nDeliv_cont_email_pos);
1107:
1108: -- 2823215
1109: xProgress := 'POOB-10-1448';
1110: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1111:
1112: xProgress := 'POOB-10-1449';
1113: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1114:
1109: xProgress := 'POOB-10-1448';
1110: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CODE_UOM',nShp_uom_pos);
1111:
1112: xProgress := 'POOB-10-1449';
1113: ece_flatfile_pvt.find_pos(l_line_tbl,'UOM_CODE',nLine_uom_pos);
1114:
1115: if ec_debug.G_debug_level = 3 then
1116: ec_debug.pl(3,'n_trx_date_pos: ',n_trx_date_pos);
1117: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
1128: end if;
1129:
1130: -- Timezone enhancement
1131: xProgress := 'POOB-TZ-1000';
1132: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1133:
1134: xProgress := 'POOB-TZ-1001';
1135: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1136:
1131: xProgress := 'POOB-TZ-1000';
1132: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DATE', nRel_date_pos);
1133:
1134: xProgress := 'POOB-TZ-1001';
1135: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1136:
1137: xProgress := 'POOB-TZ-1002';
1138: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1139:
1134: xProgress := 'POOB-TZ-1001';
1135: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_TZ_CODE',nRel_dt_tz_pos);
1136:
1137: xProgress := 'POOB-TZ-1002';
1138: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1139:
1140: xProgress := 'POOB-TZ-1003';
1141: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1142:
1137: xProgress := 'POOB-TZ-1002';
1138: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_DT_OFF',nRel_dt_off_pos);
1139:
1140: xProgress := 'POOB-TZ-1003';
1141: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1142:
1143: xProgress := 'POOB-TZ-1004';
1144: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1145:
1140: xProgress := 'POOB-TZ-1003';
1141: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DATE',nCrtn_date_pos);
1142:
1143: xProgress := 'POOB-TZ-1004';
1144: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1145:
1146: xProgress := 'POOB-TZ-1005';
1147: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1148:
1143: xProgress := 'POOB-TZ-1004';
1144: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_TZ_CODE',nCrtn_dt_tz_pos);
1145:
1146: xProgress := 'POOB-TZ-1005';
1147: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1148:
1149: xProgress := 'POOB-TZ-1006';
1150: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1151:
1146: xProgress := 'POOB-TZ-1005';
1147: ece_flatfile_pvt.find_pos(l_header_tbl,'CREATION_DT_OFF',nCrtn_dt_off_pos);
1148:
1149: xProgress := 'POOB-TZ-1006';
1150: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1151:
1152: xProgress := 'POOB-TZ-1007';
1153: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1154:
1149: xProgress := 'POOB-TZ-1006';
1150: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_REVISION_DATE',nRev_date_pos);
1151:
1152: xProgress := 'POOB-TZ-1007';
1153: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1154:
1155: xProgress := 'POOB-TZ-1008';
1156: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1157:
1152: xProgress := 'POOB-TZ-1007';
1153: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_TZ_CODE',nRev_dt_tz_pos);
1154:
1155: xProgress := 'POOB-TZ-1008';
1156: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1157:
1158: xProgress := 'POOB-TZ-1009';
1159: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1160:
1155: xProgress := 'POOB-TZ-1008';
1156: ece_flatfile_pvt.find_pos(l_header_tbl,'REVISION_DT_OFF',nRev_dt_off_pos);
1157:
1158: xProgress := 'POOB-TZ-1009';
1159: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1160:
1161: xProgress := 'POOB-TZ-1010';
1162: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1163:
1158: xProgress := 'POOB-TZ-1009';
1159: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPTANCE_DUE_BY_DATE',nAcc_due_dt_pos);
1160:
1161: xProgress := 'POOB-TZ-1010';
1162: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1163:
1164: xProgress := 'POOB-TZ-1011';
1165: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1166:
1161: xProgress := 'POOB-TZ-1010';
1162: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_TZ_CODE',nAcc_due_tz_pos);
1163:
1164: xProgress := 'POOB-TZ-1011';
1165: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1166:
1167: xProgress := 'POOB-TZ-1012';
1168: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1169:
1164: xProgress := 'POOB-TZ-1011';
1165: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_ACCEPT_DUE_OFF',nAcc_due_off_pos);
1166:
1167: xProgress := 'POOB-TZ-1012';
1168: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1169:
1170: xProgress := 'POOB-TZ-1013';
1171: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1172:
1167: xProgress := 'POOB-TZ-1012';
1168: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_START_DATE',nBlkt_srt_dt_pos);
1169:
1170: xProgress := 'POOB-TZ-1013';
1171: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1172:
1173: xProgress := 'POOB-TZ-1014';
1174: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1175:
1170: xProgress := 'POOB-TZ-1013';
1171: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_TZ_CODE',nBlkt_srt_tz_pos);
1172:
1173: xProgress := 'POOB-TZ-1014';
1174: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1175:
1176: xProgress := 'POOB-TZ-1015';
1177: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1178:
1173: xProgress := 'POOB-TZ-1014';
1174: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_SRT_DT_OFF',nBlkt_srt_off_pos);
1175:
1176: xProgress := 'POOB-TZ-1015';
1177: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1178:
1179: xProgress := 'POOB-TZ-1016';
1180: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1181:
1176: xProgress := 'POOB-TZ-1015';
1177: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DATE',nBlkt_end_dt_pos);
1178:
1179: xProgress := 'POOB-TZ-1016';
1180: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1181:
1182: xProgress := 'POOB-TZ-1017';
1183: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1184:
1179: xProgress := 'POOB-TZ-1016';
1180: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_TZ_CODE',nBlkt_end_tz_pos);
1181:
1182: xProgress := 'POOB-TZ-1017';
1183: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1184:
1185: xProgress := 'POOB-TZ-1018';
1186: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1187:
1182: xProgress := 'POOB-TZ-1017';
1183: ece_flatfile_pvt.find_pos(l_header_tbl,'BLANKET_END_DT_OFF',nBlkt_end_off_pos);
1184:
1185: xProgress := 'POOB-TZ-1018';
1186: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1187:
1188: xProgress := 'POOB-TZ-1019';
1189: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1190:
1185: xProgress := 'POOB-TZ-1018';
1186: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPIRATION_DATE',nPcard_exp_dt_pos);
1187:
1188: xProgress := 'POOB-TZ-1019';
1189: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1190:
1191: xProgress := 'POOB-TZ-1020';
1192: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1193:
1188: xProgress := 'POOB-TZ-1019';
1189: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_TZ_CODE',nPcard_exp_tz_pos);
1190:
1191: xProgress := 'POOB-TZ-1020';
1192: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1193:
1194:
1195: xProgress := 'POOB-TZ-1021';
1196: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1192: ece_flatfile_pvt.find_pos(l_header_tbl,'PCARD_EXPRN_DT_OFF',nPcard_exp_off_pos);
1193:
1194:
1195: xProgress := 'POOB-TZ-1021';
1196: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1197:
1198: xProgress := 'POOB-TZ-1022';
1199: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1200:
1195: xProgress := 'POOB-TZ-1021';
1196: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCELLED_DATE',nLine_can_dt_pos);
1197:
1198: xProgress := 'POOB-TZ-1022';
1199: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1200:
1201: xProgress := 'POOB-TZ-1023';
1202: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1203:
1198: xProgress := 'POOB-TZ-1022';
1199: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_TZ_CODE',nLine_can_tz_pos);
1200:
1201: xProgress := 'POOB-TZ-1023';
1202: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1203:
1204: xProgress := 'POOB-TZ-1024';
1205: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1206:
1201: xProgress := 'POOB-TZ-1023';
1202: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_CANCEL_DT_OFF',nLine_can_off_pos);
1203:
1204: xProgress := 'POOB-TZ-1024';
1205: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1206:
1207: xProgress := 'POOB-TZ-1025';
1208: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1209:
1204: xProgress := 'POOB-TZ-1024';
1205: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DATE',nExprn_dt_pos);
1206:
1207: xProgress := 'POOB-TZ-1025';
1208: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1209:
1210: xProgress := 'POOB-TZ-1026';
1211: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1212:
1207: xProgress := 'POOB-TZ-1025';
1208: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_TZ_CODE',nExprn_tz_pos);
1209:
1210: xProgress := 'POOB-TZ-1026';
1211: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1212:
1213: xProgress := 'POOB-TZ-1027';
1214: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1215:
1210: xProgress := 'POOB-TZ-1026';
1211: ece_flatfile_pvt.find_pos(l_line_tbl,'EXPIRATION_DT_OFF',nExprn_off_pos);
1212:
1213: xProgress := 'POOB-TZ-1027';
1214: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1215:
1216: xProgress := 'POOB-TZ-1028';
1217: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1218:
1213: xProgress := 'POOB-TZ-1027';
1214: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_BY_DATE',nShip_need_dt_pos);
1215:
1216: xProgress := 'POOB-TZ-1028';
1217: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1218:
1219: xProgress := 'POOB-TZ-1029';
1220: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1221:
1216: xProgress := 'POOB-TZ-1028';
1217: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_TZ_CODE',nShip_need_tz_pos);
1218:
1219: xProgress := 'POOB-TZ-1029';
1220: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1221:
1222: xProgress := 'POOB-TZ-1030';
1223: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1224:
1219: xProgress := 'POOB-TZ-1029';
1220: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_NEED_DT_OFF',nShip_need_off_pos);
1221:
1222: xProgress := 'POOB-TZ-1030';
1223: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1224:
1225: xProgress := 'POOB-TZ-1031';
1226: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1227:
1222: xProgress := 'POOB-TZ-1030';
1223: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROMISED_DATE',nShip_prom_dt_pos);
1224:
1225: xProgress := 'POOB-TZ-1031';
1226: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1227:
1228: xProgress := 'POOB-TZ-1032';
1229: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1230:
1225: xProgress := 'POOB-TZ-1031';
1226: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_TZ_CODE',nShip_prom_tz_pos);
1227:
1228: xProgress := 'POOB-TZ-1032';
1229: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1230:
1231: xProgress := 'POOB-TZ-1033';
1232: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1233:
1228: xProgress := 'POOB-TZ-1032';
1229: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_PROM_DT_OFF',nShip_prom_off_pos);
1230:
1231: xProgress := 'POOB-TZ-1033';
1232: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1233:
1234: xProgress := 'POOB-TZ-1034';
1235: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1236:
1231: xProgress := 'POOB-TZ-1033';
1232: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACCEPTABLE_DATE',nShip_accept_dt_pos);
1233:
1234: xProgress := 'POOB-TZ-1034';
1235: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1236:
1237: xProgress := 'POOB-TZ-1035';
1238: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1239:
1234: xProgress := 'POOB-TZ-1034';
1235: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_TZ_CODE',nShip_accept_tz_pos);
1236:
1237: xProgress := 'POOB-TZ-1035';
1238: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1239:
1240: xProgress := 'POOB-TZ-1036';
1241: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1242:
1237: xProgress := 'POOB-TZ-1035';
1238: ece_flatfile_pvt.find_pos(l_shipment_tbl,'SHIPMENT_LAST_ACC_DT_OFF',nShip_accept_off_pos);
1239:
1240: xProgress := 'POOB-TZ-1036';
1241: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1242:
1243: xProgress := 'POOB-TZ-1037';
1244: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1245:
1240: xProgress := 'POOB-TZ-1036';
1241: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCELLED_DATE',nShp_can_dt_pos);
1242:
1243: xProgress := 'POOB-TZ-1037';
1244: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1245:
1246: xProgress := 'POOB-TZ-1038';
1247: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1248:
1243: xProgress := 'POOB-TZ-1037';
1244: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_TZ_CODE',nShp_can_tz_pos);
1245:
1246: xProgress := 'POOB-TZ-1038';
1247: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1248:
1249: xProgress := 'POOB-TZ-1039';
1250: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1251:
1246: xProgress := 'POOB-TZ-1038';
1247: ece_flatfile_pvt.find_pos(l_shipment_tbl,'CANCEL_DT_OFF',nShp_can_off_pos);
1248:
1249: xProgress := 'POOB-TZ-1039';
1250: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1251:
1252: xProgress := 'POOB-TZ-1040';
1253: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1254:
1249: xProgress := 'POOB-TZ-1039';
1250: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DATE',nShp_strt_dt_pos);
1251:
1252: xProgress := 'POOB-TZ-1040';
1253: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1254:
1255: xProgress := 'POOB-TZ-1041';
1256: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1257:
1252: xProgress := 'POOB-TZ-1040';
1253: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_TZ_CODE',nShp_strt_tz_pos);
1254:
1255: xProgress := 'POOB-TZ-1041';
1256: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1257:
1258: xProgress := 'POOB-TZ-1042';
1259: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1260:
1255: xProgress := 'POOB-TZ-1041';
1256: ece_flatfile_pvt.find_pos(l_shipment_tbl,'START_DT_OFF',nShp_strt_off_pos);
1257:
1258: xProgress := 'POOB-TZ-1042';
1259: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1260:
1261: xProgress := 'POOB-TZ-1043';
1262: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1263:
1258: xProgress := 'POOB-TZ-1042';
1259: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DATE',nShp_end_dt_pos);
1260:
1261: xProgress := 'POOB-TZ-1043';
1262: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1263:
1264: xProgress := 'POOB-TZ-1044';
1265: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1266: -- Timezone enhancement
1261: xProgress := 'POOB-TZ-1043';
1262: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_TZ_CODE',nShp_end_tz_pos);
1263:
1264: xProgress := 'POOB-TZ-1044';
1265: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1266: -- Timezone enhancement
1267: xProgress := 'POOB-09-1400';
1268: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1269:
1264: xProgress := 'POOB-TZ-1044';
1265: ece_flatfile_pvt.find_pos(l_shipment_tbl,'END_DT_OFF',nShp_end_off_pos);
1266: -- Timezone enhancement
1267: xProgress := 'POOB-09-1400';
1268: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1269:
1270: xProgress := 'POOB-09-1401';
1271: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1272:
1267: xProgress := 'POOB-09-1400';
1268: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,n_header_common_key_pos);
1269:
1270: xProgress := 'POOB-09-1401';
1271: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1272:
1273: xProgress := 'POOB-09-1402';
1274: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1275:
1270: xProgress := 'POOB-09-1401';
1271: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,n_line_common_key_pos);
1272:
1273: xProgress := 'POOB-09-1402';
1274: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,n_ship_common_key_pos);
1275:
1276: xProgress := 'POOB-10-1407';
1277: -- bind variables
1278: dbms_sql.bind_variable(header_sel_c,'cComm_Method',cCommunication_Method);
1332: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1333: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1334: end if;
1335: xProgress := 'POOB-10-1431';
1336: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);
1337:
1338: -- ***************************************************
1339: -- also need to populate transaction_date and run_id
1340: -- ***************************************************
1610: -- ****************************
1611: -- store values in pl/sql table
1612: -- ****************************
1613: xProgress := 'POOB-10-1550';
1614: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,iHeader_count,l_line_tbl,l_key_tbl);
1615:
1616: -- The following procedure gets the part number for the
1617: -- item ID returned
1618: xProgress := 'POOB-10-1560';
1917: -- ****************************
1918: -- store values in pl/sql table
1919: -- ****************************
1920: xProgress := 'POOB-10-1660';
1921: ece_flatfile_pvt.assign_column_value_to_tbl(shipment_sel_c,iHeader_count + iLine_count,l_shipment_tbl,l_key_tbl);
1922:
1923: xProgress := 'POOB-10-1670';
1924: BEGIN
1925: SELECT ece_poo_shipment_s.NEXTVAL INTO l_shipment_fkey
2257:
2258: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2259: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2260:
2261: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2262: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2263: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2264:
2265: l_document_type VARCHAR2(30);
2258: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';
2259: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2260:
2261: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2262: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2263: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2264:
2265: l_document_type VARCHAR2(30);
2266:
2259: cAtt_Detail_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_DETAILS';
2260:
2261: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
2262: l_line_tbl ece_flatfile_pvt.Interface_tbl_type;
2263: l_shipment_tbl ece_flatfile_pvt.Interface_tbl_type;
2264:
2265: l_document_type VARCHAR2(30);
2266:
2267: c_header_common_key_name VARCHAR2(40);
2407: ec_debug.pl(3,'v_project_acct_industry: ',v_project_acct_industry);
2408: ec_debug.pl(3,'v_project_acct_schema: ' ,v_project_acct_schema);
2409: */
2410: xProgress := 'POOB-20-1005';
2411: ece_flatfile_pvt.select_clause(cTransaction_Type,
2412: cCommunication_Method,
2413: cHeader_Interface,
2414: cHeader_X_Interface,
2415: l_header_tbl,
2418: cHeader_from,
2419: cHeader_where);
2420:
2421: xProgress := 'POOB-20-1010';
2422: ece_flatfile_pvt.select_clause(cTransaction_Type,
2423: cCommunication_Method,
2424: cLine_Interface,
2425: cLine_X_Interface,
2426: l_line_tbl,
2429: cLine_from,
2430: cLine_where);
2431:
2432: xProgress := 'POOB-20-1020';
2433: ece_flatfile_pvt.select_clause(cTransaction_Type,
2434: cCommunication_Method,
2435: cShipment_Interface,
2436: cShipment_X_Interface,
2437: l_shipment_tbl,
2441: cShipment_where);
2442:
2443: -- Header Level Find Positions
2444: xProgress := 'POOB-20-1021';
2445: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2446:
2447: xProgress := 'POOB-20-1022';
2448: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2449:
2444: xProgress := 'POOB-20-1021';
2445: ece_flatfile_pvt.find_pos(l_header_tbl,ece_flatfile_pvt.G_Translator_Code,nTrans_code_pos);
2446:
2447: xProgress := 'POOB-20-1022';
2448: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2449:
2450:
2451: xProgress := 'POOB-20-1023';
2452: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2448: ece_flatfile_pvt.find_pos(l_header_tbl,c_header_common_key_name,nHeader_key_pos);
2449:
2450:
2451: xProgress := 'POOB-20-1023';
2452: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2453:
2454: xProgress := 'POOB-20-1024';
2455: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2456:
2451: xProgress := 'POOB-20-1023';
2452: ece_flatfile_pvt.find_pos(l_header_tbl,'RELEASE_NUMBER',nRelease_num_pos);
2453:
2454: xProgress := 'POOB-20-1024';
2455: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2456:
2457: xProgress := 'POOB-20-1025';
2458: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2459:
2454: xProgress := 'POOB-20-1024';
2455: ece_flatfile_pvt.find_pos(l_header_tbl,'PO_RELEASE_ID',nRelease_ID_pos);
2456:
2457: xProgress := 'POOB-20-1025';
2458: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2459:
2460: -- Line Level Find Positions
2461: xProgress := 'POOB-20-1026';
2462: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2458: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_TYPE',nDocument_type_pos);
2459:
2460: -- Line Level Find Positions
2461: xProgress := 'POOB-20-1026';
2462: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2463:
2464: xProgress := 'POOB-20-1027';
2465: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2466:
2461: xProgress := 'POOB-20-1026';
2462: ece_flatfile_pvt.find_pos(l_line_tbl,c_line_common_key_name,nLine_key_pos);
2463:
2464: xProgress := 'POOB-20-1027';
2465: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2466:
2467: xProgress := 'POOB-20-1028';
2468: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2469:
2464: xProgress := 'POOB-20-1027';
2465: ece_flatfile_pvt.find_pos(l_line_tbl,'LINE_NUMBER',nLine_num_pos);
2466:
2467: xProgress := 'POOB-20-1028';
2468: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2469:
2470: xProgress := 'POOB-20-1029';
2471: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2472:
2467: xProgress := 'POOB-20-1028';
2468: ece_flatfile_pvt.find_pos(l_line_tbl,'PO_LINE_LOCATION_ID',nPO_Line_Location_ID_pos);
2469:
2470: xProgress := 'POOB-20-1029';
2471: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2472:
2473: -- Shipment Level Find Positions
2474: xProgress := 'POOB-20-1030';
2475: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2471: ece_flatfile_pvt.find_pos(l_line_tbl,'ITEM_ID',nItem_ID_pos);
2472:
2473: -- Shipment Level Find Positions
2474: xProgress := 'POOB-20-1030';
2475: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2476:
2477: xProgress := 'POOB-20-1032';
2478: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);
2479: if ec_debug.G_debug_level = 3 then
2474: xProgress := 'POOB-20-1030';
2475: ece_flatfile_pvt.find_pos(l_shipment_tbl,'LINE_LOCATION_ID',nLine_Location_ID_pos);
2476:
2477: xProgress := 'POOB-20-1032';
2478: ece_flatfile_pvt.find_pos(l_shipment_tbl,c_shipment_key_name,nShipment_key_pos);
2479: if ec_debug.G_debug_level = 3 then
2480: ec_debug.pl(3,'nTrans_code_pos: ',nTrans_code_pos);
2481: ec_debug.pl(3,'nHeader_key_pos: ',nHeader_key_pos);
2482: ec_debug.pl(3,'nRelease_num_pos: ',nRelease_num_pos);
2769: -- However, for simplicity, we will convert
2770: -- everything to varchar2.
2771: -- ******************************************************
2772: xProgress := 'POOB-20-1270';
2773: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
2774: cHeader_select,
2775: ece_flatfile_pvt.G_MaxColWidth,
2776: l_header_tbl);
2777:
2771: -- ******************************************************
2772: xProgress := 'POOB-20-1270';
2773: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
2774: cHeader_select,
2775: ece_flatfile_pvt.G_MaxColWidth,
2776: l_header_tbl);
2777:
2778: -- ***************************************************
2779: -- Need rowid for delete (Header Level)
2787: xProgress := 'POOB-20-1300';
2788: dbms_sql.define_column(Header_sel_c,iHeader_count + 3,n_po_header_ID);
2789:
2790: xProgress := 'POOB-20-1310';
2791: ece_flatfile_pvt.define_interface_column_type(line_sel_c,cLine_select,ece_flatfile_pvt.G_MaxColWidth,l_line_tbl);
2792:
2793: -- ***************************************************
2794: -- Need rowid for delete (Line Level)
2795: -- ***************************************************
2802: xProgress := 'POOB-20-1340';
2803: dbms_sql.define_column(line_sel_c,iLine_count + 3,n_po_line_ID);
2804:
2805: xProgress := 'POOB-20-1350';
2806: ece_flatfile_pvt.define_interface_column_type(Shipment_sel_c,cShipment_select,ece_flatfile_pvt.G_MaxColWidth,l_shipment_tbl);
2807:
2808: -- ***************************************************
2809: -- Need rowid for delete (Shipment Level)
2810: -- ***************************************************
2845: -- ******************************
2846: -- store values in pl/sql table
2847: -- ******************************
2848: xProgress := 'POOB-20-1400';
2849: ece_flatfile_pvt.assign_column_value_to_tbl(header_sel_c,l_header_tbl);
2850:
2851: xProgress := 'POOB-20-1410';
2852: dbms_sql.column_value(header_sel_c,iHeader_count + 1,rHeader_rowid);
2853:
2979: -- ***************************************************
2980: -- store values in pl/sql table
2981: -- ***************************************************
2982: xProgress := 'POOB-20-1530';
2983: ece_flatfile_pvt.assign_column_value_to_tbl(line_sel_c,l_line_tbl);
2984:
2985: xProgress := 'POOB-20-1533';
2986: dbms_sql.column_value(line_sel_c,iLine_count + 1,rLine_rowid);
2987:
3147: -- *********************************
3148: -- store values in pl/sql table
3149: -- *********************************
3150: xProgress := 'POCOB-10-1600';
3151: ece_flatfile_pvt.assign_column_value_to_tbl(Shipment_sel_c,l_shipment_tbl);
3152:
3153: xProgress := 'POCOB-10-1603';
3154: dbms_sql.column_value(shipment_sel_c,iShipment_count + 1,rShipment_rowid);
3155:
3555: cCommunication_Method IN VARCHAR2,
3556: cTransaction_Type IN VARCHAR2,
3557: iRun_id IN INTEGER,
3558: cDistribution_Interface IN VARCHAR2,
3559: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
3560: cPO_Header_ID IN NUMBER,
3561: cPO_Release_ID IN NUMBER,
3562: cPO_Line_ID IN NUMBER,
3563: cPO_Line_Location_ID IN NUMBER,
3566: xProgress VARCHAR2(80);
3567: v_LevelProcessed VARCHAR(40);
3568:
3569: /* Bug 2490109
3570: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3571: project_sel_c INTEGER;
3572: */
3573: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291
3574:
3644: iKey_count := l_key_tbl.COUNT;
3645: if ec_debug.G_debug_level = 3 then
3646: ec_debug.pl(3,'iKey_count: ',iKey_count);
3647: END if;
3648: ece_flatfile_pvt.init_table(cTransaction_Type,cDistribution_Interface,iProject_output_level,TRUE,l_project_tbl,l_key_tbl);
3649:
3650: xProgress := 'POOB-40-1010';
3651: ece_extract_utils_pub.select_clause(cTransaction_Type,
3652: cCommunication_Method,
3710: --ec_debug.pl(3,'iKey_count: ',iKey_count);
3711:
3712: -- Define Column Types
3713: xProgress := 'POOB-40-1090';
3714: ece_flatfile_pvt.define_interface_column_type(project_sel_c,cProject_select,ece_extract_utils_PUB.G_MaxColWidth,l_project_tbl);
3715:
3716: -- Project Level Positions
3717:
3718: end if; --Bug 2490109
3716: -- Project Level Positions
3717:
3718: end if; --Bug 2490109
3719: --2823215
3720: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3721: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3722: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3723: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3717:
3718: end if; --Bug 2490109
3719: --2823215
3720: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3721: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3722: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3723: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3725:
3718: end if; --Bug 2490109
3719: --2823215
3720: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3721: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3722: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3723: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3725:
3726:
3719: --2823215
3720: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3721: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3722: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3723: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3725:
3726:
3727: --2823215
3720: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_ID',nTask_id_pos);
3721: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_ID',nProject_id_pos);
3722: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_NUMBER',nProject_num_pos);
3723: ece_flatfile_pvt.find_pos(l_project_tbl,'PROJECT_TYPE',nProject_type_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3725:
3726:
3727: --2823215
3728: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3724: ece_flatfile_pvt.find_pos(l_project_tbl,'TASK_NUMBER',nTask_num_pos);
3725:
3726:
3727: --2823215
3728: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3729: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3730: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3731:
3732: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3725:
3726:
3727: --2823215
3728: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3729: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3730: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3731:
3732: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3733: -- Bind Variables
3726:
3727: --2823215
3728: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3729: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3730: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3731:
3732: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3733: -- Bind Variables
3734: xProgress := 'POOB-40-1140';
3751: xProgress := 'POOB-40-1190';
3752: WHILE dbms_sql.fetch_rows(project_sel_c) > 0 LOOP -- Project Level Loop
3753: -- Store Internal Values in the PL/SQL Table
3754: xProgress := 'POOB-40-1200';
3755: ece_flatfile_pvt.assign_column_value_to_tbl(project_sel_c,iKey_count,l_project_tbl,l_key_tbl);
3756:
3757: xProgress := 'POOB-TZ-4500';
3758:
3759: ece_timezone_api.get_server_timezone_details
3934:
3935: nProject_key_pos NUMBER;
3936:
3937: /* Bug 2490109
3938: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3939: project_sel_c INTEGER;
3940: project_del_c1 INTEGER;
3941: project_del_c2 INTEGER;
3942: */
3983: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3984:
3985: -- Build the SELECT, FROM, and WHERE Clauses
3986: xProgress := 'POOB-50-1000';
3987: ece_flatfile_pvt.select_clause(cTransaction_Type,
3988: cCommunication_Method,
3989: cDistribution_Interface,
3990: cProject_X_Interface,
3991: l_project_tbl,
4097: end if;
4098:
4099: -- Define Column Types
4100: xProgress := 'POOB-50-1120';
4101: ece_flatfile_pvt.define_interface_column_type(project_sel_c,
4102: cProject_select,
4103: ece_flatfile_pvt.G_MaxColWidth,
4104: l_project_tbl);
4105:
4099: -- Define Column Types
4100: xProgress := 'POOB-50-1120';
4101: ece_flatfile_pvt.define_interface_column_type(project_sel_c,
4102: cProject_select,
4103: ece_flatfile_pvt.G_MaxColWidth,
4104: l_project_tbl);
4105:
4106: -- Define Additional Column Types
4107: xProgress := 'POOB-50-1130';
4134: xProgress := 'POOB-50-1210';
4135: WHILE dbms_sql.fetch_rows(project_sel_c) > 0 LOOP -- Project Level Loop
4136: -- Store the Fetched Data in the PL/SQL Table
4137: xProgress := 'POOB-50-1220';
4138: ece_flatfile_pvt.assign_column_value_to_tbl(project_sel_c,l_project_tbl);
4139:
4140: xProgress := 'POOB-50-1230';
4141: dbms_sql.column_value(project_sel_c,iProject_count + 1,rProject_rowid);
4142:
4229: cPK3_Value IN VARCHAR2,
4230: cPK4_Value IN VARCHAR2,
4231: cPK5_Value IN VARCHAR2,
4232: cSegment_Size IN NUMBER,
4233: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4234: cFile_Common_Key IN VARCHAR2,
4235: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4236: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4237: l_key_count IN OUT NOCOPY NUMBER) IS
4231: cPK5_Value IN VARCHAR2,
4232: cSegment_Size IN NUMBER,
4233: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4234: cFile_Common_Key IN VARCHAR2,
4235: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4236: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4237: l_key_count IN OUT NOCOPY NUMBER) IS
4238:
4239: xProgress VARCHAR2(80);
4232: cSegment_Size IN NUMBER,
4233: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4234: cFile_Common_Key IN VARCHAR2,
4235: l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4236: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4237: l_key_count IN OUT NOCOPY NUMBER) IS
4238:
4239: xProgress VARCHAR2(80);
4240:
4237: l_key_count IN OUT NOCOPY NUMBER) IS
4238:
4239: xProgress VARCHAR2(80);
4240:
4241: --l_att_header_tbl ece_flatfile_pvt.Interface_tbl_type;
4242:
4243: v_att_header_select VARCHAR2(32000);
4244: v_att_header_from VARCHAR2(32000);
4245: v_att_header_where VARCHAR2(32000);
4269:
4270: xProgress := 'POOB-60-1000';
4271: if ( l_att_header_tbl.count = 0) then
4272: l_key_count := l_key_tbl.count;
4273: ece_flatfile_pvt.init_table(cTransaction_Type,
4274: cAtt_Header_Interface,
4275: cHeader_Output_Level,
4276: TRUE,
4277: l_att_header_tbl,
4447: ec_debug.pl(3,'n_header_count: ',n_header_count);
4448: end if;
4449:
4450: xProgress := 'POOB-60-1130';
4451: ece_flatfile_pvt.define_interface_column_type(n_att_header_sel_c,
4452: v_att_header_select,
4453: ece_extract_utils_pub.G_MAXCOLWIDTH,
4454: l_att_header_tbl);
4455:
4494:
4495: xProgress := 'POOB-60-1150';
4496: WHILE dbms_sql.fetch_rows(n_att_header_sel_c) > 0 LOOP
4497: xProgress := 'POOB-60-1160';
4498: ece_flatfile_pvt.assign_column_value_to_tbl(n_att_header_sel_c,l_key_count,l_att_header_tbl,l_key_tbl);
4499:
4500: xProgress := 'POOB-60-1170';
4501: /* BEGIN
4502: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey
4581: cPK4_Value IN VARCHAR2,
4582: cPK5_Value IN VARCHAR2,
4583: cData_Type_ID IN NUMBER, -- 1=Short, 2=Long
4584: cSegment_Size IN NUMBER,
4585: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4586: cAtt_doc_id IN NUMBER,
4587: cFile_Common_Key IN VARCHAR2,
4588: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
4589:
4584: cSegment_Size IN NUMBER,
4585: l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
4586: cAtt_doc_id IN NUMBER,
4587: cFile_Common_Key IN VARCHAR2,
4588: l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type) IS
4589:
4590: xProgress VARCHAR2(80);
4591:
4592: c_local_chr_10 VARCHAR2(1) := fnd_global.local_chr(10);
4591:
4592: c_local_chr_10 VARCHAR2(1) := fnd_global.local_chr(10);
4593: c_local_chr_13 VARCHAR2(1) := fnd_global.local_chr(13);
4594:
4595: --l_att_detail_tbl ece_flatfile_pvt.Interface_tbl_type;
4596: l_short_text VARCHAR2(32000);
4597: l_data_chunk VARCHAR2(32000);
4598: l_temp_text VARCHAR2(32000);
4599:
4659: ec_debug.pl(3,'v_split_word: ',v_split_word);
4660:
4661: xProgress := 'POOB-70-1000';
4662: if (l_att_detail_tbl.count = 0) then
4663: ece_flatfile_pvt.init_table(cTransaction_Type,cAtt_Detail_Interface,cDetail_Output_Level,TRUE,l_att_detail_tbl,l_key_tbl);
4664:
4665: end if;
4666:
4667: xProgress := 'POOB-70-1010';
4664:
4665: end if;
4666:
4667: xProgress := 'POOB-70-1010';
4668: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4665: end if;
4666:
4667: xProgress := 'POOB-70-1010';
4668: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4666:
4667: xProgress := 'POOB-70-1010';
4668: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4667: xProgress := 'POOB-70-1010';
4668: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4668: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATT_SEQ_NUM', n_att_seq_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4669: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ENTITY_NAME', n_entity_name_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4670: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'NAME', n_name_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4671: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK1_VALUE', n_pk1_value_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4672: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK2_VALUE', n_pk2_value_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4673: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK3_VALUE', n_pk3_value_pos);
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4674: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK4_VALUE', n_pk4_value_pos);
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4682: xProgress := 'POOB-70-1020';
4675: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'PK5_VALUE', n_pk5_value_pos);
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4682: xProgress := 'POOB-70-1020';
4683: -- Build the SELECT Clause.
4676: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'SEGMENT_NUMBER', n_seg_num_pos);
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4682: xProgress := 'POOB-70-1020';
4683: -- Build the SELECT Clause.
4684: ece_extract_utils_pub.select_clause(cTransaction_Type,
4677: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'CONTINUE_FLAG' , n_cont_flag_pos);
4678: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHMENT_SEGMENT', n_att_seg_pos);
4679: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'RUN_ID', n_run_id_pos);
4680: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'TRANSACTION_RECORD_ID',n_transaction_record_id_pos);
4681: ece_flatfile_pvt.find_pos(l_att_detail_tbl,'ATTACHED_DOCUMENT_ID', n_att_doc_id_pos); --Bug2187958
4682: xProgress := 'POOB-70-1020';
4683: -- Build the SELECT Clause.
4684: ece_extract_utils_pub.select_clause(cTransaction_Type,
4685: cCommunication_Method,
4900: end if;
4901:
4902: -- Define Columns
4903: xProgress := 'POOB-70-1320';
4904: ece_flatfile_pvt.define_interface_column_type(n_att_detail_sel_c,
4905: v_att_detail_select,
4906: ece_extract_utils_pub.G_MAXCOLWIDTH,
4907: l_att_detail_tbl);
4908:
4926: WHILE dbms_sql.fetch_rows(n_att_detail_sel_c) > 0 LOOP
4927: xProgress := 'POOB-70-1370';
4928: ec_debug.pl(3,'xProgress: ',xProgress);
4929:
4930: ece_flatfile_pvt.assign_column_value_to_tbl(n_att_detail_sel_c,l_att_detail_tbl);
4931:
4932: n_segment_number := 1;
4933: n_cur_pos := 1;
4934: n_new_chunk_size := 0;
5307: cFile_Common_Key IN VARCHAR2) IS
5308:
5309: xProgress VARCHAR2(80);
5310:
5311: l_header_tbl ece_flatfile_pvt.Interface_tbl_type;
5312:
5313: c_header_common_key_name VARCHAR2(40);
5314:
5315: nSeq_Num_pos NUMBER;
5347: ec_debug.pl(3,'cPK5_Value: ', cPK5_Value);
5348: end if;
5349:
5350: xProgress := 'POOB-80-1000';
5351: ece_flatfile_pvt.select_clause(cTransaction_Type,
5352: cCommunication_Method,
5353: cHeader_Interface,
5354: cHeader_X_Interface,
5355: l_header_tbl,
5547: ec_debug.pl(3,'iHeader_count: ',iHeader_count);
5548: end if;
5549:
5550: xProgress := 'POOB-80-1160';
5551: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
5552: cHeader_select,
5553: ece_flatfile_pvt.G_MaxColWidth,
5554: l_header_tbl );
5555:
5549:
5550: xProgress := 'POOB-80-1160';
5551: ece_flatfile_pvt.define_interface_column_type(Header_sel_c,
5552: cHeader_select,
5553: ece_flatfile_pvt.G_MaxColWidth,
5554: l_header_tbl );
5555:
5556: xProgress := 'POOB-80-1170';
5557: dbms_sql.define_column_rowid(Header_sel_c,iHeader_count + 1,rHeader_rowid);
5582:
5583: xProgress := 'POOB-80-1200';
5584: WHILE dbms_sql.fetch_rows(Header_sel_c) > 0 LOOP
5585: xProgress := 'POOB-80-1210';
5586: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,l_header_tbl);
5587:
5588: xProgress := 'POOB-80-1220';
5589: dbms_sql.column_value(Header_sel_c,iHeader_count + 1,rHeader_rowid);
5590:
5592: dbms_sql.column_value(Header_sel_c,iHeader_count + 2,rHeader_X_rowid);
5593:
5594: -- Find the Position of the Attachemnt Doc ID
5595: xProgress := 'POOB-80-1232';
5596: ece_flatfile_pvt.find_pos(l_header_tbl,'DOCUMENT_ID',nDoc_ID_pos);
5597: nDoc_ID := l_header_tbl(nDoc_ID_pos).value;
5598:
5599: -- Find the Position of the Attachment Sequence Number
5600: xProgress := 'POOB-80-1240';
5597: nDoc_ID := l_header_tbl(nDoc_ID_pos).value;
5598:
5599: -- Find the Position of the Attachment Sequence Number
5600: xProgress := 'POOB-80-1240';
5601: ece_flatfile_pvt.find_pos(l_header_tbl,'ATT_SEQ_NUM',nSeq_Num_pos);
5602: -- Get the Attachment Sequence Number itself.
5603: nSeq_Num := l_header_tbl(nSeq_Num_pos).value;
5604: -- Bug 2187958
5605: ece_flatfile_pvt.find_pos(l_header_tbl,'ATTACHED_DOCUMENT_ID',nAtt_Doc_ID);
5601: ece_flatfile_pvt.find_pos(l_header_tbl,'ATT_SEQ_NUM',nSeq_Num_pos);
5602: -- Get the Attachment Sequence Number itself.
5603: nSeq_Num := l_header_tbl(nSeq_Num_pos).value;
5604: -- Bug 2187958
5605: ece_flatfile_pvt.find_pos(l_header_tbl,'ATTACHED_DOCUMENT_ID',nAtt_Doc_ID);
5606: -- Get the Attachment Document ID
5607: nAtt_Doc_ID := l_header_tbl(nAtt_Doc_ID).value;
5608:
5609: if ec_debug.G_debug_level = 3 then
5694: cAtt_Doc_ID IN NUMBER) IS
5695:
5696: xProgress VARCHAR2(80);
5697:
5698: l_detail_tbl ece_flatfile_pvt.Interface_tbl_type;
5699:
5700: c_detail_common_key_name VARCHAR2(40);
5701:
5702: Detail_sel_c INTEGER;
5732: ec_debug.pl(3,'cAtt_Doc_ID: ' ,cAtt_Doc_ID);
5733: end if;
5734:
5735: xProgress := 'POOB-90-1000';
5736: ece_flatfile_pvt.select_clause(cTransaction_Type,
5737: cCommunication_Method,
5738: cDetail_Interface,
5739: cDetail_X_Interface,
5740: l_detail_tbl,
5941: ec_debug.pl(3,'iDetail_count: ',iDetail_count);
5942: end if;
5943:
5944: xProgress := 'POOB-90-1180';
5945: ece_flatfile_pvt.define_interface_column_type(Detail_sel_c,
5946: cDetail_select,
5947: ece_flatfile_pvt.G_MaxColWidth,
5948: l_detail_tbl);
5949:
5943:
5944: xProgress := 'POOB-90-1180';
5945: ece_flatfile_pvt.define_interface_column_type(Detail_sel_c,
5946: cDetail_select,
5947: ece_flatfile_pvt.G_MaxColWidth,
5948: l_detail_tbl);
5949:
5950: xProgress := 'POOB-90-1190';
5951: dbms_sql.define_column_rowid(Detail_sel_c,iDetail_count + 1,rDetail_rowid);
5998:
5999: xProgress := 'POOB-90-1220';
6000: WHILE dbms_sql.fetch_rows(Detail_sel_c) > 0 LOOP
6001: xProgress := 'POOB-90-1230';
6002: ece_flatfile_pvt.assign_column_value_to_tbl(Detail_sel_c,l_detail_tbl);
6003:
6004: xProgress := 'POOB-90-1240';
6005: dbms_sql.column_value(Detail_sel_c,iDetail_count + 1,rDetail_rowid);
6006:
6053: PROCEDURE write_to_file(
6054: cTransaction_Type IN VARCHAR2,
6055: cCommunication_Method IN VARCHAR2,
6056: cInterface_Table IN VARCHAR2,
6057: p_Interface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
6058: iOutput_width IN INTEGER,
6059: iRun_id IN INTEGER,
6060: p_common_key IN VARCHAR2,
6061: p_foreign_key IN NUMBER) IS