APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_HEADERS

Line 123: FROM po_headers poh

119: SELECT nvl(poh.authorization_status, 'INCOMPLETE'),
120: nvl(poh.closed_code, 'OPEN'),
121: nvl(poh.frozen_flag, 'N'),
122: nvl(poh.user_hold_flag, 'N')
123: FROM po_headers poh
124: WHERE poh.po_header_id = docid;
125:
126: CURSOR state_req(docid NUMBER) IS
127: SELECT nvl(prh.authorization_status, 'INCOMPLETE'),

Line 531: FROM po_headers_all poh

527: d_progress := 40;
528:
529: SELECT poh.agent_id
530: INTO x_preparer_id
531: FROM po_headers_all poh
532: WHERE poh.po_header_id = p_document_id;
533:
534: d_progress := 50;
535: IF (PO_LOG.d_stmt) THEN

Line 832: l_old_status PO_HEADERS.authorization_status%TYPE;

828:
829: l_emp_flag BOOLEAN;
830: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
831:
832: l_old_status PO_HEADERS.authorization_status%TYPE;
833: l_creation_date PO_HEADERS.creation_date%TYPE;
834: l_revision_num PO_HEADERS.revision_num%TYPE;
835:
836: d_progress NUMBER;

Line 833: l_creation_date PO_HEADERS.creation_date%TYPE;

829: l_emp_flag BOOLEAN;
830: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
831:
832: l_old_status PO_HEADERS.authorization_status%TYPE;
833: l_creation_date PO_HEADERS.creation_date%TYPE;
834: l_revision_num PO_HEADERS.revision_num%TYPE;
835:
836: d_progress NUMBER;
837: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';

Line 834: l_revision_num PO_HEADERS.revision_num%TYPE;

830: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
831:
832: l_old_status PO_HEADERS.authorization_status%TYPE;
833: l_creation_date PO_HEADERS.creation_date%TYPE;
834: l_revision_num PO_HEADERS.revision_num%TYPE;
835:
836: d_progress NUMBER;
837: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';
838:

Line 920: FROM PO_HEADERS poh

916: poh.revision_num
917: INTO l_old_status,
918: l_creation_date,
919: l_revision_num
920: FROM PO_HEADERS poh
921: WHERE poh.po_header_id = p_document_id;
922:
923: ELSIF (p_document_type = 'RELEASE')
924: THEN

Line 1069: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

1065: l_rollup_msg VARCHAR2(256);
1066: l_ctl_replaced_null_entry BOOLEAN := FALSE;
1067: l_count_hist NUMBER;
1068:
1069: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
1070:
1071: BEGIN
1072:
1073: d_progress := 0;

Line 1262: FROM po_headers_all poh

1258: -- so we're safe using headers_all
1259:
1260: SELECT max(poh.revision_num)
1261: INTO l_revision_num
1262: FROM po_headers_all poh
1263: WHERE poh.po_header_id = p_document_id;
1264:
1265: d_progress := 160;
1266: IF (PO_LOG.d_stmt) THEN

Line 1625: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;

1621: , x_return_status OUT NOCOPY VARCHAR2
1622: )
1623: IS
1624:
1625: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;
1626: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;
1627:
1628: l_ret_sts VARCHAR2(1);
1629: l_err_msg VARCHAR2(200);

Line 1626: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;

1622: )
1623: IS
1624:
1625: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;
1626: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;
1627:
1628: l_ret_sts VARCHAR2(1);
1629: l_err_msg VARCHAR2(200);
1630: l_msg_count NUMBER;

Line 1687: UPDATE PO_HEADERS poh

1683: THEN
1684:
1685: d_progress := 20;
1686:
1687: UPDATE PO_HEADERS poh
1688: SET poh.authorization_status = p_new_status,
1689: poh.approved_flag = DECODE(p_new_status,
1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

Line 1717: FROM PO_HEADERS poh

1713: d_progress := 30;
1714:
1715: SELECT NVL(poh.pending_signature_flag, 'N'), NVL(poh.conterms_exist_flag, 'N')
1716: INTO l_pending_signature, l_conterms_exist
1717: FROM PO_HEADERS poh
1718: WHERE po_header_id = p_document_id;
1719:
1720: d_progress := 40;
1721:

Line 1765: UPDATE PO_HEADERS poh

1761: END IF;
1762:
1763: d_progress := 80;
1764:
1765: UPDATE PO_HEADERS poh
1766: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED
1767: , poh.approved_flag = 'N'
1768: , poh.last_update_date = SYSDATE
1769: , poh.last_updated_by = p_user_id

Line 1788: FROM PO_HEADERS_ALL poh

1784: WHERE poll.po_header_id = p_document_id
1785: AND poll.po_release_id IS NULL
1786: AND NVL(poll.approved_flag, 'N') <> 'Y'
1787: AND EXISTS ( SELECT 'PO Does not require signature'
1788: FROM PO_HEADERS_ALL poh
1789: WHERE poh.po_header_id = poll.po_header_id
1790: AND NVL(poh.pending_signature_flag, 'N') <> 'Y');
1791:
1792: END IF; -- p_new_status = g_doc_status_APPROVED