DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_GEN_FCST_AMT_PUB1

Line 795: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl

791: END IF;
792:
793: --Start Bug 5726785
794:
795: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl
796: (p_project_id => p_project_id
797: ,p_budget_version_id => p_budget_version_id
798: ,x_call_maintain_data_api => l_call_maintain_data_api
799: ,x_return_status => x_return_status

Line 822: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

818:
819: IF p_pa_debug_mode = 'Y' THEN
820: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
821: P_CALLED_MODE => P_CALLED_MODE,
822: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
823: 'MAINTAIN_BUDGET_VERSION',
824: P_MODULE_NAME => l_module_name);
825: END IF;
826: --dbms_output.put_line('++Before pub1.maintain_bv++');

Line 827: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION

823: 'MAINTAIN_BUDGET_VERSION',
824: P_MODULE_NAME => l_module_name);
825: END IF;
826: --dbms_output.put_line('++Before pub1.maintain_bv++');
827: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION
828: (P_PROJECT_ID => P_PROJECT_ID,
829: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
830: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
831: P_CALL_MAINTAIN_DATA_API => L_CALL_MAINTAIN_DATA_API,

Line 840: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

836: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
837: IF p_pa_debug_mode = 'Y' THEN
838: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
839: P_CALLED_MODE => P_CALLED_MODE,
840: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
841: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
842: P_MODULE_NAME => l_module_name);
843: END IF;
844: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1684: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

1680: /* When the task id is passed as NULL, the wrapper API generates
1681: the ETC numbers for all the target version planning resources
1682: based on the average value of the actual txn data. */
1683:
1684: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
1685: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1686: P_TASK_ID => NULL,
1687: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
1688: P_FP_COLS_REC => P_FP_COLS_REC,

Line 1830: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

1826:
1827: IF P_PA_DEBUG_MODE = 'Y' THEN
1828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1829: P_CALLED_MODE => P_CALLED_MODE,
1830: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1831: 'CALL_SUMM_POP_TMPS',
1832: P_MODULE_NAME => l_module_name);
1833: END IF;
1834:

Line 1841: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1837: hr_utility.trace('1.l_resource_list_id: '||l_resource_list_id);
1838: hr_utility.trace('1.l_struct_ver_id: '||l_struct_ver_id);
1839: hr_utility.trace('1.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1840:
1841: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1842: P_PROJECT_ID => P_PROJECT_ID,
1843: P_CALENDAR_TYPE => l_calendar_type,
1844: P_RECORD_TYPE => l_record_type,
1845: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 1856: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

1852: -- hr_utility.trace('1.Status after calling call_summ_pop_tmps api: '||x_return_status);
1853: IF P_PA_DEBUG_MODE = 'Y' THEN
1854: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1855: P_CALLED_MODE => P_CALLED_MODE,
1856: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1857: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1858: P_MODULE_NAME => l_module_name);
1859: END IF;
1860: --dbms_output.put_line('After calling pji api: '||x_return_status);

Line 1888: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

1884:
1885: IF P_PA_DEBUG_MODE = 'Y' THEN
1886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1887: P_CALLED_MODE => P_CALLED_MODE,
1888: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1889: 'CALL_SUMM_POP_TMPS',
1890: P_MODULE_NAME => l_module_name);
1891: END IF;
1892:

Line 1899: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1895: hr_utility.trace('2.l_resource_list_id: '||l_resource_list_id);
1896: hr_utility.trace('2.l_struct_ver_id: '||l_struct_ver_id);
1897: hr_utility.trace('2.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1898:
1899: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1900: P_PROJECT_ID => P_PROJECT_ID,
1901: P_CALENDAR_TYPE => l_calendar_type,
1902: P_RECORD_TYPE => l_record_type,
1903: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 1914: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

1910: -- hr_utility.trace('2.Status after calling call_summ_pop_tmps api: '||x_return_status);
1911: IF P_PA_DEBUG_MODE = 'Y' THEN
1912: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1913: P_CALLED_MODE => P_CALLED_MODE,
1914: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1915: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1916: P_MODULE_NAME => l_module_name);
1917: END IF;
1918: --dbms_output.put_line('After calling pji api: '||x_return_status);

Line 1942: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

