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 2225: cAtt_Header_Interface VARCHAR2(120) := 'ECE_ATTACHMENT_HEADERS';

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

Line 4469: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey

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
4470: FROM DUAL;
4471:
4472: EXCEPTION
4473: WHEN NO_DATA_FOUND THEN

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

4470: FROM DUAL;
4471:
4472: EXCEPTION
4473: WHEN NO_DATA_FOUND THEN
4474: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');
4475: END; */
4476:
4477: xProgress := 'POOB-60-1180';
4478: /* ece_extract_utils_pub.insert_into_interface_tbl(iRun_id,

Line 5390: of the item will be repeated in ece_attachment_headers

5386: /* Bug 1892253
5387: If an item has an attachment and if this
5388: item is used in more than 1 PO while
5389: extracting,then the attachment information
5390: of the item will be repeated in ece_attachment_headers
5391: n number of times if n number of POs with the same
5392: item are extracted.
5393: Added code to pick up no of rows having distinct
5394: attachment data from ece_attachment_headers and

Line 5394: attachment data from ece_attachment_headers and

5390: of the item will be repeated in ece_attachment_headers
5391: n number of times if n number of POs with the same
5392: item are extracted.
5393: Added code to pick up no of rows having distinct
5394: attachment data from ece_attachment_headers and
5395: appended this number to the where condition.
5396: */
5397:
5398:

Line 5405: from ece_attachment_headers

5401: begin
5402: get_no_rows := 0;
5403:
5404: select count(distinct(att_seq_num)) into get_no_rows
5405: from ece_attachment_headers
5406: where pk1_value = cPK1_value
5407: and pk2_value = cPK2_value
5408: and entity_name like 'MTL_SYSTEM_ITEMS';
5409: get_no_rows:=get_no_rows+1;

Line 5426: from ece_attachment_headers

5422: begin
5423: get_no_lrows := 0;
5424:
5425: select count(distinct(attached_document_id)) into get_no_lrows
5426: from ece_attachment_headers
5427: where pk1_value = cPK1_value
5428: and entity_name like 'PO_LINES';
5429:
5430: get_no_lrows:=get_no_lrows+1;