DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_BUDGET_VERSIONS

Line 8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

4:
5: /**This procedure is called to copy actuals to budget version lines**/
6: PROCEDURE COPY_ACTUALS
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: P_END_DATE IN DATE,
11: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
12: P_COMMIT_FLAG IN VARCHAR2 default 'N',

Line 601: FROM pa_budget_Versions

597: --Structure version id should be the structure version id of the current published version
598: --for B/F.
599: SELECT wp_version_flag
600: INTO l_wp_version_flag
601: FROM pa_budget_Versions
602: WHERE budget_version_id=P_BUDGET_VERSION_ID;
603:
604: IF l_wp_version_flag = 'Y' THEN
605: l_struct_ver_id_tab(1) := p_fp_cols_rec.X_PROJECT_STRUCTURE_VERSION_ID;

Line 1186: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1182:
1183:
1184: PROCEDURE CREATE_RES_ASG (
1185: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1186: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1187: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1188: P_CALLING_PROCESS IN VARCHAR2,
1189: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1190: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1584: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1580:
1581:
1582: PROCEDURE UPDATE_RES_ASG (
1583: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1584: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1585: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1586: P_CALLING_PROCESS IN VARCHAR2,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,