APPS.IGF_AW_DB_COD_DTLS_PKG dependencies on IGF_AW_DB_COD_DTLS

Line 1: PACKAGE BODY igf_aw_db_cod_dtls_pkg AS

1: PACKAGE BODY igf_aw_db_cod_dtls_pkg AS
2: /* $Header: IGFWI65B.pls 120.0 2005/06/01 15:20:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_cod_dtls%ROWTYPE;

Line 5: old_references igf_aw_db_cod_dtls%ROWTYPE;

1: PACKAGE BODY igf_aw_db_cod_dtls_pkg AS
2: /* $Header: IGFWI65B.pls 120.0 2005/06/01 15:20:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_cod_dtls%ROWTYPE;
6: new_references igf_aw_db_cod_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_db_cod_dtls%ROWTYPE;

2: /* $Header: IGFWI65B.pls 120.0 2005/06/01 15:20:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_db_cod_dtls%ROWTYPE;
6: new_references igf_aw_db_cod_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 45: FROM igf_aw_db_cod_dtls

41: */
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM igf_aw_db_cod_dtls
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 130: FROM igf_aw_db_cod_dtls

126: || (reverse chronological order - newest change first)
127: */
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM igf_aw_db_cod_dtls
131: WHERE award_id = x_award_id
132: AND disb_num = x_disb_num
133: AND disb_seq_num = x_disb_seq_num
134: FOR UPDATE NOWAIT;

Line 167: FROM igf_aw_db_cod_dtls

163: || (reverse chronological order - newest change first)
164: */
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igf_aw_db_cod_dtls
168: WHERE ((award_id = x_award_id));
169:
170: lv_rowid cur_rowid%RowType;
171:

Line 203: FROM igf_aw_db_cod_dtls

199: || (reverse chronological order - newest change first)
200: */
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igf_aw_db_cod_dtls
204: WHERE award_id = x_award_id
205: AND disb_num = x_disb_num;
206:
207: lv_rowid cur_rowid%RowType;

Line 354: FROM igf_aw_db_cod_dtls

350: */
351:
352: CURSOR c IS
353: SELECT rowid
354: FROM igf_aw_db_cod_dtls
355: WHERE award_id = x_award_id
356: AND disb_num = x_disb_num
357: AND disb_seq_num = x_disb_seq_num;
358:

Line 396: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.INSERT_ROW');

392: x_program_update_date := SYSDATE;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.INSERT_ROW');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400:

Line 427: INSERT INTO igf_aw_db_cod_dtls (

423: x_last_updated_by => x_last_updated_by,
424: x_last_update_login => x_last_update_login
425: );
426:
427: INSERT INTO igf_aw_db_cod_dtls (
428: award_id,
429: document_id_txt,
430: disb_num,
431: disb_seq_num,

Line 536: FROM igf_aw_db_cod_dtls

532: pymnt_per_start_date,
533: note_message,
534: rep_entity_id_txt,
535: atd_entity_id_txt
536: FROM igf_aw_db_cod_dtls
537: WHERE rowid = x_rowid
538: FOR UPDATE NOWAIT;
539:
540: tlinfo c1%ROWTYPE;

Line 636: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.UPDATE_ROW');

632: x_last_update_login := -1;
633: END IF;
634: ELSE
635: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
636: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.UPDATE_ROW');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640:

Line 681: UPDATE igf_aw_db_cod_dtls

677: x_program_update_date := SYSDATE;
678: END IF;
679: END IF;
680:
681: UPDATE igf_aw_db_cod_dtls
682: SET
683: document_id_txt = new_references.document_id_txt,
684: disb_accepted_amt = new_references.disb_accepted_amt,
685: orig_fee_amt = new_references.orig_fee_amt,

Line 743: FROM igf_aw_db_cod_dtls

739: || (reverse chronological order - newest change first)
740: */
741: CURSOR c1 IS
742: SELECT rowid
743: FROM igf_aw_db_cod_dtls
744: WHERE award_id = x_award_id
745: AND disb_num = x_disb_num
746: AND disb_seq_num = x_disb_seq_num;
747:

Line 822: DELETE FROM igf_aw_db_cod_dtls

818: p_action => 'DELETE',
819: x_rowid => x_rowid
820: );
821:
822: DELETE FROM igf_aw_db_cod_dtls
823: WHERE rowid = x_rowid;
824:
825: IF (SQL%NOTFOUND) THEN
826: RAISE NO_DATA_FOUND;

Line 832: END igf_aw_db_cod_dtls_pkg;

828:
829: END delete_row;
830:
831:
832: END igf_aw_db_cod_dtls_pkg;