APPS.XTR_DNM_PKG dependencies on XTR_BATCH_EVENTS

Line 28: XTR_BATCH_EVENTS C,

24: , 'REVAL' DATE_TYPE
25: FROM
26: XTR_REVALUATION_DETAILS A,
27: XTR_BATCHES B,
28: XTR_BATCH_EVENTS C,
29: XTR_PARTIES_V P,
30: GL_SETS_OF_BOOKS SOB
31: WHERE B.BATCH_ID = p_batch_id
32: AND B.BATCH_ID = A.BATCH_ID

Line 126: Update XTR_BATCH_EVENTS

122:
123: End Loop;
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,

Line 143: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error updating XTR_BATCH_EVENTS');

139: end if;
140: Exception
141: When Others Then
142: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
143: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error updating XTR_BATCH_EVENTS');
144: END IF;
145: Raise;
146: End;
147:

Line 172: and EXISTS (select 'Dummy' from XTR_BATCH_EVENTS B

168: Cursor DNM is
169: Select rowid
170: From XTR_GAIN_LOSS_DNM A
171: where A.BATCH_ID = p_batch_id
172: and EXISTS (select 'Dummy' from XTR_BATCH_EVENTS B
173: where B.BATCH_ID = A.BATCH_ID
174: and B.EVENT_CODE = 'REVAL'
175: and B.AUTHORIZED = 'Y')
176: and NOT EXISTS (select 'X' from XTR_BATCH_EVENTS C

Line 176: and NOT EXISTS (select 'X' from XTR_BATCH_EVENTS C

172: and EXISTS (select 'Dummy' from XTR_BATCH_EVENTS B
173: where B.BATCH_ID = A.BATCH_ID
174: and B.EVENT_CODE = 'REVAL'
175: and B.AUTHORIZED = 'Y')
176: and NOT EXISTS (select 'X' from XTR_BATCH_EVENTS C
177: where C.BATCH_ID = A.BATCH_ID
178: and C.EVENT_CODE = 'JRNLGN')
179: for update nowait;
180:

Line 183: From XTR_BATCH_EVENTS

179: for update nowait;
180:
181: Cursor BE is
182: Select rowid
183: From XTR_BATCH_EVENTS
184: Where BATCH_ID = p_batch_id
185: and EVENT_CODE = 'REVAL'
186: and AUTHORIZED = 'Y'
187: for update of batch_id nowait;

Line 218: Update XTR_BATCH_EVENTS

214: Loop
215: Fetch BE into l_rowid;
216: Exit when BE%NOTFOUND;
217:
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,