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

Line 1588: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;

1584:
1585: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
1586: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
1587: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
1588: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
1589: l_err_code NUMBER;
1590: l_err_stage VARCHAR2(100);
1591: l_err_stack VARCHAR2(1000);
1592:

Line 1955: This procedure inserts records into PA_RESOURCE_ASSIGNMENTS in BULK

1951:
1952: END Insert_Bulk_Rows;
1953:
1954: /*==================================================================================================
1955: This procedure inserts records into PA_RESOURCE_ASSIGNMENTS in BULK
1956: ==================================================================================================*/
1957:
1958: PROCEDURE Insert_Bulk_Rows_Res (
1959: p_project_id IN NUMBER

Line 2003: pa_debug.g_err_stage := TO_CHAR(l_stage)||': Bulk inserting into PA_RESOURCE_ASSIGNMENTS';

1999: IF P_PA_DEBUG_MODE = 'Y' THEN
2000: pa_debug.write('Insert_Bulk_Rows: ' || l_module_name,pa_debug.g_err_stage,2);
2001: END IF;
2002:
2003: pa_debug.g_err_stage := TO_CHAR(l_stage)||': Bulk inserting into PA_RESOURCE_ASSIGNMENTS';
2004: IF P_PA_DEBUG_MODE = 'Y' THEN
2005: pa_debug.write('Insert_Bulk_Rows: ' || l_module_name,pa_debug.g_err_stage,2);
2006: END IF;
2007:

Line 2010: INSERT INTO pa_resource_assignments

2006: END IF;
2007:
2008: FORALL i in p_task_id_tbl.first..p_task_id_tbl.last
2009:
2010: INSERT INTO pa_resource_assignments
2011: (RESOURCE_ASSIGNMENT_ID
2012: ,BUDGET_VERSION_ID
2013: ,PROJECT_ID
2014: ,TASK_ID

Line 2026: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

2022: ,TRACK_AS_LABOR_FLAG
2023: ,PROJECT_ASSIGNMENT_ID
2024: ,RESOURCE_ASSIGNMENT_TYPE )
2025: VALUES
2026: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
2027: ,p_plan_version_id -- BUDGET_VERSION_ID
2028: ,p_project_id -- PROJECT_ID
2029: ,p_task_id_tbl(i) -- TASK_ID
2030: ,p_res_list_mem_id_tbl(i) -- RESOURCE_LIST_MEMBER_ID

Line 2064: if they aren't already present in PA_RESOURCE_ASSIGNMENTS. Uncategorised

2060:
2061:
2062: /*============================================================================
2063: This api makes use of PA_FP_ELEMENTS and enters only user_entered records
2064: if they aren't already present in PA_RESOURCE_ASSIGNMENTS. Uncategorised
2065: resource_list has been dealt separately, as in this case, we can avoid a
2066: table join with pa_resource_list_members.It also deals the case when
2067: planning level is project and resource_list is uncategorised, in which
2068: case the given version doesn't have a record in PA_FP_ELEMENTS.

Line 2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;

2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
2103:
2104: TYPE l_ra_id_tbl_typ IS TABLE OF

Line 2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;

2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
2103:
2104: TYPE l_ra_id_tbl_typ IS TABLE OF
2105: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
2106:

Line 2105: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
2103:
2104: TYPE l_ra_id_tbl_typ IS TABLE OF
2105: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
2106:
2107: l_task_id_tbl l_task_id_tbl_typ;
2108: l_rlmid_tbl l_res_list_mem_id_tbl_typ;
2109: l_track_as_labor_flag_tbl l_track_as_labor_flag_tbl_typ;

Line 2120: FROM pa_resource_assignments ra

2116: ,l_track_as_labor_flag
2117: ,l_unit_of_measure /* Modified for bug #2586307. */
2118: FROM DUAL
2119: WHERE NOT EXISTS ( SELECT 'x'
2120: FROM pa_resource_assignments ra
2121: WHERE ra.budget_version_id = p_plan_version_id
2122: AND ra.task_id = 0
2123: AND ra.resource_list_member_id =
2124: l_uncat_rlmid);

Line 2137: FROM pa_resource_assignments ra

2133: AND fin_plan_version_id = p_plan_version_id
2134: AND plannable_flag = 'Y'
2135: AND fp.task_id = Nvl(p_task_id,fp.task_id) /* Bug 2920954 */
2136: AND NOT EXISTS ( SELECT 'x'
2137: FROM pa_resource_assignments ra
2138: WHERE ra.budget_version_id = fp.fin_plan_version_id
2139: AND ra.project_id = fp.project_id
2140: AND ra.task_id = fp.task_id
2141: AND ra.resource_list_member_id = l_uncat_rlmid);

Line 2159: FROM pa_resource_assignments ra

2155: AND fp.resource_list_member_id = prlm.resource_list_member_id
2156: AND pr.resource_id = prlm.resource_id
2157: AND fp.task_id = Nvl(p_task_id,fp.task_id) /* Bug 2920954 */
2158: AND NOT EXISTS ( SELECT 'x'
2159: FROM pa_resource_assignments ra
2160: WHERE ra.budget_version_id = fp.fin_plan_version_id
2161: AND ra.project_id = fp.project_id
2162: AND ra.task_id = fp.task_id
2163: AND ra.resource_list_member_id =

Line 2169: FROM pa_resource_assignments pra

2165:
2166: /* Added for the bug #2615837 */
2167: CURSOR l_cur_for_res_del IS
2168: SELECT pra.resource_assignment_id
2169: FROM pa_resource_assignments pra
2170: WHERE pra.budget_version_id = p_plan_version_id
2171: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2172: AND NOT EXISTS (SELECT 1
2173: FROM pa_fp_elements fpe

Line 2302: to be deleted from pa_resource_assignments also else they will be once again

2298: p_fin_plan_version_id => p_plan_version_id);
2299:
2300: /* #2615837: If the resources have been unchecked in the pages, then the elements are
2301: deleted from pa_fp_elements but not from resource_assignments. These records have
2302: to be deleted from pa_resource_assignments also else they will be once again
2303: available in the Edit Plan page. */
2304:
2305: /* Should NOT be done when planning level is project and resource list is uncategorized
2306: as there needs to be one record existing in pa_resource_assignments for this case. */

Line 2306: as there needs to be one record existing in pa_resource_assignments for this case. */

2302: to be deleted from pa_resource_assignments also else they will be once again
2303: available in the Edit Plan page. */
2304:
2305: /* Should NOT be done when planning level is project and resource list is uncategorized
2306: as there needs to be one record existing in pa_resource_assignments for this case. */
2307:
2308: /* Bug #2634979: Modified the logic of deleting records from pa_resource_assignments.
2309: If the Planning level is 'Project' and the resource list is uncategorized, then
2310: the records for the Plan Version ID have to be deleted except the project level

Line 2308: /* Bug #2634979: Modified the logic of deleting records from pa_resource_assignments.

2304:
2305: /* Should NOT be done when planning level is project and resource list is uncategorized
2306: as there needs to be one record existing in pa_resource_assignments for this case. */
2307:
2308: /* Bug #2634979: Modified the logic of deleting records from pa_resource_assignments.
2309: If the Planning level is 'Project' and the resource list is uncategorized, then
2310: the records for the Plan Version ID have to be deleted except the project level
2311: records and the records with uncategorized resource list member id.
2312:

Line 2331: DELETE FROM pa_resource_assignments

2327: IF P_PA_DEBUG_MODE = 'Y' THEN
2328: pa_debug.write('create_enterable_resources: ' || l_module_name,pa_debug.g_err_stage,3);
2329: END IF;
2330:
2331: DELETE FROM pa_resource_assignments
2332: WHERE budget_version_id = p_plan_version_id
2333: AND (task_id <> 0 or resource_list_member_id <> l_uncat_rlmid);
2334:
2335: ELSE

Line 2337: /* In all other cases, records have to be deleted from pa_resource_assignments

2333: AND (task_id <> 0 or resource_list_member_id <> l_uncat_rlmid);
2334:
2335: ELSE
2336:
2337: /* In all other cases, records have to be deleted from pa_resource_assignments
2338: which do not exist in pa_fp_elements. */
2339:
2340: pa_debug.g_err_stage:= 'fetching resource assignments that should be deleted';
2341: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2363: DELETE FROM pa_resource_assignments

2359: IF (nvl(l_ra_id_tbl.last,0) > 0) THEN
2360:
2361: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
2362:
2363: DELETE FROM pa_resource_assignments
2364: WHERE resource_assignment_id = l_ra_id_tbl(i);
2365:
2366: pa_debug.g_err_stage := 'Deleted ' || sql%rowcount || ' records';
2367: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2735: pa_resource_assignments.

2731: The follwing procedure creates elements from the budget versions id
2732: passed for the fp options id passed. The starategy is
2733: 1)First,create resource level elements
2734: 2)Then, create task level elements which are plannable and present in
2735: pa_resource_assignments.
2736: 3)Lastly,create top task level elements for the above included tasks
2737: if they aren't already created.
2738:
2739: Bug:- 2634900, the cursors have been modified so that the api can be

