eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_DB_AWD_DISB_DTL_PKG dependencies on IGF_DB_AWD_DISB_DTL

Line 1: PACKAGE BODY igf_db_awd_disb_dtl_pkg AS

1: PACKAGE BODY igf_db_awd_disb_dtl_pkg AS
2: /* $Header: IGFDI01B.pls 120.1 2006/06/06 07:30:42 akomurav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_awd_disb_dtl_all%ROWTYPE;

Line 5: old_references igf_db_awd_disb_dtl_all%ROWTYPE;

1: PACKAGE BODY igf_db_awd_disb_dtl_pkg AS
2: /* $Header: IGFDI01B.pls 120.1 2006/06/06 07:30:42 akomurav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_awd_disb_dtl_all%ROWTYPE;
6: new_references igf_db_awd_disb_dtl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_db_awd_disb_dtl_all%ROWTYPE;

2: /* $Header: IGFDI01B.pls 120.1 2006/06/06 07:30:42 akomurav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_awd_disb_dtl_all%ROWTYPE;
6: new_references igf_db_awd_disb_dtl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 58: FROM igf_db_awd_disb_dtl_all

54: */
55:
56: CURSOR cur_old_ref_values IS
57: SELECT *
58: FROM igf_db_awd_disb_dtl_all
59: WHERE rowid = x_rowid;
60:
61: BEGIN
62:

Line 171: FROM igf_db_awd_disb_dtl_all

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igf_db_awd_disb_dtl_all
172: WHERE award_id = x_award_id
173: AND disb_num = x_disb_num
174: AND disb_seq_num = x_disb_seq_num
175: FOR UPDATE NOWAIT;

Line 209: FROM igf_db_awd_disb_dtl_all

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

Line 285: FROM igf_db_awd_disb_dtl

281:
282: CURSOR c_sf_credit_id(cp_sf_credit_id NUMBER)
283: IS
284: SELECT 'X'
285: FROM igf_db_awd_disb_dtl
286: WHERE sf_credit_id = cp_sf_credit_id
287: AND ((l_rowid IS NULL) OR (x_rowid <> l_rowid));
288:
289: l_sf_credit_id c_sf_credit_id%ROWTYPE;

Line 294: FROM igf_db_awd_disb_dtl

290:
291: CURSOR c_spnsr_credit_id(cp_spnsr_credit_id NUMBER)
292: IS
293: SELECT 'X'
294: FROM igf_db_awd_disb_dtl
295: WHERE spnsr_credit_id = cp_spnsr_credit_id
296: AND ((l_rowid IS NULL) OR (x_rowid <> l_rowid));
297:
298: l_spnsr_credit_id c_spnsr_credit_id%ROWTYPE;

Line 303: FROM igf_db_awd_disb_dtl

299:
300: CURSOR c_spnsr_charge_id(cp_spnsr_charge_id NUMBER)
301: IS
302: SELECT 'X'
303: FROM igf_db_awd_disb_dtl
304: WHERE spnsr_charge_id = cp_spnsr_charge_id
305: AND ((l_rowid IS NULL) OR (x_rowid <> l_rowid));
306:
307: l_spnsr_charge_id c_spnsr_charge_id%ROWTYPE;

Line 312: FROM igf_db_awd_disb_dtl

308:
309: CURSOR c_sf_invoice_num (cp_sf_invoice_num NUMBER)
310: IS
311: SELECT 'X'
312: FROM igf_db_awd_disb_dtl
313: WHERE sf_invoice_num = cp_sf_invoice_num
314: AND ((l_rowid IS NULL) OR (x_rowid <> l_rowid));
315:
316: l_sf_invoice_num c_sf_invoice_num%ROWTYPE;

Line 553: FROM igf_db_awd_disb_dtl_all

549: || (reverse chronological order - newest change first)
550: */
551: CURSOR c IS
552: SELECT rowid
553: FROM igf_db_awd_disb_dtl_all
554: WHERE award_id = x_award_id
555: AND disb_num = x_disb_num
556: AND disb_seq_num = x_disb_seq_num;
557:

Line 565: l_org_id igf_db_awd_disb_dtl_all.org_id%TYPE;

561: x_request_id NUMBER;
562: x_program_id NUMBER;
563: x_program_application_id NUMBER;
564: x_program_update_date DATE;
565: l_org_id igf_db_awd_disb_dtl_all.org_id%TYPE;
566:
567: BEGIN
568:
569: l_org_id := igf_aw_gen.get_org_id;

Line 641: INSERT INTO igf_db_awd_disb_dtl_all (

637: x_ld_cal_type => x_ld_cal_type,
638: x_ld_sequence_number => x_ld_sequence_number
639: );
640:
641: INSERT INTO igf_db_awd_disb_dtl_all (
642: award_id,
643: disb_num,
644: disb_seq_num,
645: disb_gross_amt,

Line 804: FROM igf_db_awd_disb_dtl_all

800: notification_date,
801: interest_rebate_amt,
802: ld_cal_type,
803: ld_sequence_number
804: FROM igf_db_awd_disb_dtl_all
805: WHERE rowid = x_rowid
806: FOR UPDATE NOWAIT;
807:
808: tlinfo c1%ROWTYPE;

Line 982: UPDATE igf_db_awd_disb_dtl_all

978: x_program_update_date := SYSDATE;
979: END IF;
980: END IF;
981:
982: UPDATE igf_db_awd_disb_dtl_all
983: SET
984: disb_gross_amt = new_references.disb_gross_amt,
985: fee_1 = new_references.fee_1,
986: fee_2 = new_references.fee_2,

Line 1070: FROM igf_db_awd_disb_dtl_all

1066: || (reverse chronological order - newest change first)
1067: */
1068: CURSOR c1 IS
1069: SELECT rowid
1070: FROM igf_db_awd_disb_dtl_all
1071: WHERE award_id = x_award_id
1072: AND disb_num = x_disb_num
1073: AND disb_seq_num = x_disb_seq_num;
1074:

Line 1175: DELETE FROM igf_db_awd_disb_dtl_all

1171: p_action => 'DELETE',
1172: x_rowid => x_rowid
1173: );
1174:
1175: DELETE FROM igf_db_awd_disb_dtl_all
1176: WHERE rowid = x_rowid;
1177:
1178: IF (SQL%NOTFOUND) THEN
1179: RAISE NO_DATA_FOUND;

Line 1185: END igf_db_awd_disb_dtl_pkg;

1181:
1182: END delete_row;
1183:
1184:
1185: END igf_db_awd_disb_dtl_pkg;