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_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_BUDGET_VERSIONS

Line 1563: Pa_budget_versions

1559: l_bv_id_tab,
1560: l_locked_person_id_tab,
1561: l_plan_proc_code_tab
1562: FROM
1563: Pa_budget_versions
1564: WHERE
1565: project_id = p_project_id
1566: AND period_profile_id IS NOT NULL;
1567: ELSIF (p_refresh_option_code = 'SELECTED') THEN

Line 1576: Pa_budget_versions

1572: l_bv_id_tab,
1573: l_locked_person_id_tab,
1574: l_plan_proc_code_tab
1575: FROM
1576: Pa_budget_versions
1577: WHERE
1578: project_id = p_project_id
1579: AND period_profile_id IS NOT NULL
1580: AND

Line 1595: UPDATE pa_budget_versions SET

1591: END LOOP; */
1592: /* PPP - Period Profile refresh in Process */
1593: /* Commented code from here for 7563735, locking will be done in the procedure Maintain_Prj_Period_Profile now.
1594: FORALL ii IN 1 .. l_bv_id_tab.COUNT
1595: UPDATE pa_budget_versions SET
1596: plan_processing_code = 'PPP',
1597: locked_by_person_id = -98,
1598: request_id = l_rpt_request_id,
1599: record_version_number = nvl(record_version_number,0) + 1,

Line 1742: SELECT COUNT(*) INTO l_count FROM Pa_Budget_Versions

1738: x_pa_start_period := null;
1739: x_pa_end_period := null;
1740: x_pa_start_date := null;
1741: x_plan_version_exists_flag := 'N';
1742: SELECT COUNT(*) INTO l_count FROM Pa_Budget_Versions
1743: WHERE Project_Id = p_project_id AND
1744: Period_Profile_Id IS NOT NULL AND
1745: Period_Profile_Id > 0;
1746: IF l_count > 0 THEN

Line 2405: UPDATE pa_budget_versions bv

2401: -- Fix for P1 bug 2682761
2402: -- Updating budget versions table for this budget version
2403: -- before calling call maintain plan matrix
2404:
2405: UPDATE pa_budget_versions bv
2406: SET bv.period_profile_id = p_period_profile_id,
2407: record_version_number = nvl(record_version_number,0) + 1,
2408: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2409: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2526: TYPE budget_version_id_tab IS TABLE OF PA_BUDGET_VERSIONS.budget_version_id%type

2522: l_return_status VARCHAR2(2000);
2523: l_msg_count NUMBER;
2524: l_msg_data VARCHAR2(2000);
2525: l_count NUMBER;
2526: TYPE budget_version_id_tab IS TABLE OF PA_BUDGET_VERSIONS.budget_version_id%type
2527: INDEX BY BINARY_INTEGER;
2528: t_budget_version_id budget_version_id_tab;
2529: l_request_id NUMBER;
2530: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2536: FROM Pa_budget_versions

2532: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2533: --Bug 7563735 Locking the records in cursor
2534: cursor c is
2535: select budget_version_id
2536: FROM Pa_budget_versions
2537: WHERE project_id = l_project_id
2538: FOR UPDATE;
2539: BEGIN
2540: -- Setting the Debug Statements

Line 2596: UPDATE pa_budget_versions SET

2592: l_plan_proc_code_tab.DELETE;
2593:
2594: /* Changes for 7563735 - Setting the locked_by_person_id here, and opening cursor c so that sql lock is obtained on those*/
2595:
2596: UPDATE pa_budget_versions SET
2597: plan_processing_code = 'PPP',
2598: locked_by_person_id = -98,
2599: request_id = l_request_id, /* 8338971 */
2600: record_version_number = nvl(record_version_number,0) + 1,

Line 2626: from pa_budget_versions where

2622: nvl(request_id,0) into
2623: l_locked_person_id_tab(l_count),
2624: l_plan_proc_code_tab(l_count),
2625: l_req_id_tab(l_count)
2626: from pa_budget_versions where
2627: budget_version_id = l_budget_version_id1;
2628:
2629:
2630: l_count := l_count + 1;

Line 2642: from pa_budget_versions where

