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 FND_GLOBAL

Line 49: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

45: G.period_set_name = c_period_set_name and
46: G.period_type = c_period_type and
47: G.adjustment_period_flag = 'N'
48: ORDER BY G.start_date;
49: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
50: l_created_by NUMBER := FND_GLOBAL.USER_ID;
51: l_creation_date DATE := SYSDATE;
52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 50: l_created_by NUMBER := FND_GLOBAL.USER_ID;

46: G.period_type = c_period_type and
47: G.adjustment_period_flag = 'N'
48: ORDER BY G.start_date;
49: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
50: l_created_by NUMBER := FND_GLOBAL.USER_ID;
51: l_creation_date DATE := SYSDATE;
52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

Line 53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

49: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
50: l_created_by NUMBER := FND_GLOBAL.USER_ID;
51: l_creation_date DATE := SYSDATE;
52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
55: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
56: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
57:

Line 54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

50: l_created_by NUMBER := FND_GLOBAL.USER_ID;
51: l_creation_date DATE := SYSDATE;
52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
55: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
56: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
57:
58: l_plan_end_period VARCHAR2(30);

Line 55: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

51: l_creation_date DATE := SYSDATE;
52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
55: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
56: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
57:
58: l_plan_end_period VARCHAR2(30);
59: BEGIN

Line 56: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

52: l_last_update_date DATE := l_creation_date;
53: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
54: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
55: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
56: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
57:
58: l_plan_end_period VARCHAR2(30);
59: BEGIN
60: /* If all the periods needs to be populated for the project,

Line 1600: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
1600: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1601: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1602: LAST_UPDATE_DATE = sysdate
1603: WHERE
1604: budget_version_id = l_bv_id_tab(ii) AND

Line 1601: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1597: locked_by_person_id = -98,
1598: request_id = l_rpt_request_id,
1599: record_version_number = nvl(record_version_number,0) + 1,
1600: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1601: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1602: LAST_UPDATE_DATE = sysdate
1603: WHERE
1604: budget_version_id = l_bv_id_tab(ii) AND
1605: locked_by_person_id IS NULL; */

Line 2351: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2347: l_debug_mode VARCHAR2(30);
2348: amt_rec PA_PLAN_MATRIX.AMOUNT_TYPE_TABTYP;
2349: l_request_id NUMBER;
2350: BEGIN
2351: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2352: -- Setting the Debug Statements
2353: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2354: l_debug_mode := NVL(l_debug_mode, 'N');
2355: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2408: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
2410: LAST_UPDATE_DATE = sysdate
2411: WHERE bv.budget_version_id = l_budget_version_id
2412: AND bv.project_id = p_project_id;

Line 2409: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2410: LAST_UPDATE_DATE = sysdate
2411: WHERE bv.budget_version_id = l_budget_version_id
2412: AND bv.project_id = p_project_id;
2413:

Line 2545: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2541: IF P_PA_DEBUG_MODE = 'Y' THEN
2542: PA_DEBUG.Set_Curr_Function( p_function => 'Wrapper_Refresh_Pd_Profile',
2543: p_debug_mode => p_debug_mode );
2544: END IF;
2545: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2546:
2547: IF P_PA_DEBUG_MODE = 'Y' THEN
2548: PA_DEBUG.g_err_stage := 'Entering Refresh Period Profile WRAPPER ' ||
2549: 'for Conc Request Id :'||to_char(nvl(l_Request_id,0));

Line 2601: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
2601: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2602: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2603: LAST_UPDATE_DATE = sysdate
2604: WHERE
2605: project_id = l_project_id

Line 2602: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2598: locked_by_person_id = -98,
2599: request_id = l_request_id, /* 8338971 */
2600: record_version_number = nvl(record_version_number,0) + 1,
2601: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2602: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2603: LAST_UPDATE_DATE = sysdate
2604: WHERE
2605: project_id = l_project_id
2606: --locked_by_person_id IS NULL

Line 2811: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
2812: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2813: LAST_UPDATE_DATE = sysdate,
2814: REQUEST_ID = l_request_id
2815: WHERE

Line 2812: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2812: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2813: LAST_UPDATE_DATE = sysdate,
2814: REQUEST_ID = l_request_id
2815: WHERE
2816: project_id = l_project_id AND

Line 2824: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
2825: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2826: LAST_UPDATE_DATE = sysdate,
2827: REQUEST_ID = l_request_id
2828: WHERE

Line 2825: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2825: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2826: LAST_UPDATE_DATE = sysdate,
2827: REQUEST_ID = l_request_id
2828: WHERE
2829: project_id = l_project_id AND

Line 3291: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
3292: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3293: LAST_UPDATE_DATE = sysdate
3294: WHERE
3295: project_id = p_project_id and

Line 3292: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
3292: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3293: LAST_UPDATE_DATE = sysdate
3294: WHERE
3295: project_id = p_project_id and
3296: request_id = p_request_id and

Line 3303: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
3304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3305: LAST_UPDATE_DATE = sysdate
3306: WHERE
3307: budget_version_id = p_budget_version_id;

Line 3304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
3304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3305: LAST_UPDATE_DATE = sysdate
3306: WHERE
3307: budget_version_id = p_budget_version_id;
3308: END IF;