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.PN_SPACE_ASSIGN_CUST_PKG dependencies on FND_GLOBAL

Line 1955: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')

1951: ---------------------------------------------------------------------------
1952: UPDATE pn_space_assign_cust_all
1953: SET cust_assign_start_date = cust_tab(i).cust_assign_start_date
1954: ,last_update_date = SYSDATE
1955: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')
1956: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')
1957: WHERE cust_space_assign_id = cust_tab(i+1).cust_space_assign_id;
1958:
1959: ---------------------------------------------------------------------------

Line 1956: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')

1952: UPDATE pn_space_assign_cust_all
1953: SET cust_assign_start_date = cust_tab(i).cust_assign_start_date
1954: ,last_update_date = SYSDATE
1955: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')
1956: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')
1957: WHERE cust_space_assign_id = cust_tab(i+1).cust_space_assign_id;
1958:
1959: ---------------------------------------------------------------------------
1960: -- ....... update the (i+1) record with the start date of the ith record

Line 2039: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')

2035: ---------------------------------------------------------------------------
2036: UPDATE pn_space_assign_emp_all
2037: SET emp_assign_start_date = emp_tab(i).emp_assign_start_date
2038: ,last_update_date = SYSDATE
2039: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')
2040: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')
2041: WHERE emp_space_assign_id = emp_tab(i+1).emp_space_assign_id;
2042:
2043: ---------------------------------------------------------------------------

Line 2040: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')

2036: UPDATE pn_space_assign_emp_all
2037: SET emp_assign_start_date = emp_tab(i).emp_assign_start_date
2038: ,last_update_date = SYSDATE
2039: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')
2040: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')
2041: WHERE emp_space_assign_id = emp_tab(i+1).emp_space_assign_id;
2042:
2043: ---------------------------------------------------------------------------
2044: -- ....... update the (i+1) record with the start date of the ith record