eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_HOLD dependencies on PO_DOCUMENT_ACTION_PVT

Line 11: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
8:
9:
10: PROCEDURE freeze_unfreeze(
11: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
12: )
13: IS
14:
15: d_progress NUMBER;

Line 46: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

42: l_login_id := FND_GLOBAL.LOGIN_ID;
43:
44: d_progress := 15;
45:
46: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
47: l_allowed_states.hold_flag := 'N';
48: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
49: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
50: l_allowed_states.fully_reserved_flag := NULL;

Line 48: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

44: d_progress := 15;
45:
46: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
47: l_allowed_states.hold_flag := 'N';
48: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
49: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
50: l_allowed_states.fully_reserved_flag := NULL;
51:
52: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE)

Line 49: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

45:
46: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
47: l_allowed_states.hold_flag := 'N';
48: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
49: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
50: l_allowed_states.fully_reserved_flag := NULL;
51:
52: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE)
53: THEN

Line 52: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE)

48: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
49: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
50: l_allowed_states.fully_reserved_flag := NULL;
51:
52: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE)
53: THEN
54:
55: l_allowed_states.frozen_flag := 'N';
56:

Line 57: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE)

53: THEN
54:
55: l_allowed_states.frozen_flag := 'N';
56:
57: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE)
58: THEN
59:
60: l_allowed_states.frozen_flag := 'Y';
61:

Line 106: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',

102: d_progress := 70;
103:
104: UPDATE po_headers poh
105: SET poh.frozen_flag = DECODE(p_action_ctl_rec.action,
106: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
107: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
108: , poh.last_update_date = SYSDATE
109: , poh.last_updated_by = l_user_id
110: , poh.last_update_login = l_login_id

Line 107: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')

103:
104: UPDATE po_headers poh
105: SET poh.frozen_flag = DECODE(p_action_ctl_rec.action,
106: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
107: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
108: , poh.last_update_date = SYSDATE
109: , poh.last_updated_by = l_user_id
110: , poh.last_update_login = l_login_id
111: WHERE poh.po_header_id = p_action_ctl_rec.document_id;

Line 120: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',

116: d_progress := 80;
117:
118: UPDATE po_releases por
119: SET por.frozen_flag = DECODE(p_action_ctl_rec.action,
120: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
121: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
122: , por.last_update_date = SYSDATE
123: , por.last_updated_by = l_user_id
124: , por.last_update_login = l_login_id

Line 121: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')

117:
118: UPDATE po_releases por
119: SET por.frozen_flag = DECODE(p_action_ctl_rec.action,
120: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
121: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
122: , por.last_update_date = SYSDATE
123: , por.last_updated_by = l_user_id
124: , por.last_update_login = l_login_id
125: WHERE por.po_release_id = p_action_ctl_rec.document_id;

Line 171: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

167: PO_LOG.exc(d_module, d_progress, d_msg);
168: END IF;
169: END IF;
170:
171: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
172:
173: END;
174:
175: p_action_ctl_rec.return_status := l_ret_sts;

Line 189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

185: EXCEPTION
186: WHEN OTHERS THEN
187: p_action_ctl_rec.return_status := 'U';
188:
189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
190: IF (PO_LOG.d_exc) THEN
191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
193: PO_LOG.proc_end(d_module);

Line 201: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

197:
198: END freeze_unfreeze;
199:
200: PROCEDURE hold_unhold(
201: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
202: )
203: IS
204:
205: d_progress NUMBER;

Line 236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;

232: l_login_id := FND_GLOBAL.LOGIN_ID;
233:
234: d_progress := 15;
235:
236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

Line 237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;

233:
234: d_progress := 15;
235:
236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

Line 238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;

234: d_progress := 15;
235:
236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

Line 239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

235:
236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

Line 240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

236: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

Line 241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

237: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
245: l_allowed_states.fully_reserved_flag := NULL;

Line 242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

238: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
245: l_allowed_states.fully_reserved_flag := NULL;
246: l_allowed_states.frozen_flag := NULL;

Line 243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

239: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
245: l_allowed_states.fully_reserved_flag := NULL;
246: l_allowed_states.frozen_flag := NULL;
247:

Line 244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

240: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
241: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
242: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
243: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
245: l_allowed_states.fully_reserved_flag := NULL;
246: l_allowed_states.frozen_flag := NULL;
247:
248: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD)

Line 248: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD)

244: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
245: l_allowed_states.fully_reserved_flag := NULL;
246: l_allowed_states.frozen_flag := NULL;
247:
248: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD)
249: THEN
250:
251: l_allowed_states.hold_flag := 'N';
252:

Line 253: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD)

249: THEN
250:
251: l_allowed_states.hold_flag := 'N';
252:
253: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD)
254: THEN
255:
256: l_allowed_states.hold_flag := 'Y';
257:

Line 302: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',

