APPS.IGS_FI_LB_OVFL_ERRS_PKG dependencies on IGS_FI_LB_OVFL_ERRS

Line 1: PACKAGE BODY igs_fi_lb_ovfl_errs_pkg AS

1: PACKAGE BODY igs_fi_lb_ovfl_errs_pkg AS
2: /* $Header: IGSSID6B.pls 115.1 2003/06/23 05:03:16 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_ovfl_errs%ROWTYPE;

Line 5: old_references igs_fi_lb_ovfl_errs%ROWTYPE;

1: PACKAGE BODY igs_fi_lb_ovfl_errs_pkg AS
2: /* $Header: IGSSID6B.pls 115.1 2003/06/23 05:03:16 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_ovfl_errs%ROWTYPE;
6: new_references igs_fi_lb_ovfl_errs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_lb_ovfl_errs%ROWTYPE;

2: /* $Header: IGSSID6B.pls 115.1 2003/06/23 05:03:16 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_ovfl_errs%ROWTYPE;
6: new_references igs_fi_lb_ovfl_errs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 47: FROM igs_fi_lb_ovfl_errs

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM igs_fi_lb_ovfl_errs
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 142: FROM igs_fi_lb_ovfl_errs

138: || (reverse chronological order - newest change first)
139: */
140: CURSOR cur_rowid IS
141: SELECT rowid
142: FROM igs_fi_lb_ovfl_errs
143: WHERE receipt_overflow_error_id = x_receipt_overflow_error_id
144: FOR UPDATE NOWAIT;
145:
146: lv_rowid cur_rowid%RowType;

Line 177: FROM igs_fi_lb_ovfl_errs

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igs_fi_lb_ovfl_errs
178: WHERE ((lockbox_receipt_error_id = x_lockbox_receipt_error_id));
179:
180: lv_rowid cur_rowid%RowType;
181:

Line 363: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_OVFL_ERRS_PKG.INSERT_ROW');

359: x_program_update_date := SYSDATE;
360: END IF;
361: ELSE
362: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
363: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_OVFL_ERRS_PKG.INSERT_ROW');
364: igs_ge_msg_stack.add;
365: app_exception.raise_exception;
366: END IF;
367:

Line 398: INSERT INTO igs_fi_lb_ovfl_errs (

394: x_last_updated_by => x_last_updated_by,
395: x_last_update_login => x_last_update_login
396: );
397:
398: INSERT INTO igs_fi_lb_ovfl_errs (
399: receipt_overflow_error_id,
400: lockbox_receipt_error_id,
401: charge_cd1,
402: charge_cd2,

Line 427: igs_fi_lb_ovfl_errs_s.NEXTVAL,

423: program_id,
424: program_application_id,
425: program_update_date
426: ) VALUES (
427: igs_fi_lb_ovfl_errs_s.NEXTVAL,
428: new_references.lockbox_receipt_error_id,
429: new_references.charge_cd1,
430: new_references.charge_cd2,
431: new_references.charge_cd3,

Line 508: FROM igs_fi_lb_ovfl_errs

504: applied_amt5,
505: applied_amt6,
506: applied_amt7,
507: applied_amt8
508: FROM igs_fi_lb_ovfl_errs
509: WHERE rowid = x_rowid
510: FOR UPDATE NOWAIT;
511:
512: tlinfo c1%ROWTYPE;

Line 614: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_OVFL_ERRS_PKG.UPDATE_ROW');

610: x_last_update_login := -1;
611: END IF;
612: ELSE
613: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
614: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_OVFL_ERRS_PKG.UPDATE_ROW');
615: igs_ge_msg_stack.add;
616: app_exception.raise_exception;
617: END IF;
618:

Line 661: UPDATE igs_fi_lb_ovfl_errs

657: x_program_update_date := SYSDATE;
658: END IF;
659: END IF;
660:
661: UPDATE igs_fi_lb_ovfl_errs
662: SET
663: lockbox_receipt_error_id = new_references.lockbox_receipt_error_id,
664: charge_cd1 = new_references.charge_cd1,
665: charge_cd2 = new_references.charge_cd2,

Line 714: DELETE FROM igs_fi_lb_ovfl_errs

710: p_action => 'DELETE',
711: x_rowid => x_rowid
712: );
713:
714: DELETE FROM igs_fi_lb_ovfl_errs
715: WHERE rowid = x_rowid;
716:
717: IF (SQL%NOTFOUND) THEN
718: RAISE NO_DATA_FOUND;

Line 724: END igs_fi_lb_ovfl_errs_pkg;

720:
721: END delete_row;
722:
723:
724: END igs_fi_lb_ovfl_errs_pkg;