APPS.IGF_AW_DB_CHG_DTLS_PKG dependencies on IGF_AW_DB_CHG_DTLS

Line 1: PACKAGE BODY igf_aw_db_chg_dtls_pkg AS

1: PACKAGE BODY igf_aw_db_chg_dtls_pkg AS
2: /* $Header: IGFWI64B.pls 120.1 2005/09/28 05:31:35 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_chg_dtls%ROWTYPE;

Line 5: old_references igf_aw_db_chg_dtls%ROWTYPE;

1: PACKAGE BODY igf_aw_db_chg_dtls_pkg AS
2: /* $Header: IGFWI64B.pls 120.1 2005/09/28 05:31:35 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_chg_dtls%ROWTYPE;
6: new_references igf_aw_db_chg_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_db_chg_dtls%ROWTYPE;

2: /* $Header: IGFWI64B.pls 120.1 2005/09/28 05:31:35 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_chg_dtls%ROWTYPE;
6: new_references igf_aw_db_chg_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 49: FROM igf_aw_db_chg_dtls

45: */
46:
47: CURSOR cur_old_ref_values IS
48: SELECT *
49: FROM igf_aw_db_chg_dtls
50: WHERE rowid = x_rowid;
51:
52: BEGIN
53:

Line 138: FROM igf_aw_db_chg_dtls

134: || (reverse chronological order - newest change first)
135: */
136: CURSOR cur_rowid IS
137: SELECT rowid
138: FROM igf_aw_db_chg_dtls
139: WHERE award_id = x_award_id
140: AND disb_num = x_disb_num
141: AND disb_seq_num = x_disb_seq_num
142: FOR UPDATE NOWAIT;

Line 174: FROM igf_aw_db_chg_dtls

170: || (reverse chronological order - newest change first)
171: */
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM igf_aw_db_chg_dtls
175: WHERE ((award_id = x_award_id));
176:
177: lv_rowid cur_rowid%RowType;
178:

Line 210: FROM igf_aw_db_chg_dtls

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igf_aw_db_chg_dtls
211: WHERE award_id = x_award_id
212: AND disb_num = x_disb_num;
213:
214: lv_rowid cur_rowid%RowType;

Line 373: FROM igf_aw_db_chg_dtls

369: */
370:
371: CURSOR c IS
372: SELECT rowid
373: FROM igf_aw_db_chg_dtls
374: WHERE award_id = x_award_id
375: AND disb_num = x_disb_num
376: AND disb_seq_num = x_disb_seq_num;
377:

Line 415: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_CHG_DTLS_PKG.INSERT_ROW');

411: x_program_update_date := SYSDATE;
412: END IF;
413: ELSE
414: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
415: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_CHG_DTLS_PKG.INSERT_ROW');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419:

Line 450: INSERT INTO igf_aw_db_chg_dtls (

446: x_last_updated_by => x_last_updated_by,
447: x_last_update_login => x_last_update_login
448: );
449:
450: INSERT INTO igf_aw_db_chg_dtls (
451: award_id,
452: disb_num,
453: disb_seq_num,
454: disb_accepted_amt,

Line 576: FROM igf_aw_db_chg_dtls

572: batch_id_txt,
573: ack_date,
574: booking_id_txt,
575: booking_date
576: FROM igf_aw_db_chg_dtls
577: WHERE rowid = x_rowid
578: FOR UPDATE NOWAIT;
579:
580: tlinfo c1%ROWTYPE;

Line 684: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_CHG_DTLS_PKG.UPDATE_ROW');

680: x_last_update_login := -1;
681: END IF;
682: ELSE
683: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
684: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_CHG_DTLS_PKG.UPDATE_ROW');
685: igs_ge_msg_stack.add;
686: app_exception.raise_exception;
687: END IF;
688:

Line 733: UPDATE igf_aw_db_chg_dtls

729: x_program_update_date := SYSDATE;
730: END IF;
731: END IF;
732:
733: UPDATE igf_aw_db_chg_dtls
734: SET
735: disb_accepted_amt = new_references.disb_accepted_amt,
736: orig_fee_amt = new_references.orig_fee_amt,
737: disb_net_amt = new_references.disb_net_amt,

Line 803: FROM igf_aw_db_chg_dtls

799: || (reverse chronological order - newest change first)
800: */
801: CURSOR c1 IS
802: SELECT rowid
803: FROM igf_aw_db_chg_dtls
804: WHERE award_id = x_award_id
805: AND disb_num = x_disb_num
806: AND disb_seq_num = x_disb_seq_num;
807:

Line 890: DELETE FROM igf_aw_db_chg_dtls

886: p_action => 'DELETE',
887: x_rowid => x_rowid
888: );
889:
890: DELETE FROM igf_aw_db_chg_dtls
891: WHERE rowid = x_rowid;
892:
893: IF (SQL%NOTFOUND) THEN
894: RAISE NO_DATA_FOUND;

Line 900: END igf_aw_db_chg_dtls_pkg;

896:
897: END delete_row;
898:
899:
900: END igf_aw_db_chg_dtls_pkg;