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_CAT_PKG dependencies on IGF_AW_FUND_CAT

Line 1: PACKAGE BODY igf_aw_fund_cat_pkg AS

1: PACKAGE BODY igf_aw_fund_cat_pkg AS
2: /* $Header: IGFWI04B.pls 120.0 2005/06/01 13:41:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_cat_all%ROWTYPE;

Line 5: old_references igf_aw_fund_cat_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fund_cat_pkg AS
2: /* $Header: IGFWI04B.pls 120.0 2005/06/01 13:41:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_cat_all%ROWTYPE;
6: new_references igf_aw_fund_cat_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fund_cat_all%ROWTYPE;

2: /* $Header: IGFWI04B.pls 120.0 2005/06/01 13:41:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_cat_all%ROWTYPE;
6: new_references igf_aw_fund_cat_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM IGF_AW_FUND_CAT_ALL

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

Line 141: || Added the call igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat

137: || Known limitations, enhancements or remarks :
138: || Change History :
139: || Who When What
140: || pkpatel 04-OCT-2002 Bug NO: 2600842
141: || Added the call igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat
142: || nalkumar 14-NOV-2002 Bug NO: 2658550
143: || Added the call igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat and
144: || igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat. As per FA110 PR Enh.
145: || (reverse chronological order - newest change first)

Line 143: || Added the call igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat and

139: || Who When What
140: || pkpatel 04-OCT-2002 Bug NO: 2600842
141: || Added the call igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat
142: || nalkumar 14-NOV-2002 Bug NO: 2658550
143: || Added the call igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat and
144: || igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat. As per FA110 PR Enh.
145: || (reverse chronological order - newest change first)
146: */
147: BEGIN

Line 144: || igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat. As per FA110 PR Enh.

140: || pkpatel 04-OCT-2002 Bug NO: 2600842
141: || Added the call igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat
142: || nalkumar 14-NOV-2002 Bug NO: 2658550
143: || Added the call igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat and
144: || igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat. As per FA110 PR Enh.
145: || (reverse chronological order - newest change first)
146: */
147: BEGIN
148:

