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 698: last_updated_by = FND_GLOBAL.USER_ID,

694: scheduled_finish_date = l_sch_finish_date_tbl(i),
695: planned_effort = l_effort_tbl(i),
696: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
697: last_update_date = sysdate,
698: last_updated_by = FND_GLOBAL.USER_ID,
699: last_update_login = FND_GLOBAL.LOGIN_ID
700: WHERE project_id = l_proj_id_tbl(i)
701: AND element_version_id = l_elem_ver_id_tbl(i)
702: AND ( scheduled_start_date <> l_sch_start_date_tbl(i) OR -- Bug 6719725

Line 699: last_update_login = FND_GLOBAL.LOGIN_ID

695: planned_effort = l_effort_tbl(i),
696: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
697: last_update_date = sysdate,
698: last_updated_by = FND_GLOBAL.USER_ID,
699: last_update_login = FND_GLOBAL.LOGIN_ID
700: WHERE project_id = l_proj_id_tbl(i)
701: AND element_version_id = l_elem_ver_id_tbl(i)
702: AND ( scheduled_start_date <> l_sch_start_date_tbl(i) OR -- Bug 6719725
703: scheduled_finish_date <> l_sch_finish_date_tbl(i) OR

Line 763: last_updated_by = FND_GLOBAL.USER_ID,

759: UPDATE pa_proj_elem_ver_schedule
760: SET scheduled_start_date_rollup = l_sch_start_date_tbl(i) - scheduled_start_date,
761: scheduled_finish_date_rollup = l_sch_finish_date_tbl(i) - scheduled_finish_date,
762: last_update_date = sysdate,
763: last_updated_by = FND_GLOBAL.USER_ID,
764: last_update_login = FND_GLOBAL.LOGIN_ID
765: WHERE project_id = l_proj_id_tbl(i)
766: AND element_version_id = l_elem_ver_id_tbl(i)
767: AND(scheduled_start_date_rollup <>(l_sch_start_date_tbl(i) - scheduled_start_date) OR -- Bug 6719725

Line 764: last_update_login = FND_GLOBAL.LOGIN_ID

760: SET scheduled_start_date_rollup = l_sch_start_date_tbl(i) - scheduled_start_date,
761: scheduled_finish_date_rollup = l_sch_finish_date_tbl(i) - scheduled_finish_date,
762: last_update_date = sysdate,
763: last_updated_by = FND_GLOBAL.USER_ID,
764: last_update_login = FND_GLOBAL.LOGIN_ID
765: WHERE project_id = l_proj_id_tbl(i)
766: AND element_version_id = l_elem_ver_id_tbl(i)
767: AND(scheduled_start_date_rollup <>(l_sch_start_date_tbl(i) - scheduled_start_date) OR -- Bug 6719725
768: scheduled_finish_date_rollup <> (l_sch_finish_date_tbl(i) - scheduled_finish_date)

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

1614: 'PLANNED_EFFORT = :pe, '||
1615: 'DURATION = :dur, '||
1616: 'RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1, '||
1617: 'LAST_UPDATE_DATE = SYSDATE, ' ||
1618: 'LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
1619: 'LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ' ||
1620: 'where '||
1621: 'project_id = :pid and element_version_id = :evid';
1622:

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

1615: 'DURATION = :dur, '||
1616: 'RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1, '||
1617: 'LAST_UPDATE_DATE = SYSDATE, ' ||
1618: 'LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
1619: 'LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ' ||
1620: 'where '||
1621: 'project_id = :pid and element_version_id = :evid';
1622:
1623: --Parse statement

Line 1773: last_updated_by = FND_GLOBAL.USER_ID,

1769: scheduled_finish_date = l_sch_finish_date_tbl(i),
1770: planned_effort = l_effort_tbl(i),
1771: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
1772: last_update_date = sysdate,
1773: last_updated_by = FND_GLOBAL.USER_ID,
1774: last_update_login = FND_GLOBAL.LOGIN_ID
1775: where project_id = l_proj_id_tbl(i)
1776: and element_version_id = l_elem_ver_id_tbl(i) and -- Bug 6719725
1777: (scheduled_start_date <> l_sch_start_date_tbl(i) or

Line 1774: last_update_login = FND_GLOBAL.LOGIN_ID

1770: planned_effort = l_effort_tbl(i),
1771: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,
1772: last_update_date = sysdate,
1773: last_updated_by = FND_GLOBAL.USER_ID,
1774: last_update_login = FND_GLOBAL.LOGIN_ID
1775: where project_id = l_proj_id_tbl(i)
1776: and element_version_id = l_elem_ver_id_tbl(i) and -- Bug 6719725
1777: (scheduled_start_date <> l_sch_start_date_tbl(i) or
1778: scheduled_finish_date <> l_sch_finish_date_tbl(i) or

Line 1825: last_updated_by = FND_GLOBAL.USER_ID,

1821: set scheduled_start_date =str_start_date,
1822: scheduled_finish_date = str_end_date,
1823: duration = str_end_date - str_start_date + 1,
1824: last_update_date = sysdate,
1825: last_updated_by = FND_GLOBAL.USER_ID,
1826: last_update_login = FND_GLOBAL.LOGIN_ID
1827: where project_id = l_baseline_proj_id
1828: and element_version_id = l_structure_version_id
1829: and (scheduled_start_date <> str_start_date or -- Bug 6719725

Line 1826: last_update_login = FND_GLOBAL.LOGIN_ID

1822: scheduled_finish_date = str_end_date,
1823: duration = str_end_date - str_start_date + 1,
1824: last_update_date = sysdate,
1825: last_updated_by = FND_GLOBAL.USER_ID,
1826: last_update_login = FND_GLOBAL.LOGIN_ID
1827: where project_id = l_baseline_proj_id
1828: and element_version_id = l_structure_version_id
1829: and (scheduled_start_date <> str_start_date or -- Bug 6719725
1830: scheduled_finish_date <> str_end_date

Line 2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2534: UPDATE PA_PROJ_ELEMENTS
2535: set status_code = l_final_status_code,
2536: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2537: LAST_UPDATE_DATE = SYSDATE,
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2539: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2540: where proj_element_id = l_rollup_table(l_cnt).object_id;
2541: END IF;
2542:

Line 2539: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2535: set status_code = l_final_status_code,
2536: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2537: LAST_UPDATE_DATE = SYSDATE,
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2539: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2540: where proj_element_id = l_rollup_table(l_cnt).object_id;
2541: END IF;
2542:
2543: EXIT when l_cnt = l_rollup_table.LAST;