eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 6: FUNCTION GET_REV_GEN_METHOD( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE)

2: /* $Header: PAFPGFPB.pls 120.10 2007/11/27 11:34:27 vgovvala ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: FUNCTION GET_REV_GEN_METHOD( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE)
7: RETURN VARCHAR2 IS
8:
9: x_rev_gen_method VARCHAR2(3);
10: l_error_msg VARCHAR2(30);

Line 817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

813: **/
814: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
815: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

815: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

Line 820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

Line 821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

Line 822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

Line 823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

Line 824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

Line 826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
829: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
830: P_ACTUALS_TO_PERIOD IN VARCHAR2,

Line 827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
829: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
830: P_ACTUALS_TO_PERIOD IN VARCHAR2,
831: P_ETC_FROM_PERIOD IN VARCHAR2,

Line 844: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

840: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
841:
842: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
843: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
844: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
845: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
846: l_return_status VARCHAR2(10);
847: l_msg_count NUMBER;
848: l_msg_data VARCHAR2(2000);

Line 845: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

841:
842: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
843: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
844: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
845: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
846: l_return_status VARCHAR2(10);
847: l_msg_count NUMBER;
848: l_msg_data VARCHAR2(2000);
849: l_data VARCHAR2(2000);

Line 1237: --Updating the pa_proj_fp_options table for cost version type

1233: END IF;
1234: END IF;
1235:
1236: IF P_VERSION_TYPE = 'COST' THEN
1237: --Updating the pa_proj_fp_options table for cost version type
1238: UPDATE PA_PROJ_FP_OPTIONS
1239: SET GEN_COST_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1240: GEN_COST_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1241: GEN_COST_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,

Line 1238: UPDATE PA_PROJ_FP_OPTIONS

1234: END IF;
1235:
1236: IF P_VERSION_TYPE = 'COST' THEN
1237: --Updating the pa_proj_fp_options table for cost version type
1238: UPDATE PA_PROJ_FP_OPTIONS
1239: SET GEN_COST_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1240: GEN_COST_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1241: GEN_COST_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,
1242: GEN_COST_RET_MANUAL_LINE_FLAG = P_RET_MANUAL_LNS_FLAG,

Line 1247: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);

1243: GEN_SRC_COST_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1244: GEN_SRC_COST_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1245: GEN_SRC_COST_WP_VERSION_ID = l_wp_version_id
1246: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1247: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1248:
1249: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1250: --Updating the pa_proj_fp_options table for revenue version type
1251: UPDATE PA_PROJ_FP_OPTIONS

Line 1250: --Updating the pa_proj_fp_options table for revenue version type

1246: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1247: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1248:
1249: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1250: --Updating the pa_proj_fp_options table for revenue version type
1251: UPDATE PA_PROJ_FP_OPTIONS
1252: SET
1253: GEN_REV_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1254: GEN_REV_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,

Line 1251: UPDATE PA_PROJ_FP_OPTIONS

1247: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1248:
1249: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1250: --Updating the pa_proj_fp_options table for revenue version type
1251: UPDATE PA_PROJ_FP_OPTIONS
1252: SET
1253: GEN_REV_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1254: GEN_REV_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,
1255: GEN_REV_RET_MANUAL_LINE_FLAG = P_RET_MANUAL_LNS_FLAG,

Line 1260: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);

1256: GEN_SRC_REV_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1257: GEN_SRC_REV_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1258: GEN_SRC_REV_WP_VERSION_ID = l_wp_version_id
1259: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1260: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1261:
1262: ELSIF P_VERSION_TYPE = 'ALL' THEN
1263: --Updating the pa_proj_fp_options table for all version type
1264: UPDATE PA_PROJ_FP_OPTIONS

Line 1263: --Updating the pa_proj_fp_options table for all version type

1259: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1260: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1261:
1262: ELSIF P_VERSION_TYPE = 'ALL' THEN
1263: --Updating the pa_proj_fp_options table for all version type
1264: UPDATE PA_PROJ_FP_OPTIONS
1265: SET GEN_ALL_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1266: GEN_ALL_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1267: GEN_ALL_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,

Line 1264: UPDATE PA_PROJ_FP_OPTIONS

1260: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1261:
1262: ELSIF P_VERSION_TYPE = 'ALL' THEN
1263: --Updating the pa_proj_fp_options table for all version type
1264: UPDATE PA_PROJ_FP_OPTIONS
1265: SET GEN_ALL_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1266: GEN_ALL_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1267: GEN_ALL_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,
1268: GEN_ALL_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,

Line 1274: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for all:'||sql%rowcount);

1270: GEN_SRC_ALL_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1271: GEN_SRC_ALL_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1272: GEN_SRC_ALL_WP_VERSION_ID = l_wp_version_id
1273: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1274: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for all:'||sql%rowcount);
1275: END IF;
1276:
1277: UPDATE PA_BUDGET_VERSIONS
1278: SET ACTUAL_AMTS_THRU_PERIOD = P_ACTUALS_THRU_PERIOD

Line 1471: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

1467:
1468: PROCEDURE VALIDATE_PERIODS
1469: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1470: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1471: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1472: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1473: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1474: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1475: P_ETC_FROM_PERIOD IN VARCHAR2,

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

1958:
1959: END VALIDATE_PA_GL_PERIODS;
1960:
1961: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
1962: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1963: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1964: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1965: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1966: P_CALLING_CONTEXT IN VARCHAR2,

Line 1963: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

1959: END VALIDATE_PA_GL_PERIODS;
1960:
1961: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
1962: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1963: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1964: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1965: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1966: P_CALLING_CONTEXT IN VARCHAR2,
1967: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1964: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

1960:
1961: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
1962: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1963: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1964: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1965: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1966: P_CALLING_CONTEXT IN VARCHAR2,
1967: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1968: X_MSG_COUNT OUT NOCOPY NUMBER,