APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_RELEASES

Line 113: l_auth_status po_releases.authorization_status%TYPE;

109:
110: i BINARY_INTEGER;
111:
112: l_fully_res_flag financials_system_parameters.req_encumbrance_flag%TYPE;
113: l_auth_status po_releases.authorization_status%TYPE;
114: l_head_closed po_releases.closed_code%TYPE;
115:
116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;

Line 114: l_head_closed po_releases.closed_code%TYPE;

110: i BINARY_INTEGER;
111:
112: l_fully_res_flag financials_system_parameters.req_encumbrance_flag%TYPE;
113: l_auth_status po_releases.authorization_status%TYPE;
114: l_head_closed po_releases.closed_code%TYPE;
115:
116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;
118: l_line_closed po_lines.closed_code%TYPE;

Line 116: l_user_hold_flag po_releases.hold_flag%TYPE;

112: l_fully_res_flag financials_system_parameters.req_encumbrance_flag%TYPE;
113: l_auth_status po_releases.authorization_status%TYPE;
114: l_head_closed po_releases.closed_code%TYPE;
115:
116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;
118: l_line_closed po_lines.closed_code%TYPE;
119: l_closed_code VARCHAR2(26);
120: l_frozen_flag po_releases.frozen_flag%TYPE;

Line 120: l_frozen_flag po_releases.frozen_flag%TYPE;

116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;
118: l_line_closed po_lines.closed_code%TYPE;
119: l_closed_code VARCHAR2(26);
120: l_frozen_flag po_releases.frozen_flag%TYPE;
121:
122: l_state_found BOOLEAN;
123:
124: d_progress NUMBER;

Line 135: FROM po_releases por

131: SELECT nvl(por.authorization_status, 'INCOMPLETE'),
132: nvl(por.closed_code, 'OPEN'),
133: nvl(por.frozen_flag, 'N'),
134: nvl(por.hold_flag, 'N')
135: FROM po_releases por
136: WHERE por.po_release_id = docid;
137:
138: CURSOR state_po(docid NUMBER) IS
139: SELECT nvl(poh.authorization_status, 'INCOMPLETE'),

Line 618: FROM po_releases_all por

614: d_progress := 20;
615:
616: SELECT por.agent_id
617: INTO x_preparer_id
618: FROM po_releases_all por
619: WHERE por.po_release_id = p_document_id;
620:
621: d_progress := 30;
622: IF (PO_LOG.d_stmt) THEN

Line 1110: FROM PO_RELEASES por

1106: por.revision_num
1107: INTO l_old_status,
1108: l_creation_date,
1109: l_revision_num
1110: FROM PO_RELEASES por
1111: WHERE por.po_release_id = p_document_id; --
1112:
1113: ELSE
1114:

Line 2120: UPDATE PO_RELEASES por

2116: THEN
2117:
2118: d_progress := 110;
2119:
2120: UPDATE PO_RELEASES por
2121: SET por.authorization_status = p_new_status,
2122: por.approved_flag = DECODE(p_new_status,
2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',