DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on FND_GLOBAL

Line 70: FND_GLOBAL.user_id,

66: jtf_tasks_vl.task_id,
67: csd_repairs.repair_line_id,
68: 'N',
69: 1,
70: FND_GLOBAL.user_id,
71: SYSDATE,
72: FND_GLOBAL.user_id,
73: SYSDATE,
74: FND_GLOBAL.login_id

Line 72: FND_GLOBAL.user_id,

68: 'N',
69: 1,
70: FND_GLOBAL.user_id,
71: SYSDATE,
72: FND_GLOBAL.user_id,
73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS

Line 74: FND_GLOBAL.login_id

70: FND_GLOBAL.user_id,
71: SYSDATE,
72: FND_GLOBAL.user_id,
73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'

Line 204: FND_GLOBAL.USER_ID,

200: FlowStatusCodes(i), -- literal value is same
201: 'Y',
202: 1,
203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.LOGIN_ID
208: );

Line 206: FND_GLOBAL.USER_ID,

202: 1,
203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.LOGIN_ID
208: );
209:
210: EXCEPTION

Line 207: FND_GLOBAL.LOGIN_ID

203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.LOGIN_ID
208: );
209:
210: EXCEPTION
211: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN

Line 231: FND_GLOBAL.user_id,

227: SOURCE_LANG
228: ) select
229: FS_B.flow_status_id,
230: NULL, -- EXTERNAL_DISPLAY_STATUS
231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id,

Line 233: FND_GLOBAL.user_id,

229: FS_B.flow_status_id,
230: NULL, -- EXTERNAL_DISPLAY_STATUS
231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id,
236: L.LANGUAGE_CODE,
237: L.LANGUAGE_CODE

Line 235: FND_GLOBAL.login_id,

231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id,
236: L.LANGUAGE_CODE,
237: L.LANGUAGE_CODE
238: from FND_LANGUAGES L,
239: CSD_FLOW_STATUSES_B FS_B

Line 278: FND_GLOBAL.user_id,

274: 'Y', -- P_ALLOW_ALL_RESP_FLAG,
275: 1,
276: CSD_FLWSTS_TRANS_S1.nextval,
277: SYSDATE,
278: FND_GLOBAL.user_id,
279: SYSDATE,
280: FND_GLOBAL.user_id,
281: FND_GLOBAL.login_id
282: FROM CSD_REPAIR_TYPES_B RT,

Line 280: FND_GLOBAL.user_id,

276: CSD_FLWSTS_TRANS_S1.nextval,
277: SYSDATE,
278: FND_GLOBAL.user_id,
279: SYSDATE,
280: FND_GLOBAL.user_id,
281: FND_GLOBAL.login_id
282: FROM CSD_REPAIR_TYPES_B RT,
283: CSD_FLOW_STATUSES_B FS_B1,
284: CSD_FLOW_STATUSES_B FS_B2

Line 281: FND_GLOBAL.login_id

277: SYSDATE,
278: FND_GLOBAL.user_id,
279: SYSDATE,
280: FND_GLOBAL.user_id,
281: FND_GLOBAL.login_id
282: FROM CSD_REPAIR_TYPES_B RT,
283: CSD_FLOW_STATUSES_B FS_B1,
284: CSD_FLOW_STATUSES_B FS_B2
285: WHERE FS_B1.flow_status_code IN ('C','H','O')

Line 311: FND_GLOBAL.user_id,

307: SOURCE_LANG
308: ) select
309: FLWSTS_B.flwsts_tran_id,
310: NULL, -- P_DESCRIPTION,
311: FND_GLOBAL.user_id,
312: SYSDATE,
313: FND_GLOBAL.user_id,
314: SYSDATE,
315: FND_GLOBAL.login_id,

Line 313: FND_GLOBAL.user_id,

309: FLWSTS_B.flwsts_tran_id,
310: NULL, -- P_DESCRIPTION,
311: FND_GLOBAL.user_id,
312: SYSDATE,
313: FND_GLOBAL.user_id,
314: SYSDATE,
315: FND_GLOBAL.login_id,
316: L.LANGUAGE_CODE,
317: L.LANGUAGE_CODE

Line 315: FND_GLOBAL.login_id,

311: FND_GLOBAL.user_id,
312: SYSDATE,
313: FND_GLOBAL.user_id,
314: SYSDATE,
315: FND_GLOBAL.login_id,
316: L.LANGUAGE_CODE,
317: L.LANGUAGE_CODE
318: from FND_LANGUAGES L,
319: CSD_FLWSTS_TRANS_B FLWSTS_B

Line 341: last_updated_by = FND_GLOBAL.user_id,

337:
338: UPDATE CSD_REPAIR_TYPES_B
339: SET start_flow_Status_id = FlowStatusIDs(c_open_index),
340: last_update_date = SYSDATE,
341: last_updated_by = FND_GLOBAL.user_id,
342: last_update_login = FND_GLOBAL.login_id
343: WHERE start_flow_Status_id IS NULL;
344:
345: -- STEP 5: Update all repair orders that do not have a value.

Line 342: last_update_login = FND_GLOBAL.login_id

338: UPDATE CSD_REPAIR_TYPES_B
339: SET start_flow_Status_id = FlowStatusIDs(c_open_index),
340: last_update_date = SYSDATE,
341: last_updated_by = FND_GLOBAL.user_id,
342: last_update_login = FND_GLOBAL.login_id
343: WHERE start_flow_Status_id IS NULL;
344:
345: -- STEP 5: Update all repair orders that do not have a value.
346: -- Update Inventory_Org_id and Flow_status_id

Line 401: last_updated_by = FND_GLOBAL.user_id,

397: 'D', FlowStatusIDs(c_draft_index)
398: ),
399: inventory_org_id = l_inv_org_id,
400: last_update_date = SYSDATE,
401: last_updated_by = FND_GLOBAL.user_id,
402: last_update_login = FND_GLOBAL.login_id
403: WHERE repair_line_id = repair_line_id_arr(i);
404:
405: END LOOP;

Line 402: last_update_login = FND_GLOBAL.login_id

398: ),
399: inventory_org_id = l_inv_org_id,
400: last_update_date = SYSDATE,
401: last_updated_by = FND_GLOBAL.user_id,
402: last_update_login = FND_GLOBAL.login_id
403: WHERE repair_line_id = repair_line_id_arr(i);
404:
405: END LOOP;
406: