APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_PLANNING_RES_TMP1

Line 4971: DELETE FROM PA_FP_PLANNING_RES_TMP1;

4967: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4968: p_debug_mode => p_pa_debug_mode);
4969: END IF;
4970:
4971: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4972: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
4973: -- hr_utility.trace('inside lowest task in maintain res asg :');
4974: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4975: > 0 value - actual res asg id from WP or FP budget version

Line 4974: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with

4970:
4971: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4972: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
4973: -- hr_utility.trace('inside lowest task in maintain res asg :');
4974: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4975: > 0 value - actual res asg id from WP or FP budget version
4976: source, all negative res asg values are inserted either for
4977: tasks with etc source as WORK_QUANTITY or the etc is NONE or NULL. */
4978: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

Line 4978: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

4974: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4975: > 0 value - actual res asg id from WP or FP budget version
4976: source, all negative res asg values are inserted either for
4977: tasks with etc source as WORK_QUANTITY or the etc is NONE or NULL. */
4978: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
4979: TASK_ID,
4980: RESOURCE_LIST_MEMBER_ID,
4981: CBS_ELEMENT_ID,--bug#16791711
4982: RESOURCE_ASSIGNMENT_ID,

Line 4995: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

4991: FROM PA_FP_CALC_AMT_TMP1
4992: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,CBS_ELEMENT_ID,to_number(NULL));
4993: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
4994: -- hr_utility.trace('inside proj lvl in maintain res asg :');
4995: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
4996: TASK_ID,
4997: RESOURCE_LIST_MEMBER_ID,
4998: CBS_ELEMENT_ID,--bug#16791711
4999: RESOURCE_ASSIGNMENT_ID,

Line 5013: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

5009: group by 0, TARGET_RLM_ID,CBS_ELEMENT_ID,
5010: to_number(NULL) );
5011: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
5012: -- hr_utility.trace('inside top task in maintain res asg :');
5013: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
5014: TASK_ID,
5015: RESOURCE_LIST_MEMBER_ID,
5016: CBS_ELEMENT_ID,--bug#16791711
5017: RESOURCE_ASSIGNMENT_ID,

Line 5030: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;

5026: FROM PA_FP_CALC_AMT_TMP1 group by
5027: mapped_fin_task_id,TARGET_RLM_ID,CBS_ELEMENT_ID,
5028: to_number(NULL) );
5029: END IF;
5030: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;
5031: -- hr_utility.trace('in maintain res asg plan res tmp1 count :'||l_count);
5032: IF P_PA_DEBUG_MODE = 'Y' THEN
5033: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5034: P_MSG => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',