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_MASS_UPDATE_PO_PVT dependencies on PO_HEADERS

Line 365: l_po_num po_headers.segment1%TYPE;

361: -- Cursor Output Variables.
362:
363: l_po_rowid ROWID;
364: l_rel_rowid ROWID;
365: l_po_num po_headers.segment1%TYPE;
366: l_rel_num po_releases.release_num%TYPE;
367: l_doc_type po_document_types_all.type_name%TYPE;
368: l_auth_status po_headers.authorization_status%TYPE;
369: l_itemtype wf_items.item_type%TYPE;

Line 368: l_auth_status po_headers.authorization_status%TYPE;

364: l_rel_rowid ROWID;
365: l_po_num po_headers.segment1%TYPE;
366: l_rel_num po_releases.release_num%TYPE;
367: l_doc_type po_document_types_all.type_name%TYPE;
368: l_auth_status po_headers.authorization_status%TYPE;
369: l_itemtype wf_items.item_type%TYPE;
370: l_itemkey wf_items.item_key%TYPE;
371:
372: -- Variables used in OKC API.

Line 374: l_document_id po_headers.po_header_id%TYPE;

370: l_itemkey wf_items.item_key%TYPE;
371:
372: -- Variables used in OKC API.
373:
374: l_document_id po_headers.po_header_id%TYPE;
375: l_document_type po_headers.type_lookup_code%TYPE;
376: l_document_version po_headers.revision_num%TYPE;
377: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
378: l_contracts_document_type VARCHAR2(150);

Line 375: l_document_type po_headers.type_lookup_code%TYPE;

371:
372: -- Variables used in OKC API.
373:
374: l_document_id po_headers.po_header_id%TYPE;
375: l_document_type po_headers.type_lookup_code%TYPE;
376: l_document_version po_headers.revision_num%TYPE;
377: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
378: l_contracts_document_type VARCHAR2(150);
379: SUBTYPE busdocs_tbl_type IS okc_manage_deliverables_grp.busdocs_tbl_type;

Line 376: l_document_version po_headers.revision_num%TYPE;

372: -- Variables used in OKC API.
373:
374: l_document_id po_headers.po_header_id%TYPE;
375: l_document_type po_headers.type_lookup_code%TYPE;
376: l_document_version po_headers.revision_num%TYPE;
377: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
378: l_contracts_document_type VARCHAR2(150);
379: SUBTYPE busdocs_tbl_type IS okc_manage_deliverables_grp.busdocs_tbl_type;
380: l_busdocs_tbl busdocs_tbl_type;

Line 377: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;

373:
374: l_document_id po_headers.po_header_id%TYPE;
375: l_document_type po_headers.type_lookup_code%TYPE;
376: l_document_version po_headers.revision_num%TYPE;
377: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
378: l_contracts_document_type VARCHAR2(150);
379: SUBTYPE busdocs_tbl_type IS okc_manage_deliverables_grp.busdocs_tbl_type;
380: l_busdocs_tbl busdocs_tbl_type;
381: l_empty_busdocs_tbl busdocs_tbl_type;

Line 525: FROM po_headers poh,

521: poh.po_header_id,
522: poh.type_lookup_code,
523: poh.revision_num,
524: Nvl(poh.conterms_exist_flag, ''N'')
525: FROM po_headers poh,
526: po_document_types_vl pdt
527: WHERE poh.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
528: AND pdt.document_type_code IN (''PO'',''PA'')
529: AND pdt.document_subtype = poh.type_lookup_code

Line 664: UPDATE po_headers_all

660:
661: END IF;
662: BEGIN
663:
664: UPDATE po_headers_all
665: SET agent_id = p_new_personid,
666: last_update_date = sysdate,
667: last_updated_by = fnd_global.user_id,
668: last_update_login = fnd_global.login_id

Line 672: UPDATE po_headers_archive_all

668: last_update_login = fnd_global.login_id
669: WHERE rowid = l_po_rowid;
670:
671: --Bug 8846315, update archive also.
672: UPDATE po_headers_archive_all
673: SET agent_id = p_new_personid,
674: last_update_date = sysdate,
675: last_updated_by = fnd_global.user_id,
676: last_update_login = fnd_global.login_id

