DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on FND_REQUEST

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

4179: pa_budget_versions
4180: where
4181: budget_version_id=p_budget_version_id;
4182: **/
4183: -- get org id to initiaize before submit the fnd request
4184: SELECT pp.org_id
4185: ,bv.budget_status_code
4186: INTO l_org_id
4187: ,l_budget_status_code

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

4223: IF P_PA_DEBUG_MODE = 'Y' THEN
4224: pa_debug.write_file('no business logic errors; proceeding with regenerate');
4225: END IF;
4226: /* submit the concurrent request to generate the forecast */
4227: /* will need to FND_REQUEST.set_mode if submit_request is called from database trigger */
4228:
4229: /* SUBMIT THE REQUEST ONLY WHEN version_type = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST */
4230: /* Moac changes:4510784 initialize org id before submitting the request for single org context */
4231: MO_GLOBAL.INIT('PA');

Line 4236: FND_REQUEST.SET_ORG_ID(l_org_id);

4232: If P_PA_DEBUG_MODE = 'Y' THEN
4233: PA_DEBUG.Log_Message(p_message => 'Calling MO_GLOBAL.SET_POLICY_CONTEXT for OrgId:'||l_org_id);
4234: End If;
4235: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
4236: FND_REQUEST.SET_ORG_ID(l_org_id);
4237: l_request_id := FND_REQUEST.submit_request
4238: (application => 'PA',
4239: program => 'PAFPORGF', /* refer to HLD: Generate Organization Forecast */
4240: description => NULL,

Line 4237: l_request_id := FND_REQUEST.submit_request

4233: PA_DEBUG.Log_Message(p_message => 'Calling MO_GLOBAL.SET_POLICY_CONTEXT for OrgId:'||l_org_id);
4234: End If;
4235: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
4236: FND_REQUEST.SET_ORG_ID(l_org_id);
4237: l_request_id := FND_REQUEST.submit_request
4238: (application => 'PA',
4239: program => 'PAFPORGF', /* refer to HLD: Generate Organization Forecast */
4240: description => NULL,
4241: start_time => NULL,