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 637: FROM pa_budget_Versions

633: --Structure version id should be the structure version id of the current published version
634: --for B/F.
635: SELECT wp_version_flag
636: INTO l_wp_version_flag
637: FROM pa_budget_Versions
638: WHERE budget_version_id=P_BUDGET_VERSION_ID;
639:
640: IF l_wp_version_flag = 'Y' THEN
641: l_struct_ver_id_tab(1) := p_fp_cols_rec.X_PROJECT_STRUCTURE_VERSION_ID;

Line 1227: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1223:
1224:
1225: PROCEDURE CREATE_RES_ASG (
1226: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1227: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1228: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1229: P_CALLING_PROCESS IN VARCHAR2,
1230: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1231: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1819: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1815:
1816:
1817: PROCEDURE UPDATE_RES_ASG (
1818: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1819: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1820: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1821: P_CALLING_PROCESS IN VARCHAR2,
1822: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1823: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1993: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1989: * for a whole budget version given.
1990: **/
1991: PROCEDURE COLLECT_ACTUALS
1992: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1993: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1994: P_RESOURCE_ASSGN_IDS IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1995: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
1996: P_COMMIT_FLAG IN VARCHAR2 default 'N',
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2029: l_record_version_number pa_budget_versions.record_version_number%type;

2025: l_txn_currency_flag VARCHAR2(1) := 'Y';
2026: l_org_id NUMBER;
2027: l_rate_based_flag VARCHAR2(1);
2028: l_budget_line_exists varchar2(1) := 'N';
2029: l_record_version_number pa_budget_versions.record_version_number%type;
2030: l_wp_version_flag pa_budget_versions.wp_version_flag%type;
2031: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2032:
2033: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 2030: l_wp_version_flag pa_budget_versions.wp_version_flag%type;

2026: l_org_id NUMBER;
2027: l_rate_based_flag VARCHAR2(1);
2028: l_budget_line_exists varchar2(1) := 'N';
2029: l_record_version_number pa_budget_versions.record_version_number%type;
2030: l_wp_version_flag pa_budget_versions.wp_version_flag%type;
2031: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2032:
2033: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
2034: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 2392: from pa_budget_versions

2388: /* Begining of acquiring lock */
2389: -- acquire version lock
2390: select record_version_number
2391: into l_record_version_number
2392: from pa_budget_versions
2393: where budget_version_id = p_budget_version_id;
2394: IF p_pa_debug_mode = 'Y' THEN
2395: pa_fp_gen_amount_utils.fp_debug
2396: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',

Line 2523: from pa_budget_versions

2519: --Structure version id should be the structure version id of the
2520: --current published version for B/F.
2521: select wp_version_flag
2522: into l_wp_version_flag
2523: from pa_budget_versions
2524: where budget_version_id=p_budget_version_id;
2525:
2526: if l_wp_version_flag = 'Y' then
2527: l_struct_ver_id_tab(1) := l_fp_cols_rec.x_project_structure_version_id;