APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_HEADERS_ALL

Line 83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

79: d_api_name CONSTANT VARCHAR2(30) := 'udpate_approval_status';
80: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
81: d_position NUMBER;
82:
83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

80: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
81: d_position NUMBER;
82:
83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
88:

Line 85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

81: d_position NUMBER;
82:
83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
88:
89: l_change_status BOOLEAN := FALSE;

Line 86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

82:
83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
88:
89: l_change_status BOOLEAN := FALSE;
90: BEGIN

Line 87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

83: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
84: l_new_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
85: l_orig_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
86: l_orig_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
87: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
88:
89: l_change_status BOOLEAN := FALSE;
90: BEGIN
91:

Line 111: FROM po_headers_all

107: type_lookup_code --Bug#5264722
108: INTO l_orig_auth_status,
109: l_orig_approved_flag,
110: l_type_lookup_code --Bug#5264722
111: FROM po_headers_all
112: WHERE po_header_id = p_draft_info.po_header_id;
113:
114: d_position := 20;
115:

Line 198: UPDATE po_headers_all

194: END IF;
195:
196: d_position := 90;
197:
198: UPDATE po_headers_all
199: SET authorization_status = l_new_auth_status,
200: approved_flag = l_new_approved_flag,
201: last_update_date = SYSDATE
202: WHERE po_header_id = p_draft_info.po_header_id;

Line 422: po_headers_all PH

418: FROM dual
419: WHERE EXISTS
420: ( SELECT NULL
421: FROM po_headers_draft_all PHD,
422: po_headers_all PH
423: WHERE PHD.po_header_id = p_draft_info.po_header_id
424: AND PHD.draft_id = p_draft_info.draft_id
425: AND NVL(PHD.delete_flag, 'N') = 'N'
426: AND NVL(PHD.change_accepted_flag, 'Y') = 'Y'