Line 927: FROM po_headers poh,

923: por.authorization_status,
924: por.wf_item_type,
925: por.wf_item_key,
926: por.po_release_id --8846315 fix
927: FROM po_headers poh,
928: po_releases por,
929: po_document_types_vl pdt
930: WHERE poh.po_header_id = por.po_header_id
931: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

Line 1296: l_po_num po_headers.segment1%TYPE;

1292: stmt_rel VARCHAR2(4000);
1293: stmt_po VARCHAR2(4000);
1294: l_po_rowid ROWID;
1295: l_rel_rowid ROWID;
1296: l_po_num po_headers.segment1%TYPE;
1297: l_rel_num po_releases.release_num%TYPE;
1298: po_num_type VARCHAR2(100);
1299: l_commit_count NUMBER := 0;
1300: l_progress VARCHAR2(3) := '000';

Line 1303: l_auth_status po_headers.authorization_status%TYPE;

1299: l_commit_count NUMBER := 0;
1300: l_progress VARCHAR2(3) := '000';
1301: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1302: l_doc_type po_document_types_all.type_name%TYPE;
1303: l_auth_status po_headers.authorization_status%TYPE;
1304: l_notification_id wf_notifications.notification_id%TYPE;
1305: l_msg16 VARCHAR2(240);
1306: l_msg17 VARCHAR2(240);
1307:

Line 1445: po_headers poh,

1441: poh.segment1,
1442: pdt.type_name
1443: FROM wf_notifications wfn,
1444: wf_item_activity_statuses wfa,
1445: po_headers poh,
1446: po_document_types_vl pdt
1447: WHERE wfn.notification_id = wfa.notification_id
1448: AND wfa.item_type = poh.wf_item_type
1449: AND wfa.item_key = poh.wf_item_key

Line 1646: po_headers poh,

1642: por.release_num,
1643: pdt.type_name
1644: FROM wf_notifications wfn,
1645: wf_item_activity_statuses wfa,
1646: po_headers poh,
1647: po_releases por,
1648: po_document_types_vl pdt
1649: WHERE wfn.notification_id = wfa.notification_id
1650: AND wfa.item_type = por.wf_item_type

Line 1912: l_po_num po_headers.segment1%TYPE;

1908: stmt_po VARCHAR2(4000);
1909: po_num_type VARCHAR2(100);
1910: l_po_rowid ROWID;
1911: l_rel_rowid ROWID;
1912: l_po_num po_headers.segment1%TYPE;
1913: l_rel_num po_releases.release_num%TYPE;
1914: l_commit_count NUMBER := 0;
1915: l_progress VARCHAR2(3) := '000';
1916: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Deliver_To';

Line 1918: l_auth_status po_headers.authorization_status%TYPE;

1914: l_commit_count NUMBER := 0;
1915: l_progress VARCHAR2(3) := '000';
1916: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Deliver_To';
1917: l_doc_type po_document_types_all.type_name%TYPE;
1918: l_auth_status po_headers.authorization_status%TYPE;
1919: l_msg18 VARCHAR2(240);
1920: l_release_id po_releases.po_release_id%TYPE;
1921:
1922: BEGIN

Line 2053: FROM po_headers poh,

2049: stmt_po := 'SELECT pod.ROWID,
2050: poh.segment1,
2051: pdt.type_name,
2052: pod.po_release_id
2053: FROM po_headers poh,
2054: po_document_types_vl pdt,
2055: po_distributions pod
2056: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
2057: AND poh.po_header_id = pod.po_header_id

Line 2257: po_headers poh,

2253: poh.segment1,
2254: por.release_num,
2255: pdt.type_name
2256: FROM po_releases por,
2257: po_headers poh,
2258: po_document_types_vl pdt,
2259: po_distributions_all pod
2260: WHERE por.po_header_id = poh.po_header_id
2261: AND poh.po_header_id = pod.po_header_id