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_PROJECT_STRUCTURE_PVT1 dependencies on FND_GLOBAL

Line 1043: open get_person_id(FND_GLOBAL.USER_ID);

1039: l_status_code := 'STRUCTURE_PUBLISHED';
1040: l_published_date := sysdate;
1041:
1042: --get published person id
1043: open get_person_id(FND_GLOBAL.USER_ID);
1044: fetch get_person_id into l_published_person_id;
1045: IF get_person_id%NOTFOUND then
1046: l_published_person_id := -1;
1047: END IF;

Line 1130: open get_person_id(FND_GLOBAL.USER_ID);

1126: l_published_person_id := NULL;
1127: l_effective_date := sysdate;
1128:
1129: IF (l_status_code = 'STRUCTURE_PUBLISHED') THEN
1130: open get_person_id(FND_GLOBAL.USER_ID);
1131: fetch get_person_id into l_published_person_id;
1132: IF get_person_id%NOTFOUND then
1133: l_published_person_id := NULL;
1134: END IF;

Line 1898: open get_person_id(FND_GLOBAL.USER_ID);

1894: END IF;
1895: CLOSE getids;
1896:
1897: --get person id
1898: open get_person_id(FND_GLOBAL.USER_ID);
1899: fetch get_person_id into l_person_id;
1900: IF get_person_id%NOTFOUND then
1901: l_person_id := -1;
1902: END IF;

Line 2023: l_get_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,

2019: pa_debug.debug('Not Published');
2020: END IF;
2021:
2022: --Check lock
2023: l_get_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,
2024: l_structure_version_id);
2025:
2026: IF (p_debug_mode = 'Y') THEN
2027: pa_debug.debug('l_get_lock value = '||l_get_lock);

Line 2897: last_updated_by = FND_GLOBAL.USER_ID,

2893: else
2894: update PA_PROJ_ELEM_VER_STRUCTURE
2895: set PURGED_FLAG = 'Y',
2896: last_update_date = sysdate,
2897: last_updated_by = FND_GLOBAL.USER_ID,
2898: conc_request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */
2899: WHERE ROWID = l_rowid;
2900: end if;
2901: /* Added for bug 8708651 */

Line 2898: conc_request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */

2894: update PA_PROJ_ELEM_VER_STRUCTURE
2895: set PURGED_FLAG = 'Y',
2896: last_update_date = sysdate,
2897: last_updated_by = FND_GLOBAL.USER_ID,
2898: conc_request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */
2899: WHERE ROWID = l_rowid;
2900: end if;
2901: /* Added for bug 8708651 */
2902:

Line 3258: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;

3254: l_financial_type VARCHAR2(1);
3255:
3256: --maansari
3257: i NUMBER := 1;
3258: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;
3259: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3260: --maansari
3261:
3262: --bug 3047602

Line 3259: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3255:
3256: --maansari
3257: i NUMBER := 1;
3258: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;
3259: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3260: --maansari
3261:
3262: --bug 3047602
3263: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

Line 3316: l_user_id := FND_GLOBAL.USER_ID;

3312:
3313: ----------
3314: -- code --
3315: IF p_user_id IS NULL THEN
3316: l_user_id := FND_GLOBAL.USER_ID;
3317: ELSE
3318: l_user_id := p_user_id;
3319: END IF;
3320:

Line 3819: -- p_user_id => FND_GLOBAL.USER_ID

3815: -- FETCH get_structure_version_info INTO l_info_struc_ver_rec;
3816: /*****************************/
3817: --dbms_output.put_line('creating rel: structure out going links for structures');
3818: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3819: -- p_user_id => FND_GLOBAL.USER_ID
3820: -- ,p_object_type_from => 'PA_STRUCTURES'
3821: -- ,p_object_id_from1 => l_new_struct_ver_id
3822: -- ,p_object_id_from2 => NULL
3823: -- ,p_object_id_from3 => NULL

Line 3855: -- p_user_id => FND_GLOBAL.USER_ID

3851: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
3852: /*****************************/
3853: --dbms_output.put_line('creating rel: structure out going links for tasks');
3854: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3855: -- p_user_id => FND_GLOBAL.USER_ID
3856: -- ,p_object_type_from => 'PA_STRUCTURES'
3857: -- ,p_object_id_from1 => l_new_struct_ver_id
3858: -- ,p_object_id_from2 => NULL
3859: -- ,p_object_id_from3 => NULL

Line 4018: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4014: UPDATE pa_proj_elements
4015: set status_code = '128',
4016: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
4017: LAST_UPDATE_DATE = SYSDATE,
4018: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4019: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4020: where proj_element_id = l_task_versions_rec.proj_element_id;
4021:
4022: update pa_proj_element_versions

