eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_PVT dependencies on PA_FP_SPREAD_CALC_TMP1

Line 3353: * with null quantities, instead population pa_fp_spread_calc_tmp1, so that calculate

3349: --rate type is stamped as User for project revenue conversion attrs.
3350:
3351: /* -----------------------------------------------------------------------------------------
3352: * Bug 4221590: commenting out the following code to avoid creation of budget lines
3353: * with null quantities, instead population pa_fp_spread_calc_tmp1, so that calculate
3354: * api can use that to insert/spread the budget lines passed from AMG/MSP
3355: *----------------------------------------------------------------------------------------
3356: INSERT INTO pa_budget_lines(
3357: RESOURCE_ASSIGNMENT_ID

Line 3513: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */

3509: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3510: END IF;
3511: ---------------------------------------------------------------------------------------------*/
3512:
3513: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */
3514: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
3515:
3516: IF P_PA_DEBUG_MODE = 'Y' THEN
3517: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;

Line 3514: DELETE FROM PA_FP_SPREAD_CALC_TMP1;

3510: END IF;
3511: ---------------------------------------------------------------------------------------------*/
3512:
3513: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */
3514: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
3515:
3516: IF P_PA_DEBUG_MODE = 'Y' THEN
3517: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;
3518: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3517: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;

3513: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */
3514: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
3515:
3516: IF P_PA_DEBUG_MODE = 'Y' THEN
3517: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;
3518: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3519: END IF;
3520:
3521: INSERT INTO PA_FP_SPREAD_CALC_TMP1(

Line 3521: INSERT INTO PA_FP_SPREAD_CALC_TMP1(

3517: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;
3518: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3519: END IF;
3520:
3521: INSERT INTO PA_FP_SPREAD_CALC_TMP1(
3522: RESOURCE_ASSIGNMENT_ID
3523: ,BUDGET_VERSION_ID
3524: ,START_DATE
3525: ,BL_CREATION_DATE

Line 3655: -- corresponding that is not getting processed and stored in pa_fp_spread_calc_tmp1

3651: -- Bug 3861261 Update resource assignments planning start and end date
3652: -- as the min(start_date) and max(end_date) of the corresponding budget lines
3653: -- Start changes for Bug 6432606
3654: -- In the AMG API flow for a scenario when task is having actuals the budget line
3655: -- corresponding that is not getting processed and stored in pa_fp_spread_calc_tmp1
3656: -- coz of that start date of that budget line is not taken in consideration.
3657: -- To avoid this planning_start_date is updated with original value if the original
3658: -- planning_start_date is least.
3659: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN

Line 3661: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines

3657: -- To avoid this planning_start_date is updated with original value if the original
3658: -- planning_start_date is least.
3659: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3660: -- For scenario if actuals exist then planning start date for resource assignment
3661: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3662: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3663:
3664: --bug#8854015 Added condition to directly update the planning_start_date and planning_end_date
3665: -- if the updation is for non-time based.

Line 3662: -- else it should be least of value present in pa_fp_spread_calc_tmp1.

3658: -- planning_start_date is least.
3659: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3660: -- For scenario if actuals exist then planning start date for resource assignment
3661: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3662: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3663:
3664: --bug#8854015 Added condition to directly update the planning_start_date and planning_end_date
3665: -- if the updation is for non-time based.
3666: l_time_phased_type_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_fin_plan_version_id);

Line 3670: UPDATE PA_FP_SPREAD_CALC_TMP1 cache

3666: l_time_phased_type_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_fin_plan_version_id);
3667: IF l_time_phased_type_code = 'N' THEN
3668:
3669: -- Bug 15861188 : added following update statement
3670: UPDATE PA_FP_SPREAD_CALC_TMP1 cache
3671: SET (cache.start_date ,cache.end_date) =
3672: (select planning_start_date,planning_end_date
3673: FROM pa_resource_assignments pra
3674: where pra.resource_assignment_id = cache.resource_assignment_id )

Line 3683: from pa_fp_spread_calc_tmp1 tmp

3679: update pa_resource_assignments pra
3680: set (planning_start_date, planning_end_date)
3681: = (select nvl(tmp.start_date, planning_start_date),
3682: nvl(tmp.end_date, planning_end_date)
3683: from pa_fp_spread_calc_tmp1 tmp
3684: where tmp.resource_assignment_id = pra.resource_assignment_id)
3685: where pra.budget_version_id = p_fin_plan_version_id;
3686:
3687: ELSE

Line 3695: from pa_fp_spread_calc_tmp1 tmp, pa_budget_lines pbl

3691: nvl(min(tmp.start_date), planning_start_date),
3692: least(nvl(min(tmp.start_date), planning_start_date),
3693: nvl(min(pbl.start_date), planning_start_date))),
3694: greatest(nvl(max(tmp.end_date), planning_end_date), planning_end_date) -- bug#10376078
3695: from pa_fp_spread_calc_tmp1 tmp, pa_budget_lines pbl
3696: where tmp.resource_assignment_id = pra.resource_assignment_id
3697: and pbl.resource_assignment_id (+)= tmp.resource_assignment_id)
3698: where pra.budget_version_id = p_fin_plan_version_id;
3699: END IF;

Line 3710: from pa_fp_spread_calc_tmp1 tmp /* Bug 4221590 */

3706: update pa_resource_assignments pra
3707: set (planning_start_date, planning_end_date)
3708: = (select nvl(min(start_date), planning_start_date),
3709: nvl(max(end_date), planning_end_date)
3710: from pa_fp_spread_calc_tmp1 tmp /* Bug 4221590 */
3711: where tmp.resource_assignment_id = pra.resource_assignment_id)
3712: where pra.budget_version_id = p_fin_plan_version_id;
3713: END IF;
3714: --End changes for Bug 6432606

Line 4595: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be

4591: -- bug 3825873 17-JUL-2004 Corrected the input parameters
4592: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4593: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4594: calculate API to skip the call to client extensions for AMG flows.
4595: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4596: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4597: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4598: THEN
4599: PA_FP_CALC_PLAN_PKG.calculate

Line 4596: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/

4592: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4593: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4594: calculate API to skip the call to client extensions for AMG flows.
4595: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4596: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4597: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4598: THEN
4599: PA_FP_CALC_PLAN_PKG.calculate
4600: ( p_project_id => l_project_id

Line 4630: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow

4626: ,p_b_cost_rate_override_tab => l_number_null_tab
4627: ,p_bill_rate_tab => l_number_null_tab
4628: ,p_bill_rate_override_tab => l_number_null_tab
4629: ,p_del_spread_calc_tmp1_flg => 'N' /* Bug: 4309290.Added the parameter to identify if
4630: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
4631: we will pass N and for other calls to calculate api it would
4632: be yes */
4633: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4634: ,x_return_status => x_return_status

Line 4683: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be

4679:
4680: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4681: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4682: calculate API to skip the call to client extensions for AMG flows.
4683: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4684: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4685: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4686: THEN
4687: PA_FP_CALC_PLAN_PKG.calculate

Line 4684: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/

4680: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4681: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4682: calculate API to skip the call to client extensions for AMG flows.
4683: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4684: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4685: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4686: THEN
4687: PA_FP_CALC_PLAN_PKG.calculate
4688: ( p_project_id => l_project_id