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 3345: * with null quantities, instead population pa_fp_spread_calc_tmp1, so that calculate

3341: --rate type is stamped as User for project revenue conversion attrs.
3342:
3343: /* -----------------------------------------------------------------------------------------
3344: * Bug 4221590: commenting out the following code to avoid creation of budget lines
3345: * with null quantities, instead population pa_fp_spread_calc_tmp1, so that calculate
3346: * api can use that to insert/spread the budget lines passed from AMG/MSP
3347: *----------------------------------------------------------------------------------------
3348: INSERT INTO pa_budget_lines(
3349: RESOURCE_ASSIGNMENT_ID

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

3501: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3502: END IF;
3503: ---------------------------------------------------------------------------------------------*/
3504:
3505: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */
3506: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
3507:
3508: IF P_PA_DEBUG_MODE = 'Y' THEN
3509: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;

Line 3506: DELETE FROM PA_FP_SPREAD_CALC_TMP1;

3502: END IF;
3503: ---------------------------------------------------------------------------------------------*/
3504:
3505: /* Bug 4221590:inserting into PA_FP_SPREAD_CALC_TMP1 */
3506: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
3507:
3508: IF P_PA_DEBUG_MODE = 'Y' THEN
3509: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;
3510: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);

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

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

Line 3513: INSERT INTO PA_FP_SPREAD_CALC_TMP1(

3509: pa_debug.g_err_stage:= 'inserting into pa_fp_spread_calc_tmp1 -> ' || sql%ROWCOUNT;
3510: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3511: END IF;
3512:
3513: INSERT INTO PA_FP_SPREAD_CALC_TMP1(
3514: RESOURCE_ASSIGNMENT_ID
3515: ,BUDGET_VERSION_ID
3516: ,START_DATE
3517: ,BL_CREATION_DATE

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

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

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

3649: -- To avoid this planning_start_date is updated with original value if the original
3650: -- planning_start_date is least.
3651: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3652: -- For scenario if actuals exist then planning start date for resource assignment
3653: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3654: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3655: update pa_resource_assignments pra
3656: set (planning_start_date, planning_end_date)
3657: = (select decode(min(pbl.start_date),NULL,

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

3650: -- planning_start_date is least.
3651: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3652: -- For scenario if actuals exist then planning start date for resource assignment
3653: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3654: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3655: update pa_resource_assignments pra
3656: set (planning_start_date, planning_end_date)
3657: = (select decode(min(pbl.start_date),NULL,
3658: nvl(min(tmp.start_date), planning_start_date),

Line 3662: from pa_fp_spread_calc_tmp1 tmp, pa_budget_lines pbl

3658: nvl(min(tmp.start_date), planning_start_date),
3659: least(nvl(min(tmp.start_date), planning_start_date),
3660: nvl(min(pbl.start_date), planning_start_date))),
3661: nvl(max(tmp.end_date), planning_end_date)
3662: from pa_fp_spread_calc_tmp1 tmp, pa_budget_lines pbl
3663: where tmp.resource_assignment_id = pra.resource_assignment_id
3664: and pbl.resource_assignment_id (+)= tmp.resource_assignment_id)
3665: where pra.budget_version_id = p_fin_plan_version_id;
3666: ELSE

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

3667: update pa_resource_assignments pra
3668: set (planning_start_date, planning_end_date)
3669: = (select nvl(min(start_date), planning_start_date),
3670: nvl(max(end_date), planning_end_date)
3671: from pa_fp_spread_calc_tmp1 tmp /* Bug 4221590 */
3672: where tmp.resource_assignment_id = pra.resource_assignment_id)
3673: where pra.budget_version_id = p_fin_plan_version_id;
3674: END IF;
3675: --End changes for Bug 6432606

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

4552: -- bug 3825873 17-JUL-2004 Corrected the input parameters
4553: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4554: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4555: calculate API to skip the call to client extensions for AMG flows.
4556: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4557: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4558: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4559: THEN
4560: PA_FP_CALC_PLAN_PKG.calculate

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

4553: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4554: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4555: calculate API to skip the call to client extensions for AMG flows.
4556: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4557: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4558: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4559: THEN
4560: PA_FP_CALC_PLAN_PKG.calculate
4561: ( p_project_id => l_project_id

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

4587: ,p_b_cost_rate_override_tab => l_number_null_tab
4588: ,p_bill_rate_tab => l_number_null_tab
4589: ,p_bill_rate_override_tab => l_number_null_tab
4590: ,p_del_spread_calc_tmp1_flg => 'N' /* Bug: 4309290.Added the parameter to identify if
4591: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
4592: we will pass N and for other calls to calculate api it would
4593: be yes */
4594: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4595: ,x_return_status => x_return_status

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

4640:
4641: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4642: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4643: calculate API to skip the call to client extensions for AMG flows.
4644: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4645: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4646: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4647: THEN
4648: PA_FP_CALC_PLAN_PKG.calculate

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

4641: /*Bug 4224464 Added the if condition to ditinguish the call to calculate API in AMG flow from other flows.
4642: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4643: calculate API to skip the call to client extensions for AMG flows.
4644: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4645: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4646: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4647: THEN
4648: PA_FP_CALC_PLAN_PKG.calculate
4649: ( p_project_id => l_project_id