DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_FP_GEN_FCST_AMT_PUB

Line 20: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

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,
20: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_MSG_COUNT OUT NOCOPY NUMBER,
23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:

Line 25: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.get_total_plan_txn_amts';

21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_MSG_COUNT OUT NOCOPY NUMBER,
23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:
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 */

Line 1284: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';

1280: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1281: X_MSG_COUNT OUT NOCOPY NUMBER,
1282: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1283:
1284: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1285:
1286: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1287: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1288: l_sysdate DATE := SYSDATE;

Line 1354: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

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,
1356: X_MSG_COUNT OUT NOCOPY NUMBER,
1357: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1358:

Line 1359: L_MODULE_NAME VARCHAR2(200) := 'PA.PLSQL.PA_FP_GEN_FCST_AMT_PUB.GET_ACTUAL_TXN_AMOUNT';

1355: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1356: X_MSG_COUNT OUT NOCOPY NUMBER,
1357: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1358:
1359: L_MODULE_NAME VARCHAR2(200) := 'PA.PLSQL.PA_FP_GEN_FCST_AMT_PUB.GET_ACTUAL_TXN_AMOUNT';
1360: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1361:
1362: L_RATE_BASED_FLAG VARCHAR2(1);
1363: /*'TC' REPRESENTS TXN CURRENCY CODE

Line 2018: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;

2014: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
2015: AND adjustment_period_flag = 'N';
2016:
2017: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
2018: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
2019: l_future_no_of_period NUMBER;
2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
2022: