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.PO_DRAFT_MERGE_PKG dependencies on PO_HEADERS

Line 129: from po_headers_draft_all phd,

125: p_draft_id IN NUMBER)
126: is
127: cursor lines_with_attachments_c(p_draft_id number) is
128: select pld.po_line_id as po_line_id
129: from po_headers_draft_all phd,
130: po_lines_draft_all pld
131: where phd.draft_id = p_draft_id
132: and phd.po_header_id = pld.po_header_id
133: and exists (select 1

Line 141: from po_headers_draft_all phd,

137:
138: cursor line_locs_with_attachments_c(p_draft_id number) is
139: select plld.po_line_id as po_line_id,
140: plld.line_location_id as line_location_id
141: from po_headers_draft_all phd,
142: po_line_locations_draft_all plld
143: where phd.draft_id = p_draft_id
144: and phd.po_header_id = plld.po_header_id
145: and exists (select 1

Line 165: where entity_name = 'PO_HEADERS'

161: into l_header_attach_exist
162: from dual
163: where exists (select 'header attachments exist'
164: from fnd_attached_documents
165: where entity_name = 'PO_HEADERS'
166: and pk1_value = to_char(p_document_id) || '-' || to_char(p_draft_id));
167: exception
168: when others then null;
169: end;

Line 177: process_attachments('PO_HEADERS', p_document_id, p_draft_id);

173: PO_LOG.stmt(d_module, d_position, x_progress);
174: END IF;
175:
176: if l_header_attach_exist = 'Y' then
177: process_attachments('PO_HEADERS', p_document_id, p_draft_id);
178: x_progress := 'Header attachment copied from Modification to header ';
179: IF (PO_LOG.d_stmt) THEN
180: PO_LOG.stmt(d_module, d_position, x_progress);
181: END IF;

Line 253: and entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL'));

249: from dual
250: where exists (select 'attachments exist for mod'
251: from fnd_attached_documents
252: where pk1_value LIKE '%-'|| to_char(p_draft_id)
253: and entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL'));
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN NULL;
256: END;
257:

Line 267: AND entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL')

263: FROM DUAL
264: WHERE EXISTS (SELECT 'mod attachments exist with orig attach id not null'
265: FROM fnd_attached_documents
266: WHERE pk1_value LIKE '%-'|| to_char(p_draft_id)
267: AND entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL')
268: AND ORIG_ATTACH_DOC_ID IS NOT NULL);
269:
270: SELECT 'Y'
271: INTO l_attach_locks_exist

Line 276: AND entity_name IN ('PO_HEADERS_ATTACH','PO_LINES_ATTACH','PO_LINE_LOCATIONS_ATTACH'));

272: FROM DUAL
273: WHERE EXISTS (SELECT 'attachment locks exist'
274: FROM po_entity_locks
275: WHERE lock_by_draft_id = p_draft_id
276: AND entity_name IN ('PO_HEADERS_ATTACH','PO_LINES_ATTACH','PO_LINE_LOCATIONS_ATTACH'));
277:
278: EXCEPTION
279: WHEN NO_DATA_FOUND then null;
280: END;

Line 328: UPDATE po_headers_draft_all

324: procedure update_mod_approved_date(p_draft_id IN NUMBER,
325: p_document_id IN NUMBER)
326: IS
327: BEGIN
328: UPDATE po_headers_draft_all
329: SET approved_date = sysdate
330: WHERE draft_id = p_draft_id
331: AND po_header_id = p_document_id;
332:

Line 579: FROM fnd_user fu, PO_HEADERS_MERGE_V ph

575:
576: IF (l_draft_id <> -1) THEN
577: SELECT fu.employee_id
578: INTO l_preparer_id
579: FROM fnd_user fu, PO_HEADERS_MERGE_V ph
580: WHERE fu.user_id = ph.OWNER_USER_ID
581: AND ph.po_header_id = l_document_id
582: AND ph.draft_id = l_draft_id ;
583:

Line 723: from po_headers_draft_all phd,

719: l_draft_id PO_DRAFTS.draft_id%TYPE;
720: cursor control_action_line_c is
721: select nvl(pld.control_action, 'NULL') as control_action,
722: pld.po_line_id as po_line_id
723: from po_headers_draft_all phd,
724: po_lines_draft_all pld
725: where phd.draft_id = l_draft_id
726: and phd.po_header_id = pld.po_header_id
727: and pld.control_action is not NULL;

Line 733: from po_headers_draft_all phd,

729: cursor control_action_line_loc_c is
730: select nvl(plld.control_action, 'NULL') as control_action,
731: plld.po_line_id as po_line_id,
732: plld.line_location_id as po_line_location_id
733: from po_headers_draft_all phd,
734: po_line_locations_draft_all plld
735: where phd.draft_id = l_draft_id
736: and phd.po_header_id = plld.po_header_id
737: and plld.control_action is not NULL;

Line 742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

738:
739:
740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;

Line 743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

739:
740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;
747: l_shipment_id NUMBER;

Line 744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;
747: l_shipment_id NUMBER;
748: x_return_status VARCHAR2(1);

Line 772: from po_headers_draft_all phd,

768: into v_type_code,
769: l_control_Action,
770: p_document_id,
771: l_date
772: from po_headers_draft_all phd,
773: po_drafts pd
774: where phd.draft_id = l_draft_id
775: and phd.draft_id = pd.draft_id;
776:

Line 963: po_headers_all poh

959: BEGIN
960: SELECT clm_flag
961: INTO l_is_clm_document
962: FROM po_doc_style_headers psh,
963: po_headers_all poh
964: WHERE psh.style_id = poh.style_id
965: AND poh.po_header_id = l_document_id;
966: EXCEPTION
967: WHEN no_data_found THEN

Line 1075: FROM po_headers_all

1071: --Mod Commercialization
1072:
1073: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
1074: INTO l_functional_area_code, l_document_type_code, l_document_style_id
1075: FROM po_headers_all
1076: WHERE PO_HEADER_ID = p_document_id;
1077:
1078: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_CLM_CLO_UTIL.Check_Uda_Enabled';
1079: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 1252: po_headers poh

1248: BEGIN
1249: SELECT clm_flag
1250: INTO l_is_clm_document
1251: FROM po_doc_style_headers psh,
1252: po_headers poh
1253: WHERE psh.style_id = poh.style_id
1254: AND poh.po_header_id = p_document_id;
1255: EXCEPTION
1256: WHEN no_data_found THEN

Line 1329: FROM po_headers_draft_all

1325:
1326:
1327: SELECT uda_template_id
1328: INTO l_uda_template_id
1329: FROM po_headers_draft_all
1330: WHERE po_header_id = l_po_hdr_id
1331: AND draft_id = l_draft_id;
1332:
1333: --

Line 1490: where fad.entity_name = 'PO_HEADERS'

1486: -- is not needed for these attachmnets
1487: cursor headers_with_new_attachments_c(p_header_id NUMBER,p_draft_id NUMBER) is
1488: select fad.attached_document_id, fd.datatype_id , fad.ORIG_ATTACH_DOC_ID
1489: from fnd_attached_documents fad , fnd_documents fd
1490: where fad.entity_name = 'PO_HEADERS'
1491: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
1492: AND fad.ORIG_ATTACH_DOC_ID IS NULL
1493: AND fd.document_id = fad.document_id
1494: AND fad.category_id NOT IN (SELECT category_id

Line 1514: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS') LOOP

1510: IF (PO_LOG.d_stmt) THEN
1511: PO_LOG.stmt(d_module, d_position, x_progress);
1512: END IF;
1513:
1514: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS') LOOP
1515: --delete the old records
1516: fnd_attached_documents3_pkg.delete_row
1517: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1518: X_datatype_id => l_rec.datatype_id,

Line 1524: ( X_from_entity_name => 'PO_HEADERS',

1520: );
1521:
1522: --copy the new records
1523: fnd_attached_documents2_pkg.copy_attachments
1524: ( X_from_entity_name => 'PO_HEADERS',
1525: X_from_pk1_value => To_Char(p_header_id)||'-'||To_Char(p_draft_id),
1526: X_to_entity_name => 'PO_HEADERS',
1527: X_to_pk1_value => To_Char(p_header_id),
1528: X_orig_attach_doc_id => l_rec.attached_document_id

Line 1526: X_to_entity_name => 'PO_HEADERS',

1522: --copy the new records
1523: fnd_attached_documents2_pkg.copy_attachments
1524: ( X_from_entity_name => 'PO_HEADERS',
1525: X_from_pk1_value => To_Char(p_header_id)||'-'||To_Char(p_draft_id),
1526: X_to_entity_name => 'PO_HEADERS',
1527: X_to_pk1_value => To_Char(p_header_id),
1528: X_orig_attach_doc_id => l_rec.attached_document_id
1529: );
1530: END LOOP;

Line 1540: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS_DEL') LOOP

1536: PO_LOG.stmt(d_module, d_position, x_progress);
1537: END IF;
1538:
1539:
1540: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS_DEL') LOOP
1541: --delete the old record
1542: fnd_attached_documents3_pkg.delete_row
1543: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1544: X_datatype_id => l_rec.datatype_id,

Line 1558: ( X_from_entity_name => 'PO_HEADERS',

1554: END IF;
1555:
1556: FOR l_rec IN headers_with_new_attachments_c(p_header_id,p_draft_id) LOOP
1557: fnd_attached_documents2_pkg.copy_attachments
1558: ( X_from_entity_name => 'PO_HEADERS',
1559: X_from_pk1_value => To_Char(p_header_id)||'-'||To_Char(p_draft_id),
1560: X_to_entity_name => 'PO_HEADERS',
1561: X_to_pk1_value => To_Char(p_header_id),
1562: X_orig_attach_doc_id => l_rec.attached_document_id

Line 1560: X_to_entity_name => 'PO_HEADERS',

1556: FOR l_rec IN headers_with_new_attachments_c(p_header_id,p_draft_id) LOOP
1557: fnd_attached_documents2_pkg.copy_attachments
1558: ( X_from_entity_name => 'PO_HEADERS',
1559: X_from_pk1_value => To_Char(p_header_id)||'-'||To_Char(p_draft_id),
1560: X_to_entity_name => 'PO_HEADERS',
1561: X_to_pk1_value => To_Char(p_header_id),
1562: X_orig_attach_doc_id => l_rec.attached_document_id
1563: );
1564: END LOOP;

Line 1829: FROM fnd_user fu, PO_HEADERS_MERGE_V ph

1825: -- Add new record ina ction history, in case tehre were no approvers and
1826: -- preparer was the only approver.
1827: SELECT fu.employee_id
1828: INTO l_preparer_id
1829: FROM fnd_user fu, PO_HEADERS_MERGE_V ph
1830: WHERE fu.user_id = ph.OWNER_USER_ID
1831: AND ph.po_header_id = po_po_header_id
1832: AND ph.draft_id = p_draft_id ;
1833:

Line 1964: FROM po_headers_draft_all pha,

1960:
1961: BEGIN
1962: SELECT par_enabled_flag
1963: INTO l_is_par_enabled
1964: FROM po_headers_draft_all pha,
1965: po_doc_style_headers pds
1966: WHERE pha.style_id = pds.style_id
1967: AND pha.po_header_id = p_document_id
1968: AND pha.draft_id = p_draft_id;

Line 2017: l_effective_date po_headers_all.clm_effective_date%TYPE;

2013: )
2014: IS
2015: d_progress NUMBER;
2016: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_delivery_event_attr';
2017: l_effective_date po_headers_all.clm_effective_date%TYPE;
2018: BEGIN
2019:
2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN

Line 2034: FROM po_headers_all

2030: IF(p_draft_id = -1) THEN
2031:
2032: SELECT clm_effective_date
2033: INTO l_effective_date
2034: FROM po_headers_all
2035: WHERE po_header_id = p_document_id;
2036:
2037: d_progress := 1;
2038:

Line 2043: FROM po_headers_all pha, po_drafts pd

2039: ELSE
2040:
2041: SELECT pd.MOD_EFFECTIVE_DATE
2042: INTO l_effective_date
2043: FROM po_headers_all pha, po_drafts pd
2044: WHERE pha.po_header_id = p_document_id
2045: AND pha.po_header_id = pd.document_id
2046: AND pd.draft_id = p_draft_id;
2047: