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 1594: UPDATE pa_budget_versions SET

1590: END IF;
1591: END LOOP; */
1592: /* PPP - Period Profile refresh in Process */
1593: FORALL ii IN 1 .. l_bv_id_tab.COUNT
1594: UPDATE pa_budget_versions SET
1595: plan_processing_code = 'PPP',
1596: locked_by_person_id = -98,
1597: request_id = l_rpt_request_id,
1598: record_version_number = nvl(record_version_number,0) + 1,

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

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

Line 2404: UPDATE pa_budget_versions bv

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

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

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

Line 2600: from pa_budget_versions where

2596: nvl(request_id,0) into
2597: l_locked_person_id_tab(l_count),
2598: l_plan_proc_code_tab(l_count),
2599: l_req_id_tab(l_count)
2600: from pa_budget_versions where
2601: budget_version_id = l_budget_version_id1;
2602:
2603:
2604: l_count := l_count + 1;

Line 2616: from pa_budget_versions where

2612: nvl(request_id,0) into
2613: l_locked_person_id_tab(l_count),
2614: l_plan_proc_code_tab(l_count),
2615: l_req_id_tab(l_count)
2616: from pa_budget_versions where
2617: budget_version_id = l_budget_version_id2;
2618:
2619: l_count := l_count + 1;
2620: END IF;

Line 2646: Pa_budget_versions

2642: l_locked_person_id_tab,
2643: l_plan_proc_code_tab,
2644: l_req_id_tab
2645: FROM
2646: Pa_budget_versions
2647: WHERE
2648: project_id = l_project_id
2649: AND period_profile_id IS NOT NULL;
2650: ELSIF (l_refresh_option_code = 'SELECTED') THEN

Line 2661: Pa_budget_versions

2657: l_locked_person_id_tab,
2658: l_plan_proc_code_tab,
2659: l_req_id_tab
2660: FROM
2661: Pa_budget_versions
2662: WHERE
2663: project_id = l_project_id
2664: AND period_profile_id IS NOT NULL
2665: AND

Line 2692: FROM pa_budget_versions bv, pa_proj_fp_options po

2688: )
2689: )
2690: INTO
2691: l_time_phased_code
2692: FROM pa_budget_versions bv, pa_proj_fp_options po
2693: WHERE
2694: bv.budget_version_id = l_budget_version_id
2695: AND po.fin_plan_version_id = bv.budget_version_id
2696: AND po.fin_plan_option_level_code = 'PLAN_VERSION'

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

3180: END get_current_period_info;
3181:
3182:
3183: function has_preceding_periods
3184: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2
3185: is
3186: l_return_value VARCHAR2(1);
3187: BEGIN
3188: l_return_value := 'N';

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

3198: END has_preceding_periods;
3199:
3200:
3201: function has_succeeding_periods
3202: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2
3203: is
3204: l_return_value VARCHAR2(1);
3205: BEGIN
3206: l_return_value := 'N';

Line 3222: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;

3218: PROCEDURE UPDATE_BUDGET_VERSION(p_budget_version_id IN NUMBER,
3219: p_return_status IN VARCHAR2,
3220: p_project_id IN NUMBER,
3221: p_request_id IN NUMBER ) IS
3222: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;
3223: BEGIN
3224: if p_return_status <> FND_API.G_RET_STS_SUCCESS then
3225: l_plan_proc_code := 'PPE';
3226: else

Line 3230: UPDATE PA_BUDGET_VERSIONS

3226: else
3227: l_plan_proc_code := 'PPG';
3228: end if;
3229: IF p_project_id IS NOT NULL THEN
3230: UPDATE PA_BUDGET_VERSIONS
3231: SET PLAN_PROCESSING_CODE = l_plan_proc_code,
3232: locked_by_person_id = NULL,
3233: record_version_number = nvl(record_version_number,0) + 1,
3234: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 3242: UPDATE PA_BUDGET_VERSIONS

3238: project_id = p_project_id and
3239: request_id = p_request_id and
3240: plan_processing_code = 'PPP';
3241: ELSE
3242: UPDATE PA_BUDGET_VERSIONS
3243: SET PLAN_PROCESSING_CODE = l_plan_proc_code,
3244: locked_by_person_id = NULL,
3245: record_version_number = nvl(record_version_number,0) + 1,
3246: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,