APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_PROJ_FP_OPTIONS

Line 7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE GEN_COMMITMENT_AMOUNTS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
11: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 18: CURSOR SUM_COMM_CRSR( c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE

14: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
15:
16: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_COMMITMENT_AMOUNTS.GEN_COMMITMENT_AMOUNTS';
17:
18: CURSOR SUM_COMM_CRSR( c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE
19: ,c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE
20: ,c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE
21: ,c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE
22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE

Line 19: ,c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE

15:
16: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_COMMITMENT_AMOUNTS.GEN_COMMITMENT_AMOUNTS';
17:
18: CURSOR SUM_COMM_CRSR( c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE
19: ,c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE
20: ,c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE
21: ,c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE
22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE
23: )

Line 239: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

235: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
236: l_calling_context VARCHAR2(30);
237:
238: /* Variables added for Bug 4549862 */
239: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
240: l_cost_based_all_from_sp_flag VARCHAR2(1);
241:
242: -- Bug 4549862: GEN_COST_BASED_REVENUE expects the BILLABLE_FLAG and
243: -- BUDGET_LINE_ID columns of the PA_FP_ROLLUP_TMP to be populated.