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 663: UPDATE po_headers_all

659: PO_DEBUG.debug_var(l_log_head,l_progress,'l_conterms_exist_flag',l_conterms_exist_flag );
660:
661: END IF;
662:
663: UPDATE po_headers_all
664: SET agent_id = p_new_personid,
665: last_update_date = sysdate,
666: last_updated_by = fnd_global.user_id,
667: last_update_login = fnd_global.login_id

Line 871: FROM po_headers poh,

867: pdt.type_name,
868: por.authorization_status,
869: por.wf_item_type,
870: por.wf_item_key
871: FROM po_headers poh,
872: po_releases por,
873: po_document_types_vl pdt
874: WHERE poh.po_header_id = por.po_header_id
875: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

Line 1223: l_po_num po_headers.segment1%TYPE;

1219: stmt_rel VARCHAR2(4000);
1220: stmt_po VARCHAR2(4000);
1221: l_po_rowid ROWID;
1222: l_rel_rowid ROWID;
1223: l_po_num po_headers.segment1%TYPE;
1224: l_rel_num po_releases.release_num%TYPE;
1225: po_num_type VARCHAR2(100);
1226: l_commit_count NUMBER := 0;
1227: l_progress VARCHAR2(3) := '000';

Line 1230: l_auth_status po_headers.authorization_status%TYPE;

1226: l_commit_count NUMBER := 0;
1227: l_progress VARCHAR2(3) := '000';
1228: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1229: l_doc_type po_document_types_all.type_name%TYPE;
1230: l_auth_status po_headers.authorization_status%TYPE;
1231: l_notification_id wf_notifications.notification_id%TYPE;
1232: l_msg16 VARCHAR2(240);
1233: l_msg17 VARCHAR2(240);
1234:

Line 1372: po_headers poh,

1368: poh.segment1,
1369: pdt.type_name
1370: FROM wf_notifications wfn,
1371: wf_item_activity_statuses wfa,
1372: po_headers poh,
1373: po_document_types_vl pdt
1374: WHERE wfn.notification_id = wfa.notification_id
1375: AND wfa.item_type = poh.wf_item_type
1376: AND wfa.item_key = poh.wf_item_key

Line 1573: po_headers poh,

1569: por.release_num,
1570: pdt.type_name
1571: FROM wf_notifications wfn,
1572: wf_item_activity_statuses wfa,
1573: po_headers poh,
1574: po_releases por,
1575: po_document_types_vl pdt
1576: WHERE wfn.notification_id = wfa.notification_id
1577: AND wfa.item_type = por.wf_item_type

Line 1839: l_po_num po_headers.segment1%TYPE;

1835: stmt_po VARCHAR2(4000);
1836: po_num_type VARCHAR2(100);
1837: l_po_rowid ROWID;
1838: l_rel_rowid ROWID;
1839: l_po_num po_headers.segment1%TYPE;
1840: l_rel_num po_releases.release_num%TYPE;
1841: l_commit_count NUMBER := 0;
1842: l_progress VARCHAR2(3) := '000';
1843: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Deliver_To';

Line 1845: l_auth_status po_headers.authorization_status%TYPE;

1841: l_commit_count NUMBER := 0;
1842: l_progress VARCHAR2(3) := '000';
1843: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Deliver_To';
1844: l_doc_type po_document_types_all.type_name%TYPE;
1845: l_auth_status po_headers.authorization_status%TYPE;
1846: l_msg18 VARCHAR2(240);
1847: l_release_id po_releases.po_release_id%TYPE;
1848:
1849: BEGIN

Line 1980: FROM po_headers poh,

1976: stmt_po := 'SELECT pod.ROWID,
1977: poh.segment1,
1978: pdt.type_name,
1979: pod.po_release_id
1980: FROM po_headers poh,
1981: po_document_types_vl pdt,
1982: po_distributions pod
1983: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
1984: AND poh.po_header_id = pod.po_header_id

Line 2184: po_headers poh,

2180: poh.segment1,
2181: por.release_num,
2182: pdt.type_name
2183: FROM po_releases por,
2184: po_headers poh,
2185: po_document_types_vl pdt,
2186: po_distributions_all pod
2187: WHERE por.po_header_id = poh.po_header_id
2188: AND poh.po_header_id = pod.po_header_id