APPS.IGF_AW_FUND_ROLLOVER_PKG dependencies on IGF_AW_FUND_ROLLOVER_ALL

Line 5: old_references igf_aw_fund_rollover_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fund_rollover_pkg AS
2: /* $Header: IGFWI28B.pls 115.6 2002/11/28 14:40:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_rollover_all%ROWTYPE;
6: new_references igf_aw_fund_rollover_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fund_rollover_all%ROWTYPE;

2: /* $Header: IGFWI28B.pls 115.6 2002/11/28 14:40:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_rollover_all%ROWTYPE;
6: new_references igf_aw_fund_rollover_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGF_AW_FUND_ROLLOVER_ALL

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

Line 164: FROM igf_aw_fund_rollover_all

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igf_aw_fund_rollover_all
165: WHERE frol_id = x_frol_id
166: FOR UPDATE NOWAIT;
167:
168: lv_rowid cur_rowid%RowType;

Line 202: l_org_id igf_aw_fund_rollover_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

198: || instead of igf_aw_fund_rollover for bug:2222272.
199: || (reverse chronological order - newest change first)
200: */
201:
202: l_org_id igf_aw_fund_rollover_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
203:
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igf_aw_fund_rollover

Line 244: FROM igf_aw_fund_rollover_all

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igf_aw_fund_rollover_all
245: WHERE ((cr_cal_type = x_cal_type) AND
246: (cr_sequence_number = x_sequence_number));
247:
248: lv_rowid cur_rowid%RowType;

Line 366: FROM igf_aw_fund_rollover_all

362: || (reverse chronological order - newest change first)
363: */
364: CURSOR c IS
365: SELECT rowid
366: FROM igf_aw_fund_rollover_all
367: WHERE frol_id = x_frol_id;
368:
369: x_last_update_date DATE;
370: x_last_updated_by NUMBER;

Line 431: INSERT INTO igf_aw_fund_rollover_all (

427: x_last_updated_by => x_last_updated_by,
428: x_last_update_login => x_last_update_login
429: );
430:
431: INSERT INTO igf_aw_fund_rollover_all (
432: frol_id,
433: cr_cal_type,
434: cr_sequence_number,
435: sc_sequence_number,

Line 499: FROM igf_aw_fund_rollover_all

495: cr_cal_type,
496: cr_sequence_number,
497: sc_sequence_number,
498: rollover_status
499: FROM igf_aw_fund_rollover_all
500: WHERE rowid = x_rowid
501: FOR UPDATE NOWAIT;
502:
503: tlinfo c1%ROWTYPE;

Line 612: UPDATE igf_aw_fund_rollover_all

608: x_program_update_date := SYSDATE;
609: END IF;
610: END IF;
611:
612: UPDATE igf_aw_fund_rollover_all
613: SET
614: cr_cal_type = new_references.cr_cal_type,
615: cr_sequence_number = new_references.cr_sequence_number,
616: sc_sequence_number = new_references.sc_sequence_number,

Line 654: FROM igf_aw_fund_rollover_all

650: || (reverse chronological order - newest change first)
651: */
652: CURSOR c1 IS
653: SELECT rowid
654: FROM igf_aw_fund_rollover_all
655: WHERE frol_id = x_frol_id;
656:
657: BEGIN
658:

Line 709: DELETE FROM igf_aw_fund_rollover_all

705: p_action => 'DELETE',
706: x_rowid => x_rowid
707: );
708:
709: DELETE FROM igf_aw_fund_rollover_all
710: WHERE rowid = x_rowid;
711:
712: IF (SQL%NOTFOUND) THEN
713: RAISE NO_DATA_FOUND;