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 1599: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 1600: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2350: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 2407: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 2408: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2538: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2534: IF P_PA_DEBUG_MODE = 'Y' THEN
2535: PA_DEBUG.Set_Curr_Function( p_function => 'Wrapper_Refresh_Pd_Profile',
2536: p_debug_mode => p_debug_mode );
2537: END IF;
2538: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2539:
2540: IF P_PA_DEBUG_MODE = 'Y' THEN
2541: PA_DEBUG.g_err_stage := 'Entering Refresh Period Profile WRAPPER ' ||
2542: 'for Conc Request Id :'||to_char(nvl(l_Request_id,0));

Line 3234: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
3235: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3236: LAST_UPDATE_DATE = sysdate
3237: WHERE
3238: project_id = p_project_id and

Line 3235: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
3235: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3236: LAST_UPDATE_DATE = sysdate
3237: WHERE
3238: project_id = p_project_id and
3239: request_id = p_request_id and

Line 3246: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
3247: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3248: LAST_UPDATE_DATE = sysdate
3249: WHERE
3250: budget_version_id = p_budget_version_id;

Line 3247: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
3247: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3248: LAST_UPDATE_DATE = sysdate
3249: WHERE
3250: budget_version_id = p_budget_version_id;
3251: END IF;