2638: nvl(request_id,0) into
2639: l_locked_person_id_tab(l_count),
2640: l_plan_proc_code_tab(l_count),
2641: l_req_id_tab(l_count)
2642: from pa_budget_versions where
2643: budget_version_id = l_budget_version_id2;
2644:
2645: l_count := l_count + 1;
2646: END IF;

Line 2672: Pa_budget_versions

2668: l_locked_person_id_tab,
2669: l_plan_proc_code_tab,
2670: l_req_id_tab
2671: FROM
2672: Pa_budget_versions
2673: WHERE
2674: project_id = l_project_id
2675: AND period_profile_id IS NOT NULL;
2676: ELSIF (l_refresh_option_code = 'SELECTED') THEN

Line 2687: Pa_budget_versions

2683: l_locked_person_id_tab,
2684: l_plan_proc_code_tab,
2685: l_req_id_tab
2686: FROM
2687: Pa_budget_versions
2688: WHERE
2689: project_id = l_project_id
2690: AND period_profile_id IS NOT NULL
2691: AND

Line 2718: FROM pa_budget_versions bv, pa_proj_fp_options po

2714: )
2715: )
2716: INTO
2717: l_time_phased_code
2718: FROM pa_budget_versions bv, pa_proj_fp_options po
2719: WHERE
2720: bv.budget_version_id = l_budget_version_id
2721: AND po.fin_plan_version_id = bv.budget_version_id
2722: AND po.fin_plan_option_level_code = 'PLAN_VERSION'

Line 2807: UPDATE pa_budget_versions SET

2803: END IF;
2804: END LOOP;
2805: /* Changes for 7563735 - unsetting the locked_by_person_id here, depending on the return_status code*/
2806: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2807: UPDATE pa_budget_versions SET
2808: plan_processing_code = 'PPE',
2809: locked_by_person_id = null,
2810: record_version_number = nvl(record_version_number,0) + 1,
2811: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 2820: UPDATE pa_budget_versions SET

2816: project_id = l_project_id AND
2817: locked_by_person_id ='-98'
2818: AND period_profile_id IS NOT NULL;
2819: ELSE
2820: UPDATE pa_budget_versions SET
2821: plan_processing_code = 'PPG',
2822: locked_by_person_id = null,
2823: record_version_number = nvl(record_version_number,0) + 1,
2824: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 3241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2

3237: END get_current_period_info;
3238:
3239:
3240: function has_preceding_periods
3241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2
3242: is
3243: l_return_value VARCHAR2(1);
3244: BEGIN
3245: l_return_value := 'N';

Line 3259: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2

3255: END has_preceding_periods;
3256:
3257:
3258: function has_succeeding_periods
3259: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2
3260: is
3261: l_return_value VARCHAR2(1);
3262: BEGIN
3263: l_return_value := 'N';

Line 3279: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;

3275: PROCEDURE UPDATE_BUDGET_VERSION(p_budget_version_id IN NUMBER,
3276: p_return_status IN VARCHAR2,
3277: p_project_id IN NUMBER,
3278: p_request_id IN NUMBER ) IS
3279: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;
3280: BEGIN
3281: if p_return_status <> FND_API.G_RET_STS_SUCCESS then
3282: l_plan_proc_code := 'PPE';
3283: else

Line 3287: UPDATE PA_BUDGET_VERSIONS

3283: else
3284: l_plan_proc_code := 'PPG';
3285: end if;
3286: IF p_project_id IS NOT NULL THEN
3287: UPDATE PA_BUDGET_VERSIONS
3288: SET PLAN_PROCESSING_CODE = l_plan_proc_code,
3289: locked_by_person_id = NULL,
3290: record_version_number = nvl(record_version_number,0) + 1,
3291: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 3299: UPDATE PA_BUDGET_VERSIONS

3295: project_id = p_project_id and
3296: request_id = p_request_id and
3297: plan_processing_code = 'PPP';
3298: ELSE
3299: UPDATE PA_BUDGET_VERSIONS
3300: SET PLAN_PROCESSING_CODE = l_plan_proc_code,
3301: locked_by_person_id = NULL,
3302: record_version_number = nvl(record_version_number,0) + 1,
3303: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,