APPS.FA_ADJUSTMENTS_PKG dependencies on FA_ADJUSTMENTS

Line 1: PACKAGE BODY FA_ADJUSTMENTS_PKG as

1: PACKAGE BODY FA_ADJUSTMENTS_PKG as
2: /* $Header: faxiajb.pls 120.3 2005/07/25 09:59:07 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Transaction_Header_Id NUMBER,

Line 31: INSERT INTO fa_adjustments_mrc_v(

27: BEGIN
28:
29: if (X_mrc_sob_type_code = 'R') then
30:
31: INSERT INTO fa_adjustments_mrc_v(
32: transaction_header_id,
33: source_type_code,
34: adjustment_type,
35: debit_credit_flag,

Line 71: INSERT INTO fa_adjustments(

67: X_Period_Counter_Created,
68: X_Asset_Invoice_Id
69: );
70: else
71: INSERT INTO fa_adjustments(
72: transaction_header_id,
73: source_type_code,
74: adjustment_type,
75: debit_credit_flag,

Line 116: calling_fn => 'FA_ADJUSTMENTS_PKG.Insert_Row'

112:
113: EXCEPTION
114: when others then
115: fa_srvr_msg.add_sql_error(
116: calling_fn => 'FA_ADJUSTMENTS_PKG.Insert_Row'
117: ,p_log_level_rec => p_log_level_rec);
118: raise;
119:
120: END Insert_Row;

Line 181: FROM fa_adjustments

177: global_attribute18,
178: global_attribute19,
179: global_attribute20,
180: global_attribute_category
181: FROM fa_adjustments
182: WHERE rowid = X_Rowid
183: FOR UPDATE of transaction_header_id NOWAIT;
184: Recinfo C%ROWTYPE;
185:

Line 257: UPDATE fa_adjustments_mrc_v

253:
254: BEGIN
255:
256: if (X_mrc_sob_type_code = 'R') then
257: UPDATE fa_adjustments_mrc_v
258: SET
259: transaction_header_id = X_Transaction_Header_Id,
260: source_type_code = X_Source_Type_Code,
261: adjustment_type = X_Adjustment_Type,

Line 279: UPDATE fa_adjustments_mrc_v

275: period_counter_created = X_Period_Counter_Created,
276: asset_invoice_id = X_Asset_Invoice_Id
277: WHERE rowid = X_Rowid;
278: else
279: UPDATE fa_adjustments_mrc_v
280: SET
281: transaction_header_id = X_Transaction_Header_Id,
282: source_type_code = X_Source_Type_Code,
283: adjustment_type = X_Adjustment_Type,

Line 309: calling_fn => 'FA_ADJUSTMENTS_PKG.Update_Row'

305:
306: EXCEPTION
307: when others then
308: fa_srvr_msg.add_sql_error(
309: calling_fn => 'FA_ADJUSTMENTS_PKG.Update_Row'
310: ,p_log_level_rec => p_log_level_rec);
311: raise;
312:
313: END Update_Row;

Line 326: DELETE FROM fa_adjustments_mrc_v

322: BEGIN
323:
324: if (X_mrc_sob_type_code = 'R') then
325: if X_Rowid is not null then
326: DELETE FROM fa_adjustments_mrc_v
327: WHERE rowid = X_Rowid;
328: elsif X_Asset_Id is not null then
329: DELETE FROM fa_adjustments_mrc_v
330: WHERE asset_id = X_Asset_id;

Line 329: DELETE FROM fa_adjustments_mrc_v

325: if X_Rowid is not null then
326: DELETE FROM fa_adjustments_mrc_v
327: WHERE rowid = X_Rowid;
328: elsif X_Asset_Id is not null then
329: DELETE FROM fa_adjustments_mrc_v
330: WHERE asset_id = X_Asset_id;
331: end if;
332: else
333: if X_Rowid is not null then

Line 334: DELETE FROM fa_adjustments

330: WHERE asset_id = X_Asset_id;
331: end if;
332: else
333: if X_Rowid is not null then
334: DELETE FROM fa_adjustments
335: WHERE rowid = X_Rowid;
336: elsif X_Asset_Id is not null then
337: DELETE FROM fa_adjustments
338: WHERE asset_id = X_Asset_id;

Line 337: DELETE FROM fa_adjustments

333: if X_Rowid is not null then
334: DELETE FROM fa_adjustments
335: WHERE rowid = X_Rowid;
336: elsif X_Asset_Id is not null then
337: DELETE FROM fa_adjustments
338: WHERE asset_id = X_Asset_id;
339: end if;
340: end if;
341:

Line 351: calling_fn => 'FA_ADJUSTMENTS_PKG.Delete_Row'

347: when no_data_found then
348: null;
349: when others then
350: fa_srvr_msg.add_sql_error(
351: calling_fn => 'FA_ADJUSTMENTS_PKG.Delete_Row'
352: ,p_log_level_rec => p_log_level_rec);
353: raise;
354:
355: END Delete_Row;

Line 357: END FA_ADJUSTMENTS_PKG;

353: raise;
354:
355: END Delete_Row;
356:
357: END FA_ADJUSTMENTS_PKG;