DBA Data[Home] [Help]

APPS.XTR_DNM_PKG dependencies on FND_GLOBAL

Line 90: fnd_global.user_id,

86: dnm_rec.REVAL_CCY,
87: dnm_rec.PERIOD_TO,
88: 'R', -- Revaluation process flag
89: sysdate,
90: fnd_global.user_id,
91: sysdate,
92: fnd_global.user_id,
93: fnd_global.login_id
94: );

Line 92: fnd_global.user_id,

88: 'R', -- Revaluation process flag
89: sysdate,
90: fnd_global.user_id,
91: sysdate,
92: fnd_global.user_id,
93: fnd_global.login_id
94: );
95: End If;
96:

Line 93: fnd_global.login_id

89: sysdate,
90: fnd_global.user_id,
91: sysdate,
92: fnd_global.user_id,
93: fnd_global.login_id
94: );
95: End If;
96:
97: If nvl(dnm_rec.CURR_GAIN_LOSS_AMOUNT,0) <> 0 Then

Line 116: fnd_global.user_id,

112: dnm_rec.SOB_CCY, -- replaced dnm_rec.REVAL_CCY with dnm_rec.SOB_CCY,
113: dnm_rec.PERIOD_TO,
114: 'R', -- Revaluation process flag
115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.user_id,
119: fnd_global.login_id
120: );

Line 118: fnd_global.user_id,

114: 'R', -- Revaluation process flag
115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.user_id,
119: fnd_global.login_id
120: );
121: End If;
122:

Line 119: fnd_global.login_id

115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.user_id,
119: fnd_global.login_id
120: );
121: End If;
122:
123: End Loop;

Line 128: AUTHORIZED_BY = FND_GLOBAL.USER_ID,

124:
125: Begin
126: Update XTR_BATCH_EVENTS
127: set AUTHORIZED = 'Y',
128: AUTHORIZED_BY = FND_GLOBAL.USER_ID,
129: AUTHORIZED_ON = SYSDATE,
130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
131: LAST_UPDATE_DATE = SYSDATE,
132: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

126: Update XTR_BATCH_EVENTS
127: set AUTHORIZED = 'Y',
128: AUTHORIZED_BY = FND_GLOBAL.USER_ID,
129: AUTHORIZED_ON = SYSDATE,
130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
131: LAST_UPDATE_DATE = SYSDATE,
132: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
133: where BATCH_ID = p_batch_id
134: and EVENT_CODE = 'REVAL'

Line 132: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

128: AUTHORIZED_BY = FND_GLOBAL.USER_ID,
129: AUTHORIZED_ON = SYSDATE,
130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
131: LAST_UPDATE_DATE = SYSDATE,
132: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
133: where BATCH_ID = p_batch_id
134: and EVENT_CODE = 'REVAL'
135: and nvl(AUTHORIZED,'N') <> 'Y';
136:

Line 222: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

218: Update XTR_BATCH_EVENTS
219: set AUTHORIZED = 'N',
220: AUTHORIZED_BY = NULL,
221: AUTHORIZED_ON = NULL,
222: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
225: where rowid = l_rowid;
226: End Loop;

Line 224: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

220: AUTHORIZED_BY = NULL,
221: AUTHORIZED_ON = NULL,
222: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
225: where rowid = l_rowid;
226: End Loop;
227: Close BE;
228: