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.

[Home] [Help]

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.13.12020000.2 2013/05/16 06:37:12 djambhek 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 816: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

812: * This method is used to validate Time Phase and ETC Source of
813: * source plan
814: */
815: PROCEDURE VALIDATION_FOR_COPY_ETC_FLAG
816: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
817: P_WP_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
818: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
819: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
820: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 817: P_WP_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

813: * source plan
814: */
815: PROCEDURE VALIDATION_FOR_COPY_ETC_FLAG
816: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
817: P_WP_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
818: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
819: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
820: X_MSG_COUNT OUT NOCOPY NUMBER,
821: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 818: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

814: */
815: PROCEDURE VALIDATION_FOR_COPY_ETC_FLAG
816: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
817: P_WP_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
818: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
819: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
820: X_MSG_COUNT OUT NOCOPY NUMBER,
821: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
822:

Line 1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

998: **/
999: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
1000: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

1000: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

Line 1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

Line 1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

Line 1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

Line 1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

Line 1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

Line 1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1014: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1015: P_ACTUALS_TO_PERIOD IN VARCHAR2,

Line 1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1014: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1015: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1016: P_ETC_FROM_PERIOD IN VARCHAR2,

Line 1029: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

1025: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1026:
1027: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
1028: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1029: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1030: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1031: l_return_status VARCHAR2(10);
1032: l_msg_count NUMBER;
1033: l_msg_data VARCHAR2(2000);

Line 1030: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

1026:
1027: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
1028: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1029: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1030: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1031: l_return_status VARCHAR2(10);
1032: l_msg_count NUMBER;
1033: l_msg_data VARCHAR2(2000);
1034: l_data VARCHAR2(2000);

Line 1050: FROM PA_PROJ_FP_OPTIONS

1046: -- Cursor to get 'Copy ETC from Plan' flag
1047: CURSOR get_copy_etc_from_plan_csr
1048: IS
1049: SELECT COPY_ETC_FROM_PLAN_FLAG
1050: FROM PA_PROJ_FP_OPTIONS
1051: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1052:
1053: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;
1054: -- gboomina added for AAI requirement 8318932 - end

Line 1053: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;

1049: SELECT COPY_ETC_FROM_PLAN_FLAG
1050: FROM PA_PROJ_FP_OPTIONS
1051: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1052:
1053: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;
1054: -- gboomina added for AAI requirement 8318932 - end
1055:
1056: BEGIN
1057: --Setting initial values

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

1514: END IF;
1515: END IF;
1516:
1517: IF P_VERSION_TYPE = 'COST' THEN
1518: --Updating the pa_proj_fp_options table for cost version type
1519: UPDATE PA_PROJ_FP_OPTIONS
1520: SET GEN_COST_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1521: GEN_COST_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1522: GEN_COST_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,

Line 1519: UPDATE PA_PROJ_FP_OPTIONS

1515: END IF;
1516:
1517: IF P_VERSION_TYPE = 'COST' THEN
1518: --Updating the pa_proj_fp_options table for cost version type
1519: UPDATE PA_PROJ_FP_OPTIONS
1520: SET GEN_COST_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1521: GEN_COST_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1522: GEN_COST_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,
1523: GEN_COST_RET_MANUAL_LINE_FLAG = P_RET_MANUAL_LNS_FLAG,

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

1524: GEN_SRC_COST_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1525: GEN_SRC_COST_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1526: GEN_SRC_COST_WP_VERSION_ID = l_wp_version_id
1527: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1528: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1529:
1530: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1531: --Updating the pa_proj_fp_options table for revenue version type
1532: UPDATE PA_PROJ_FP_OPTIONS

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

1527: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1528: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1529:
1530: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1531: --Updating the pa_proj_fp_options table for revenue version type
1532: UPDATE PA_PROJ_FP_OPTIONS
1533: SET
1534: GEN_REV_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1535: GEN_REV_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,

Line 1532: UPDATE PA_PROJ_FP_OPTIONS

1528: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for cost:'||sql%rowcount);
1529:
1530: ELSIF P_VERSION_TYPE = 'REVENUE' THEN
1531: --Updating the pa_proj_fp_options table for revenue version type
1532: UPDATE PA_PROJ_FP_OPTIONS
1533: SET
1534: GEN_REV_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1535: GEN_REV_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,
1536: GEN_REV_RET_MANUAL_LINE_FLAG = P_RET_MANUAL_LNS_FLAG,

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

1537: GEN_SRC_REV_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1538: GEN_SRC_REV_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1539: GEN_SRC_REV_WP_VERSION_ID = l_wp_version_id
1540: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1541: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1542:
1543: ELSIF P_VERSION_TYPE = 'ALL' THEN
1544: --Updating the pa_proj_fp_options table for all version type
1545: UPDATE PA_PROJ_FP_OPTIONS

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

1540: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1541: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1542:
1543: ELSIF P_VERSION_TYPE = 'ALL' THEN
1544: --Updating the pa_proj_fp_options table for all version type
1545: UPDATE PA_PROJ_FP_OPTIONS
1546: SET GEN_ALL_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1547: GEN_ALL_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1548: GEN_ALL_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,

Line 1545: UPDATE PA_PROJ_FP_OPTIONS

1541: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for revenue:'||sql%rowcount);
1542:
1543: ELSIF P_VERSION_TYPE = 'ALL' THEN
1544: --Updating the pa_proj_fp_options table for all version type
1545: UPDATE PA_PROJ_FP_OPTIONS
1546: SET GEN_ALL_INCL_UNSPENT_AMT_FLAG = P_UNSPENT_AMT_FLAG,
1547: GEN_ALL_INCL_CHANGE_DOC_FLAG = P_INCL_CHG_DOC_FLAG,
1548: GEN_ALL_INCL_OPEN_COMM_FLAG = P_INCL_OPEN_CMT_FLAG,
1549: GEN_ALL_INCL_BILL_EVENT_FLAG = P_INCL_BILL_EVT_FLAG,

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

1551: GEN_SRC_ALL_PLAN_TYPE_ID = P_ETC_PLAN_TYPE_ID,
1552: GEN_SRC_ALL_PLAN_VERSION_ID = l_ETC_PLAN_VERSION_ID,
1553: GEN_SRC_ALL_WP_VERSION_ID = l_wp_version_id
1554: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1555: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for all:'||sql%rowcount);
1556: END IF;
1557:
1558: UPDATE PA_BUDGET_VERSIONS
1559: SET ACTUAL_AMTS_THRU_PERIOD = P_ACTUALS_THRU_PERIOD

Line 1752: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

1748:
1749: PROCEDURE VALIDATE_PERIODS
1750: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1751: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1752: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1753: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1754: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1755: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1756: P_ETC_FROM_PERIOD IN VARCHAR2,

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

2239:
2240: END VALIDATE_PA_GL_PERIODS;
2241:
2242: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
2243: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2244: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
2245: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
2246: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
2247: P_CALLING_CONTEXT IN VARCHAR2,

Line 2244: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

2240: END VALIDATE_PA_GL_PERIODS;
2241:
2242: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
2243: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2244: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
2245: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
2246: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
2247: P_CALLING_CONTEXT IN VARCHAR2,
2248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

2241:
2242: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
2243: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2244: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
2245: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
2246: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
2247: P_CALLING_CONTEXT IN VARCHAR2,
2248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2249: X_MSG_COUNT OUT NOCOPY NUMBER,