DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on MO_GLOBAL

Line 177: MO_GLOBAL.init('OKL');

173: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
174: -- query to pull NON-OKL contracts
175: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
176: ------------------------------------------------------------------
177: MO_GLOBAL.init('OKL');
178: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
179:
180:
181: IF P_AR_INFO_YN like 'YES' THEN

Line 178: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);

174: -- query to pull NON-OKL contracts
175: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
176: ------------------------------------------------------------------
177: MO_GLOBAL.init('OKL');
178: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
179:
180:
181: IF P_AR_INFO_YN like 'YES' THEN
182:

Line 2366: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request

2362: ------------------------------------------------------------
2363: CURSOR op_unit_csr IS
2364: SELECT NAME
2365: FROM hr_operating_units
2366: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request
2367:
2368:
2369: l_del_row_count NUMBER;
2370: l_op_unit_name hr_operating_units.name%TYPE;

Line 2381: MO_GLOBAL.set_policy_context('S',p_operating_unit);

2377: -- Add couple of blank lines
2378: fnd_file.new_line(fnd_file.log,2);
2379: fnd_file.new_line(fnd_file.output,2);
2380:
2381: MO_GLOBAL.set_policy_context('S',p_operating_unit);
2382:
2383: -- Get the request Id
2384: l_request_id := NULL;
2385: OPEN req_id_csr;