APPS.IGS_FI_REFUND_SETUP_PKG dependencies on IGS_FI_REFUND_SETUP

Line 1: PACKAGE BODY igs_fi_refund_setup_pkg AS

1: PACKAGE BODY igs_fi_refund_setup_pkg AS
2: /* $Header: IGSSIB3B.pls 115.13 2002/12/19 06:12:32 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_refund_setup%ROWTYPE;

Line 5: old_references igs_fi_refund_setup%ROWTYPE;

1: PACKAGE BODY igs_fi_refund_setup_pkg AS
2: /* $Header: IGSSIB3B.pls 115.13 2002/12/19 06:12:32 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_refund_setup%ROWTYPE;
6: new_references igs_fi_refund_setup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_refund_setup%ROWTYPE;

2: /* $Header: IGSSIB3B.pls 115.13 2002/12/19 06:12:32 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_refund_setup%ROWTYPE;
6: new_references igs_fi_refund_setup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM igs_fi_refund_setup

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_fi_refund_setup
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 90: FROM igs_fi_refund_setup

86: || (reverse chronological order - newest change first)
87: */
88: CURSOR cur_rowid IS
89: SELECT rowid
90: FROM igs_fi_refund_setup
91: WHERE refund_setup_id = x_refund_setup_id
92: FOR UPDATE NOWAIT;
93:
94: lv_rowid cur_rowid%RowType;

Line 129: FROM igs_fi_refund_setup

125:
126: CURSOR cur_lmt is
127: SELECT start_date ,
128: end_date
129: FROM igs_fi_refund_setup
130: WHERE refund_setup_id<>p_refund_setup_id OR
131: p_refund_setup_id IS NULL;
132: l_flag BOOLEAN :=false;
133: BEGIN

Line 393: FROM igs_fi_refund_setup

389: || (reverse chronological order - newest change first)
390: */
391: CURSOR c IS
392: SELECT rowid
393: FROM igs_fi_refund_setup
394: WHERE refund_setup_id = x_refund_setup_id;
395:
396: x_last_update_date DATE;
397: x_last_updated_by NUMBER;

Line 421: SELECT igs_fi_refund_setup_s.NEXTVAL

417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
421: SELECT igs_fi_refund_setup_s.NEXTVAL
422: INTO x_refund_setup_id
423: FROM dual;
424:
425: before_dml(

Line 440: INSERT INTO igs_fi_refund_setup (

436: x_last_updated_by => x_last_updated_by,
437: x_last_update_login => x_last_update_login
438: );
439:
440: INSERT INTO igs_fi_refund_setup (
441: refund_setup_id,
442: start_date,
443: end_date,
444: amount_high,

Line 498: FROM igs_fi_refund_setup

494: start_date,
495: end_date,
496: amount_high,
497: amount_low
498: FROM igs_fi_refund_setup
499: WHERE rowid = x_rowid
500: FOR UPDATE NOWAIT;
501:
502: tlinfo c1%ROWTYPE;

Line 593: UPDATE igs_fi_refund_setup

589: x_last_updated_by => x_last_updated_by,
590: x_last_update_login => x_last_update_login
591: );
592:
593: UPDATE igs_fi_refund_setup
594: SET
595: start_date = new_references.start_date,
596: end_date = new_references.end_date,
597: amount_high = new_references.amount_high,

Line 631: FROM igs_fi_refund_setup

627: || (reverse chronological order - newest change first)
628: */
629: CURSOR c1 IS
630: SELECT rowid
631: FROM igs_fi_refund_setup
632: WHERE refund_setup_id = x_refund_setup_id;
633:
634: BEGIN
635:

Line 686: DELETE FROM igs_fi_refund_setup

682: p_action => 'DELETE',
683: x_rowid => x_rowid
684: );
685:
686: DELETE FROM igs_fi_refund_setup
687: WHERE rowid = x_rowid;
688:
689: IF (SQL%NOTFOUND) THEN
690: RAISE NO_DATA_FOUND;

Line 696: END igs_fi_refund_setup_pkg;

692:
693: END delete_row;
694:
695:
696: END igs_fi_refund_setup_pkg;