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_AW_FUND_ROLLOVER_PKG dependencies on IGF_AW_FUND_ROLLOVER

Line 1: PACKAGE BODY igf_aw_fund_rollover_pkg AS

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;

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 143: igf_aw_frlog_pkg.get_fk_igf_aw_fund_rollover (

139: || (reverse chronological order - newest change first)
140: */
141: BEGIN
142:
143: igf_aw_frlog_pkg.get_fk_igf_aw_fund_rollover (
144: old_references.frol_id
145: );
146:
147: END check_child_existance;

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 197: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_fund_rollover

193: || Purpose : Validates the Unique Keys of the table.
194: || Known limitations, enhancements or remarks :
195: || Change History :
196: || Who When What
197: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_fund_rollover
198: || instead of igf_aw_fund_rollover for bug:2222272.
199: || (reverse chronological order - newest change first)
200: */
201:

Line 198: || instead of igf_aw_fund_rollover for bug:2222272.

194: || Known limitations, enhancements or remarks :
195: || Change History :
196: || Who When What
197: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_fund_rollover
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;

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 206: FROM igf_aw_fund_rollover

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
207: WHERE cr_cal_type = x_cr_cal_type
208: AND cr_sequence_number = x_cr_sequence_number
209: AND NVL(org_id,NVL(l_org_id,-99)) = NVL(l_org_id,-99) --bug 2222272
210: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

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 410: SELECT igf_aw_fund_rollover_s.NEXTVAL

406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409:
410: SELECT igf_aw_fund_rollover_s.NEXTVAL
411: INTO x_frol_id
412: FROM dual;
413:
414: new_references.org_id := igs_ge_gen_003.get_org_id;

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;

Line 719: END igf_aw_fund_rollover_pkg;

715:
716: END delete_row;
717:
718:
719: END igf_aw_fund_rollover_pkg;