DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_FP_GEN_FCST_AMT_PUB

Line 19: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

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

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

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

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

1267: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1268: X_MSG_COUNT OUT NOCOPY NUMBER,
1269: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1270:
1271: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1272:
1273: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1274: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1275: l_sysdate DATE := SYSDATE;

Line 1340: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

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,
1342: X_MSG_COUNT OUT NOCOPY NUMBER,
1343: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1344:

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

1341: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1342: X_MSG_COUNT OUT NOCOPY NUMBER,
1343: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1344:
1345: L_MODULE_NAME VARCHAR2(200) := 'PA.PLSQL.PA_FP_GEN_FCST_AMT_PUB.GET_ACTUAL_TXN_AMOUNT';
1346: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1347:
1348: L_RATE_BASED_FLAG VARCHAR2(1);
1349: /*'TC' REPRESENTS TXN CURRENCY CODE

Line 1987: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;

1983: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1984: AND adjustment_period_flag = 'N';
1985:
1986: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
1987: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
1988: l_future_no_of_period NUMBER;
1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
1991: