DBA Data[Home] [Help]

APPS.JMF_GTA_BATCH_NUMBER_UTIL dependencies on FND_GLOBAL

Line 110: , fnd_global.LOGIN_ID()

106: VALUES
107: ( p_org_id
108: , l_next_value
109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );

Line 112: , fnd_global.LOGIN_ID()

108: , l_next_value
109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );
115:
116: x_return_status := 'S';

Line 113: , fnd_global.LOGIN_ID()

109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );
115:
116: x_return_status := 'S';
117: ELSIF l_count >= 1

Line 190: , last_updated_by = fnd_global.LOGIN_ID()

186: THEN
187: UPDATE jmf_gta_batch_numbering
188: SET next_value = p_next_value
189: , last_update_date = SYSDATE
190: , last_updated_by = fnd_global.LOGIN_ID()
191: , last_update_login = fnd_global.LOGIN_ID()
192: WHERE org_id = p_org_id;
193:
194: x_return_status := 'S';

Line 191: , last_update_login = fnd_global.LOGIN_ID()

187: UPDATE jmf_gta_batch_numbering
188: SET next_value = p_next_value
189: , last_update_date = SYSDATE
190: , last_updated_by = fnd_global.LOGIN_ID()
191: , last_update_login = fnd_global.LOGIN_ID()
192: WHERE org_id = p_org_id;
193:
194: x_return_status := 'S';
195: ELSE

Line 284: , last_updated_by = fnd_global.LOGIN_ID()

280: THEN
281: UPDATE jmf_gta_batch_numbering
282: SET next_value = l_next_val + 1
283: , last_update_date = SYSDATE
284: , last_updated_by = fnd_global.LOGIN_ID()
285: , last_update_login = fnd_global.LOGIN_ID()
286: WHERE CURRENT OF c_next_val;
287:
288: COMMIT;

Line 285: , last_update_login = fnd_global.LOGIN_ID()

281: UPDATE jmf_gta_batch_numbering
282: SET next_value = l_next_val + 1
283: , last_update_date = SYSDATE
284: , last_updated_by = fnd_global.LOGIN_ID()
285: , last_update_login = fnd_global.LOGIN_ID()
286: WHERE CURRENT OF c_next_val;
287:
288: COMMIT;
289: CLOSE c_next_val;