Line 4019: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

4015: set status_code = '128',
4016: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
4017: LAST_UPDATE_DATE = SYSDATE,
4018: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4019: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4020: where proj_element_id = l_task_versions_rec.proj_element_id;
4021:
4022: update pa_proj_element_versions
4023: set TASK_UNPUB_VER_STATUS_CODE = 'PUBLISHED'

Line 4320: -- p_user_id => FND_GLOBAL.USER_ID

4316: --dbms_output.put_line('creating rel: task out going links for structures');
4317: --dbms_output.put_line(l_project_id||','||l_struc_ver_rec.proj_element_id||','||l_new_struct_ver_id||','||','||l_task_version_id||', TO: '
4318: --||l_info_struc_ver_rec.project_id||','||l_info_struc_ver_rec.structure_id||','||l_info_struc_ver_rec.structure_version_id);
4319: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4320: -- p_user_id => FND_GLOBAL.USER_ID
4321: -- ,p_object_type_from => 'PA_TASKS'
4322: -- ,p_object_id_from1 => l_task_version_id
4323: -- ,p_object_id_from2 => NULL
4324: -- ,p_object_id_from3 => NULL

Line 4355: -- p_user_id => FND_GLOBAL.USER_ID

4351: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
4352: /*****************************/
4353: --dbms_output.put_line('creating rel: task out going links for tasks');
4354: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4355: -- p_user_id => FND_GLOBAL.USER_ID
4356: -- ,p_object_type_from => 'PA_TASKS'
4357: -- ,p_object_id_from1 => l_task_version_id
4358: -- ,p_object_id_from2 => NULL
4359: -- ,p_object_id_from3 => NULL

Line 6910: p_user_id => FND_GLOBAL.USER_ID

6906: OPEN l_get_structure_ver_csr(l_to_object_info.object_id_to);
6907: FETCH l_get_structure_ver_csr INTO l_structure_ver_to_rec;
6908:
6909: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6910: p_user_id => FND_GLOBAL.USER_ID
6911: ,p_object_type_from => 'PA_TASKS'
6912: ,p_object_id_from1 => l_task_version_id
6913: ,p_object_id_from2 => NULL
6914: ,p_object_id_from3 => NULL

Line 6969: p_user_id => FND_GLOBAL.USER_ID

6965: OPEN get_task_version_info(l_to_object_info.object_id_to);
6966: FETCH get_task_version_info INTO l_info_task_ver_rec;
6967:
6968: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6969: p_user_id => FND_GLOBAL.USER_ID
6970: ,p_object_type_from => 'PA_TASKS'
6971: ,p_object_id_from1 => l_task_version_id
6972: ,p_object_id_from2 => NULL
6973: ,p_object_id_from3 => NULL

Line 9411: ,FND_GLOBAL.USER_ID

9407: l_wf_item_type
9408: ,l_wf_process
9409: ,p_structure_version_id
9410: ,p_responsibility_id
9411: ,FND_GLOBAL.USER_ID
9412: ,l_item_key
9413: ,x_msg_count
9414: ,x_msg_data
9415: ,x_return_status

Line 9595: ,FND_GLOBAL.RESP_ID -- NULL Added for bug 5372586

9591: (
9592: l_wf_item_type
9593: ,l_wf_process
9594: ,p_structure_version_id
9595: ,FND_GLOBAL.RESP_ID -- NULL Added for bug 5372586
9596: ,FND_GLOBAL.USER_ID -- NULL Added for bug 5372586
9597: ,l_item_key
9598: ,x_msg_count
9599: ,x_msg_data

Line 9596: ,FND_GLOBAL.USER_ID -- NULL Added for bug 5372586

9592: l_wf_item_type
9593: ,l_wf_process
9594: ,p_structure_version_id
9595: ,FND_GLOBAL.RESP_ID -- NULL Added for bug 5372586
9596: ,FND_GLOBAL.USER_ID -- NULL Added for bug 5372586
9597: ,l_item_key
9598: ,x_msg_count
9599: ,x_msg_data
9600: ,x_return_status

Line 10768: FND_GLOBAL.USER_ID,

10764: PPEV.element_version_id,
10765: PPEV.project_id,
10766: PPEV.proj_element_id,
10767: SYSDATE,
10768: FND_GLOBAL.USER_ID,
10769: SYSDATE,
10770: FND_GLOBAL.USER_ID,
10771: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', decode(PT.COMPLETION_DATE, NULL, trunc(l_target_start_date), trunc(PT.START_DATE))),
10772: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_target_finish_date))),

Line 10770: FND_GLOBAL.USER_ID,

