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

Line 670: last_updated_by = FND_GLOBAL.USER_ID,

666: scheduled_finish_date = l_sch_finish_date_tbl(i),
667: planned_effort = l_effort_tbl(i),
668: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
669: last_update_date = sysdate,
670: last_updated_by = FND_GLOBAL.USER_ID,
671: last_update_login = FND_GLOBAL.LOGIN_ID
672: WHERE project_id = l_proj_id_tbl(i)
673: AND element_version_id = l_elem_ver_id_tbl(i);
674: --

Line 671: last_update_login = FND_GLOBAL.LOGIN_ID

667: planned_effort = l_effort_tbl(i),
668: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
669: last_update_date = sysdate,
670: last_updated_by = FND_GLOBAL.USER_ID,
671: last_update_login = FND_GLOBAL.LOGIN_ID
672: WHERE project_id = l_proj_id_tbl(i)
673: AND element_version_id = l_elem_ver_id_tbl(i);
674: --
675: -- Upon changes on a Task's Scheduled Dates.

Line 731: last_updated_by = FND_GLOBAL.USER_ID,

727: UPDATE pa_proj_elem_ver_schedule
728: SET scheduled_start_date_rollup = l_sch_start_date_tbl(i) - scheduled_start_date,
729: scheduled_finish_date_rollup = l_sch_finish_date_tbl(i) - scheduled_finish_date,
730: last_update_date = sysdate,
731: last_updated_by = FND_GLOBAL.USER_ID,
732: last_update_login = FND_GLOBAL.LOGIN_ID
733: WHERE project_id = l_proj_id_tbl(i)
734: AND element_version_id = l_elem_ver_id_tbl(i);
735: --

Line 732: last_update_login = FND_GLOBAL.LOGIN_ID

728: SET scheduled_start_date_rollup = l_sch_start_date_tbl(i) - scheduled_start_date,
729: scheduled_finish_date_rollup = l_sch_finish_date_tbl(i) - scheduled_finish_date,
730: last_update_date = sysdate,
731: last_updated_by = FND_GLOBAL.USER_ID,
732: last_update_login = FND_GLOBAL.LOGIN_ID
733: WHERE project_id = l_proj_id_tbl(i)
734: AND element_version_id = l_elem_ver_id_tbl(i);
735: --
736: END IF; --end if for checking versions enabled and checking auto_roolup

Line 1544: 'LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||

1540: 'PLANNED_EFFORT = :pe, '||
1541: 'DURATION = :dur, '||
1542: 'RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1, '||
1543: 'LAST_UPDATE_DATE = SYSDATE, ' ||
1544: 'LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
1545: 'LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ' ||
1546: 'where '||
1547: 'project_id = :pid and element_version_id = :evid';
1548:

Line 1545: 'LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ' ||

1541: 'DURATION = :dur, '||
1542: 'RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1, '||
1543: 'LAST_UPDATE_DATE = SYSDATE, ' ||
1544: 'LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
1545: 'LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ' ||
1546: 'where '||
1547: 'project_id = :pid and element_version_id = :evid';
1548:
1549: --Parse statement

Line 1699: last_updated_by = FND_GLOBAL.USER_ID,

1695: scheduled_finish_date = l_sch_finish_date_tbl(i),
1696: planned_effort = l_effort_tbl(i),
1697: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
1698: last_update_date = sysdate,
1699: last_updated_by = FND_GLOBAL.USER_ID,
1700: last_update_login = FND_GLOBAL.LOGIN_ID
1701: where project_id = l_proj_id_tbl(i)
1702: and element_version_id = l_elem_ver_id_tbl(i);
1703:

Line 1700: last_update_login = FND_GLOBAL.LOGIN_ID

1696: planned_effort = l_effort_tbl(i),
1697: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
1698: last_update_date = sysdate,
1699: last_updated_by = FND_GLOBAL.USER_ID,
1700: last_update_login = FND_GLOBAL.LOGIN_ID
1701: where project_id = l_proj_id_tbl(i)
1702: and element_version_id = l_elem_ver_id_tbl(i);
1703:
1704: --BUG 4290472, rtarway

Line 1747: last_updated_by = FND_GLOBAL.USER_ID,

1743: set scheduled_start_date =str_start_date,
1744: scheduled_finish_date = str_end_date,
1745: duration = str_end_date - str_start_date + 1,
1746: last_update_date = sysdate,
1747: last_updated_by = FND_GLOBAL.USER_ID,
1748: last_update_login = FND_GLOBAL.LOGIN_ID
1749: where project_id = l_baseline_proj_id
1750: and element_version_id = l_structure_version_id;
1751: end if;

Line 1748: last_update_login = FND_GLOBAL.LOGIN_ID

1744: scheduled_finish_date = str_end_date,
1745: duration = str_end_date - str_start_date + 1,
1746: last_update_date = sysdate,
1747: last_updated_by = FND_GLOBAL.USER_ID,
1748: last_update_login = FND_GLOBAL.LOGIN_ID
1749: where project_id = l_baseline_proj_id
1750: and element_version_id = l_structure_version_id;
1751: end if;
1752: --BUG 4290472, rtarway

Line 2383: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2379: UPDATE PA_PROJ_ELEMENTS
2380: set status_code = l_final_status_code,
2381: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2382: LAST_UPDATE_DATE = SYSDATE,
2383: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2384: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2385: where proj_element_id = l_rollup_table(l_cnt).object_id;
2386: END IF;
2387:

Line 2384: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2380: set status_code = l_final_status_code,
2381: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2382: LAST_UPDATE_DATE = SYSDATE,
2383: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2384: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2385: where proj_element_id = l_rollup_table(l_cnt).object_id;
2386: END IF;
2387:
2388: EXIT when l_cnt = l_rollup_table.LAST;