1938: END IF;*/
1939: IF P_PA_DEBUG_MODE = 'Y' THEN
1940: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1941: P_CALLED_MODE => P_CALLED_MODE,
1942: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1943: 'CALL_SUMM_POP_TMPS',
1944: P_MODULE_NAME => l_module_name);
1945: END IF;
1946: /* hr_utility.trace('3.l_calendar_type: '||l_calendar_type);

Line 1951: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1947: hr_utility.trace('3.l_record_type: '||l_record_type);
1948: hr_utility.trace('3.l_resource_list_id: '||l_resource_list_id);
1949: hr_utility.trace('3.l_struct_ver_id: '||l_struct_ver_id);
1950: hr_utility.trace('3.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1951: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1952: P_PROJECT_ID => P_PROJECT_ID,
1953: P_CALENDAR_TYPE => l_calendar_type,
1954: P_RECORD_TYPE => l_record_type,
1955: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 1966: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

1962: -- hr_utility.trace('3.Status after calling call_summ_pop_tmps api: '||x_return_status);
1963: IF P_PA_DEBUG_MODE = 'Y' THEN
1964: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1965: P_CALLED_MODE => P_CALLED_MODE,
1966: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1967: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1968: P_MODULE_NAME => l_module_name);
1969: END IF;
1970: --dbms_output.put_line(' --After calling pji get_summarized api: '||x_return_status);

Line 2178: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||

2174: END IF;
2175: IF P_PA_DEBUG_MODE = 'Y' THEN
2176: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2177: P_CALLED_MODE => P_CALLED_MODE,
2178: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||
2179: 'GET_ETC_WORK_QTY_AMTS',
2180: P_MODULE_NAME => l_module_name);
2181: END IF;
2182: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and

Line 2184: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(

2180: P_MODULE_NAME => l_module_name);
2181: END IF;
2182: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and
2183: P_RESOURCE_LIST_MEMBER_ID are not needed*/
2184: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(
2185: P_PROJECT_ID => P_PROJECT_ID,
2186: P_PROJ_CURRENCY_CODE => P_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
2187: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2188: P_TASK_ID => l_curr_task_id,

Line 2199: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||

2195: X_MSG_DATA => x_msg_data);
2196: IF p_pa_debug_mode = 'Y' THEN
2197: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2198: P_CALLED_MODE => P_CALLED_MODE,
2199: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2200: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,
2201: P_MODULE_NAME => l_module_name);
2202: END IF;
2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',

2207: ELSIF l_curr_etc_source = 'NONE' THEN
2208: IF P_PA_DEBUG_MODE = 'Y' THEN
2209: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2210: P_CALLED_MODE => P_CALLED_MODE,
2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2212: P_MODULE_NAME => l_module_name);
2213: END IF;
2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2215: P_PROJECT_ID => P_PROJECT_ID,

Line 2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(

2210: P_CALLED_MODE => P_CALLED_MODE,
2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2212: P_MODULE_NAME => l_module_name);
2213: END IF;
2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2215: P_PROJECT_ID => P_PROJECT_ID,
2216: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2217: P_RESOURCE_LIST_ID => l_fp_cols_rec_target.X_RESOURCE_LIST_ID,
2218: P_TASK_ID => l_curr_task_id,

Line 2342: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

2338: hr_utility.trace('P_ACTUALS_FROM_PERIOD: '||P_ACTUALS_FROM_PERIOD);
2339: hr_utility.trace('P_ACTUALS_TO_PERIOD: '||P_ACTUALS_TO_PERIOD);
2340: hr_utility.trace('P_ETC_FROM_PERIOD: '||P_ETC_FROM_PERIOD);
2341: hr_utility.trace('P_ETC_TO_PERIOD: '||P_ETC_TO_PERIOD); */
2342: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
2343: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2344: P_TASK_ID => l_avg_actuals_task_id_tab(i),
2345: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
2346: P_FP_COLS_REC => P_FP_COLS_REC,

Line 3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',

3786: IF P_PA_DEBUG_MODE = 'Y' THEN
3787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3788: P_CALLED_MODE => P_CALLED_MODE,
3789: P_MSG =>
3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
3791: P_MODULE_NAME => l_module_name);
3792: END IF;
3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
3794: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),

Line 3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE

3789: P_MSG =>
3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
3791: P_MODULE_NAME => l_module_name);
3792: END IF;
3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
3794: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),
3795: P_TARGET_RES_ASG_ID => l_cal_ra_id_tab(i),
3796: P_TXN_CURRENCY_CODE => l_cal_txn_currency_code_tab(i),
3797: X_RETURN_STATUS => x_return_status,

Line 3807: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,

3803: IF P_PA_DEBUG_MODE = 'Y' THEN
3804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3805: P_CALLED_MODE => P_CALLED_MODE,
3806: P_MSG =>
3807: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,
3808: P_MODULE_NAME => l_module_name);
3809: END IF;
3810:
3811: /* Populate the period rates table for the Client Extension API */

Line 3920: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate

3916: END IF;
3917: /*For client_extn, many attributes are passed as NULL is because
3918: this API is still under developmen and some parameters are not
3919: available.Null values will be replaced later*/
3920: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate
3921: pa_fp_gen_rate_tmp, which is used to populate input parameter
3922: P_PERIOD_RATES_TBL */
3923:
3924: -- hr_utility.trace('==before calling client extn api ');