APPS.XTR_DNM_PKG dependencies on XTR_GAIN_LOSS_DNM

Line 73: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;

69: Loop
70:
71: -- If nvl(dnm_rec.CUMM_GAIN_LOSS_AMOUNT,0) <> 0 Then
72: If nvl(dnm_rec.REAL_UNREAL_AMT,0) <> 0 Then
73: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;
74:
75: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(
76: row_id,
77: l_dnm_id ,

Line 75: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(

71: -- If nvl(dnm_rec.CUMM_GAIN_LOSS_AMOUNT,0) <> 0 Then
72: If nvl(dnm_rec.REAL_UNREAL_AMT,0) <> 0 Then
73: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;
74:
75: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(
76: row_id,
77: l_dnm_id ,
78: dnm_rec.BATCH_ID,
79: dnm_rec.COMPANY_CODE,

Line 99: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;

95: End If;
96:
97: If nvl(dnm_rec.CURR_GAIN_LOSS_AMOUNT,0) <> 0 Then
98:
99: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;
100:
101: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(
102: row_id,
103: l_dnm_id,

Line 101: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(

97: If nvl(dnm_rec.CURR_GAIN_LOSS_AMOUNT,0) <> 0 Then
98:
99: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;
100:
101: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(
102: row_id,
103: l_dnm_id,
104: dnm_rec.BATCH_ID,
105: dnm_rec.COMPANY_CODE,

Line 158: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error in XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW');

154:
155: EXCEPTION
156: When Others Then
157: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
158: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error in XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW');
159: END IF;
160: Raise;
161: End AUTHORIZE;
162:

Line 170: From XTR_GAIN_LOSS_DNM A

166: -- Bug 2685848 additions.
167:
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'

Line 207: Delete from XTR_GAIN_LOSS_DNM

203: Loop
204: Fetch DNM into l_rowid;
205: Exit when DNM%NOTFOUND;
206:
207: Delete from XTR_GAIN_LOSS_DNM
208: Where rowid = l_rowid;
209: End Loop;
210: Close DNM;
211: