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_ALL

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 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 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 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;