APPS.PO_MASS_UPDATE_PO_PVT dependencies on PO_RELEASES

Line 366: l_rel_num po_releases.release_num%TYPE;

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;
370: l_itemkey wf_items.item_key%TYPE;

Line 872: po_releases por,

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
876: AND pdt.document_type_code = ''RELEASE''

Line 1013: UPDATE po_releases_all

1009: PO_DEBUG.debug_var(l_log_head,l_progress,'l_itemkey',l_itemkey );
1010:
1011: END IF;
1012:
1013: UPDATE po_releases_all
1014: SET agent_id = p_new_personid,
1015: last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id

Line 1224: l_rel_num po_releases.release_num%TYPE;

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';
1228: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';

Line 1574: po_releases por,

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
1578: AND wfa.item_key = por.wf_item_key

Line 1840: l_rel_num po_releases.release_num%TYPE;

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';
1844: l_doc_type po_document_types_all.type_name%TYPE;

Line 1847: l_release_id po_releases.po_release_id%TYPE;

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
1850:
1851: -- Intializing package variables

Line 2183: FROM po_releases por,

2179: stmt_rel := 'SELECT pod.ROWID,
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