Line 2823: FROM pa_resource_assignments pra

2819: ,'Y' plannable_flag
2820: ,NULL resources_planned_for_task
2821: ,'Y' plan_amount_exists_flag
2822: ,DECODE(prlm.parent_member_id, NULL, 'G','R') resource_level -- Bug :- 2625872
2823: FROM pa_resource_assignments pra
2824: ,pa_resource_list_members prlm
2825: WHERE budget_version_id = c_from_version_id
2826: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2827: PA_FP_CONSTANTS_PKG.G_USER_ENTERED

Line 2849: FROM pa_resource_assignments pra

2845: ,'Y' plannable_flag
2846: ,NULL resources_planned_for_task
2847: ,'Y' plan_amount_exists_flag
2848: ,DECODE(prlm.parent_member_id, NULL, 'G','R') resource_level -- Bug :- 2625872
2849: FROM pa_resource_assignments pra
2850: ,pa_tasks pt
2851: ,pa_resource_list_members prlm
2852: WHERE budget_version_id = c_from_version_id
2853: AND pt.task_id = pra.task_id

Line 2917: FROM pa_resource_assignments pra

2913: ,l_grouped_flag ) resource_planning_level
2914: ,'Y' plannable_flag
2915: ,DECODE(l_uncategorized_flag,'Y',NULL,'Y') resources_planned_for_task
2916: ,'Y' plan_amount_exists_flag
2917: FROM pa_resource_assignments pra
2918: ,pa_tasks pt
2919: ,pa_resource_list_members prlm
2920: WHERE budget_version_id = c_from_version_id
2921: AND pt.task_id = pra.task_id

