APPS.PA_MOAC_UTILS dependencies on HR_OPERATING_UNITS

Line 40: ( p_org_id hr_operating_units.organization_id%TYPE DEFAULT NULL , p_product_code VARCHAR2 )

36: END GET_OU_COUNT;
37:
38: -- ****************************************************************/
39: FUNCTION GET_VALID_OU
40: ( p_org_id hr_operating_units.organization_id%TYPE DEFAULT NULL , p_product_code VARCHAR2 )
41: RETURN NUMBER
42: --
43: -- This function is used to determine and get valid operating unit where Projects is implmented.
44: -- Returns ORG_ID if valid and PA is implemneted or retruns NULL if invalid or PA is not implemented.

Line 188: p_default_org_id OUT NOCOPY hr_operating_units.organization_id%TYPE,

184: -- ****************************************************************/
185: PROCEDURE GET_DEFAULT_OU
186: (
187: p_product_code IN VARCHAR2 DEFAULT 'PA',
188: p_default_org_id OUT NOCOPY hr_operating_units.organization_id%TYPE,
189: p_default_ou_name OUT NOCOPY hr_operating_units.name%TYPE,
190: p_ou_count OUT NOCOPY NUMBER
191: ) IS
192: --

Line 189: p_default_ou_name OUT NOCOPY hr_operating_units.name%TYPE,

185: PROCEDURE GET_DEFAULT_OU
186: (
187: p_product_code IN VARCHAR2 DEFAULT 'PA',
188: p_default_org_id OUT NOCOPY hr_operating_units.organization_id%TYPE,
189: p_default_ou_name OUT NOCOPY hr_operating_units.name%TYPE,
190: p_ou_count OUT NOCOPY NUMBER
191: ) IS
192: --
193: -- This procedure should be used to get the default operating unit for a user

Line 202: l_default_org_id hr_operating_units.organization_id%TYPE ;

198: --=====
199:
200: --Here we need to check whether Projects is implemented for that OU
201:
202: l_default_org_id hr_operating_units.organization_id%TYPE ;
203: l_default_ou_name hr_operating_units.name%TYPE ;
204: l_ou_count NUMBER ;
205: BEGIN
206: MO_UTILS.GET_DEFAULT_OU( l_default_org_id,

Line 203: l_default_ou_name hr_operating_units.name%TYPE ;

199:
200: --Here we need to check whether Projects is implemented for that OU
201:
202: l_default_org_id hr_operating_units.organization_id%TYPE ;
203: l_default_ou_name hr_operating_units.name%TYPE ;
204: l_ou_count NUMBER ;
205: BEGIN
206: MO_UTILS.GET_DEFAULT_OU( l_default_org_id,
207: l_default_ou_name,

Line 256: p_org_id hr_operating_units.organization_id%TYPE

252: -- ****************************************************************/
253: PROCEDURE SET_POLICY_CONTEXT
254: (
255: p_access_mode VARCHAR2,
256: p_org_id hr_operating_units.organization_id%TYPE
257: )
258: IS
259: --
260: -- This procedure is used to initialize org context. If the access mode is S, the context

Line 276: p_org_id hr_operating_units.organization_id%TYPE, p_product_code varchar2 DEFAULT 'PA')

272: -- ****************************************************************/
273:
274: FUNCTION CHECK_ACCESS
275: (
276: p_org_id hr_operating_units.organization_id%TYPE, p_product_code varchar2 DEFAULT 'PA')
277: RETURN VARCHAR2
278: -- This function checks if the org_id exists in the
279: -- global temorary table or not, if it is present function returns 'Y', else returns 'N'.
280: -- Global temporary table gets populated if MOAC is initialized.