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 928: po_releases por,

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

Line 1071: UPDATE po_releases_all

1067:
1068: END IF;
1069:
1070: BEGIN
1071: UPDATE po_releases_all
1072: SET agent_id = p_new_personid,
1073: last_update_date = sysdate,
1074: last_updated_by = fnd_global.user_id,
1075: last_update_login = fnd_global.login_id

Line 1079: UPDATE po_releases_archive_all

1075: last_update_login = fnd_global.login_id
1076: WHERE rowid = l_rel_rowid;
1077: --Bug 8846315, update archive also.
1078:
1079: UPDATE po_releases_archive_all
1080: SET agent_id = p_new_personid,
1081: last_update_date = sysdate,
1082: last_updated_by = fnd_global.user_id,
1083: last_update_login = fnd_global.login_id

Line 1297: l_rel_num po_releases.release_num%TYPE;

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

Line 1647: po_releases por,

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

Line 1913: l_rel_num po_releases.release_num%TYPE;

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

Line 1920: l_release_id po_releases.po_release_id%TYPE;

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
1923:
1924: -- Intializing package variables

Line 2256: FROM po_releases por,

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