10766: PPEV.proj_element_id,
10767: SYSDATE,
10768: FND_GLOBAL.USER_ID,
10769: SYSDATE,
10770: FND_GLOBAL.USER_ID,
10771: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', decode(PT.COMPLETION_DATE, NULL, trunc(l_target_start_date), trunc(PT.START_DATE))),
10772: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_target_finish_date))),
10773: 'N',
10774: 'N',

Line 10777: FND_GLOBAL.LOGIN_ID,

10773: 'N',
10774: 'N',
10775: l_calendar_id,
10776: 0,
10777: FND_GLOBAL.LOGIN_ID,
10778: PPEV.project_id,
10779: 'PA_PROJECTS'
10780: FROM PA_TASKS PT,
10781: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 13626: l_user_id := FND_GLOBAl.user_id;

13622:
13623: -- Amit The code to get all the task versions and then create task versions one by one is commented
13624: -- Now we are using bulk insert for this purpose.
13625:
13626: l_user_id := FND_GLOBAl.user_id;
13627: l_login_id := FND_GLOBAl.login_id;
13628:
13629: INSERT INTO pa_proj_element_versions(
13630: ELEMENT_VERSION_ID

Line 13627: l_login_id := FND_GLOBAl.login_id;

13623: -- Amit The code to get all the task versions and then create task versions one by one is commented
13624: -- Now we are using bulk insert for this purpose.
13625:
13626: l_user_id := FND_GLOBAl.user_id;
13627: l_login_id := FND_GLOBAl.login_id;
13628:
13629: INSERT INTO pa_proj_element_versions(
13630: ELEMENT_VERSION_ID
13631: ,PROJ_ELEMENT_ID

Line 15478: FND_GLOBAL.USER_ID,

15474: PPEV.element_version_id,
15475: PPEV.project_id,
15476: PPEV.proj_element_id,
15477: SYSDATE,
15478: FND_GLOBAL.USER_ID,
15479: SYSDATE,
15480: FND_GLOBAL.USER_ID,
15481: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
15482: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

Line 15480: FND_GLOBAL.USER_ID,

15476: PPEV.proj_element_id,
15477: SYSDATE,
15478: FND_GLOBAL.USER_ID,
15479: SYSDATE,
15480: FND_GLOBAL.USER_ID,
15481: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
15482: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
15483: 'N',
15484: 'N',

Line 15487: FND_GLOBAL.LOGIN_ID,

15483: 'N',
15484: 'N',
15485: NULL,
15486: 0,
15487: FND_GLOBAL.LOGIN_ID,
15488: PPEV.project_id,
15489: 'PA_PROJECTS'
15490: FROM PA_TASKS PT,
15491: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 17467: FND_GLOBAL.USER_ID,

17463: PPEV.element_version_id,
17464: PPEV.project_id,
17465: PPEV.proj_element_id,
17466: SYSDATE,
17467: FND_GLOBAL.USER_ID,
17468: SYSDATE,
17469: FND_GLOBAL.USER_ID,
17470: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17471: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

Line 17469: FND_GLOBAL.USER_ID,

17465: PPEV.proj_element_id,
17466: SYSDATE,
17467: FND_GLOBAL.USER_ID,
17468: SYSDATE,
17469: FND_GLOBAL.USER_ID,
17470: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17471: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17472: 'N',
17473: 'N',

Line 17476: FND_GLOBAL.LOGIN_ID,

17472: 'N',
17473: 'N',
17474: NULL,
17475: 0,
17476: FND_GLOBAL.LOGIN_ID,
17477: PPEV.project_id,
17478: 'PA_PROJECTS'
17479: FROM PA_TASKS PT,
17480: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 17859: FND_GLOBAL.USER_ID,

17855: PPEV.element_version_id,
17856: PPEV.project_id,
17857: PPEV.proj_element_id,
17858: SYSDATE,
17859: FND_GLOBAL.USER_ID,
17860: SYSDATE,
17861: FND_GLOBAL.USER_ID,
17862: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17863: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

Line 17861: FND_GLOBAL.USER_ID,

17857: PPEV.proj_element_id,
17858: SYSDATE,
17859: FND_GLOBAL.USER_ID,
17860: SYSDATE,
17861: FND_GLOBAL.USER_ID,
17862: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17863: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17864: 'N',
17865: 'N',

Line 17868: FND_GLOBAL.LOGIN_ID,

17864: 'N',
17865: 'N',
17866: NULL,
17867: 0,
17868: FND_GLOBAL.LOGIN_ID,
17869: PPEV.project_id,
17870: 'PA_PROJECTS'
17871: FROM PA_TASKS PT,
17872: PA_PROJ_ELEMENT_VERSIONS PPEV