1 PACKAGE QA_MOAC_PKG AS
2 /* $Header: qamoacs.pls 120.1 2005/10/02 03:12 bso noship $ */
3
4
5 -- Initialize the MOAC context for Quality application
6 -- R12 Project MOAC 4637896 redesign. p_ou_id is currently unused.
7 PROCEDURE init(p_ou_id NUMBER DEFAULT NULL);
8
9
10 -- Initialize the MOAC context to single MOAC for given Inv Org
11 PROCEDURE init_single_ou(p_ou_id NUMBER);
12
13
14 -- Save existing MOAC context into a global package variable.
15 -- Useful in transaction scenario to save parent context;
16 -- init context to single;
17 -- then restoring parent context before returning.
18 PROCEDURE save_context;
19
20
21 -- Restore the existing context used prior to returning
22 -- to parent transaction
23 PROCEDURE restore_context;
24
25
26 -- Derive parent OU given an Inventory Organization ID.
27 FUNCTION derive_ou_id(p_organization_id NUMBER) RETURN NUMBER;
28
29
30 END QA_MOAC_PKG;