APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PJI_FM_XBS_ACCUM_TMP1

Line 801: --Calling PJI API to get table pji_fm_xbs_accum_tmp1 populated

797: p_module_name => l_module_name,
798: p_log_level => 5);
799: END IF;
800: --dbms_output.put_line('Before calling pji api');
801: --Calling PJI API to get table pji_fm_xbs_accum_tmp1 populated
802: PJI_FM_XBS_ACCUM_UTILS.get_summarized_data(
803: p_project_ids => l_project_id_tab,
804: p_resource_list_ids => l_resource_list_id_tab,
805: p_struct_ver_ids => l_struct_ver_id_tab,

Line 824: select count(*) into l_count from PJI_FM_XBS_ACCUM_TMP1;

820: return status is:'||x_return_status,
821: p_module_name => l_module_name,
822: p_log_level => 5);
823: END IF;
824: select count(*) into l_count from PJI_FM_XBS_ACCUM_TMP1;
825: --hr_utility.trace('CALLSUM: After calling pji api, PJI_FM_XBS_ACCUM_TMP1 has:'|| l_count);
826: --hr_utility.trace('CALLSUM: After calling pji api: '||x_return_status);
827: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
828: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 825: --hr_utility.trace('CALLSUM: After calling pji api, PJI_FM_XBS_ACCUM_TMP1 has:'|| l_count);

821: p_module_name => l_module_name,
822: p_log_level => 5);
823: END IF;
824: select count(*) into l_count from PJI_FM_XBS_ACCUM_TMP1;
825: --hr_utility.trace('CALLSUM: After calling pji api, PJI_FM_XBS_ACCUM_TMP1 has:'|| l_count);
826: --hr_utility.trace('CALLSUM: After calling pji api: '||x_return_status);
827: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
828: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
829: END IF;

Line 831: /* Update rlm_id for all rows in pji_fm_xbs_accum_tmp1 if the resource list

827: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
828: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
829: END IF;
830:
831: /* Update rlm_id for all rows in pji_fm_xbs_accum_tmp1 if the resource list
832: * (p_fp_cols_rec.X_RESOURCE_LIST_ID) is None - Uncategorized.
833: * This logic is not handled by the PJI generic resource mapping API. */
834:
835: SELECT NVL(uncategorized_flag,'N')

Line 845: UPDATE pji_fm_xbs_accum_tmp1

841: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (
842: p_project_id => p_project_id,
843: p_resource_list_id => p_resource_list_id,
844: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
845: UPDATE pji_fm_xbs_accum_tmp1
846: SET res_list_member_id = l_rlm_id;
847: END IF;
848:
849: INSERT INTO PA_FP_FCST_GEN_TMP1 (

Line 954: FROM PJI_FM_XBS_ACCUM_TMP1 );

950: LABOR_HOURS,
951: EQUIPMENT_HOURS,
952: SOURCE_ID,
953: P_DATA_TYPE_CODE
954: FROM PJI_FM_XBS_ACCUM_TMP1 );
955: IF p_pa_debug_mode = 'Y' THEN
956: PA_DEBUG.Reset_Curr_Function;
957: END IF;
958: EXCEPTION