APPS.IEX_TERR_PUB dependencies on FND_GLOBAL

Line 370: ,FND_GLOBAL.user_id

366: ,l_party_id
367: ,l_custaccount_id
368: ,null
369: ,sysdate
370: ,FND_GLOBAL.user_id
371: ,sysdate
372: ,FND_GLOBAL.user_id
373: ,FND_GLOBAL.login_id
374: ,'ACCOUNT'

Line 372: ,FND_GLOBAL.user_id

368: ,null
369: ,sysdate
370: ,FND_GLOBAL.user_id
371: ,sysdate
372: ,FND_GLOBAL.user_id
373: ,FND_GLOBAL.login_id
374: ,'ACCOUNT'
375: ,'N'
376: );

Line 373: ,FND_GLOBAL.login_id

369: ,sysdate
370: ,FND_GLOBAL.user_id
371: ,sysdate
372: ,FND_GLOBAL.user_id
373: ,FND_GLOBAL.login_id
374: ,'ACCOUNT'
375: ,'N'
376: );
377: -- COMMIT; -- Commented for bug#7678917 by PNAVEENK on 5-1-2009

Line 429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

425: BEGIN
426: UPDATE HZ_CUSTOMER_PROFILES ACC
427: SET object_version_number = nvl(object_version_number,0) + 1,
428: ACC.LAST_UPDATE_DATE = SYSDATE,
429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,
431: ACC.PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
432: ACC.PROGRAM_UPDATE_DATE = SYSDATE,
433: ACC.COLLECTOR_ID = x_winners_rec.resource_id(i)

Line 430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,

426: UPDATE HZ_CUSTOMER_PROFILES ACC
427: SET object_version_number = nvl(object_version_number,0) + 1,
428: ACC.LAST_UPDATE_DATE = SYSDATE,
429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,
431: ACC.PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
432: ACC.PROGRAM_UPDATE_DATE = SYSDATE,
433: ACC.COLLECTOR_ID = x_winners_rec.resource_id(i)
434: WHERE ACC.PARTY_ID = x_winners_rec.trans_object_id(i)

Line 431: ACC.PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

427: SET object_version_number = nvl(object_version_number,0) + 1,
428: ACC.LAST_UPDATE_DATE = SYSDATE,
429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,
431: ACC.PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
432: ACC.PROGRAM_UPDATE_DATE = SYSDATE,
433: ACC.COLLECTOR_ID = x_winners_rec.resource_id(i)
434: WHERE ACC.PARTY_ID = x_winners_rec.trans_object_id(i)
435: AND ACC.SITE_USE_ID IS NULL