eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_POO_TRANSACTION dependencies on ECE_ATTACHMENT_HEADERS

Line 266: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';

262:
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;

Line 2258: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';

2254:
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;

Line 4502: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey

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
4503: FROM DUAL;
4504:
4505: EXCEPTION
4506: WHEN NO_DATA_FOUND THEN

Line 4507: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');

4503: FROM DUAL;
4504:
4505: EXCEPTION
4506: WHEN NO_DATA_FOUND THEN
4507: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');
4508: END; */
4509:
4510: xProgress := 'POOB-60-1180';
4511: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

Line 5423: of the item will be repeated in ece_attachment_headers

5419: /* Bug 1892253
5420: If an item has an attachment and if this
5421: item is used in more than 1 PO while
5422: extracting,then the attachment information
5423: of the item will be repeated in ece_attachment_headers
5424: n number of times if n number of POs with the same
5425: item are extracted.
5426: Added code to pick up no of rows having distinct
5427: attachment data from ece_attachment_headers and

Line 5427: attachment data from ece_attachment_headers and

5423: of the item will be repeated in ece_attachment_headers
5424: n number of times if n number of POs with the same
5425: item are extracted.
5426: Added code to pick up no of rows having distinct
5427: attachment data from ece_attachment_headers and
5428: appended this number to the where condition.
5429: */
5430:
5431:

Line 5438: from ece_attachment_headers

5434: begin
5435: get_no_rows := 0;
5436:
5437: select count(distinct(att_seq_num)) into get_no_rows
5438: from ece_attachment_headers
5439: where pk1_value = cPK1_value
5440: and pk2_value = cPK2_value
5441: and entity_name like 'MTL_SYSTEM_ITEMS';
5442: get_no_rows:=get_no_rows+1;

Line 5459: from ece_attachment_headers

5455: begin
5456: get_no_lrows := 0;
5457:
5458: select count(distinct(attached_document_id)) into get_no_lrows
5459: from ece_attachment_headers
5460: where pk1_value = cPK1_value
5461: and entity_name like 'PO_LINES';
5462:
5463: get_no_lrows:=get_no_lrows+1;