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

Line 6: g_first_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;

2: /* $Header: PAFPRLPB.pls 120.3 2005/09/26 12:20:20 rnamburi noship $ */
3:
4: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_rollup_pkg';
5: g_plsql_max_array_size NUMBER := 200;
6: g_first_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;
7:
8: -- Bug Fix: 4569365. Removed MRC code.
9: -- g_mrc_exception EXCEPTION; /* FPB2: MRC */
10:

Line 37: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;

33:
34: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
35: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
36: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
37: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
38: l_err_code NUMBER;
39: l_err_stage VARCHAR2(100);
40: l_err_stack VARCHAR2(1000);
41:

Line 264: FROM pa_resource_assignments pra, pa_resource_list_members prlm

260: SELECT resource_assignment_id
261: ,parent_assignment_id
262: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
263: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
264: FROM pa_resource_assignments pra, pa_resource_list_members prlm
265: WHERE pra.budget_version_id = p_budget_version_id
266: AND pra.resource_list_member_id = prlm.resource_list_member_id
267: AND prlm.parent_member_id IS NOT NULL
268: AND pra.parent_assignment_id > g_first_ra_id;

Line 287: FROM pa_resource_assignments pra, pa_resource_list_members prlm

283: SELECT resource_assignment_id
284: ,parent_assignment_id
285: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
286: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
287: FROM pa_resource_assignments pra, pa_resource_list_members prlm
288: WHERE pra.budget_version_id = p_budget_version_id
289: AND pra.resource_list_member_id = prlm.resource_list_member_id
290: AND prlm.parent_member_id IS NULL
291: AND pra.parent_assignment_id > g_first_ra_id;

Line 309: FROM pa_resource_assignments pra, pa_tasks pt

305: SELECT pra.resource_assignment_id
306: ,pra.parent_assignment_id
307: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
308: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
309: FROM pa_resource_assignments pra, pa_tasks pt
310: WHERE pra.budget_version_id = p_budget_version_id
311: AND pra.task_id = pt.task_id
312: AND pra.resource_list_member_id in (0,l_uncat_rlm_id) -- Added for bug #2723515
313: and pt.wbs_level = p_curr_rollup_level

Line 340: pa_resource_assignments, PA_PROJ_PERIODS_DENORM and pa_budget_versions_tables.

336: END Insert_Parent_Rec_Tmp;
337:
338: /*====================================================================================================
339: ROLLUP_BUDGET_VERSION: This is the main API which will do whatever necessary for doing rollup into
340: pa_resource_assignments, PA_PROJ_PERIODS_DENORM and pa_budget_versions_tables.
341:
342:
343: r11.5 FP.M Developement ----------------------------------
344:

Line 352: a) pa_budget_lines to pa_resource_assignments

348: a lot of it.
349:
350:
351: - Replaced pre-M rollup logic with two-level rollup:
352: a) pa_budget_lines to pa_resource_assignments
353: b) pa_resource_assignments to pa_budget_versions
354:
355: - For p_entire_version = 'N', gutted all logic for
356: this condition. All logic was obsolete.

Line 353: b) pa_resource_assignments to pa_budget_versions

349:
350:
351: - Replaced pre-M rollup logic with two-level rollup:
352: a) pa_budget_lines to pa_resource_assignments
353: b) pa_resource_assignments to pa_budget_versions
354:
355: - For p_entire_version = 'N', gutted all logic for
356: this condition. All logic was obsolete.
357:

Line 381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;

377: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
378: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
379: l_project_id pa_projects.project_id%TYPE;
380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;

Line 382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;

378: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
379: l_project_id pa_projects.project_id%TYPE;
380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

Line 383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;

379: l_project_id pa_projects.project_id%TYPE;
380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

Line 384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */

380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
388: l_rec_insert NUMBER;

Line 385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;

381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
388: l_rec_insert NUMBER;
389: l_data_source VARCHAR2(20);

Line 386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
388: l_rec_insert NUMBER;
389: l_data_source VARCHAR2(20);
390: l_proj_raw_cost_tbl l_proj_raw_cost_tbl_typ;

Line 387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */
385: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
386: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
387: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
388: l_rec_insert NUMBER;
389: l_data_source VARCHAR2(20);
390: l_proj_raw_cost_tbl l_proj_raw_cost_tbl_typ;
391: l_proj_burd_cost_tbl l_proj_burd_cost_tbl_typ;

Line 417: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

413: -- End, Bug 3362316, 08-JAN-2004: ---------------------
414:
415: -- Bug 3441943, 18-FEB-2004: New Vars to sum people (labor) and equipment quantities ------------
416:
417: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
418: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
419:
420: -- End, Bug 3441943, 18-FEB-2004: New Vars to sum people and equipment quantities -------
421:

Line 418: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

414:
415: -- Bug 3441943, 18-FEB-2004: New Vars to sum people (labor) and equipment quantities ------------
416:
417: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
418: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
419:
420: -- End, Bug 3441943, 18-FEB-2004: New Vars to sum people and equipment quantities -------
421:
422:

Line 442: FROM pa_resource_assignments

438: ,sum(nvl(total_plan_burdened_cost,0))
439: ,sum(nvl(total_plan_revenue,0))
440: ,sum(decode(RESOURCE_CLASS_CODE, 'PEOPLE', decode(unit_of_measure,'HOURS',nvl(total_plan_quantity,0),0),0 ) )
441: ,sum(decode(RESOURCE_CLASS_CODE, 'EQUIPMENT',decode(unit_of_measure,'HOURS',nvl(total_plan_quantity,0),0),0 ) )
442: FROM pa_resource_assignments
443: WHERE budget_version_id = p_budget_version_id;
444:
445:
446: -- End, Bug 3441943, 18-FEB-2004: Added DECODE to separately sum people and equipment quantities ---------

Line 541: UPDATE pa_resource_assignments pra

