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 3228: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;

3224: l_financial_type VARCHAR2(1);
3225:
3226: --maansari
3227: i NUMBER := 1;
3228: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;
3229: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3230: --maansari
3231:
3232: --bug 3047602

Line 3229: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3225:
3226: --maansari
3227: i NUMBER := 1;
3228: -- l_user_id NUMBER := FND_GLOBAL.USER_ID;
3229: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3230: --maansari
3231:
3232: --bug 3047602
3233: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

Line 3276: l_user_id := FND_GLOBAL.USER_ID;

3272:
3273: ----------
3274: -- code --
3275: IF p_user_id IS NULL THEN
3276: l_user_id := FND_GLOBAL.USER_ID;
3277: ELSE
3278: l_user_id := p_user_id;
3279: END IF;
3280:

Line 3759: -- p_user_id => FND_GLOBAL.USER_ID

3755: -- FETCH get_structure_version_info INTO l_info_struc_ver_rec;
3756: /*****************************/
3757: --dbms_output.put_line('creating rel: structure out going links for structures');
3758: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3759: -- p_user_id => FND_GLOBAL.USER_ID
3760: -- ,p_object_type_from => 'PA_STRUCTURES'
3761: -- ,p_object_id_from1 => l_new_struct_ver_id
3762: -- ,p_object_id_from2 => NULL
3763: -- ,p_object_id_from3 => NULL

Line 3795: -- p_user_id => FND_GLOBAL.USER_ID

3791: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
3792: /*****************************/
3793: --dbms_output.put_line('creating rel: structure out going links for tasks');
3794: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3795: -- p_user_id => FND_GLOBAL.USER_ID
3796: -- ,p_object_type_from => 'PA_STRUCTURES'
3797: -- ,p_object_id_from1 => l_new_struct_ver_id
3798: -- ,p_object_id_from2 => NULL
3799: -- ,p_object_id_from3 => NULL

Line 3958: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3954: UPDATE pa_proj_elements
3955: set status_code = '128',
3956: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
3957: LAST_UPDATE_DATE = SYSDATE,
3958: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3959: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3960: where proj_element_id = l_task_versions_rec.proj_element_id;
3961:
3962: update pa_proj_element_versions

Line 3959: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3955: set status_code = '128',
3956: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
3957: LAST_UPDATE_DATE = SYSDATE,
3958: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3959: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3960: where proj_element_id = l_task_versions_rec.proj_element_id;
3961:
3962: update pa_proj_element_versions
3963: set TASK_UNPUB_VER_STATUS_CODE = 'PUBLISHED'

Line 4260: -- p_user_id => FND_GLOBAL.USER_ID

4256: --dbms_output.put_line('creating rel: task out going links for structures');
4257: --dbms_output.put_line(l_project_id||','||l_struc_ver_rec.proj_element_id||','||l_new_struct_ver_id||','||','||l_task_version_id||', TO: '
4258: --||l_info_struc_ver_rec.project_id||','||l_info_struc_ver_rec.structure_id||','||l_info_struc_ver_rec.structure_version_id);
4259: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4260: -- p_user_id => FND_GLOBAL.USER_ID
4261: -- ,p_object_type_from => 'PA_TASKS'
4262: -- ,p_object_id_from1 => l_task_version_id
4263: -- ,p_object_id_from2 => NULL
4264: -- ,p_object_id_from3 => NULL

Line 4295: -- p_user_id => FND_GLOBAL.USER_ID

4291: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
4292: /*****************************/
4293: --dbms_output.put_line('creating rel: task out going links for tasks');
4294: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4295: -- p_user_id => FND_GLOBAL.USER_ID
4296: -- ,p_object_type_from => 'PA_TASKS'
4297: -- ,p_object_id_from1 => l_task_version_id
4298: -- ,p_object_id_from2 => NULL
4299: -- ,p_object_id_from3 => NULL

Line 6850: p_user_id => FND_GLOBAL.USER_ID

6846: OPEN l_get_structure_ver_csr(l_to_object_info.object_id_to);
6847: FETCH l_get_structure_ver_csr INTO l_structure_ver_to_rec;
6848:
6849: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6850: p_user_id => FND_GLOBAL.USER_ID
6851: ,p_object_type_from => 'PA_TASKS'
6852: ,p_object_id_from1 => l_task_version_id
6853: ,p_object_id_from2 => NULL
6854: ,p_object_id_from3 => NULL

Line 6909: p_user_id => FND_GLOBAL.USER_ID

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

Line 9039: ,FND_GLOBAL.USER_ID

9035: l_wf_item_type
9036: ,l_wf_process
9037: ,p_structure_version_id
9038: ,p_responsibility_id
9039: ,FND_GLOBAL.USER_ID
9040: ,l_item_key
9041: ,x_msg_count
9042: ,x_msg_data
9043: ,x_return_status

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