Line 149: igf_aw_fund_excl_pkg.get_ufk_igf_aw_fund_cat (

145: || (reverse chronological order - newest change first)
146: */
147: BEGIN
148:
149: igf_aw_fund_excl_pkg.get_ufk_igf_aw_fund_cat (
150: old_references.fund_code
151: );
152:
153: igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (

Line 153: igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (

149: igf_aw_fund_excl_pkg.get_ufk_igf_aw_fund_cat (
150: old_references.fund_code
151: );
152:
153: igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (
154: old_references.fund_code
155: );
156:
157: igf_aw_fund_mast_pkg.get_ufk_igf_aw_fund_cat (

Line 157: igf_aw_fund_mast_pkg.get_ufk_igf_aw_fund_cat (

153: igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (
154: old_references.fund_code
155: );
156:
157: igf_aw_fund_mast_pkg.get_ufk_igf_aw_fund_cat (
158: old_references.fund_code ,
159: old_references.org_id
160: );
161:

Line 162: igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat (

158: old_references.fund_code ,
159: old_references.org_id
160: );
161:
162: igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat (
163: old_references.fund_code
164: );
165:
166: igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat (

Line 166: igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat (

162: igs_pe_fund_excl_pkg.get_ufk_igf_aw_fund_cat (
163: old_references.fund_code
164: );
165:
166: igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat (
167: old_references.fund_code
168: );
169: igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat (
170: old_references.fund_code

Line 169: igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat (

165:
166: igs_pr_ou_fnd_pkg.get_fk_igf_aw_fund_cat (
167: old_references.fund_code
168: );
169: igs_pr_stdnt_pr_fnd_pkg.get_fk_igf_aw_fund_cat (
170: old_references.fund_code
171: );
172: END check_child_existance;
173:

Line 190: ELSE igf_aw_fund_excl_pkg.get_ufk_igf_aw_fund_cat (

186:
187: IF (((old_references.fund_code = new_references.fund_code)) OR
188: ((old_references.fund_code IS NULL))) THEN
189: NULL;
190: ELSE igf_aw_fund_excl_pkg.get_ufk_igf_aw_fund_cat (
191: old_references.fund_code
192: );
193: END IF;
194:

Line 198: ELSE igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (

194:
195: IF (((old_references.fund_code = new_references.fund_code)) OR
196: ((old_references.fund_code IS NULL))) THEN
197: NULL;
198: ELSE igf_aw_fund_incl_pkg.get_ufk_igf_aw_fund_cat (
199: old_references.fund_code
200: );
201: END IF;
202:

Line 206: ELSE igf_aw_fund_mast_pkg.get_ufk_igf_aw_fund_cat (

202:
203: IF (((old_references.fund_code = new_references.fund_code)) OR
204: ((old_references.fund_code IS NULL))) THEN
205: NULL;
206: ELSE igf_aw_fund_mast_pkg.get_ufk_igf_aw_fund_cat (
207: old_references.fund_code ,
208: old_references.org_id
209: );
210: END IF;

Line 229: FROM igf_aw_fund_cat_all

225: || (reverse chronological order - newest change first)
226: */
227: CURSOR cur_rowid IS
228: SELECT rowid
229: FROM igf_aw_fund_cat_all
230: WHERE fcat_id = x_fcat_id
231: FOR UPDATE NOWAIT;
232:
233: lv_rowid cur_rowid%RowType;

Line 263: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

259: || Who When What
260: || (reverse chronological order - newest change first)
261: */
262:
263: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_aw_fund_cat_all
267: WHERE fund_code = x_fund_code

Line 266: FROM igf_aw_fund_cat_all

262:
263: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_aw_fund_cat_all
267: WHERE fund_code = x_fund_code
268: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
269: AND NVL(org_id,NVL(l_org_id,-99))=NVL(l_org_id,-99)
270: FOR UPDATE NOWAIT;

Line 303: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

299: || uniqueness of the alt_loan_code column.
300: || (reverse chronological order - newest change first)
301: */
302:
303: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igf_aw_fund_cat_all
307: WHERE (NVL(alt_loan_code,'*') = NVL(x_alt_loan_code,'**')

Line 306: FROM igf_aw_fund_cat_all

302:
303: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igf_aw_fund_cat_all
307: WHERE (NVL(alt_loan_code,'*') = NVL(x_alt_loan_code,'**')
308: AND ((l_rowid IS NULL) OR (rowid <> l_rowid)))
309: FOR UPDATE NOWAIT;
310:

Line 341: FROM igf_aw_fund_cat_all

337: || (reverse chronological order - newest change first)
338: */
339: CURSOR cur_rowid IS
340: SELECT rowid
341: FROM igf_aw_fund_cat_all
342: WHERE NVL(alt_rel_code,'*') = x_relationship_cd;
343:
344: lv_rowid cur_rowid%RowType;
345:

Line 352: fnd_message.set_name ('IGF','IGF_AW_FUND_CAT_FK');

348: OPEN cur_rowid;
349: FETCH cur_rowid INTO lv_rowid;
350: IF (cur_rowid%FOUND) THEN
351: CLOSE cur_rowid;
352: fnd_message.set_name ('IGF','IGF_AW_FUND_CAT_FK');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: RETURN;
356: END IF;

Line 374: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

370: || Who When What
371: || (reverse chronological order - newest change first)
372: */
373:
374: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igf_aw_fund_cat_all
378: WHERE ((fund_type = x_fund_type))

Line 377: FROM igf_aw_fund_cat_all

373:
374: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igf_aw_fund_cat_all
378: WHERE ((fund_type = x_fund_type))
379: AND NVL(org_id,NVL(l_org_id,-99))=NVL(l_org_id,-99);
380:
381: lv_rowid cur_rowid%RowType;

Line 517: FROM igf_aw_fund_cat_all

513: || (reverse chronological order - newest change first)
514: */
515: CURSOR c IS
516: SELECT rowid
517: FROM igf_aw_fund_cat_all
518: WHERE fcat_id = x_fcat_id;
519:
520: x_last_update_date DATE;
521: x_last_updated_by NUMBER;

Line 524: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

520: x_last_update_date DATE;
521: x_last_updated_by NUMBER;
522: x_last_update_login NUMBER;
523:
524: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
525:
526: BEGIN
527:
528: x_last_update_date := SYSDATE;

Line 547: SELECT igf_aw_fund_cat_all_s.nextval INTO x_fcat_id FROM dual;

543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:
547: SELECT igf_aw_fund_cat_all_s.nextval INTO x_fcat_id FROM dual;
548:
549: before_dml(
550: p_action => 'INSERT',
551: x_rowid => x_rowid,

Line 568: INSERT INTO igf_aw_fund_cat_all (

564: x_last_update_login => x_last_update_login,
565: x_alt_loan_code => x_alt_loan_code ,
566: x_alt_rel_code => x_alt_rel_code
567: );
568: INSERT INTO igf_aw_fund_cat_all (
569: fund_code,
570: description,
571: fund_type,
572: fund_source,

Line 648: FROM igf_aw_fund_cat

644: sys_fund_type,
645: active,
646: alt_loan_code,
647: alt_rel_code
648: FROM igf_aw_fund_cat
649: WHERE rowid = x_rowid
650: FOR UPDATE NOWAIT;
651:
652: tlinfo c1%ROWTYPE;

Line 758: UPDATE igf_aw_fund_cat_all

754: x_alt_loan_code => x_alt_loan_code ,
755: x_alt_rel_code => x_alt_rel_code
756: );
757:
758: UPDATE igf_aw_fund_cat_all
759: SET
760: fund_code = new_references.fund_code,
761: description = new_references.description,
762: fund_type = new_references.fund_type,

Line 806: FROM igf_aw_fund_cat_all

802: || (reverse chronological order - newest change first)
803: */
804: CURSOR c1 IS
805: SELECT rowid
806: FROM igf_aw_fund_cat_all
807: WHERE fcat_id = x_fcat_id;
808:
809: BEGIN
810:

Line 871: DELETE FROM igf_aw_fund_cat_all

867: p_action => 'DELETE',
868: x_rowid => x_rowid
869: );
870:
871: DELETE FROM igf_aw_fund_cat_all
872: WHERE rowid = x_rowid;
873:
874: IF (SQL%NOTFOUND) THEN
875: RAISE NO_DATA_FOUND;

Line 881: END igf_aw_fund_cat_pkg;

877:
878: END delete_row;
879:
880:
881: END igf_aw_fund_cat_pkg;