APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_PROJ_FP_OPTIONS

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

855: * -- The structure must be fully shared in this case.
856: *
857: **/
858: PROCEDURE MAINTAIN_ACTUAL_AMT_RA
859: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
860: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
861: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
862: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
863: P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,

Line 960: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

956: l_spread_curve_code PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE;
957:
958: l_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
959:
960: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
961:
962: /* Variables for Bug 4142150 */
963:
964: l_open_pd_plan_amt_flag VARCHAR2(1);

Line 993: l_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;

989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
992:
993: l_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
994:
995: BEGIN
996: --Setting initial values
997: X_MSG_COUNT := 0;

Line 1075: FROM pa_proj_fp_options opt

1071: 'REVENUE', opt.gen_rev_ret_manual_line_flag,
1072: 'ALL', opt.gen_all_ret_manual_line_flag)
1073: INTO l_time_phased_code,
1074: l_ret_manual_line_flag
1075: FROM pa_proj_fp_options opt
1076: WHERE opt.fin_plan_version_id = p_budget_version_id;
1077:
1078: /* Initialize l_open_pd_plan_amt_flag */
1079: IF l_time_phased_code IN ('P','G') THEN