Line 3831: from pa_resource_assignments pra

3827: ,pa_proj_element_versions pelm
3828: where not exists
3829: (
3830: select pra.resource_assignment_id
3831: from pa_resource_assignments pra
3832: where pra.task_id=rollup.system_reference1
3833: and pra.resource_list_member_id = rollup.system_reference2
3834: and pra.budget_version_id = c_version_id
3835: )

Line 3977: from pa_resource_assignments ra

3973: update pa_fp_rollup_tmp rollup
3974: set resource_assignment_id =
3975: (
3976: select resource_assignment_id
3977: from pa_resource_assignments ra
3978: where ra.budget_version_id = p_fin_plan_version_id
3979: and ra.task_id = rollup.system_reference1
3980: and ra.resource_list_member_id = system_reference2
3981: );

Line 4033: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.

4029: END CREATE_ASSGMT_FROM_ROLLUPTMP;
4030:
4031: /*==============================================================================
4032: This is a private api called from Create_CI_Resource_Assignments api for
4033: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.
4034: ===============================================================================*/
4035:
4036: PROCEDURE Insert_Resource_Assignment(
4037: p_project_id IN pa_resource_assignments.project_id%TYPE

Line 4037: p_project_id IN pa_resource_assignments.project_id%TYPE

4033: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.
4034: ===============================================================================*/
4035:
4036: PROCEDURE Insert_Resource_Assignment(
4037: p_project_id IN pa_resource_assignments.project_id%TYPE
4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

4034: ===============================================================================*/
4035:
4036: PROCEDURE Insert_Resource_Assignment(
4037: p_project_id IN pa_resource_assignments.project_id%TYPE
4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )

Line 4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE

4035:
4036: PROCEDURE Insert_Resource_Assignment(
4037: p_project_id IN pa_resource_assignments.project_id%TYPE
4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4043: AS

Line 4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

4036: PROCEDURE Insert_Resource_Assignment(
4037: p_project_id IN pa_resource_assignments.project_id%TYPE
4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4043: AS
4044:

Line 4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

4037: p_project_id IN pa_resource_assignments.project_id%TYPE
4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4043: AS
4044:
4045: l_row_id rowid;

Line 4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )

4038: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4039: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4040: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4041: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4042: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4043: AS
4044:
4045: l_row_id rowid;
4046: l_return_status VARCHAR2(30);

Line 4047: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

4043: AS
4044:
4045: l_row_id rowid;
4046: l_return_status VARCHAR2(30);
4047: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4048:
4049: BEGIN
4050:
4051: PA_FP_RESOURCE_ASSIGNMENTS_PKG.Insert_Row

Line 4093: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';

4089: ,x_row_id => l_row_id
4090: ,x_return_status => l_return_status);
4091:
4092: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4093: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4094: IF P_PA_DEBUG_MODE = 'Y' THEN
4095: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4096: END IF;
4097: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 4121: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE

4117: PROCEDURE Create_CI_Resource_Assignments
4118: ( p_project_id IN pa_budget_versions.project_id%TYPE
4119: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4120: ,p_version_type IN pa_budget_versions.version_type%TYPE
4121: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4122: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4123: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4124: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4125: AS

Line 4185: FROM pa_resource_assignments pra

4181: pra.planning_end_date,
4182: pra.schedule_start_date,
4183: pra.schedule_end_date,
4184: pra.resource_list_member_id -- Bug 3615617
4185: FROM pa_resource_assignments pra
4186: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id;
4187:
4188: CURSOR cur_elements_for_task (c_task_id pa_tasks.task_id%TYPE) IS
4189: SELECT pra.resource_assignment_id,

Line 4198: FROM pa_resource_assignments pra

4194: pra.planning_end_date,
4195: pra.schedule_start_date,
4196: pra.schedule_end_date,
4197: pra.resource_list_member_id -- Bug 3615617
4198: FROM pa_resource_assignments pra
4199: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
4200: AND pra.task_id IN (SELECT t.task_id
4201: FROM pa_tasks t
4202: WHERE t.project_id = p_project_id

Line 5021: (pa_fp_elements/pa_resource_assignments) of this task and all

5017: RAISE;
5018: END Add_resources_automatically;
5019:
5020: /* Bug 2920954 - This procedure deletes all the planning elements
5021: (pa_fp_elements/pa_resource_assignments) of this task and all
5022: its child tasks. This is called during the task deletion. These
5023: tasks would have plannable plan_amount_exists_flag as 'N'. Its
5024: assumed that the check apis would have been called to ensure
5025: that deletion of p_task_id is allowed. One main check in the check api

Line 5026: is that p_task_id should not be present in pa_resource_assignments

5022: its child tasks. This is called during the task deletion. These
5023: tasks would have plannable plan_amount_exists_flag as 'N'. Its
5024: assumed that the check apis would have been called to ensure
5025: that deletion of p_task_id is allowed. One main check in the check api
5026: is that p_task_id should not be present in pa_resource_assignments
5027: of a BASELINED version since we should not be touching RA table
5028: of BASELINED versions. When plan amounts donot exists, pa_proj_periods_denorm
5029: will not contain any data for that task.
5030:

Line 5082: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_task_id);

5078: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5079: END IF;
5080:
5081: IF l_debug_mode = 'Y' THEN
5082: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_task_id);
5083: pa_debug.write(l_module_name,pa_debug.g_err_stage,
5084: L_DEBUG_LEVEL3);
5085: END IF;
5086:

Line 5087: DELETE FROM pa_resource_assignments r

5083: pa_debug.write(l_module_name,pa_debug.g_err_stage,
5084: L_DEBUG_LEVEL3);
5085: END IF;
5086:
5087: DELETE FROM pa_resource_assignments r
5088: WHERE r.task_id IN (SELECT t.task_id
5089: FROM pa_tasks t
5090: CONNECT BY PRIOR t.task_id = t.parent_task_id
5091: START WITH t.task_id = p_task_id);

Line 5823: DELETE pa_resource_assignments pra

5819:
5820: /* If this option corresponds to a plan version, we should delete the resource assignments also
5821: for p_task_id. */
5822:
5823: DELETE pa_resource_assignments pra
5824: WHERE pra.budget_version_id = proj_fp_options_rec.fin_plan_version_id
5825: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5826: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5827:

Line 5829: pa_debug.g_err_stage:= 'PLAN_VERSION option. ' || to_char(sql%rowcount) || ' records deleted from pa_resource_assignments';

5825: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5826: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5827:
5828: IF l_debug_mode = 'Y' THEN
5829: pa_debug.g_err_stage:= 'PLAN_VERSION option. ' || to_char(sql%rowcount) || ' records deleted from pa_resource_assignments';
5830: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5831: END IF;
5832:
5833: END IF; /* Option is PLAN_VERSION */

Line 6122: pa_fp_elements and pa_resource_assignments */

6118:
6119: FOR i IN p_tasks_tbl.first .. p_tasks_tbl.last
6120: LOOP
6121: /* If the task is a middle level task delete all the references of that task from
6122: pa_fp_elements and pa_resource_assignments */
6123:
6124: IF l_debug_mode = 'Y' THEN
6125: pa_debug.g_err_stage:= 'task_id ' || p_tasks_tbl(i).task_id;
6126: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 6145: --Delete the task references from pa_resource_assignments

6141: pa_debug.g_err_stage:= 'No of records deleted from pa_fp_elements ' ||SQL%ROWCOUNT;
6142: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6143: END IF;
6144:
6145: --Delete the task references from pa_resource_assignments
6146: FORALL k IN p_refresh_fp_options_tbl.first .. p_refresh_fp_options_tbl.last
6147: DELETE
6148: FROM pa_resource_assignments pra
6149: WHERE pra.task_id = p_tasks_tbl(i).task_id

Line 6148: FROM pa_resource_assignments pra

6144:
6145: --Delete the task references from pa_resource_assignments
6146: FORALL k IN p_refresh_fp_options_tbl.first .. p_refresh_fp_options_tbl.last
6147: DELETE
6148: FROM pa_resource_assignments pra
6149: WHERE pra.task_id = p_tasks_tbl(i).task_id
6150: AND pra.budget_version_id in (SELECT pfo.fin_plan_version_id
6151: FROM pa_proj_fp_options pfo
6152: WHERE pfo.proj_fp_options_id =

Line 6157: pa_debug.g_err_stage:= 'No of records deleted from pa_resource_assignments ' ||SQL%ROWCOUNT;

6153: p_refresh_fp_options_tbl(k))
6154: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
6155:
6156: IF l_debug_mode = 'Y' THEN
6157: pa_debug.g_err_stage:= 'No of records deleted from pa_resource_assignments ' ||SQL%ROWCOUNT;
6158: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6159: END IF;
6160:
6161: END IF; /* IF p_tasks_tbl(i).task_level = M */

Line 6931: plannable impacted task also from pa_fp_elements and pa_resource_assignments */

6927: IF pa_fin_plan_utils.check_task_in_fp_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' THEN
6928: /* Delete planning elements and resource assignments for new parent task id.
6929: Pls note that delete task elements deletes the task and its children from
6930: all plan options. Hence we cannot call it since it might delete a
6931: plannable impacted task also from pa_fp_elements and pa_resource_assignments */
6932:
6933: IF l_debug_mode = 'Y' THEN
6934:
6935: pa_debug.g_err_stage:= 'Deleting task fp elements for new parent task id';

Line 6954: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_impacted_tasks_tbl(i).new_parent_task_id);

6950:
6951: IF l_records_deleted <> 0 THEN
6952:
6953: IF l_debug_mode = 'Y' THEN
6954: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_impacted_tasks_tbl(i).new_parent_task_id);
6955: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6956: L_DEBUG_LEVEL3);
6957: END IF;
6958:

Line 6959: DELETE FROM pa_resource_assignments r

6955: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6956: L_DEBUG_LEVEL3);
6957: END IF;
6958:
6959: DELETE FROM pa_resource_assignments r
6960: WHERE r.task_id = p_impacted_tasks_tbl(i).new_parent_task_id;
6961:
6962: l_records_deleted := sql%rowcount;
6963: