DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on FND_REQUEST

Line 4167: -- get org id to initiaize before submit the fnd request

4163: pa_budget_versions
4164: where
4165: budget_version_id=p_budget_version_id;
4166: **/
4167: -- get org id to initiaize before submit the fnd request
4168: SELECT pp.org_id
4169: ,bv.budget_status_code
4170: INTO l_org_id
4171: ,l_budget_status_code

Line 4211: /* will need to FND_REQUEST.set_mode if submit_request is called from database trigger */

4207: IF P_PA_DEBUG_MODE = 'Y' THEN
4208: pa_debug.write_file('no business logic errors; proceeding with regenerate');
4209: END IF;
4210: /* submit the concurrent request to generate the forecast */
4211: /* will need to FND_REQUEST.set_mode if submit_request is called from database trigger */
4212:
4213: /* SUBMIT THE REQUEST ONLY WHEN version_type = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST */
4214: /* Moac changes:4510784 initialize org id before submitting the request for single org context */
4215: MO_GLOBAL.INIT('PA');

Line 4220: FND_REQUEST.SET_ORG_ID(l_org_id);

4216: If P_PA_DEBUG_MODE = 'Y' THEN
4217: PA_DEBUG.Log_Message(p_message => 'Calling MO_GLOBAL.SET_POLICY_CONTEXT for OrgId:'||l_org_id);
4218: End If;
4219: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
4220: FND_REQUEST.SET_ORG_ID(l_org_id);
4221: l_request_id := FND_REQUEST.submit_request
4222: (application => 'PA',
4223: program => 'PAFPORGF', /* refer to HLD: Generate Organization Forecast */
4224: description => NULL,

Line 4221: l_request_id := FND_REQUEST.submit_request

4217: PA_DEBUG.Log_Message(p_message => 'Calling MO_GLOBAL.SET_POLICY_CONTEXT for OrgId:'||l_org_id);
4218: End If;
4219: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
4220: FND_REQUEST.SET_ORG_ID(l_org_id);
4221: l_request_id := FND_REQUEST.submit_request
4222: (application => 'PA',
4223: program => 'PAFPORGF', /* refer to HLD: Generate Organization Forecast */
4224: description => NULL,
4225: start_time => NULL,