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_FP_EDIT_LINE_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 15: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

11: calling DERIVE_PD_SD_START_END_DATES if they are not available in budget lines.
12: */
13:
14: PROCEDURE POPULATE_LOCAL_VARIABLES(
15: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
16: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
17: ,p_calling_context IN VARCHAR2
18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

Line 93: FROM pa_resource_assignments pra,

89: INTO x_fin_plan_version_id
90: ,x_period_profile_id
91: ,x_project_id
92: ,l_task_id
93: FROM pa_resource_assignments pra,
94: pa_budget_versions pbv
95: WHERE pra.resource_assignment_id = p_resource_assignment_id
96: AND pra.budget_version_id = pbv.budget_version_id;
97:

Line 274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

270: (p_calling_context IN VARCHAR2
271: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895

Line 372: FROM PA_RESOURCE_ASSIGNMENTS

368:
369: BEGIN
370: SELECT project_id, budget_version_id
371: INTO l_project_id, l_budget_version_id
372: FROM PA_RESOURCE_ASSIGNMENTS
373: WHERE RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id;
374:
375: EXCEPTION
376: WHEN OTHERS THEN

Line 657: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

653:
654: END DERIVE_PD_SD_START_END_DATES;
655:
656: PROCEDURE POPULATE_ROLLUP_TMP(
657: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
658: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
659: ,p_calling_context IN VARCHAR2
660: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
661: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 835: FROM pa_resource_assignments pra

831: ,mc_rec.PROJFUNC_REV_RATE_TYPE
832: ,mc_rec.PROJFUNC_REV_EXCHANGE_RATE
833: ,mc_rec.PROJFUNC_REV_RATE_DATE_TYPE
834: ,mc_rec.PROJFUNC_REV_RATE_DATE
835: FROM pa_resource_assignments pra
836: where resource_assignment_id = p_resource_assignment_id;
837:
838: END insert_dummy_record_pvt;
839:

Line 1355: FROM pa_resource_assignments pra

1351: ,pbl.BURDENED_COST_SOURCE
1352: ,pbl.QUANTITY_SOURCE
1353: ,pbl.REVENUE_SOURCE
1354: ,pbl.PM_PRODUCT_CODE
1355: FROM pa_resource_assignments pra
1356: ,pa_budget_lines pbl
1357: ,pa_fp_cpy_periods_tmp tmp
1358: WHERE pra.resource_assignment_id = p_resource_assignment_id
1359: AND pbl.resource_assignment_id(+) = p_resource_assignment_id

Line 1555: FROM pa_resource_assignments pra

1551: ,pbl.BURDENED_COST_SOURCE
1552: ,pbl.QUANTITY_SOURCE
1553: ,pbl.REVENUE_SOURCE
1554: ,pbl.PM_PRODUCT_CODE
1555: FROM pa_resource_assignments pra
1556: ,pa_budget_lines pbl
1557: ,pa_proj_fp_options pfo
1558: -- ,pa_fp_txn_currencies pftc -- Bug # 2615998
1559: WHERE pra.resource_assignment_id = p_resource_assignment_id

Line 1658: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

1654: PROCEDURE PROCESS_MODIFIED_LINES
1655: (
1656: -- Bug Fix: 4569365. Removed MRC code.
1657: p_calling_context IN VARCHAR2 -- pa_mrc_finplan.g_calling_module%TYPE /* Bug# 2674353 */
1658: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
1659: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE -- DEFAULT NULL
1660: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1661: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1662: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 1659: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE -- DEFAULT NULL

1655: (
1656: -- Bug Fix: 4569365. Removed MRC code.
1657: p_calling_context IN VARCHAR2 -- pa_mrc_finplan.g_calling_module%TYPE /* Bug# 2674353 */
1658: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
1659: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE -- DEFAULT NULL
1660: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1661: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1662: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
1663:

Line 1691: from pa_resource_list_members prlm, pa_resource_assignments pra, pa_fp_rollup_tmp tmp

1687:
1688: Cursor c_disabled_resource_exists IS
1689: select 1 from dual
1690: where exists (select prlm.resource_list_member_id
1691: from pa_resource_list_members prlm, pa_resource_assignments pra, pa_fp_rollup_tmp tmp
1692: where pra.resource_assignment_id = p_resource_assignment_id
1693: and pra.resource_list_member_id= prlm.resource_list_member_id
1694: and nvl(prlm.enabled_flag,'Y') = 'N'
1695: and tmp.resource_assignment_id = pra.resource_assignment_id

Line 1798: FROM pa_resource_assignments

1794: --Included this block for bug 3050933.
1795: BEGIN
1796: SELECT budget_version_id, task_id, resource_list_member_id
1797: INTO l_budget_version_id, l_task_id, l_resource_list_member_id
1798: FROM pa_resource_assignments
1799: WHERE resource_assignment_id = p_resource_assignment_id;
1800: EXCEPTION
1801: WHEN NO_DATA_FOUND THEN
1802: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Input res assmt id not found in pa_resource_assignments';

Line 1802: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Input res assmt id not found in pa_resource_assignments';

1798: FROM pa_resource_assignments
1799: WHERE resource_assignment_id = p_resource_assignment_id;
1800: EXCEPTION
1801: WHEN NO_DATA_FOUND THEN
1802: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Input res assmt id not found in pa_resource_assignments';
1803: IF P_PA_DEBUG_MODE = 'Y' THEN
1804: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,5);
1805: END IF;
1806: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2389: ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

2385:
2386: END PROCESS_MODIFIED_LINES;
2387:
2388: PROCEDURE GET_ELEMENT_AMOUNT_INFO
2389: ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
2390: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2391: ,p_calling_context IN VARCHAR2
2392: ,x_quantity_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_qty_flag%TYPE --File.Sql.39 bug 4440895
2393: ,x_raw_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.raw_cost_flag%TYPE --File.Sql.39 bug 4440895

Line 3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

3217: for each txn currency and hence cannot be used.
3218: */
3219:
3220: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

3398: END GET_PD_SD_AMT_IN_PC_PFC;
3399:
3400: PROCEDURE GET_PRECEDING_SUCCEEDING_AMT(
3401: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3454: ,pa_resource_assignments pra

3450:
3451: SELECT fin_plan_preference_code
3452: INTO l_fin_plan_preference_code
3453: FROM pa_proj_fp_options pfo
3454: ,pa_resource_assignments pra
3455: WHERE pra.resource_assignment_id = p_resource_assignment_id
3456: AND pra.budget_version_id = pfo.fin_plan_version_id;
3457:
3458: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3897: (c_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE)

3893: HAVING COUNT(*)>1;
3894:
3895: -- Cursor to get the resource assignment details
3896: CURSOR l_res_assignment_details_csr
3897: (c_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE)
3898: IS
3899: SELECT pra.project_id
3900: ,pra.task_id
3901: ,pra.resource_list_member_id

Line 3904: FROM pa_resource_assignments pra

3900: ,pra.task_id
3901: ,pra.resource_list_member_id
3902: ,pbv.budget_type_code
3903: ,pbv.fin_plan_type_id
3904: FROM pa_resource_assignments pra
3905: ,pa_budget_versions pbv
3906: WHERE pra.resource_assignment_id = c_resource_assignment_id
3907: AND pra.budget_version_id = pbv.budget_version_id ;
3908:

Line 4044: in pa_resource_assignments and pa_proj_periods_denorm.

4040:
4041: /*=================================================================================================
4042: This api will do the final processing of budget lines data for a budget version. The processing
4043: includes computing the MC amounts, creating MRC lines if required and rolling budget lines data
4044: in pa_resource_assignments and pa_proj_periods_denorm.
4045: This API does not do maintenance of plan amount exist flag on pa_fp_elements because as of now
4046: this process does not create budget lines. The maintenance of the flag should be done from the
4047: place where budget lines are created always.
4048: =================================================================================================*/