APPS.IGF_SL_AWD_DISB_LOC_PKG dependencies on IGF_SL_AWD_DISB_LOC_ALL

Line 5: old_references igf_sl_awd_disb_loc_all%ROWTYPE;

1: PACKAGE BODY igf_sl_awd_disb_loc_pkg AS
2: /* $Header: IGFLI24B.pls 120.0 2005/06/01 14:44:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_awd_disb_loc_all%ROWTYPE;
6: new_references igf_sl_awd_disb_loc_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_awd_disb_loc_all%ROWTYPE;

2: /* $Header: IGFLI24B.pls 120.0 2005/06/01 14:44:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_awd_disb_loc_all%ROWTYPE;
6: new_references igf_sl_awd_disb_loc_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM IGF_SL_AWD_DISB_LOC_ALL

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGF_SL_AWD_DISB_LOC_ALL
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 127: FROM igf_sl_awd_disb_loc_all

123: || (reverse chronological order - newest change first)
124: */
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM igf_sl_awd_disb_loc_all
128: WHERE award_id = x_award_id
129: AND disb_num = x_disb_num
130: FOR UPDATE NOWAIT;
131:

Line 163: FROM igf_sl_awd_disb_loc_all

159: || (reverse chronological order - newest change first)
160: */
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM igf_sl_awd_disb_loc_all
164: WHERE ((award_id = x_award_id));
165:
166: lv_rowid cur_rowid%RowType;
167:

Line 291: FROM igf_sl_awd_disb_loc_all

287: || (reverse chronological order - newest change first)
288: */
289: CURSOR c IS
290: SELECT rowid
291: FROM igf_sl_awd_disb_loc_all
292: WHERE award_id = x_award_id
293: AND disb_num = x_disb_num;
294:
295: x_last_update_date DATE;

Line 302: l_org_id igf_sl_awd_disb_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

298: x_request_id NUMBER;
299: x_program_id NUMBER;
300: x_program_application_id NUMBER;
301: x_program_update_date DATE;
302: l_org_id igf_sl_awd_disb_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
303:
304: BEGIN
305:
306: x_last_update_date := SYSDATE;

Line 357: INSERT INTO igf_sl_awd_disb_loc_all(

353: x_last_updated_by => x_last_updated_by,
354: x_last_update_login => x_last_update_login
355: );
356:
357: INSERT INTO igf_sl_awd_disb_loc_all(
358: award_id,
359: disb_num,
360: disb_gross_amt,
361: fee_1,

Line 447: FROM igf_sl_awd_disb_loc_all

443: hold_rel_ind,
444: fee_paid_1,
445: fee_paid_2,
446: org_id
447: FROM igf_sl_awd_disb_loc_all
448: WHERE rowid = x_rowid
449: FOR UPDATE NOWAIT;
450:
451: tlinfo c1%ROWTYPE;

Line 574: UPDATE igf_sl_awd_disb_loc_all

570: x_program_update_date := SYSDATE;
571: END IF;
572: END IF;
573:
574: UPDATE igf_sl_awd_disb_loc_all
575: SET
576: disb_gross_amt = new_references.disb_gross_amt,
577: fee_1 = new_references.fee_1,
578: fee_2 = new_references.fee_2,

Line 626: FROM igf_sl_awd_disb_loc_all

622: || (reverse chronological order - newest change first)
623: */
624: CURSOR c1 IS
625: SELECT rowid
626: FROM igf_sl_awd_disb_loc_all
627: WHERE award_id = x_award_id
628: AND disb_num = x_disb_num;
629:
630: BEGIN

Line 692: DELETE FROM igf_sl_awd_disb_loc_all

688: p_action => 'DELETE',
689: x_rowid => x_rowid
690: );
691:
692: DELETE FROM igf_sl_awd_disb_loc_all
693: WHERE rowid = x_rowid;
694:
695: IF (SQL%NOTFOUND) THEN
696: RAISE NO_DATA_FOUND;