3:
4:
5: PROCEDURE UPDATE_RES_DEFAULTS
6: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
9: P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
10: P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'N',
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
18: X_MSG_COUNT OUT NOCOPY NUMBER,
19: X_MSG_DATA OUT NOCOPY VARCHAR2);
20:
21: PROCEDURE UNSPENT_AMOUNT
22: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
23: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
24: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
25: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
26: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_DATA OUT NOCOPY VARCHAR2);
20:
21: PROCEDURE UNSPENT_AMOUNT
22: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
23: P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
24: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
25: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
26: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27: X_MSG_COUNT OUT NOCOPY NUMBER,
27: X_MSG_COUNT OUT NOCOPY NUMBER,
28: X_MSG_DATA OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE UPD_WBS_ELEMENT_VERSION_ID
31: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
32: P_STRUCTURE_VERSION_ID IN NUMBER DEFAULT null,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2);
53: X_MSG_DATA OUT NOCOPY VARCHAR2);
54:
55: /* Added 10/26/2004 by dkuo */
56: PROCEDURE MAINTAIN_FIXED_DATE_SP
57: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
58: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2);