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_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 1: PACKAGE BODY PO_DOCUMENT_ACTION_PVT AS

1: PACKAGE BODY PO_DOCUMENT_ACTION_PVT AS
2: -- $Header: POXVDACB.pls 120.21.12020000.3 2013/02/11 13:21:54 vegajula ship $
3:
4: -- Private package constants
5:

Line 6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_PVT';

2: -- $Header: POXVDACB.pls 120.21.12020000.3 2013/02/11 13:21:54 vegajula ship $
3:
4: -- Private package constants
5:
6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_PVT';
7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
8:
9: -- Private package variables
10:

Line 28: -- package PO_DOCUMENT_ACTION_PVT. Performs all the common logic

24: -- None, directly.Calls PO_DOCUMENT_LOCK_GRP to lock document
25: -- if action ctl record's lock_document = TRUE
26: --Function:
27: -- This procedure is the switchboard for all document actions in
28: -- package PO_DOCUMENT_ACTION_PVT. Performs all the common logic
29: -- for these actions.
30: -- This includes:
31: -- setting the org context to that of the document
32: -- initializing g_err_message, the shared error string

Line 53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

49: -- See individual actions and package spec for more info on outputs.
50: --End of Comments
51: -------------------------------------------------------------------------------
52: PROCEDURE do_action(
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;

Line 66: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.do_action';

62: l_msg_count NUMBER;
63: l_msg_data VARCHAR2(2000) := NULL;
64:
65: d_progress NUMBER;
66: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.do_action';
67: d_log_msg VARCHAR2(200);
68:
69: -- variables required for locking
70: -- resource_busy_exc definition copied from PO_DOCUMENT_LOCK_GRP

Line 257: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE)

253:
254:
255: -- Switchboard: run appropriate handler routine based on action
256:
257: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE)
258: THEN
259:
260: d_progress := 30.1;
261: PO_DOCUMENT_ACTION_AUTH.approve(p_action_ctl_rec => p_action_ctl_rec);

Line 263: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT)

259:
260: d_progress := 30.1;
261: PO_DOCUMENT_ACTION_AUTH.approve(p_action_ctl_rec => p_action_ctl_rec);
262:
263: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT)
264: THEN
265:
266: d_progress := 30.2;
267: PO_DOCUMENT_ACTION_AUTH.reject(p_action_ctl_rec => p_action_ctl_rec);

Line 269: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FORWARD)

265:
266: d_progress := 30.2;
267: PO_DOCUMENT_ACTION_AUTH.reject(p_action_ctl_rec => p_action_ctl_rec);
268:
269: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FORWARD)
270: THEN
271:
272: d_progress := 30.3;
273: PO_DOCUMENT_ACTION_AUTH.forward(p_action_ctl_rec => p_action_ctl_rec);

Line 275: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)

271:
272: d_progress := 30.3;
273: PO_DOCUMENT_ACTION_AUTH.forward(p_action_ctl_rec => p_action_ctl_rec);
274:
275: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)
276: THEN
277:
278: d_progress := 30.4;
279: PO_DOCUMENT_ACTION_AUTH.return_action(p_action_ctl_rec => p_action_ctl_rec);

Line 281: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_APPROVE)

277:
278: d_progress := 30.4;
279: PO_DOCUMENT_ACTION_AUTH.return_action(p_action_ctl_rec => p_action_ctl_rec);
280:
281: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_APPROVE)
282: THEN
283:
284: d_progress := 40.1;
285: PO_DOCUMENT_ACTION_CHECK.approve_status_check(p_action_ctl_rec => p_action_ctl_rec);

Line 287: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_REJECT)

283:
284: d_progress := 40.1;
285: PO_DOCUMENT_ACTION_CHECK.approve_status_check(p_action_ctl_rec => p_action_ctl_rec);
286:
287: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_REJECT)
288: THEN
289:
290: d_progress := 40.2;
291: PO_DOCUMENT_ACTION_CHECK.reject_status_check(p_action_ctl_rec => p_action_ctl_rec);

Line 293: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_AUTHORITY)

289:
290: d_progress := 40.2;
291: PO_DOCUMENT_ACTION_CHECK.reject_status_check(p_action_ctl_rec => p_action_ctl_rec);
292:
293: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_AUTHORITY)
294: THEN
295:
296: d_progress := 40.3;
297: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);

Line 299: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,

295:
296: d_progress := 40.3;
297: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);
298:
299: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,
300: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))
301: THEN
302:
303: d_progress := 50.1;

Line 300: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))

296: d_progress := 40.3;
297: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);
298:
299: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,
300: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))
301: THEN
302:
303: d_progress := 50.1;
304: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);

Line 306: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

302:
303: d_progress := 50.1;
304: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);
305:
306: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))
308: THEN
309:
310: d_progress := 50.2;

Line 307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))

303: d_progress := 50.1;
304: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);
305:
306: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
307: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))
308: THEN
309:
310: d_progress := 50.2;
311: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);

Line 313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,

309:
310: d_progress := 50.2;
311: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
312:
313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

Line 314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,

310: d_progress := 50.2;
311: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
312:
313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,

Line 315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,

311: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
312:
313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

Line 316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,

312:
313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
320: THEN

Line 317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

313: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
320: THEN
321:

Line 318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,

314: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
320: THEN
321:
322: d_progress := 60.1;

Line 319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

315: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
316: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
317: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
318: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
319: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
320: THEN
321:
322: d_progress := 60.1;
323: PO_DOCUMENT_ACTION_CLOSE.manual_close_po(p_action_ctl_rec => p_action_ctl_rec);

Line 325: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UPDATE_CLOSE_AUTO)

321:
322: d_progress := 60.1;
323: PO_DOCUMENT_ACTION_CLOSE.manual_close_po(p_action_ctl_rec => p_action_ctl_rec);
324:
325: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UPDATE_CLOSE_AUTO)
326: THEN
327:
328: d_progress := 60.2;
329: PO_DOCUMENT_ACTION_CLOSE.auto_close_po(p_action_ctl_rec => p_action_ctl_rec);

Line 1335: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.find_forward_to_id';

1331: )
1332: IS
1333:
1334: d_progress NUMBER;
1335: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.find_forward_to_id';
1336: d_msg VARCHAR2(200);
1337:
1338: l_ret_sts VARCHAR2(1) := 'S'; -- Bug 4448215
1339: l_ret_code VARCHAR2(25);

Line 1867: -- Use one of PO_DOCUMENT_ACTION_PVT.g_doc_action<>

1863: -- Uses do_action switchboard
1864: --Parameters:
1865: --IN:
1866: -- p_action
1867: -- Use one of PO_DOCUMENT_ACTION_PVT.g_doc_action<>
1868: -- Where <> could be:
1869: -- OPEN, CLOSE, CLOSE_RCV, OPEN_RCV, CLOSE_INV, OPEN_INV, or FINALLY_CLOSE
1870: -- p_document_id
1871: -- ID of the document's header (e.g. po_release_id, po_header_id, ...)

Line 2223: END PO_DOCUMENT_ACTION_PVT;

2219: END do_cancel;
2220:
2221:
2222:
2223: END PO_DOCUMENT_ACTION_PVT;