APPS.PA_FP_REV_GEN_PUB dependencies on PA_BUDGET_VERSIONS

Line 7: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE GEN_COST_BASED_REVENUE
7: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
9: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
10: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
11: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 9: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

5:
6: PROCEDURE GEN_COST_BASED_REVENUE
7: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
9: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
10: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
11: X_MSG_COUNT OUT NOCOPY NUMBER,
12: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
13:

Line 18: l_pfc_burdened_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE := 0;

14: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_REV_GEN_PUB.GEN_COST_BASED_REVENUE';
15:
16: l_pfc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
17: l_pc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
18: l_pfc_burdened_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE := 0;
19: l_pfc_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE := 0;
20: l_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
21: l_rev NUMBER;
22: l_running_rev NUMBER := 0;

Line 19: l_pfc_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE := 0;

15:
16: l_pfc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
17: l_pc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
18: l_pfc_burdened_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE := 0;
19: l_pfc_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE := 0;
20: l_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
21: l_rev NUMBER;
22: l_running_rev NUMBER := 0;
23: l_diff NUMBER;

Line 30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;

26: l_msg_data VARCHAR2(2000);
27: l_data VARCHAR2(2000);
28: l_msg_index_out NUMBER:=0;
29:
30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;
31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;
55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

Line 59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

Line 61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
64:
65: l_cost_or_rev_code VARCHAR2(30) := 'COST';

Line 162: FROM PA_BUDGET_VERSIONS bv,

158: END IF;
159:
160: SELECT fpt.PLAN_CLASS_CODE
161: INTO l_plan_class_code
162: FROM PA_BUDGET_VERSIONS bv,
163: PA_FIN_PLAN_TYPES_B fpt
164: WHERE bv.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
165: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
166:

Line 302: FROM PA_BUDGET_VERSIONS

298: NVL(APPROVED_REV_PLAN_TYPE_FLAG, 'N')
299: INTO
300: l_appr_cost_plan_type_flag,
301: l_appr_rev_plan_type_flag
302: FROM PA_BUDGET_VERSIONS
303: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
304:
305: IF l_appr_cost_plan_type_flag = 'Y' OR
306: l_appr_rev_plan_type_flag = 'Y' THEN

Line 415: FROM PA_BUDGET_VERSIONS

411: SELECT NVL(REVENUE,0),
412: NVL(TOTAL_PROJECT_REVENUE,0)
413: INTO l_pfc_project_value,
414: l_pc_project_value
415: FROM PA_BUDGET_VERSIONS
416: WHERE BUDGET_VERSION_ID = l_approved_fp_version_id;
417: END IF;
418: END IF;
419: END IF;

Line 1617: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1613: * This API should always be called by GEN_COST_BASED_REVENUE before
1614: * returning with return status of Success.
1615: **/
1616: PROCEDURE PUSH_RES_SCH_DATA_TO_BL
1617: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1618: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1619: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
1620: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
1621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1619: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

1615: **/
1616: PROCEDURE PUSH_RES_SCH_DATA_TO_BL
1617: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1618: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1619: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
1620: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
1621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1622: X_MSG_COUNT OUT NOCOPY NUMBER,
1623: X_MSG_DATA OUT NOCOPY VARCHAR2) IS