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 3834: from pa_resource_assignments pra

3830: ,pa_proj_element_versions pelm
3831: where not exists
3832: (
3833: select pra.resource_assignment_id
3834: from pa_resource_assignments pra
3835: where pra.task_id=rollup.system_reference1
3836: and pra.project_id = pelm.project_id --Bug #16297013
3837: and pra.resource_list_member_id = rollup.system_reference2
3838: and NVL(pra.cbs_element_id,-1) = NVL(rollup.system_reference3,-1) -- Added for CBS 16598322

Line 3984: from pa_resource_assignments ra

3980: update pa_fp_rollup_tmp rollup
3981: set resource_assignment_id =
3982: (
3983: select resource_assignment_id
3984: from pa_resource_assignments ra
3985: where ra.budget_version_id = p_fin_plan_version_id
3986: and ra.task_id = rollup.system_reference1
3987: and ra.resource_list_member_id = rollup.system_reference2
3988: and NVL(ra.cbs_element_id,-1) = NVL(rollup.system_reference3,-1)

Line 4042: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.

4038: END CREATE_ASSGMT_FROM_ROLLUPTMP;
4039:
4040: /*==============================================================================
4041: This is a private api called from Create_CI_Resource_Assignments api for
4042: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.
4043: ===============================================================================*/
4044:
4045: PROCEDURE Insert_Resource_Assignment(
4046: p_project_id IN pa_resource_assignments.project_id%TYPE

Line 4046: p_project_id IN pa_resource_assignments.project_id%TYPE

4042: insertion of a record into PA_RESOURCE_ASSIGNMENTS package.
4043: ===============================================================================*/
4044:
4045: PROCEDURE Insert_Resource_Assignment(
4046: p_project_id IN pa_resource_assignments.project_id%TYPE
4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

4043: ===============================================================================*/
4044:
4045: PROCEDURE Insert_Resource_Assignment(
4046: p_project_id IN pa_resource_assignments.project_id%TYPE
4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4051: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )

Line 4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE

4044:
4045: PROCEDURE Insert_Resource_Assignment(
4046: p_project_id IN pa_resource_assignments.project_id%TYPE
4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4051: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4052: AS

Line 4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

4045: PROCEDURE Insert_Resource_Assignment(
4046: p_project_id IN pa_resource_assignments.project_id%TYPE
4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4051: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4052: AS
4053:

Line 4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

4046: p_project_id IN pa_resource_assignments.project_id%TYPE
4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4051: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4052: AS
4053:
4054: l_row_id rowid;

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

4047: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
4048: ,p_task_id IN pa_resource_assignments.task_id%TYPE
4049: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
4050: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
4051: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE )
4052: AS
4053:
4054: l_row_id rowid;
4055: l_return_status VARCHAR2(30);

Line 4056: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

4052: AS
4053:
4054: l_row_id rowid;
4055: l_return_status VARCHAR2(30);
4056: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4057:
4058: BEGIN
4059:
4060: PA_FP_RESOURCE_ASSIGNMENTS_PKG.Insert_Row

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

4098: ,x_row_id => l_row_id
4099: ,x_return_status => l_return_status);
4100:
4101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4102: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4103: IF P_PA_DEBUG_MODE = 'Y' THEN
4104: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4105: END IF;
4106: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 4130: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE

4126: PROCEDURE Create_CI_Resource_Assignments
4127: ( p_project_id IN pa_budget_versions.project_id%TYPE
4128: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4129: ,p_version_type IN pa_budget_versions.version_type%TYPE
4130: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4132: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4133: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4134: AS

Line 4194: FROM pa_resource_assignments pra

4190: pra.planning_end_date,
4191: pra.schedule_start_date,
4192: pra.schedule_end_date,
4193: pra.resource_list_member_id -- Bug 3615617
4194: FROM pa_resource_assignments pra
4195: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id;
4196:
4197: CURSOR cur_elements_for_task (c_task_id pa_tasks.task_id%TYPE) IS
4198: SELECT pra.resource_assignment_id,

Line 4207: FROM pa_resource_assignments pra

4203: pra.planning_end_date,
4204: pra.schedule_start_date,
4205: pra.schedule_end_date,
4206: pra.resource_list_member_id -- Bug 3615617
4207: FROM pa_resource_assignments pra
4208: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
4209: AND pra.task_id IN (SELECT t.task_id
4210: FROM pa_tasks t
4211: WHERE t.project_id = p_project_id

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

5026: RAISE;
5027: END Add_resources_automatically;
5028:
5029: /* Bug 2920954 - This procedure deletes all the planning elements
5030: (pa_fp_elements/pa_resource_assignments) of this task and all
5031: its child tasks. This is called during the task deletion. These
5032: tasks would have plannable plan_amount_exists_flag as 'N'. Its
5033: assumed that the check apis would have been called to ensure
5034: that deletion of p_task_id is allowed. One main check in the check api

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

5031: its child tasks. This is called during the task deletion. These
5032: tasks would have plannable plan_amount_exists_flag as 'N'. Its
5033: assumed that the check apis would have been called to ensure
5034: that deletion of p_task_id is allowed. One main check in the check api
5035: is that p_task_id should not be present in pa_resource_assignments
5036: of a BASELINED version since we should not be touching RA table
5037: of BASELINED versions. When plan amounts donot exists, pa_proj_periods_denorm
5038: will not contain any data for that task.
5039:

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

5087: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5088: END IF;
5089:
5090: IF l_debug_mode = 'Y' THEN
5091: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_task_id);
5092: pa_debug.write(l_module_name,pa_debug.g_err_stage,
5093: L_DEBUG_LEVEL3);
5094: END IF;
5095:

Line 5096: DELETE FROM pa_resource_assignments r

5092: pa_debug.write(l_module_name,pa_debug.g_err_stage,
5093: L_DEBUG_LEVEL3);
5094: END IF;
5095:
5096: DELETE FROM pa_resource_assignments r
5097: WHERE r.task_id IN (SELECT t.task_id
5098: FROM pa_tasks t
5099: CONNECT BY PRIOR t.task_id = t.parent_task_id
5100: START WITH t.task_id = p_task_id);

Line 5832: DELETE pa_resource_assignments pra

5828:
5829: /* If this option corresponds to a plan version, we should delete the resource assignments also
5830: for p_task_id. */
5831:
5832: DELETE pa_resource_assignments pra
5833: WHERE pra.budget_version_id = proj_fp_options_rec.fin_plan_version_id
5834: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5835: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5836:

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

5834: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5835: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5836:
5837: IF l_debug_mode = 'Y' THEN
5838: pa_debug.g_err_stage:= 'PLAN_VERSION option. ' || to_char(sql%rowcount) || ' records deleted from pa_resource_assignments';
5839: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5840: END IF;
5841:
5842: END IF; /* Option is PLAN_VERSION */

Line 6131: pa_fp_elements and pa_resource_assignments */

6127:
6128: FOR i IN p_tasks_tbl.first .. p_tasks_tbl.last
6129: LOOP
6130: /* If the task is a middle level task delete all the references of that task from
6131: pa_fp_elements and pa_resource_assignments */
6132:
6133: IF l_debug_mode = 'Y' THEN
6134: pa_debug.g_err_stage:= 'task_id ' || p_tasks_tbl(i).task_id;
6135: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 6154: --Delete the task references from pa_resource_assignments

6150: pa_debug.g_err_stage:= 'No of records deleted from pa_fp_elements ' ||SQL%ROWCOUNT;
6151: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6152: END IF;
6153:
6154: --Delete the task references from pa_resource_assignments
6155: FORALL k IN p_refresh_fp_options_tbl.first .. p_refresh_fp_options_tbl.last
6156: DELETE
6157: FROM pa_resource_assignments pra
6158: WHERE pra.task_id = p_tasks_tbl(i).task_id

Line 6157: FROM pa_resource_assignments pra

6153:
6154: --Delete the task references from pa_resource_assignments
6155: FORALL k IN p_refresh_fp_options_tbl.first .. p_refresh_fp_options_tbl.last
6156: DELETE
6157: FROM pa_resource_assignments pra
6158: WHERE pra.task_id = p_tasks_tbl(i).task_id
6159: AND pra.budget_version_id in (SELECT pfo.fin_plan_version_id
6160: FROM pa_proj_fp_options pfo
6161: WHERE pfo.proj_fp_options_id =

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

6162: p_refresh_fp_options_tbl(k))
6163: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
6164:
6165: IF l_debug_mode = 'Y' THEN
6166: pa_debug.g_err_stage:= 'No of records deleted from pa_resource_assignments ' ||SQL%ROWCOUNT;
6167: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6168: END IF;
6169:
6170: END IF; /* IF p_tasks_tbl(i).task_level = M */

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

6936: IF pa_fin_plan_utils.check_task_in_fp_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' THEN
6937: /* Delete planning elements and resource assignments for new parent task id.
6938: Pls note that delete task elements deletes the task and its children from
6939: all plan options. Hence we cannot call it since it might delete a
6940: plannable impacted task also from pa_fp_elements and pa_resource_assignments */
6941:
6942: IF l_debug_mode = 'Y' THEN
6943:
6944: pa_debug.g_err_stage:= 'Deleting task fp elements for new parent task id';

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

6959:
6960: IF l_records_deleted <> 0 THEN
6961:
6962: IF l_debug_mode = 'Y' THEN
6963: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_impacted_tasks_tbl(i).new_parent_task_id);
6964: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6965: L_DEBUG_LEVEL3);
6966: END IF;
6967:

Line 6968: DELETE FROM pa_resource_assignments r

6964: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6965: L_DEBUG_LEVEL3);
6966: END IF;
6967:
6968: DELETE FROM pa_resource_assignments r
6969: WHERE r.task_id = p_impacted_tasks_tbl(i).new_parent_task_id;
6970:
6971: l_records_deleted := sql%rowcount;
6972: