APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_HEADERS_ALL

Line 57: l_doc_org_id PO_HEADERS_ALL.org_id%TYPE;

53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
54: )
55: IS
56:
57: l_doc_org_id PO_HEADERS_ALL.org_id%TYPE;
58: l_old_org_id PO_HEADERS_ALL.org_id%TYPE;
59: l_lock_status VARCHAR2(1);
60:
61: l_ret_sts VARCHAR2(1);

Line 58: l_old_org_id PO_HEADERS_ALL.org_id%TYPE;

54: )
55: IS
56:
57: l_doc_org_id PO_HEADERS_ALL.org_id%TYPE;
58: l_old_org_id PO_HEADERS_ALL.org_id%TYPE;
59: l_lock_status VARCHAR2(1);
60:
61: l_ret_sts VARCHAR2(1);
62: l_msg_count NUMBER;

Line 114: FROM po_headers_all poh

110: d_progress := 11.1;
111:
112: SELECT org_id
113: INTO l_doc_org_id
114: FROM po_headers_all poh
115: WHERE poh.po_header_id = p_action_ctl_rec.document_id;
116:
117: ELSIF (p_action_ctl_rec.document_type = 'RELEASE')
118: THEN