537: --code modified for bug 4160258.
538: IF p_context IS NOT NULL AND p_context = 'DELETE_RA'
539: THEN NULL;
540: ELSE
541: UPDATE pa_resource_assignments pra
542: SET (parent_assignment_id
543: ,total_project_raw_cost
544: ,total_project_burdened_cost
545: ,total_project_revenue

Line 641: UPDATE pa_resource_assignments

637:
638: IF l_ra_id_tbl.COUNT > 0 THEN
639:
640: FORALL i IN l_ra_id_tbl.first..l_ra_id_tbl.last
641: UPDATE pa_resource_assignments
642: SET TOTAL_PROJECT_RAW_COST = nvl(TOTAL_PROJECT_RAW_COST,0) + l_proj_raw_cost_tbl(i)
643: ,TOTAL_PROJECT_BURDENED_COST = nvl(TOTAL_PROJECT_BURDENED_COST,0) + l_proj_burd_cost_tbl(i)
644: ,TOTAL_PROJECT_REVENUE = nvl(TOTAL_PROJECT_REVENUE,0) + l_proj_revenue_tbl(i)
645: ,TOTAL_PLAN_RAW_COST = nvl(TOTAL_PLAN_RAW_COST,0) + l_projfunc_raw_cost_tbl(i)

Line 656: using top_task level records from pa_resource_assignments. */

652: END IF; -- p_entire_version = 'Y'
653:
654:
655: /* Update Budget Versions Table with rolled up amounts. Update budget versions table
656: using top_task level records from pa_resource_assignments. */
657:
658: pa_debug.g_err_stage := 'selecting Amounts from project level record';
659: IF P_PA_DEBUG_MODE = 'Y' THEN
660: pa_debug.write('ROLLUP_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,3);

Line 772: It does following deletes all rolled up records from pa_resource_assignments.Update amounts

768: END ROLLUP_BUDGET_VERSION;
769:
770: /*===================================================================================================
771: REFRESH_RESOURCE_ASSIGNMENTS: This API refreshes the complete resource assignments table.
772: It does following deletes all rolled up records from pa_resource_assignments.Update amounts
773: from pa_budget_lines on all user_entered records. Insert parents for all the records with amounts.
774: Stamps the parent_assignment_id on all the records.
775: This procedure returns without any action in case there are no records in PA_RESOURCE_ASSIGNMENTS.
776: ===================================================================================================*/

Line 775: This procedure returns without any action in case there are no records in PA_RESOURCE_ASSIGNMENTS.

771: REFRESH_RESOURCE_ASSIGNMENTS: This API refreshes the complete resource assignments table.
772: It does following deletes all rolled up records from pa_resource_assignments.Update amounts
773: from pa_budget_lines on all user_entered records. Insert parents for all the records with amounts.
774: Stamps the parent_assignment_id on all the records.
775: This procedure returns without any action in case there are no records in PA_RESOURCE_ASSIGNMENTS.
776: ===================================================================================================*/
777:
778: PROCEDURE REFRESH_RESOURCE_ASSIGNMENTS(p_budget_version_id IN NUMBER
779: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 806: FROM pa_resource_assignments pra

802: ,MAX(DECODE(parent_prlm.track_as_labor_flag,'Y',
803: 'HOURS',NULL)) unit_of_measure -- Modified for bug #2697999
804: ,MAX(parent_prlm.track_as_labor_flag) track_as_labor_flag
805: -- Modified for bug #2697999
806: FROM pa_resource_assignments pra
807: ,pa_resource_list_members prlm
808: ,pa_resource_list_members parent_prlm -- Added for bug #2697999
809: WHERE pra.budget_version_id = c_budget_version_id
810: AND pra.resource_list_member_id <> 0

Line 833: FROM pa_resource_assignments pra

829: ,sum(nvl(decode(pra.unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,
830: pra.total_plan_quantity,0),0)) quantity
831: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for bug #2697999
832: ,'Y' -- Modified for bug #2697999
833: FROM pa_resource_assignments pra
834: WHERE pra.budget_version_id = c_budget_version_id
835: AND pra.resource_list_member_id <> 0
836: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED
837: AND (pra.total_plan_quantity IS NOT NULL -- Added for bug #2784520

Line 858: FROM pa_resource_assignments pra

854: ,sum(nvl(pra.total_plan_revenue,0))
855: ,sum(nvl(pra.total_plan_quantity,0)) quantity /* no decode required on quantity */
856: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for bug #2697999
857: ,'Y' -- Modified for bug #2697999
858: FROM pa_resource_assignments pra
859: ,pa_tasks pt
860: WHERE pra.budget_version_id = c_budget_version_id
861: AND pra.resource_list_member_id IN (c_uncat_rlm_id,0)
862: -- AND resource_assignment_id > c_curr_res_assignment_id /* mano: this is wrong with new logic */

Line 893: FROM pa_resource_assignments pra

889: ,sum(decode(unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,
890: nvl(total_plan_quantity,0),0)) quantity
891: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS unit_of_measure --Modified for bug #2697999
892: ,'Y' track_as_labor_flag --Modified for bug #2697999
893: FROM pa_resource_assignments pra
894: WHERE pra.budget_version_id = p_budget_Version_id
895: AND pra.resource_assignment_type = 'USER_ENTERED'
896: AND (pra.total_plan_quantity IS NOT NULL
897: OR pra.total_plan_raw_cost IS NOT NULL

Line 918: FROM pa_resource_assignments pra,

914: ,sum(pra.total_plan_revenue)
915: ,sum(nvl(total_plan_quantity,0)) quantity
916: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS unit_of_measure --Modified for bug #2697999
917: ,'Y' track_as_labor_flag --Modified for bug #2697999
918: FROM pa_resource_assignments pra,
919: pa_tasks pt
920: WHERE pra.budget_version_id = p_budget_Version_id
921: AND pra.resource_list_member_id in (l_uncat_rlm_id,0)
922: AND pra.project_id = pt.project_id -- Fixed for #2807678

Line 953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE ;

949: l_res_list_mem_id_tbl l_res_list_mem_id_tbl_typ;
950: l_unit_of_measure_tbl l_unit_of_measure_tbl_typ;
951: l_track_as_labor_flag_tbl l_track_as_labor_flag_tbl_typ;
952:
953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE ;
954: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
955: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
956: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
957: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

Line 961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;

957: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
958: l_project_id pa_projects.project_id%TYPE;
959: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
960:
961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;

Line 962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;

958: l_project_id pa_projects.project_id%TYPE;
959: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
960:
961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;

Line 963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;

959: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
960:
961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:

Line 964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;

960:
961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;

Line 965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;

961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:

Line 966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;

962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;
964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:
970: l_uom pa_resource_assignments.unit_of_measure%TYPE;

Line 968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;

964: l_projfunc_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
965: l_projfunc_burd_cost pa_resource_assignments.total_plan_burdened_cost%TYPE;
966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:
970: l_uom pa_resource_assignments.unit_of_measure%TYPE;
971: l_track_labor_flag pa_resource_assignments.track_as_labor_flag%TYPE;
972: l_proj_ra_id pa_resource_assignments.resource_assignment_id%TYPE ;

Line 970: l_uom pa_resource_assignments.unit_of_measure%TYPE;

966: l_proj_func_revenue pa_resource_assignments.total_plan_revenue%TYPE;
967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:
970: l_uom pa_resource_assignments.unit_of_measure%TYPE;
971: l_track_labor_flag pa_resource_assignments.track_as_labor_flag%TYPE;
972: l_proj_ra_id pa_resource_assignments.resource_assignment_id%TYPE ;
973:
974: /* Variables to be used for debugging purpose */

Line 971: l_track_labor_flag pa_resource_assignments.track_as_labor_flag%TYPE;

967:
968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:
970: l_uom pa_resource_assignments.unit_of_measure%TYPE;
971: l_track_labor_flag pa_resource_assignments.track_as_labor_flag%TYPE;
972: l_proj_ra_id pa_resource_assignments.resource_assignment_id%TYPE ;
973:
974: /* Variables to be used for debugging purpose */
975:

Line 972: l_proj_ra_id pa_resource_assignments.resource_assignment_id%TYPE ;

968: l_quantity pa_resource_assignments.total_plan_quantity%TYPE;
969:
970: l_uom pa_resource_assignments.unit_of_measure%TYPE;
971: l_track_labor_flag pa_resource_assignments.track_as_labor_flag%TYPE;
972: l_proj_ra_id pa_resource_assignments.resource_assignment_id%TYPE ;
973:
974: /* Variables to be used for debugging purpose */
975:
976: l_msg_count NUMBER := 0;

Line 1039: /* Delete all ROLLED_UP records from pa_resource_assignments for the

1035: x_return_status => x_return_status,
1036: x_msg_count => x_msg_count,
1037: x_msg_data => x_msg_data);
1038:
1039: /* Delete all ROLLED_UP records from pa_resource_assignments for the
1040: budget_version_id. */
1041:
1042: pa_debug.g_err_stage := 'deleting rolled up records from pa_resource_assignments';
1043: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1042: pa_debug.g_err_stage := 'deleting rolled up records from pa_resource_assignments';

1038:
1039: /* Delete all ROLLED_UP records from pa_resource_assignments for the
1040: budget_version_id. */
1041:
1042: pa_debug.g_err_stage := 'deleting rolled up records from pa_resource_assignments';
1043: IF P_PA_DEBUG_MODE = 'Y' THEN
1044: pa_debug.write('REFRESH_RESOURCE_ASSIGNMENTS: ' || l_module_name,pa_debug.g_err_stage,3);
1045: END IF;
1046:

Line 1047: DELETE FROM pa_resource_assignments

1043: IF P_PA_DEBUG_MODE = 'Y' THEN
1044: pa_debug.write('REFRESH_RESOURCE_ASSIGNMENTS: ' || l_module_name,pa_debug.g_err_stage,3);
1045: END IF;
1046:
1047: DELETE FROM pa_resource_assignments
1048: WHERE budget_version_id = p_budget_version_id
1049: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_ROLLED_UP;
1050:
1051: /* Update the pa_resource_assignments USER_ENTERED records set

Line 1051: /* Update the pa_resource_assignments USER_ENTERED records set

1047: DELETE FROM pa_resource_assignments
1048: WHERE budget_version_id = p_budget_version_id
1049: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_ROLLED_UP;
1050:
1051: /* Update the pa_resource_assignments USER_ENTERED records set
1052: parent_assignment_id as null. Also update the amounts. Amounts need to
1053: be updated as in case of copy from and copy actual amounts may not be updated.
1054: We assume that in certain other cases also it may be difficult to update amounts
1055: before calling this api.*/

Line 1062: UPDATE pa_resource_assignments pra

1058: IF P_PA_DEBUG_MODE = 'Y' THEN
1059: pa_debug.write('REFRESH_RESOURCE_ASSIGNMENTS: ' || l_module_name,pa_debug.g_err_stage,3);
1060: END IF;
1061:
1062: UPDATE pa_resource_assignments pra
1063: SET (parent_assignment_id
1064: ,total_project_raw_cost
1065: ,total_project_burdened_cost
1066: ,total_project_revenue

Line 1148: /* Call a common API to bulk insert into pa_resource_assignments. */

1144: LIMIT g_plsql_max_array_size;
1145:
1146: IF nvl(l_task_id_tbl.last,0) >= 1 THEN /* only if something is fetched */
1147:
1148: /* Call a common API to bulk insert into pa_resource_assignments. */
1149:
1150: pa_debug.g_err_stage := 'got ' || l_task_id_tbl.last || ' records ' || 'calling Insert_Bulk_Rows_Res';
1151: IF P_PA_DEBUG_MODE = 'Y' THEN
1152: pa_debug.write('REFRESH_RESOURCE_ASSIGNMENTS: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1282: /* Creating a Loop where the steps of insertion into PA_Resource_Assignments

1278:
1279: /* Initialise the variable l_cur_res_assignment_id to 0. */
1280: l_curr_res_assignment_id := 0;
1281:
1282: /* Creating a Loop where the steps of insertion into PA_Resource_Assignments
1283: for the Parent_Task records and then selecting records for the Resource Assignments
1284: for the records that have been created. */
1285:
1286: pa_debug.g_err_stage := 'Inserting the Parent Task Level Records';

Line 1316: SELECT PA_RESOURCE_ASSIGNMENTS_S.nextval

1312: /* Get the current/next value of sequence for resource assignment
1313: id into l_curr_res_assignment_id just after opening the cursor. */
1314:
1315: IF l_curr_res_assignment_id = 0 THEN
1316: SELECT PA_RESOURCE_ASSIGNMENTS_S.nextval
1317: INTO l_curr_res_assignment_id
1318: FROM dual;
1319: ELSE
1320: SELECT PA_RESOURCE_ASSIGNMENTS_S.currval

Line 1320: SELECT PA_RESOURCE_ASSIGNMENTS_S.currval

1316: SELECT PA_RESOURCE_ASSIGNMENTS_S.nextval
1317: INTO l_curr_res_assignment_id
1318: FROM dual;
1319: ELSE
1320: SELECT PA_RESOURCE_ASSIGNMENTS_S.currval
1321: INTO l_curr_res_assignment_id
1322: FROM dual;
1323: END IF;
1324: pa_debug.g_err_stage := 'l_curr_res_assignment_id = ' || l_curr_res_assignment_id;

Line 1489: -- PA_RESOURCE_ASSIGNMENTS_S.CURRVAL not yet defined ,when

1485:
1486: END IF; /* l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT */
1487:
1488: -- bug#2659956 : Added the IF condition to avoid the issue of
1489: -- PA_RESOURCE_ASSIGNMENTS_S.CURRVAL not yet defined ,when
1490: -- planning level is project and resource list is uncategorized.
1491:
1492: IF l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT
1493: AND l_uncat_flag = 'Y' THEN

Line 1529: select pa_resource_assignments_s.currval

1525: ,x_return_status => x_return_status
1526: ,x_msg_count => x_msg_count
1527: ,x_msg_data => x_msg_data );
1528:
1529: select pa_resource_assignments_s.currval
1530: into l_proj_ra_id
1531: from dual;
1532:
1533: END IF;

Line 1675: UPDATE pa_resource_assignments pra1

1671: IF P_PA_DEBUG_MODE = 'Y' THEN
1672: pa_debug.write('UPDATE_RES_PARENT_ASSIGN_ID: ' || l_module_name,pa_debug.g_err_stage,3);
1673: END IF;
1674:
1675: UPDATE pa_resource_assignments pra1
1676: SET parent_assignment_id =
1677: (SELECT resource_assignment_id
1678: FROM pa_resource_assignments pra2
1679: ,pa_tasks t

Line 1678: FROM pa_resource_assignments pra2

1674:
1675: UPDATE pa_resource_assignments pra1
1676: SET parent_assignment_id =
1677: (SELECT resource_assignment_id
1678: FROM pa_resource_assignments pra2
1679: ,pa_tasks t
1680: WHERE pra2.task_id = t.parent_task_id
1681: AND pra1.task_id = t.task_id
1682: AND pra2.budget_version_id = p_budget_version_id

Line 1709: UPDATE pa_resource_assignments pra1

1705: IF P_PA_DEBUG_MODE = 'Y' THEN
1706: pa_debug.write('UPDATE_RES_PARENT_ASSIGN_ID: ' || l_module_name,pa_debug.g_err_stage,3);
1707: END IF;
1708:
1709: UPDATE pa_resource_assignments pra1
1710: SET parent_assignment_id =
1711: (SELECT resource_assignment_id
1712: FROM pa_resource_assignments pra2
1713: ,pa_resource_list_members prlm

Line 1712: FROM pa_resource_assignments pra2

1708:
1709: UPDATE pa_resource_assignments pra1
1710: SET parent_assignment_id =
1711: (SELECT resource_assignment_id
1712: FROM pa_resource_assignments pra2
1713: ,pa_resource_list_members prlm
1714: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
1715: AND pra1.task_id = pra2.task_id
1716: AND pra2.resource_list_member_id = prlm.parent_member_id

Line 1744: UPDATE pa_resource_assignments pra1

1740: /* Do the following only when Planning Level is not 'Project' */
1741:
1742: IF l_planning_level <> PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
1743:
1744: UPDATE pa_resource_assignments pra1
1745: SET parent_assignment_id =
1746: (SELECT resource_assignment_id
1747: FROM pa_resource_assignments pra2
1748: WHERE pra1.task_id = pra2.task_id

Line 1747: FROM pa_resource_assignments pra2

1743:
1744: UPDATE pa_resource_assignments pra1
1745: SET parent_assignment_id =
1746: (SELECT resource_assignment_id
1747: FROM pa_resource_assignments pra2
1748: WHERE pra1.task_id = pra2.task_id
1749: AND pra2.resource_list_member_id = 0
1750: AND pra2.budget_version_id = p_budget_version_id
1751: AND pra2.project_id = pra1.project_id ) -- Bug 2814165

Line 1775: UPDATE pa_resource_assignments pra

1771: END IF;
1772:
1773: IF l_planning_level <> PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
1774:
1775: UPDATE pa_resource_assignments pra
1776: SET parent_assignment_id = p_proj_ra_id
1777: WHERE task_id in
1778: (SELECT top_task_id
1779: FROM pa_tasks

Line 1806: UPDATE pa_resource_assignments pra

1802: IF P_PA_DEBUG_MODE = 'Y' THEN
1803: pa_debug.write('UPDATE_RES_PARENT_ASSIGN_ID: ' || l_module_name,pa_debug.g_err_stage,3);
1804: END IF;
1805:
1806: UPDATE pa_resource_assignments pra
1807: SET parent_assignment_id = p_proj_ra_id
1808: WHERE parent_assignment_id is null
1809: AND budget_version_id = p_budget_version_id -- bug 2760675, missing version_id join condition
1810: AND resource_list_member_id <> 0

Line 1911: /* Bulk Insert records into PA_RESOURCE_ASSIGNMENTS table for the records fetched

1907: pa_debug.write('Insert_Bulk_Rows_Res: ' || l_module_name,pa_debug.g_err_stage,3);
1908: END IF;
1909:
1910:
1911: /* Bulk Insert records into PA_RESOURCE_ASSIGNMENTS table for the records fetched
1912: from cursor top_task_cur. */
1913:
1914: pa_debug.g_err_stage := 'In Insert_Bulk_Rows_Res';
1915: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1919: pa_debug.g_err_stage := 'Bulk inserting into PA_RESOURCE_ASSIGNMENTS';

1915: IF P_PA_DEBUG_MODE = 'Y' THEN
1916: pa_debug.write('Insert_Bulk_Rows_Res: ' || l_module_name,pa_debug.g_err_stage,3);
1917: END IF;
1918:
1919: pa_debug.g_err_stage := 'Bulk inserting into PA_RESOURCE_ASSIGNMENTS';
1920: IF P_PA_DEBUG_MODE = 'Y' THEN
1921: pa_debug.write('Insert_Bulk_Rows_Res: ' || l_module_name,pa_debug.g_err_stage,3);
1922: END IF;
1923:

Line 1928: INSERT INTO pa_resource_assignments

1924: IF nvl(p_task_id_tbl.LAST,0) > 0 THEN
1925:
1926: FORALL i in p_task_id_tbl.first..p_task_id_tbl.last
1927:
1928: INSERT INTO pa_resource_assignments
1929: (RESOURCE_ASSIGNMENT_ID
1930: ,BUDGET_VERSION_ID
1931: ,PROJECT_ID
1932: ,TASK_ID

Line 1951: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

1947: ,TRACK_AS_LABOR_FLAG
1948: ,PROJECT_ASSIGNMENT_ID
1949: ,RESOURCE_ASSIGNMENT_TYPE )
1950: VALUES
1951: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
1952: ,p_plan_version_id -- BUDGET_VERSION_ID
1953: ,p_project_id -- PROJECT_ID
1954: ,p_task_id_tbl(i) -- TASK_ID
1955: ,nvl(p_res_list_mem_id_tbl(i),0) -- RESOURCE_LIST_MEMBER_ID

Line 2505: FROM pa_resource_assignments pra

2501:
2502: UPDATE pa_proj_periods_denorm ppd
2503: SET ppd.parent_assignment_id =
2504: (SELECT parent_assignment_id
2505: FROM pa_resource_assignments pra
2506: WHERE pra.resource_assignment_id = ppd.resource_assignment_id)
2507: WHERE ppd.budget_version_id = p_budget_version_id; /* M21-AUG: added this condition */
2508:
2509: pa_debug.g_err_stage := 'updated ' || sql%rowcount || ' records';

Line 2546: FROM pa_resource_assignments pra1,

2542: /* Added for the bug #2622594. */
2543: CURSOR cur_parent_ra_id(c_budget_version_id IN NUMBER
2544: ,c_project_id IN NUMBER ) IS --bug#2708524
2545: SELECT pra1.resource_assignment_id child_ra_id , pra2.resource_assignment_id parent_ra_id
2546: FROM pa_resource_assignments pra1,
2547: pa_resource_assignments pra2,
2548: pa_resource_list_members prlm
2549: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
2550: AND pra2.resource_list_member_id = prlm.parent_member_id

Line 2547: pa_resource_assignments pra2,

2543: CURSOR cur_parent_ra_id(c_budget_version_id IN NUMBER
2544: ,c_project_id IN NUMBER ) IS --bug#2708524
2545: SELECT pra1.resource_assignment_id child_ra_id , pra2.resource_assignment_id parent_ra_id
2546: FROM pa_resource_assignments pra1,
2547: pa_resource_assignments pra2,
2548: pa_resource_list_members prlm
2549: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
2550: AND pra2.resource_list_member_id = prlm.parent_member_id
2551: AND pra1.task_id = pra2.task_id

Line 2576: FROM pa_resource_assignments pra

2572: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS
2573: ,NULL)) unit_of_measure -- Added for bug #2697999
2574: ,max(parent_prlm.track_as_labor_flag) track_as_labor_flag
2575: -- Added for bug #2697999
2576: FROM pa_resource_assignments pra
2577: ,pa_resource_list_members prlm
2578: ,pa_resource_list_members parent_prlm
2579: WHERE pra.project_id = c_project_id --bug#2708524
2580: AND pra.budget_version_id = c_budget_version_id

Line 2592: FROM pa_resource_assignments pra

2588:
2589: CURSOR cur_task_rec(c_budget_version_id IN NUMBER
2590: ,c_project_id IN NUMBER) IS --bug#2708524
2591: SELECT task_id
2592: FROM pa_resource_assignments pra
2593: WHERE pra.budget_version_id = c_budget_version_id
2594: AND pra.project_id = c_project_id
2595: AND pra.resource_list_member_id <> 0
2596: AND pra.resource_assignment_id IN

Line 2604: FROM pa_resource_assignments pra

2600: CURSOR cur_parent_task_rec(c_curr_wbs_level IN NUMBER
2601: ,c_budget_version_id IN NUMBER --bug#2708524
2602: ,c_project_id IN NUMBER) IS --bug#2708524
2603: SELECT PARENT_TASK_ID TASK_ID
2604: FROM pa_resource_assignments pra
2605: ,pa_tasks pt
2606: WHERE pra.resource_assignment_id IN
2607: (select resource_assignment_id FROM pa_fp_ra_map_tmp )
2608: AND pra.project_id = c_project_id --bug#2708524

Line 2616: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;

2612: AND pt.wbs_level = c_curr_wbs_level
2613: GROUP BY pt.parent_task_id;
2614:
2615: l_continue_processing_flag VARCHAR2(1);
2616: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;
2617: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
2618: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
2619: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
2620: l_project_id pa_projects.project_id%TYPE;

Line 2629: l_proj_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;

2625: l_parent_ra_id_tbl l_par_id_tbl_typ;
2626: l_task_id_tbl l_task_id_tbl_typ;
2627: l_res_list_mem_id_tbl l_res_list_mem_id_tbl_typ;
2628: l_proj_count_rec NUMBER;
2629: l_proj_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;
2630: l_unit_of_measure_tbl l_unit_of_measure_tbl_typ;
2631: l_track_as_labor_flag_tbl l_track_as_labor_flag_tbl_typ;
2632:
2633: l_msg_count NUMBER := 0;

Line 2716: /* Update parent_assignment_id on pa_resource_assignments for the resource level records

2712: END IF;
2713:
2714: LOOP
2715:
2716: /* Update parent_assignment_id on pa_resource_assignments for the resource level records
2717: for which parents are inserted in last step. */
2718:
2719: pa_debug.g_err_stage := 'Updating Parent_Assignment_IDs for Recs having parents */';
2720: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2727: /* UPDATE pa_resource_assignments pra1

2723:
2724: /* Bug #2622594: Modified the logic of updating the resource asignments for the
2725: resource level records. Using a cursor instead of a direct update. */
2726:
2727: /* UPDATE pa_resource_assignments pra1
2728: SET parent_assignment_id =
2729: (SELECT resource_assignment_id
2730: FROM pa_resource_assignments pra2, pa_resource_list_members prlm
2731: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id

Line 2730: FROM pa_resource_assignments pra2, pa_resource_list_members prlm

2726:
2727: /* UPDATE pa_resource_assignments pra1
2728: SET parent_assignment_id =
2729: (SELECT resource_assignment_id
2730: FROM pa_resource_assignments pra2, pa_resource_list_members prlm
2731: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
2732: AND pra2.resource_list_member_id = prlm.parent_member_id
2733: AND pra1.task_id = pra2.task_id
2734: AND pra2.budget_version_id = p_budget_version_id)

Line 2751: UPDATE pa_resource_assignments

2747:
2748: IF nvl(l_ra_id_tbl.last,0) > 0 THEN
2749:
2750: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
2751: UPDATE pa_resource_assignments
2752: SET parent_assignment_id = l_parent_ra_id_tbl(i)
2753: WHERE resource_assignment_id = l_ra_id_tbl(i);
2754:
2755: pa_debug.g_err_stage := 'updated ' || sql%rowcount || ' records';

Line 2801: INSERT INTO pa_resource_assignments

2797: IF nvl(l_task_id_tbl.last,0) > 0 THEN
2798:
2799: FORALL i in l_task_id_tbl.first..l_task_id_tbl.last
2800:
2801: INSERT INTO pa_resource_assignments
2802: (RESOURCE_ASSIGNMENT_ID
2803: ,BUDGET_VERSION_ID
2804: ,PROJECT_ID
2805: ,TASK_ID

Line 2817: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

2813: ,TRACK_AS_LABOR_FLAG
2814: ,PROJECT_ASSIGNMENT_ID
2815: ,RESOURCE_ASSIGNMENT_TYPE )
2816: VALUES
2817: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
2818: ,p_budget_version_id
2819: ,l_project_id
2820: ,l_task_id_tbl(i)
2821: ,l_res_list_mem_id_tbl(i)

Line 2882: /* If task level records are already present in the PA_Resource_Assignments table,

2878: l_task_id_tbl.delete; /* Deleting records from TASKID pl/sql table so that it can be used later. */
2879:
2880: LOOP
2881:
2882: /* If task level records are already present in the PA_Resource_Assignments table,
2883: then parent_assignment_id needs to be stamped on pa_Resource_assignments table. */
2884:
2885: pa_debug.g_err_stage := 'Updating the Parent Assignment IDs for resource level records';
2886: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2883: then parent_assignment_id needs to be stamped on pa_Resource_assignments table. */

2879:
2880: LOOP
2881:
2882: /* If task level records are already present in the PA_Resource_Assignments table,
2883: then parent_assignment_id needs to be stamped on pa_Resource_assignments table. */
2884:
2885: pa_debug.g_err_stage := 'Updating the Parent Assignment IDs for resource level records';
2886: IF P_PA_DEBUG_MODE = 'Y' THEN
2887: pa_debug.write('INSERT_MISSING_RES_PARENTS: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2889: UPDATE pa_resource_assignments pra1

2885: pa_debug.g_err_stage := 'Updating the Parent Assignment IDs for resource level records';
2886: IF P_PA_DEBUG_MODE = 'Y' THEN
2887: pa_debug.write('INSERT_MISSING_RES_PARENTS: ' || l_module_name,pa_debug.g_err_stage,3);
2888: END IF;
2889: UPDATE pa_resource_assignments pra1
2890: SET parent_assignment_id =
2891: (SELECT resource_assignment_id
2892: FROM pa_resource_assignments pra2
2893: WHERE pra2.task_id = pra1.task_id

Line 2892: FROM pa_resource_assignments pra2

2888: END IF;
2889: UPDATE pa_resource_assignments pra1
2890: SET parent_assignment_id =
2891: (SELECT resource_assignment_id
2892: FROM pa_resource_assignments pra2
2893: WHERE pra2.task_id = pra1.task_id
2894: AND pra2.resource_list_member_id = 0
2895: AND pra2.budget_version_id = p_budget_version_id)
2896: WHERE resource_assignment_id in

Line 2940: INSERT INTO PA_RESOURCE_ASSIGNMENTS

2936:
2937: IF nvl(l_task_id_tbl.last,0) > 0 THEN
2938:
2939: FORALL i in l_task_id_tbl.first..l_task_id_tbl.last
2940: INSERT INTO PA_RESOURCE_ASSIGNMENTS
2941: (RESOURCE_ASSIGNMENT_ID
2942: ,BUDGET_VERSION_ID
2943: ,PROJECT_ID
2944: ,TASK_ID

Line 2956: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

2952: ,TRACK_AS_LABOR_FLAG
2953: ,PROJECT_ASSIGNMENT_ID
2954: ,RESOURCE_ASSIGNMENT_TYPE )
2955: VALUES
2956: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
2957: ,p_budget_version_id
2958: ,l_project_id
2959: ,l_task_id_tbl(i)
2960: ,0 -- res_list_mem_id is 0 for tasks

Line 3038: level tasks and top task records into PA_RESOURCE_ASSIGNMENTS. */

3034: IF (l_planning_level NOT IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
3035: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT)) THEN
3036:
3037: /* If task planning level for the version is not 'TOP_TASK'or 'PROJECT' THEN Insert middle
3038: level tasks and top task records into PA_RESOURCE_ASSIGNMENTS. */
3039:
3040: l_curr_wbs_level := 0;
3041: select max(wbs_level)
3042: into l_curr_wbs_level

Line 3066: UPDATE /+ INDEX(pra1 PA_RESOURCE_ASSIGNMENTS_U1)/ pa_resource_assignments pra1 --Bug 2782166

3062:
3063: l_ra_id_tbl.delete;
3064: l_parent_ra_id_tbl.delete;
3065:
3066: UPDATE /*+ INDEX(pra1 PA_RESOURCE_ASSIGNMENTS_U1)*/ pa_resource_assignments pra1 --Bug 2782166
3067: SET parent_assignment_id =
3068: (select resource_assignment_id
3069: from pa_resource_assignments pra2
3070: ,pa_tasks t

Line 3069: from pa_resource_assignments pra2

3065:
3066: UPDATE /*+ INDEX(pra1 PA_RESOURCE_ASSIGNMENTS_U1)*/ pa_resource_assignments pra1 --Bug 2782166
3067: SET parent_assignment_id =
3068: (select resource_assignment_id
3069: from pa_resource_assignments pra2
3070: ,pa_tasks t
3071: where pra2.task_id = t.parent_task_id
3072: and pra1.task_id = t.task_id
3073: and pra2.budget_version_id = p_budget_version_id) /* manokuma: fixed during ut */

Line 3114: INSERT INTO PA_RESOURCE_ASSIGNMENTS

3110: FETCH cur_parent_task_rec BULK COLLECT INTO l_task_id_tbl;
3111:
3112: IF nvl(l_task_id_tbl.last,0) > 0 THEN -- if parent records found
3113: FORALL i in l_task_id_tbl.first..l_task_id_tbl.last
3114: INSERT INTO PA_RESOURCE_ASSIGNMENTS
3115: (RESOURCE_ASSIGNMENT_ID
3116: ,BUDGET_VERSION_ID
3117: ,PROJECT_ID
3118: ,TASK_ID

Line 3130: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

3126: ,TRACK_AS_LABOR_FLAG
3127: ,PROJECT_ASSIGNMENT_ID
3128: ,RESOURCE_ASSIGNMENT_TYPE )
3129: VALUES
3130: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
3131: ,p_budget_version_id
3132: ,l_project_id
3133: ,l_task_id_tbl(i)
3134: ,0 -- res_list_mem_id is 0 for tasks

Line 3193: /* By now, all parent task level records would have been inserted into PA_RESOURCE_ASSIGNMENTS

3189:
3190: END IF; /* l_continue_procesing_flag = 'Y'*/
3191:
3192:
3193: /* By now, all parent task level records would have been inserted into PA_RESOURCE_ASSIGNMENTS
3194: table with parent_assignment_id stamped correctly. PA_RA_MAP temp table will contain only
3195: top task level records. In case planning level is project or top task and resource list is
3196: attached then pa_fp_ra_map_tmp table will contain resource/resource group level records with
3197: task_id as 0. */

Line 3227: FROM pa_resource_assignments

3223:
3224: BEGIN
3225: SELECT resource_assignment_id
3226: INTO l_proj_ra_id
3227: FROM pa_resource_assignments
3228: WHERE budget_version_id = p_budget_version_id
3229: AND task_id = 0
3230: AND resource_list_member_id IN (l_uncat_rlm_id,0);
3231:

Line 3241: INSERT INTO pa_resource_assignments

3237: IF P_PA_DEBUG_MODE = 'Y' THEN
3238: pa_debug.write('INSERT_MISSING_RES_PARENTS: ' || l_module_name,pa_debug.g_err_stage,3);
3239: END IF;
3240:
3241: INSERT INTO pa_resource_assignments
3242: (RESOURCE_ASSIGNMENT_ID
3243: ,BUDGET_VERSION_ID
3244: ,PROJECT_ID
3245: ,TASK_ID

Line 3257: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL

3253: ,TRACK_AS_LABOR_FLAG
3254: ,PROJECT_ASSIGNMENT_ID
3255: ,RESOURCE_ASSIGNMENT_TYPE)
3256: VALUES
3257: (PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL
3258: ,p_budget_version_id
3259: ,l_project_id
3260: ,0
3261: ,0 -- res_list_mem_id is 0 for tasks

Line 3281: /* Update all PA_RESOURCE_ASSIGNMENTS for resource_assignment id in pa_fp_ra_map_tmp table

3277: END IF;
3278:
3279: END;
3280:
3281: /* Update all PA_RESOURCE_ASSIGNMENTS for resource_assignment id in pa_fp_ra_map_tmp table
3282: with parent_assignment_id as that obtained earlier. */
3283:
3284: pa_debug.g_err_stage := 'updating top records with project level record as parent ';
3285: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3289: UPDATE PA_RESOURCE_ASSIGNMENTS

3285: IF P_PA_DEBUG_MODE = 'Y' THEN
3286: pa_debug.write('INSERT_MISSING_RES_PARENTS: ' || l_module_name,pa_debug.g_err_stage,3);
3287: END IF;
3288:
3289: UPDATE PA_RESOURCE_ASSIGNMENTS
3290: SET parent_assignment_id = l_proj_ra_id
3291: WHERE resource_assignment_id IN
3292: (SELECT resource_assignment_id
3293: FROM pa_fp_ra_map_tmp)

Line 3341: and will update rollup amount for each level in pa_resource_assignments table.

3337: END INSERT_MISSING_RES_PARENTS;
3338:
3339: /***********************************************************************************************
3340: ROLLUP_RES_ASSIGNMENT_AMOUNTS: This API will take input from PA_FP_ROLLUP_TMP table
3341: and will update rollup amount for each level in pa_resource_assignments table.
3342: Before this API is called, INSERT_MISSING_RES_PARENTS would have created parents for all the
3343: records affected in PA_RESOURCE_ASSIGNMENTS. This API will just rollup the amounts.
3344: Pre-requisite: For an existing element users should have populated old and new amount fields
3345: into the temp table PA_FP_ROLLUP_TMP before calling this API.

Line 3343: records affected in PA_RESOURCE_ASSIGNMENTS. This API will just rollup the amounts.

3339: /***********************************************************************************************
3340: ROLLUP_RES_ASSIGNMENT_AMOUNTS: This API will take input from PA_FP_ROLLUP_TMP table
3341: and will update rollup amount for each level in pa_resource_assignments table.
3342: Before this API is called, INSERT_MISSING_RES_PARENTS would have created parents for all the
3343: records affected in PA_RESOURCE_ASSIGNMENTS. This API will just rollup the amounts.
3344: Pre-requisite: For an existing element users should have populated old and new amount fields
3345: into the temp table PA_FP_ROLLUP_TMP before calling this API.
3346: For a new element (thru excel sheets) users will populate old as null and new
3347: as the current value.

Line 3478: pa_debug.g_err_stage := 'Updating amounts on pa_resource_assignments for user_entered recs- 1';

3474: But if the records are not USER_ENTERED, we have to consider
3475: the quantities only if the Unit OF Measure is HOURS. Hence the Update stmt
3476: has been split into two depending on the value of the flag. */
3477:
3478: pa_debug.g_err_stage := 'Updating amounts on pa_resource_assignments for user_entered recs- 1';
3479: IF P_PA_DEBUG_MODE = 'Y' THEN
3480: pa_debug.write('ROLLUP_RES_ASSIGNMENT_AMOUNTS: ' || l_module_name,pa_debug.g_err_stage,3);
3481: END IF;
3482:

Line 3484: /* Update pa_resource_assignments for the records found in last step

3480: pa_debug.write('ROLLUP_RES_ASSIGNMENT_AMOUNTS: ' || l_module_name,pa_debug.g_err_stage,3);
3481: END IF;
3482:
3483: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
3484: /* Update pa_resource_assignments for the records found in last step
3485: adding all the amount diffs */
3486: UPDATE pa_resource_assignments
3487: SET TOTAL_PROJECT_RAW_COST = nvl(TOTAL_PROJECT_RAW_COST,0) + l_proj_raw_cost_tbl(i)
3488: ,TOTAL_PROJECT_BURDENED_COST = nvl(TOTAL_PROJECT_BURDENED_COST,0) + l_proj_burd_cost_tbl(i)

Line 3486: UPDATE pa_resource_assignments

3482:
3483: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
3484: /* Update pa_resource_assignments for the records found in last step
3485: adding all the amount diffs */
3486: UPDATE pa_resource_assignments
3487: SET TOTAL_PROJECT_RAW_COST = nvl(TOTAL_PROJECT_RAW_COST,0) + l_proj_raw_cost_tbl(i)
3488: ,TOTAL_PROJECT_BURDENED_COST = nvl(TOTAL_PROJECT_BURDENED_COST,0) + l_proj_burd_cost_tbl(i)
3489: ,TOTAL_PROJECT_REVENUE = nvl(TOTAL_PROJECT_REVENUE,0) + l_proj_revenue_tbl(i)
3490: ,TOTAL_PLAN_RAW_COST = nvl(TOTAL_PLAN_RAW_COST,0) + l_projfunc_raw_cost_tbl(i)

Line 3506: pa_debug.g_err_stage := 'Updating amounts on pa_resource_assignments for rolled up recs ';

3502:
3503: -- l_upd_rec := SQL%ROWCOUNT; Not required now.
3504: ELSE
3505:
3506: pa_debug.g_err_stage := 'Updating amounts on pa_resource_assignments for rolled up recs ';
3507: IF P_PA_DEBUG_MODE = 'Y' THEN
3508: pa_debug.write('ROLLUP_RES_ASSIGNMENT_AMOUNTS: ' || l_module_name,pa_debug.g_err_stage,3);
3509: END IF;
3510:

Line 3512: /* Update pa_resource_assignments for the records found in last step

3508: pa_debug.write('ROLLUP_RES_ASSIGNMENT_AMOUNTS: ' || l_module_name,pa_debug.g_err_stage,3);
3509: END IF;
3510:
3511: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
3512: /* Update pa_resource_assignments for the records found in last step
3513: adding all the amount diffs */
3514: UPDATE pa_resource_assignments
3515: SET TOTAL_PROJECT_RAW_COST = nvl(TOTAL_PROJECT_RAW_COST,0) + l_proj_raw_cost_tbl(i)
3516: ,TOTAL_PROJECT_BURDENED_COST = nvl(TOTAL_PROJECT_BURDENED_COST,0) + l_proj_burd_cost_tbl(i)

Line 3514: UPDATE pa_resource_assignments

3510:
3511: FORALL i in l_ra_id_tbl.first..l_ra_id_tbl.last
3512: /* Update pa_resource_assignments for the records found in last step
3513: adding all the amount diffs */
3514: UPDATE pa_resource_assignments
3515: SET TOTAL_PROJECT_RAW_COST = nvl(TOTAL_PROJECT_RAW_COST,0) + l_proj_raw_cost_tbl(i)
3516: ,TOTAL_PROJECT_BURDENED_COST = nvl(TOTAL_PROJECT_BURDENED_COST,0) + l_proj_burd_cost_tbl(i)
3517: ,TOTAL_PROJECT_REVENUE = nvl(TOTAL_PROJECT_REVENUE,0) + l_proj_revenue_tbl(i)
3518: ,TOTAL_PLAN_RAW_COST = nvl(TOTAL_PLAN_RAW_COST,0) + l_projfunc_raw_cost_tbl(i)

Line 3679: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;

3675: l_currency_type_tbl l_currency_type_tbl_typ;
3676: l_currency_code_tbl l_currency_code_tbl_typ;
3677:
3678:
3679: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;
3680: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
3681: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
3682: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
3683: l_project_id pa_projects.project_id%TYPE;

Line 3707: FROM pa_resource_assignments pra,

3703: ppd.amount_subtype_id,
3704: ppd.currency_type,
3705: decode(ppd.amount_subtype_code,PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY,
3706: l_proj_currency_code,ppd.currency_code) --#2801522:For Qty, store Proj Curr Code
3707: FROM pa_resource_assignments pra,
3708: pa_proj_periods_denorm ppd
3709: WHERE ppd.budget_version_id = p_budget_version_id -- #2839138
3710: AND pra.resource_assignment_id = ppd.resource_assignment_id
3711: AND ppd.object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT -- #2839138

Line 4158: FROM PA_PROJ_PERIODS_DENORM ppd2, pa_resource_assignments pra

4154: ,sum(nvl(period_amount49,0))
4155: ,sum(nvl(period_amount50,0))
4156: ,sum(nvl(period_amount51,0))
4157: ,sum(nvl(period_amount52,0))
4158: FROM PA_PROJ_PERIODS_DENORM ppd2, pa_resource_assignments pra
4159: WHERE ppd1.resource_assignment_id = ppd2.parent_assignment_id
4160: AND ppd1.currency_type = ppd2.currency_type
4161: AND ppd1.currency_code = decode(ppd2.amount_subtype_code,PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY,
4162: ppd1.currency_code,ppd2.currency_code) --#2801522:Dont check curr code for Qty

Line 4395: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;

4391: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4392: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
4393:
4394:
4395: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE;
4396: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
4397: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
4398: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
4399: l_project_id pa_projects.project_id%TYPE;

Line 4402: l_parent_assignment_id pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE;

4398: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
4399: l_project_id pa_projects.project_id%TYPE;
4400: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
4401:
4402: l_parent_assignment_id pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE;
4403: l_rec_exists VARCHAR2(1);
4404: l_child_res_count NUMBER;
4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;

Line 4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;

4401:
4402: l_parent_assignment_id pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE;
4403: l_rec_exists VARCHAR2(1);
4404: l_child_res_count NUMBER;
4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

Line 4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;

4402: l_parent_assignment_id pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE;
4403: l_rec_exists VARCHAR2(1);
4404: l_child_res_count NUMBER;
4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

Line 4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;

4403: l_rec_exists VARCHAR2(1);
4404: l_child_res_count NUMBER;
4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

Line 4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;

4404: l_child_res_count NUMBER;
4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
4412: l_records_deleted NUMBER;

Line 4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

4405: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
4412: l_records_deleted NUMBER;
4413:

Line 4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

4406: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
4412: l_records_deleted NUMBER;
4413:
4414: l_msg_count NUMBER := 0;

Line 4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

4407: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
4408: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
4409: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
4410: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
4411: l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
4412: l_records_deleted NUMBER;
4413:
4414: l_msg_count NUMBER := 0;
4415: l_data VARCHAR2(2000);

Line 4601: ,pa_resource_assignments pra

4597: ,'Y' delete_flag
4598: ,l_project_currency_code --Bug # 2615807
4599: ,l_projFunc_currency_code --Bug # 2615807
4600: FROM pa_budget_lines bl
4601: ,pa_resource_assignments pra
4602: WHERE bl.resource_assignment_id = p_resource_assignment_id
4603: AND pra.resource_assignment_id = bl.resource_assignment_id
4604: /* FPB2: Removed grouped by and null handling in select columns as
4605: budget_line_id needs to be included

Line 4746: pa_resource_assignments b

4742: ,l_res_class_code_tbl
4743: ,l_rate_based_flag_tbl
4744: From
4745: pa_budget_lines a,
4746: pa_resource_assignments b
4747: Where a.resource_assignment_id = b.resource_assignment_id
4748: and b.budget_version_id = p_budget_version_id
4749: and b.resource_assignment_id = p_resource_assignment_id
4750: and a.txn_currency_code = nvl(p_txn_currency_code,a.txn_currency_code);

Line 4846: DELETE FROM pa_resource_assignments

4842:
4843: END IF;
4844: */
4845:
4846: DELETE FROM pa_resource_assignments
4847: WHERE resource_assignment_id = p_resource_assignment_id
4848: RETURNING parent_assignment_id, task_id, resource_list_member_id
4849: INTO l_parent_assignment_id
4850: ,l_task_id

Line 4988: DELETE FROM pa_resource_assignments

4984: IF P_PA_DEBUG_MODE = 'Y' THEN
4985: pa_debug.write('DELETE_ELEMENT: ' || l_module_name,pa_debug.g_err_stage,3);
4986: END IF;
4987:
4988: DELETE FROM pa_resource_assignments
4989: WHERE resource_assignment_id = p_resource_assignment_id
4990: RETURNING parent_assignment_id, task_id, resource_list_member_id
4991: INTO l_parent_assignment_id
4992: ,l_task_id

Line 5027: FROM pa_resource_assignments pra

5023: l_child_res_count := 0;
5024:
5025: SELECT count(1)
5026: INTO l_child_res_count
5027: FROM pa_resource_assignments pra
5028: WHERE pra.parent_assignment_id = l_parent_assignment_id;
5029:
5030: IF l_child_res_count = 0 THEN
5031:

Line 5033: resource_assignment_id record from pa_resource_assignments and pa

5029:
5030: IF l_child_res_count = 0 THEN
5031:
5032: /* If no child is found for this Parent Assignment ID,then delete this
5033: resource_assignment_id record from pa_resource_assignments and pa
5034: pa_proj_periods_denorm. Get the parent of this resource assignment id.
5035: Continue this loop until some parent is found with child records. */
5036:
5037: pa_debug.g_err_stage := 'no child found. deleting the parent';

Line 5051: DELETE FROM pa_resource_assignments

5047: WHERE resource_assignment_id = l_parent_assignment_id;
5048: /* WHERE resource_assignment_id = p_resource_assignment_id during bug fix 2649117 found that it
5049: was p_resource_assignment_id */
5050:
5051: DELETE FROM pa_resource_assignments
5052: WHERE resource_assignment_id = l_parent_assignment_id
5053: RETURNING parent_assignment_id INTO l_parent_assignment_id;
5054:
5055: pa_debug.g_err_stage := 'deleted ' || sql%rowcount || ' from denorm';