[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;
2255: xProgress VARCHAR2(80);
2256: v_LevelProcessed VARCHAR2(40);
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;
5194: BEGIN
5195: xProgress := 'POOB-70-1620';
5196: ec_debug.pl(3,'xProgress: ',xProgress);
5197:
5198: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5199: FROM DUAL;
5200: if ec_debug.G_debug_level = 3 then
5201: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5202: end if;
5201: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5202: end if;
5203: EXCEPTION
5204: WHEN NO_DATA_FOUND THEN
5205: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_DETAILS_S');
5206: END;
5207:
5208: -- I have to execute the following few lines of code because, I have no way of knowing at this point
5209: -- whether to set the Continue Flag 'Y' or 'N' until I loop around to the top again. This is how I find
5827: get_no_rows:=0;
5828: begin
5829:
5830: select max(segment_number) into get_no_rows
5831: from ece_attachment_details
5832: where pk1_value = cPK1_value
5833: and pk2_value = cPK2_value
5834: and entity_name like 'MTL_SYSTEM_ITEMS'
5835: and attached_document_id = catt_doc_id;
5852: begin
5853: get_no_lrows := 0;
5854:
5855: select count(distinct(segment_number)) into get_no_lrows
5856: from ece_attachment_details
5857: where pk1_value = cPK1_value
5858: and entity_name like 'PO_LINES'
5859: and attached_document_id = catt_doc_id;
5860: