DBA Data[Home] [Help]

APPS.ZPB_DC_UTIL dependencies on FND_GLOBAL

Line 40: last_updated_by = fnd_global.USER_ID,

36: SET status = 'LOCKED',
37: prior_lock_status = l_prior_lock_status,
38: freeze_flag = 'Y',
39: --who columns
40: last_updated_by = fnd_global.USER_ID,
41: last_update_date = SYSDATE,
42: last_update_login = fnd_global.LOGIN_ID
43: WHERE object_id = p_object_id;
44:

Line 42: last_update_login = fnd_global.LOGIN_ID

38: freeze_flag = 'Y',
39: --who columns
40: last_updated_by = fnd_global.USER_ID,
41: last_update_date = SYSDATE,
42: last_update_login = fnd_global.LOGIN_ID
43: WHERE object_id = p_object_id;
44:
45: IF(SQL%ROWCOUNT > 0)
46: THEN

Line 103: last_updated_by = fnd_global.USER_ID,

99: UPDATE ZPB_DC_OBJECTS
100: SET status = l_prior_lock_status,
101: freeze_flag = 'N',
102: --who columns
103: last_updated_by = fnd_global.USER_ID,
104: last_update_date = SYSDATE,
105: last_update_login = fnd_global.LOGIN_ID
106: WHERE object_id = p_object_id
107: AND status = 'LOCKED';

Line 105: last_update_login = fnd_global.LOGIN_ID

101: freeze_flag = 'N',
102: --who columns
103: last_updated_by = fnd_global.USER_ID,
104: last_update_date = SYSDATE,
105: last_update_login = fnd_global.LOGIN_ID
106: WHERE object_id = p_object_id
107: AND status = 'LOCKED';
108:
109: IF(SQL%ROWCOUNT > 0)

Line 162: last_updated_by = fnd_global.USER_ID,

158: SET status = 'DISTRIBUTION_PENDING',
159: freeze_flag = 'N',
160: distributor_user_id = -100,
161: --who columns
162: last_updated_by = fnd_global.USER_ID,
163: last_update_date = SYSDATE,
164: last_update_login = fnd_global.LOGIN_ID
165: WHERE object_id = p_object_id;
166:

Line 164: last_update_login = fnd_global.LOGIN_ID

160: distributor_user_id = -100,
161: --who columns
162: last_updated_by = fnd_global.USER_ID,
163: last_update_date = SYSDATE,
164: last_update_login = fnd_global.LOGIN_ID
165: WHERE object_id = p_object_id;
166:
167: IF(SQL%ROWCOUNT > 0)
168: THEN