DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on MO_GLOBAL

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

159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
160: -- query to pull NON-OKL contracts
161: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
162: ------------------------------------------------------------------
163: MO_GLOBAL.init('OKL');
164: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
165:
166:
167: IF P_AR_INFO_YN like 'YES' THEN

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

160: -- query to pull NON-OKL contracts
161: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
162: ------------------------------------------------------------------
163: MO_GLOBAL.init('OKL');
164: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
165:
166:
167: IF P_AR_INFO_YN like 'YES' THEN
168:

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

2348: ------------------------------------------------------------
2349: CURSOR op_unit_csr IS
2350: SELECT NAME
2351: FROM hr_operating_units
2352: WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request
2353:
2354:
2355: l_del_row_count NUMBER;
2356: l_op_unit_name hr_operating_units.name%TYPE;

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

2363: -- Add couple of blank lines
2364: fnd_file.new_line(fnd_file.log,2);
2365: fnd_file.new_line(fnd_file.output,2);
2366:
2367: MO_GLOBAL.set_policy_context('S',p_operating_unit);
2368:
2369: -- Get the request Id
2370: l_request_id := NULL;
2371: OPEN req_id_csr;