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_GEN_FCST_AMT_PVT dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

9: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
11: P_BV_ID_ETC_WP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
17: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,

Line 14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
11: P_BV_ID_ETC_WP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
17: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
18: P_CALLING_CONTEXT IN VARCHAR2,

Line 15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

11: P_BV_ID_ETC_WP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
17: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
18: P_CALLING_CONTEXT IN VARCHAR2,
19: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

Line 28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */

24: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.get_total_plan_txn_amts';
25:
26: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
27:
28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;

Line 30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;

26: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
27:
28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */

Line 31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;

27:
28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */

Line 32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;

28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

Line 33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;

29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;

Line 842: pa_fp_gen_amount_utils.fp_debug

838:
839: FOR i IN 1..l_res_asg_id_tab.count LOOP
840: --Calling the Get_values_for_planning_Rate api
841: IF p_pa_debug_mode = 'Y' THEN
842: pa_fp_gen_amount_utils.fp_debug
843: (p_called_mode => p_calling_context,
844: p_msg => 'Before calling
845: pa_fp_gen_amount_utils.get_values_for_planning_rate',
846: p_module_name => l_module_name,

Line 845: pa_fp_gen_amount_utils.get_values_for_planning_rate',

841: IF p_pa_debug_mode = 'Y' THEN
842: pa_fp_gen_amount_utils.fp_debug
843: (p_called_mode => p_calling_context,
844: p_msg => 'Before calling
845: pa_fp_gen_amount_utils.get_values_for_planning_rate',
846: p_module_name => l_module_name,
847: p_log_level => 5);
848: END IF;
849: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE

Line 849: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE

845: pa_fp_gen_amount_utils.get_values_for_planning_rate',
846: p_module_name => l_module_name,
847: p_log_level => 5);
848: END IF;
849: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE
850: (p_project_id => p_project_id,
851: p_budget_version_id => p_budget_version_id,
852: p_resource_assignment_id => l_res_asg_id_tab(i),
853: p_task_id => p_task_id,

Line 868: pa_fp_gen_amount_utils.fp_debug

864: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
865: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
866: END IF;
867: IF p_pa_debug_mode = 'Y' THEN
868: pa_fp_gen_amount_utils.fp_debug
869: (p_called_mode => p_calling_context,
870: p_msg => 'Status after calling
871: pa_fp_gen_amount_utils.
872: get_values_for_planning_rate'

Line 871: pa_fp_gen_amount_utils.

867: IF p_pa_debug_mode = 'Y' THEN
868: pa_fp_gen_amount_utils.fp_debug
869: (p_called_mode => p_calling_context,
870: p_msg => 'Status after calling
871: pa_fp_gen_amount_utils.
872: get_values_for_planning_rate'
873: ||x_return_status,
874: p_module_name => l_module_name,
875: p_log_level => 5);

Line 935: pa_fp_gen_amount_utils.fp_debug

931: END IF;
932:
933: --Calling the Get_planning_Rates api
934: IF p_pa_debug_mode = 'Y' THEN
935: pa_fp_gen_amount_utils.fp_debug
936: (p_called_mode => p_calling_context,
937: p_msg => 'Before calling
938: pa_plan_revenue.Get_planning_Rates',
939: p_module_name => l_module_name,

Line 1036: pa_fp_gen_amount_utils.fp_debug

1032: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1033: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1034: END IF;
1035: IF p_pa_debug_mode = 'Y' THEN
1036: pa_fp_gen_amount_utils.fp_debug
1037: (p_called_mode => p_calling_context,
1038: p_msg => 'Status after calling
1039: pa_plan_revenue.Get_planning_Rates'
1040: ||x_return_status,

Line 1070: pa_fp_gen_amount_utils.fp_debug

1066: l_cost_txn_curr_code <>
1067: p_fp_cols_rec.X_PROJECT_CURRENCY_CODE THEN
1068: --Calling the conv_mc_bulk api
1069: IF p_pa_debug_mode = 'Y' THEN
1070: pa_fp_gen_amount_utils.fp_debug
1071: (p_called_mode => p_calling_context,
1072: p_msg => 'Before calling
1073: pa_fp_multi_currency_pkg.conv_mc_bulk',
1074: p_module_name => l_module_name,

Line 1148: pa_fp_gen_amount_utils.fp_debug

1144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1146: END IF;
1147: IF p_pa_debug_mode = 'Y' THEN
1148: pa_fp_gen_amount_utils.fp_debug
1149: (p_called_mode => p_calling_context,
1150: p_msg => 'Status after calling
1151: pa_fp_multi_currency_pkg.conv_mc_bulk: '
1152: ||x_return_status,

Line 1210: pa_fp_gen_amount_utils.fp_debug

1206: EXCEPTION
1207: WHEN NO_DATA_FOUND THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: IF P_PA_DEBUG_MODE = 'Y' THEN
1210: pa_fp_gen_amount_utils.fp_debug
1211: (p_called_mode => p_calling_context,
1212: p_msg => 'Invalid Resource assignment Id',
1213: p_module_name => l_module_name,
1214: p_log_level => 5);

Line 1238: pa_fp_gen_amount_utils.fp_debug

1234: ROLLBACK;
1235:
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: IF P_PA_DEBUG_MODE = 'Y' THEN
1238: pa_fp_gen_amount_utils.fp_debug
1239: (p_called_mode => p_calling_context,
1240: p_msg => 'Invalid Arguments Passed',
1241: p_module_name => l_module_name,
1242: p_log_level => 5);

Line 1254: pa_fp_gen_amount_utils.fp_debug

1250: FND_MSG_PUB.add_exc_msg
1251: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1252: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');
1253: IF P_PA_DEBUG_MODE = 'Y' THEN
1254: pa_fp_gen_amount_utils.fp_debug
1255: (p_called_mode => p_calling_context,
1256: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1257: p_module_name => l_module_name,
1258: p_log_level => 5);

Line 1321: pa_fp_gen_amount_utils.fp_debug

1317: FND_MSG_PUB.add_exc_msg
1318: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1319: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');
1320: IF P_PA_DEBUG_MODE = 'Y' THEN
1321: pa_fp_gen_amount_utils.fp_debug
1322: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1323: p_module_name => l_module_name,
1324: p_log_level => 5);
1325: PA_DEBUG.Reset_Curr_Function;

Line 1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,
1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1338: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1339: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1340: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1341: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1926: pa_fp_gen_amount_utils.fp_debug

1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN
1924: x_return_status := FND_API.G_RET_STS_ERROR;
1925: IF P_PA_DEBUG_MODE = 'Y' THEN
1926: pa_fp_gen_amount_utils.fp_debug
1927: (p_msg => 'Invalid Resource assignment Id',
1928: p_module_name => l_module_name,
1929: p_log_level => 5);
1930: PA_DEBUG.Reset_Curr_Function;

Line 1941: pa_fp_gen_amount_utils.fp_debug

1937: FND_MSG_PUB.add_exc_msg
1938: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1939: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');
1940: IF P_PA_DEBUG_MODE = 'Y' THEN
1941: pa_fp_gen_amount_utils.fp_debug
1942: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1943: p_module_name => l_module_name,
1944: p_log_level => 5);
1945: PA_DEBUG.Reset_Curr_Function;

Line 1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1956: P_CURRENCY_FLAG IN VARCHAR2,
1957: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1958: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1959: P_ACTUALS_THRU_DATE IN DATE,
1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

Line 2120: pa_fp_gen_amount_utils.fp_debug

2116:
2117: /* Calling the get actual txn amt api to get
2118: the sum of init qty,cost and rev for the given period */
2119: IF p_pa_debug_mode = 'Y' THEN
2120: pa_fp_gen_amount_utils.fp_debug
2121: (p_msg => 'Before calling
2122: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'
2123: ||'P_RES_ASG_ID:'||l_res_asg_id
2124: ||';P_ACTUAL_FROM_DATE:'||l_actual_from_date

Line 2148: pa_fp_gen_amount_utils.fp_debug

2144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2146: END IF;
2147: IF p_pa_debug_mode = 'Y' THEN
2148: pa_fp_gen_amount_utils.fp_debug
2149: (p_msg => 'Status after calling
2150: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '
2151: ||x_return_status,
2152: p_module_name => l_module_name,

Line 2194: pa_fp_gen_amount_utils.fp_debug

2190: l_quantity_sum := (l_txn_amt_rec.quantity_sum/l_txn_amt_rec.no_of_periods);
2191: END IF;
2192:
2193: IF p_pa_debug_mode = 'Y' THEN
2194: pa_fp_gen_amount_utils.fp_debug
2195: (p_msg => '===in average_of_actuals,l_txn_amt_rec.no_of_periods:'
2196: ||l_txn_amt_rec.no_of_periods||';l_txn_amt_rec.txn_raw_cost_sum:'
2197: ||l_txn_amt_rec.txn_raw_cost_sum||';l_txn_amt_rec.txn_burdened_cost_sum:'
2198: ||l_txn_amt_rec.txn_burdened_cost_sum||';l_txn_amt_rec.txn_revenue_sum:'

Line 2270: pa_fp_gen_amount_utils.fp_debug

2266:
2267:
2268: --Calling the maintain actual amt ra api
2269: IF p_pa_debug_mode = 'Y' THEN
2270: pa_fp_gen_amount_utils.fp_debug
2271: (p_msg => 'Before calling
2272: pa_fp_maintain_actual_pub.maintain_actual_amt_ra',
2273: p_module_name => l_module_name,
2274: p_log_level => 5);

Line 2291: pa_fp_gen_amount_utils.fp_debug

2287: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2288: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2289: END IF;
2290: IF p_pa_debug_mode = 'Y' THEN
2291: pa_fp_gen_amount_utils.fp_debug
2292: (p_msg => 'Status after calling
2293: pa_fp_maintain_actual_pub.maintain_actual_amt_ra: '
2294: ||x_return_status,
2295: p_module_name => l_module_name,

Line 2323: pa_fp_gen_amount_utils.fp_debug

2319: ROLLBACK;
2320:
2321: x_return_status := FND_API.G_RET_STS_ERROR;
2322: IF P_PA_DEBUG_MODE = 'Y' THEN
2323: pa_fp_gen_amount_utils.fp_debug
2324: (p_msg => 'Invalid Arguments Passed',
2325: p_module_name => l_module_name,
2326: p_log_level => 5);
2327: PA_DEBUG.Reset_Curr_Function;

Line 2337: pa_fp_gen_amount_utils.fp_debug

2333: FND_MSG_PUB.add_exc_msg
2334: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2335: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');
2336: IF P_PA_DEBUG_MODE = 'Y' THEN
2337: pa_fp_gen_amount_utils.fp_debug
2338: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2339: p_module_name => l_module_name,
2340: p_log_level => 5);
2341: PA_DEBUG.Reset_Curr_Function;

Line 2359: (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2355: * based flag of 'N', target res asg will be updated to
2356: * non rate based. And for this target res asg, all existing
2357: * budget lines will be updated accordingly. **/
2358: PROCEDURE UPD_TGT_RATE_BASED_FLAG
2359: (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2361: X_MSG_COUNT OUT NOCOPY NUMBER,
2362: X_MSG_DATA OUT NOCOPY VARCHAR2)
2363: IS

Line 2414: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date

2410: AND tmp.rate_based_flag = 'N';
2411:
2412: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
2413: If p_fp_cols_rec.x_time_phased_code IN ('P','G') then
2414: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date
2415: ( p_fp_cols_rec.x_budget_version_id );
2416:
2417: -- SQL Repository Bug 4884824; SQL ID 14902422
2418: -- Fixed Full Index Scan violation by replacing