DBA Data[Home] [Help]

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_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007

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_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007
18: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,

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_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007
18: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
19: P_CALLING_CONTEXT IN VARCHAR2,

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

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

Line 31: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;

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

Line 32: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;

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

Line 33: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;

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

Line 34: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;

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

Line 855: pa_fp_gen_amount_utils.fp_debug

851:
852: FOR i IN 1..l_res_asg_id_tab.count LOOP
853: --Calling the Get_values_for_planning_Rate api
854: IF p_pa_debug_mode = 'Y' THEN
855: pa_fp_gen_amount_utils.fp_debug
856: (p_called_mode => p_calling_context,
857: p_msg => 'Before calling
858: pa_fp_gen_amount_utils.get_values_for_planning_rate',
859: p_module_name => l_module_name,

Line 858: pa_fp_gen_amount_utils.get_values_for_planning_rate',

854: IF p_pa_debug_mode = 'Y' THEN
855: pa_fp_gen_amount_utils.fp_debug
856: (p_called_mode => p_calling_context,
857: p_msg => 'Before calling
858: pa_fp_gen_amount_utils.get_values_for_planning_rate',
859: p_module_name => l_module_name,
860: p_log_level => 5);
861: END IF;
862: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE

Line 862: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE

858: pa_fp_gen_amount_utils.get_values_for_planning_rate',
859: p_module_name => l_module_name,
860: p_log_level => 5);
861: END IF;
862: PA_FP_GEN_AMOUNT_UTILS.GET_VALUES_FOR_PLANNING_RATE
863: (p_project_id => p_project_id,
864: p_budget_version_id => p_budget_version_id,
865: p_resource_assignment_id => l_res_asg_id_tab(i),
866: p_task_id => p_task_id,

Line 881: pa_fp_gen_amount_utils.fp_debug

877: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
878: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
879: END IF;
880: IF p_pa_debug_mode = 'Y' THEN
881: pa_fp_gen_amount_utils.fp_debug
882: (p_called_mode => p_calling_context,
883: p_msg => 'Status after calling
884: pa_fp_gen_amount_utils.
885: get_values_for_planning_rate'

Line 884: pa_fp_gen_amount_utils.

880: IF p_pa_debug_mode = 'Y' THEN
881: pa_fp_gen_amount_utils.fp_debug
882: (p_called_mode => p_calling_context,
883: p_msg => 'Status after calling
884: pa_fp_gen_amount_utils.
885: get_values_for_planning_rate'
886: ||x_return_status,
887: p_module_name => l_module_name,
888: p_log_level => 5);

Line 948: pa_fp_gen_amount_utils.fp_debug

944: END IF;
945:
946: --Calling the Get_planning_Rates api
947: IF p_pa_debug_mode = 'Y' THEN
948: pa_fp_gen_amount_utils.fp_debug
949: (p_called_mode => p_calling_context,
950: p_msg => 'Before calling
951: pa_plan_revenue.Get_planning_Rates',
952: p_module_name => l_module_name,

Line 1049: pa_fp_gen_amount_utils.fp_debug

1045: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1046: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1047: END IF;
1048: IF p_pa_debug_mode = 'Y' THEN
1049: pa_fp_gen_amount_utils.fp_debug
1050: (p_called_mode => p_calling_context,
1051: p_msg => 'Status after calling
1052: pa_plan_revenue.Get_planning_Rates'
1053: ||x_return_status,

Line 1083: pa_fp_gen_amount_utils.fp_debug

1079: l_cost_txn_curr_code <>
1080: p_fp_cols_rec.X_PROJECT_CURRENCY_CODE THEN
1081: --Calling the conv_mc_bulk api
1082: IF p_pa_debug_mode = 'Y' THEN
1083: pa_fp_gen_amount_utils.fp_debug
1084: (p_called_mode => p_calling_context,
1085: p_msg => 'Before calling
1086: pa_fp_multi_currency_pkg.conv_mc_bulk',
1087: p_module_name => l_module_name,

Line 1161: pa_fp_gen_amount_utils.fp_debug

1157: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1158: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1159: END IF;
1160: IF p_pa_debug_mode = 'Y' THEN
1161: pa_fp_gen_amount_utils.fp_debug
1162: (p_called_mode => p_calling_context,
1163: p_msg => 'Status after calling
1164: pa_fp_multi_currency_pkg.conv_mc_bulk: '
1165: ||x_return_status,

Line 1223: pa_fp_gen_amount_utils.fp_debug

1219: EXCEPTION
1220: WHEN NO_DATA_FOUND THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: IF P_PA_DEBUG_MODE = 'Y' THEN
1223: pa_fp_gen_amount_utils.fp_debug
1224: (p_called_mode => p_calling_context,
1225: p_msg => 'Invalid Resource assignment Id',
1226: p_module_name => l_module_name,
1227: p_log_level => 5);

Line 1251: pa_fp_gen_amount_utils.fp_debug

1247: ROLLBACK;
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: IF P_PA_DEBUG_MODE = 'Y' THEN
1251: pa_fp_gen_amount_utils.fp_debug
1252: (p_called_mode => p_calling_context,
1253: p_msg => 'Invalid Arguments Passed',
1254: p_module_name => l_module_name,
1255: p_log_level => 5);

Line 1267: pa_fp_gen_amount_utils.fp_debug

1263: FND_MSG_PUB.add_exc_msg
1264: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1265: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');
1266: IF P_PA_DEBUG_MODE = 'Y' THEN
1267: pa_fp_gen_amount_utils.fp_debug
1268: (p_called_mode => p_calling_context,
1269: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1270: p_module_name => l_module_name,
1271: p_log_level => 5);

Line 1334: pa_fp_gen_amount_utils.fp_debug

1330: FND_MSG_PUB.add_exc_msg
1331: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1332: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');
1333: IF P_PA_DEBUG_MODE = 'Y' THEN
1334: pa_fp_gen_amount_utils.fp_debug
1335: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1336: p_module_name => l_module_name,
1337: p_log_level => 5);
1338: PA_DEBUG.Reset_Curr_Function;

Line 1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,
1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1352: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1353: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1354: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1355: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1956: pa_fp_gen_amount_utils.fp_debug

1952: EXCEPTION
1953: WHEN NO_DATA_FOUND THEN
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: IF P_PA_DEBUG_MODE = 'Y' THEN
1956: pa_fp_gen_amount_utils.fp_debug
1957: (p_msg => 'Invalid Resource assignment Id',
1958: p_module_name => l_module_name,
1959: p_log_level => 5);
1960: PA_DEBUG.Reset_Curr_Function;

Line 1971: pa_fp_gen_amount_utils.fp_debug

1967: FND_MSG_PUB.add_exc_msg
1968: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1969: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');
1970: IF P_PA_DEBUG_MODE = 'Y' THEN
1971: pa_fp_gen_amount_utils.fp_debug
1972: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1973: p_module_name => l_module_name,
1974: p_log_level => 5);
1975: PA_DEBUG.Reset_Curr_Function;

Line 1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1987: P_CURRENCY_FLAG IN VARCHAR2,
1988: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1989: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1990: P_ACTUALS_THRU_DATE IN DATE,
1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

Line 2152: pa_fp_gen_amount_utils.fp_debug

2148:
2149: /* Calling the get actual txn amt api to get
2150: the sum of init qty,cost and rev for the given period */
2151: IF p_pa_debug_mode = 'Y' THEN
2152: pa_fp_gen_amount_utils.fp_debug
2153: (p_msg => 'Before calling
2154: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'
2155: ||'P_RES_ASG_ID:'||l_res_asg_id
2156: ||';P_ACTUAL_FROM_DATE:'||l_actual_from_date

Line 2181: pa_fp_gen_amount_utils.fp_debug

2177: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2178: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2179: END IF;
2180: IF p_pa_debug_mode = 'Y' THEN
2181: pa_fp_gen_amount_utils.fp_debug
2182: (p_msg => 'Status after calling
2183: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '
2184: ||x_return_status,
2185: p_module_name => l_module_name,

Line 2227: pa_fp_gen_amount_utils.fp_debug

2223: l_quantity_sum := (l_txn_amt_rec.quantity_sum/l_txn_amt_rec.no_of_periods);
2224: END IF;
2225:
2226: IF p_pa_debug_mode = 'Y' THEN
2227: pa_fp_gen_amount_utils.fp_debug
2228: (p_msg => '===in average_of_actuals,l_txn_amt_rec.no_of_periods:'
2229: ||l_txn_amt_rec.no_of_periods||';l_txn_amt_rec.txn_raw_cost_sum:'
2230: ||l_txn_amt_rec.txn_raw_cost_sum||';l_txn_amt_rec.txn_burdened_cost_sum:'
2231: ||l_txn_amt_rec.txn_burdened_cost_sum||';l_txn_amt_rec.txn_revenue_sum:'

Line 2303: pa_fp_gen_amount_utils.fp_debug

2299:
2300:
2301: --Calling the maintain actual amt ra api
2302: IF p_pa_debug_mode = 'Y' THEN
2303: pa_fp_gen_amount_utils.fp_debug
2304: (p_msg => 'Before calling
2305: pa_fp_maintain_actual_pub.maintain_actual_amt_ra',
2306: p_module_name => l_module_name,
2307: p_log_level => 5);

Line 2324: pa_fp_gen_amount_utils.fp_debug

2320: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2322: END IF;
2323: IF p_pa_debug_mode = 'Y' THEN
2324: pa_fp_gen_amount_utils.fp_debug
2325: (p_msg => 'Status after calling
2326: pa_fp_maintain_actual_pub.maintain_actual_amt_ra: '
2327: ||x_return_status,
2328: p_module_name => l_module_name,

Line 2356: pa_fp_gen_amount_utils.fp_debug

2352: ROLLBACK;
2353:
2354: x_return_status := FND_API.G_RET_STS_ERROR;
2355: IF P_PA_DEBUG_MODE = 'Y' THEN
2356: pa_fp_gen_amount_utils.fp_debug
2357: (p_msg => 'Invalid Arguments Passed',
2358: p_module_name => l_module_name,
2359: p_log_level => 5);
2360: PA_DEBUG.Reset_Curr_Function;

Line 2370: pa_fp_gen_amount_utils.fp_debug

2366: FND_MSG_PUB.add_exc_msg
2367: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2368: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');
2369: IF P_PA_DEBUG_MODE = 'Y' THEN
2370: pa_fp_gen_amount_utils.fp_debug
2371: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2372: p_module_name => l_module_name,
2373: p_log_level => 5);
2374: PA_DEBUG.Reset_Curr_Function;

Line 2392: (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2388: * based flag of 'N', target res asg will be updated to
2389: * non rate based. And for this target res asg, all existing
2390: * budget lines will be updated accordingly. **/
2391: PROCEDURE UPD_TGT_RATE_BASED_FLAG
2392: (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2393: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2394: X_MSG_COUNT OUT NOCOPY NUMBER,
2395: X_MSG_DATA OUT NOCOPY VARCHAR2)
2396: IS

Line 2447: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date

2443: AND tmp.rate_based_flag = 'N';
2444:
2445: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
2446: If p_fp_cols_rec.x_time_phased_code IN ('P','G') then
2447: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date
2448: ( p_fp_cols_rec.x_budget_version_id );
2449:
2450: -- SQL Repository Bug 4884824; SQL ID 14902422
2451: -- Fixed Full Index Scan violation by replacing