298: d_progress := 70;
299:
300: UPDATE po_headers poh
301: SET poh.user_hold_flag = DECODE(p_action_ctl_rec.action,
302: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
303: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
304: , poh.approved_flag = DECODE(p_action_ctl_rec.action,
305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
306: DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),

Line 303: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')

299:
300: UPDATE po_headers poh
301: SET poh.user_hold_flag = DECODE(p_action_ctl_rec.action,
302: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
303: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
304: , poh.approved_flag = DECODE(p_action_ctl_rec.action,
305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
306: DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)

Line 305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

301: SET poh.user_hold_flag = DECODE(p_action_ctl_rec.action,
302: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
303: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
304: , poh.approved_flag = DECODE(p_action_ctl_rec.action,
305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
306: DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)
308: , poh.authorization_status = DECODE(p_action_ctl_rec.action,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

Line 307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)

303: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
304: , poh.approved_flag = DECODE(p_action_ctl_rec.action,
305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
306: DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)
308: , poh.authorization_status = DECODE(p_action_ctl_rec.action,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
310: DECODE(poh.authorization_status,
311: 'APPROVED', 'REQUIRES REAPPROVAL',

Line 309: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

305: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
306: DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)
308: , poh.authorization_status = DECODE(p_action_ctl_rec.action,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
310: DECODE(poh.authorization_status,
311: 'APPROVED', 'REQUIRES REAPPROVAL',
312: poh.authorization_status),
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.authorization_status)

Line 313: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.authorization_status)

309: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
310: DECODE(poh.authorization_status,
311: 'APPROVED', 'REQUIRES REAPPROVAL',
312: poh.authorization_status),
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.authorization_status)
314: , poh.last_update_date = sysdate
315: , poh.last_updated_by = l_user_id
316: , poh.last_update_login = l_login_id
317: WHERE poh.po_header_id = p_action_ctl_rec.document_id;

Line 326: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

322: d_progress := 80;
323:
324: UPDATE po_line_locations poll
325: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
326: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
327: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
328: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
329: , poll.last_update_date = SYSDATE
330: , poll.last_updated_by = l_user_id

Line 328: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)

324: UPDATE po_line_locations poll
325: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
326: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
327: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
328: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
329: , poll.last_update_date = SYSDATE
330: , poll.last_updated_by = l_user_id
331: , poll.last_update_login = l_login_id
332: WHERE poll.po_header_id = p_action_ctl_rec.document_id

Line 345: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',

341: d_progress := 90;
342:
343: UPDATE po_releases por
344: SET por.hold_flag = DECODE(p_action_ctl_rec.action,
345: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
347: , por.approved_flag = DECODE(p_action_ctl_rec.action,
348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
349: DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),

Line 346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')

342:
343: UPDATE po_releases por
344: SET por.hold_flag = DECODE(p_action_ctl_rec.action,
345: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
347: , por.approved_flag = DECODE(p_action_ctl_rec.action,
348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
349: DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),
350: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)

Line 348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

344: SET por.hold_flag = DECODE(p_action_ctl_rec.action,
345: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
347: , por.approved_flag = DECODE(p_action_ctl_rec.action,
348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
349: DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),
350: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)
351: , por.authorization_status = DECODE(p_action_ctl_rec.action,
352: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

Line 350: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)

346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
347: , por.approved_flag = DECODE(p_action_ctl_rec.action,
348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
349: DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),
350: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)
351: , por.authorization_status = DECODE(p_action_ctl_rec.action,
352: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
353: DECODE(por.authorization_status,
354: 'APPROVED', 'REQUIRES REAPPROVAL',

Line 352: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

348: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
349: DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),
350: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)
351: , por.authorization_status = DECODE(p_action_ctl_rec.action,
352: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
353: DECODE(por.authorization_status,
354: 'APPROVED', 'REQUIRES REAPPROVAL',
355: por.authorization_status),
356: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.authorization_status)

Line 356: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.authorization_status)

352: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
353: DECODE(por.authorization_status,
354: 'APPROVED', 'REQUIRES REAPPROVAL',
355: por.authorization_status),
356: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.authorization_status)
357: , por.last_update_date = sysdate
358: , por.last_updated_by = l_user_id
359: , por.last_update_login = l_login_id
360: WHERE por.po_release_id = p_action_ctl_rec.document_id;

Line 366: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

362: d_progress := 100;
363:
364: UPDATE po_line_locations poll
365: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
366: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
367: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
368: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
369: , poll.last_update_date = SYSDATE
370: , poll.last_updated_by = l_user_id

Line 368: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)

364: UPDATE po_line_locations poll
365: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
366: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
367: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
368: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
369: , poll.last_update_date = SYSDATE
370: , poll.last_updated_by = l_user_id
371: , poll.last_update_login = l_login_id
372: WHERE poll.po_release_id = p_action_ctl_rec.document_id

Line 419: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

415: PO_LOG.exc(d_module, d_progress, d_msg);
416: END IF;
417: END IF;
418:
419: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
420:
421: END;
422:
423: p_action_ctl_rec.return_status := l_ret_sts;

Line 437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

433: EXCEPTION
434: WHEN OTHERS THEN
435: p_action_ctl_rec.return_status := 'U';
436:
437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
438: IF (PO_LOG.d_exc) THEN
439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
441: PO_LOG.proc_end(d_module);