9219: (
9220: l_wf_item_type
9221: ,l_wf_process
9222: ,p_structure_version_id
9223: ,FND_GLOBAL.RESP_ID -- NULL Added for bug 5372586
9224: ,FND_GLOBAL.USER_ID -- NULL Added for bug 5372586
9225: ,l_item_key
9226: ,x_msg_count
9227: ,x_msg_data

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

9220: l_wf_item_type
9221: ,l_wf_process
9222: ,p_structure_version_id
9223: ,FND_GLOBAL.RESP_ID -- NULL Added for bug 5372586
9224: ,FND_GLOBAL.USER_ID -- NULL Added for bug 5372586
9225: ,l_item_key
9226: ,x_msg_count
9227: ,x_msg_data
9228: ,x_return_status

Line 10396: FND_GLOBAL.USER_ID,

10392: PPEV.element_version_id,
10393: PPEV.project_id,
10394: PPEV.proj_element_id,
10395: SYSDATE,
10396: FND_GLOBAL.USER_ID,
10397: SYSDATE,
10398: FND_GLOBAL.USER_ID,
10399: 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))),
10400: 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 10398: FND_GLOBAL.USER_ID,

10394: PPEV.proj_element_id,
10395: SYSDATE,
10396: FND_GLOBAL.USER_ID,
10397: SYSDATE,
10398: FND_GLOBAL.USER_ID,
10399: 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))),
10400: 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))),
10401: 'N',
10402: 'N',

Line 10405: FND_GLOBAL.LOGIN_ID,

10401: 'N',
10402: 'N',
10403: l_calendar_id,
10404: 0,
10405: FND_GLOBAL.LOGIN_ID,
10406: PPEV.project_id,
10407: 'PA_PROJECTS'
10408: FROM PA_TASKS PT,
10409: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 13254: l_user_id := FND_GLOBAl.user_id;

13250:
13251: -- Amit The code to get all the task versions and then create task versions one by one is commented
13252: -- Now we are using bulk insert for this purpose.
13253:
13254: l_user_id := FND_GLOBAl.user_id;
13255: l_login_id := FND_GLOBAl.login_id;
13256:
13257: INSERT INTO pa_proj_element_versions(
13258: ELEMENT_VERSION_ID

Line 13255: l_login_id := FND_GLOBAl.login_id;

13251: -- Amit The code to get all the task versions and then create task versions one by one is commented
13252: -- Now we are using bulk insert for this purpose.
13253:
13254: l_user_id := FND_GLOBAl.user_id;
13255: l_login_id := FND_GLOBAl.login_id;
13256:
13257: INSERT INTO pa_proj_element_versions(
13258: ELEMENT_VERSION_ID
13259: ,PROJ_ELEMENT_ID

Line 15102: FND_GLOBAL.USER_ID,

15098: PPEV.element_version_id,
15099: PPEV.project_id,
15100: PPEV.proj_element_id,
15101: SYSDATE,
15102: FND_GLOBAL.USER_ID,
15103: SYSDATE,
15104: FND_GLOBAL.USER_ID,
15105: 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))),
15106: 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 15104: FND_GLOBAL.USER_ID,

15100: PPEV.proj_element_id,
15101: SYSDATE,
15102: FND_GLOBAL.USER_ID,
15103: SYSDATE,
15104: FND_GLOBAL.USER_ID,
15105: 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))),
15106: 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))),
15107: 'N',
15108: 'N',

Line 15111: FND_GLOBAL.LOGIN_ID,

15107: 'N',
15108: 'N',
15109: NULL,
15110: 0,
15111: FND_GLOBAL.LOGIN_ID,
15112: PPEV.project_id,
15113: 'PA_PROJECTS'
15114: FROM PA_TASKS PT,
15115: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 17091: FND_GLOBAL.USER_ID,

17087: PPEV.element_version_id,
17088: PPEV.project_id,
17089: PPEV.proj_element_id,
17090: SYSDATE,
17091: FND_GLOBAL.USER_ID,
17092: SYSDATE,
17093: FND_GLOBAL.USER_ID,
17094: 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))),
17095: 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 17093: FND_GLOBAL.USER_ID,

17089: PPEV.proj_element_id,
17090: SYSDATE,
17091: FND_GLOBAL.USER_ID,
17092: SYSDATE,
17093: FND_GLOBAL.USER_ID,
17094: 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))),
17095: 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))),
17096: 'N',
17097: 'N',

Line 17100: FND_GLOBAL.LOGIN_ID,

17096: 'N',
17097: 'N',
17098: NULL,
17099: 0,
17100: FND_GLOBAL.LOGIN_ID,
17101: PPEV.project_id,
17102: 'PA_PROJECTS'
17103: FROM PA_TASKS PT,
17104: PA_PROJ_ELEMENT_VERSIONS PPEV

Line 17483: FND_GLOBAL.USER_ID,

17479: PPEV.element_version_id,
17480: PPEV.project_id,
17481: PPEV.proj_element_id,
17482: SYSDATE,
17483: FND_GLOBAL.USER_ID,
17484: SYSDATE,
17485: FND_GLOBAL.USER_ID,
17486: 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))),
17487: 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 17485: FND_GLOBAL.USER_ID,

17481: PPEV.proj_element_id,
17482: SYSDATE,
17483: FND_GLOBAL.USER_ID,
17484: SYSDATE,
17485: FND_GLOBAL.USER_ID,
17486: 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))),
17487: 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))),
17488: 'N',
17489: 'N',

Line 17492: FND_GLOBAL.LOGIN_ID,

17488: 'N',
17489: 'N',
17490: NULL,
17491: 0,
17492: FND_GLOBAL.LOGIN_ID,
17493: PPEV.project_id,
17494: 'PA_PROJECTS'
17495: FROM PA_TASKS PT,
17496: PA_PROJ_ELEMENT_VERSIONS PPEV