[Home] [Help]
263: xProgress VARCHAR2(30);
264: v_LevelProcessed VARCHAR2(40);
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;
2222: xProgress VARCHAR2(80);
2223: v_LevelProcessed VARCHAR2(40);
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;
5161: BEGIN
5162: xProgress := 'POOB-70-1620';
5163: ec_debug.pl(3,'xProgress: ',xProgress);
5164:
5165: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5166: FROM DUAL;
5167: if ec_debug.G_debug_level = 3 then
5168: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5169: end if;
5168: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5169: end if;
5170: EXCEPTION
5171: WHEN NO_DATA_FOUND THEN
5172: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_DETAILS_S');
5173: END;
5174:
5175: -- I have to execute the following few lines of code because, I have no way of knowing at this point
5176: -- whether to set the Continue Flag 'Y' or 'N' until I loop around to the top again. This is how I find
5794: get_no_rows:=0;
5795: begin
5796:
5797: select max(segment_number) into get_no_rows
5798: from ece_attachment_details
5799: where pk1_value = cPK1_value
5800: and pk2_value = cPK2_value
5801: and entity_name like 'MTL_SYSTEM_ITEMS'
5802: and attached_document_id = catt_doc_id;
5819: begin
5820: get_no_lrows := 0;
5821:
5822: select count(distinct(segment_number)) into get_no_lrows
5823: from ece_attachment_details
5824: where pk1_value = cPK1_value
5825: and entity_name like 'PO_LINES'
5826: and attached_document_id = catt_doc_id;
5827: