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_MAST_PKG dependencies on IGF_AW_FUND_MAST

Line 1: PACKAGE BODY igf_aw_fund_mast_pkg AS

1: PACKAGE BODY igf_aw_fund_mast_pkg AS
2: /* $Header: IGFWI11B.pls 120.3 2005/07/15 09:58:43 appldev ship $ */
3:
4: /*=======================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|

Line 10: | PL/SQL body for package: IGF_AW_FUND_MAST_PKG

6: | All rights reserved. |
7: +=======================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL body for package: IGF_AW_FUND_MAST_PKG
11: | |
12: | NOTES |
13: | |
14: | This package has a flag on the end of some of the procedures called |

Line 35: | to the table 'IGF_AW_FUND_MAST_ALL'. Added |

31: | Modified TBH procs for the new columns |
32: | |
33: | museshad 25-May-2005 Build# FA157 - Bug# 4382371. |
34: | New column 'DISB_ROUNDING_CODE' has been added|
35: | to the table 'IGF_AW_FUND_MAST_ALL'. Added |
36: | this to all TBH procs. |
37: | |
38: | brajendr 14-Oct-2004 Added the new columns for FA152 - Repackaging |
39: | and COA Build. |

Line 57: | changed it to igf_aw_fund_mast_all |

53: | adhawan 06-nov-2002 #Bug id 2613536 |
54: | Obsoletion of SAP_TYPE |
55: | ADHAWAN 31-OCT-2002 #Bug 2613546 added gift_aid to the Tbh calls |
56: | PROCEDURE get_fk_igs_ca_inst was referrring to igf_aw_pkg_run_all |
57: | changed it to igf_aw_fund_mast_all |
58: | vchappid 02-Apr-2002 Enh# bug2293676, modified check child |
59: | vvutukur 19-feb-2002 modification done in check_parent_existance |
60: | reg. org_id for bug:2222272 as part of SWSCR006|
61: *=======================================================================*/

Line 64: old_references igf_aw_fund_mast_all%ROWTYPE;

60: | reg. org_id for bug:2222272 as part of SWSCR006|
61: *=======================================================================*/
62:
63: l_rowid VARCHAR2(25);
64: old_references igf_aw_fund_mast_all%ROWTYPE;
65: new_references igf_aw_fund_mast_all%ROWTYPE;
66:
67: PROCEDURE set_column_values (
68: p_action IN VARCHAR2,

Line 65: new_references igf_aw_fund_mast_all%ROWTYPE;

61: *=======================================================================*/
62:
63: l_rowid VARCHAR2(25);
64: old_references igf_aw_fund_mast_all%ROWTYPE;
65: new_references igf_aw_fund_mast_all%ROWTYPE;
66:
67: PROCEDURE set_column_values (
68: p_action IN VARCHAR2,
69: x_rowid IN VARCHAR2,

Line 209: || to the table 'IGF_AW_FUND_MAST_ALL'.

205: || Changes relating to the addition of new
206: || columns.
207: || museshad 25-May-2005 Build# FA157 - Bug# 4382371.
208: || New column 'DISB_ROUNDING_CODE' has been added
209: || to the table 'IGF_AW_FUND_MAST_ALL'.
210: || Modified the TBH to include this.
211: || veramach 1-NOV-2003 FA 125 - Removed elig_criteria from assigments
212: || (reverse chronological order - newest change first)
213: */

Line 217: FROM IGF_AW_FUND_MAST_ALL

213: */
214:
215: CURSOR cur_old_ref_values IS
216: SELECT *
217: FROM IGF_AW_FUND_MAST_ALL
218: WHERE rowid = x_rowid;
219:
220: BEGIN
221:

Line 391: FROM igf_aw_fund_mast_all

387: || (reverse chronological order - newest change first)
388: */
389: CURSOR cur_rowid IS
390: SELECT rowid
391: FROM igf_aw_fund_mast_all
392: WHERE fund_code = x_fund_code
393: AND ci_cal_type = x_ci_cal_type
394: AND ci_sequence_number = x_ci_sequence_number
395: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 450: l_org_id igf_aw_fund_mast_all.org_id%TYPE := igf_aw_gen.get_org_id; --bug:2222272

446: || for bug:2222272 as part of SWSCR006(MO).
447: || (reverse chronological order - newest change first)
448: */
449:
450: l_org_id igf_aw_fund_mast_all.org_id%TYPE := igf_aw_gen.get_org_id; --bug:2222272
451:
452: BEGIN
453:
454: IF (((old_references.fund_code = new_references.fund_code) AND

Line 535: || veramach 3-NOV-2003 removed call to igf_aw_fund_tp_pkg.get_fk_igf_aw_fund_mast

531: || Purpose : Checks for the existance of Child records.
532: || Known limitations, enhancements or remarks :
533: || Change History :
534: || Who When What
535: || veramach 3-NOV-2003 removed call to igf_aw_fund_tp_pkg.get_fk_igf_aw_fund_mast
536: || vchappid 02-Apr-2002 Enh# 2293676, Added igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast
537: || (reverse chronological order - newest change first)
538: */
539: BEGIN

Line 536: || vchappid 02-Apr-2002 Enh# 2293676, Added igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast

532: || Known limitations, enhancements or remarks :
533: || Change History :
534: || Who When What
535: || veramach 3-NOV-2003 removed call to igf_aw_fund_tp_pkg.get_fk_igf_aw_fund_mast
536: || vchappid 02-Apr-2002 Enh# 2293676, Added igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast
537: || (reverse chronological order - newest change first)
538: */
539: BEGIN
540:

Line 541: igf_aw_award_pkg.get_fk_igf_aw_fund_mast (

537: || (reverse chronological order - newest change first)
538: */
539: BEGIN
540:
541: igf_aw_award_pkg.get_fk_igf_aw_fund_mast (
542: old_references.fund_id );
543:
544: igf_aw_fund_excl_pkg.get_fk_igf_aw_fund_mast (
545: old_references.fund_id );

Line 544: igf_aw_fund_excl_pkg.get_fk_igf_aw_fund_mast (

540:
541: igf_aw_award_pkg.get_fk_igf_aw_fund_mast (
542: old_references.fund_id );
543:
544: igf_aw_fund_excl_pkg.get_fk_igf_aw_fund_mast (
545: old_references.fund_id );
546:
547: igf_aw_fund_incl_pkg.get_fk_igf_aw_fund_mast (
548: old_references.fund_id );

Line 547: igf_aw_fund_incl_pkg.get_fk_igf_aw_fund_mast (

543:
544: igf_aw_fund_excl_pkg.get_fk_igf_aw_fund_mast (
545: old_references.fund_id );
546:
547: igf_aw_fund_incl_pkg.get_fk_igf_aw_fund_mast (
548: old_references.fund_id );
549:
550:
551: --

Line 554: igf_sp_fc_pkg.get_fk_igf_aw_fund_mast(

550:
551: --
552: -- added fk checks for sponsor setups
553: --
554: igf_sp_fc_pkg.get_fk_igf_aw_fund_mast(
555: old_references.fund_id);
556:
557: igf_sp_stdnt_rel_pkg.get_fk_igf_aw_fund_mast(
558: old_references.fund_id);

Line 557: igf_sp_stdnt_rel_pkg.get_fk_igf_aw_fund_mast(

553: --
554: igf_sp_fc_pkg.get_fk_igf_aw_fund_mast(
555: old_references.fund_id);
556:
557: igf_sp_stdnt_rel_pkg.get_fk_igf_aw_fund_mast(
558: old_references.fund_id);
559:
560: igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast(
561: old_references.fund_id);

Line 560: igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast(

556:
557: igf_sp_stdnt_rel_pkg.get_fk_igf_aw_fund_mast(
558: old_references.fund_id);
559:
560: igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast(
561: old_references.fund_id);
562:
563: igf_aw_fund_feeclas_pkg.get_fk_igf_aw_fund_mast(
564: old_references.fund_id);

Line 563: igf_aw_fund_feeclas_pkg.get_fk_igf_aw_fund_mast(

559:
560: igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_fund_mast(
561: old_references.fund_id);
562:
563: igf_aw_fund_feeclas_pkg.get_fk_igf_aw_fund_mast(
564: old_references.fund_id);
565:
566: igf_aw_fund_unit_pkg.get_fk_igf_aw_fund_mast(
567: old_references.fund_id);

Line 566: igf_aw_fund_unit_pkg.get_fk_igf_aw_fund_mast(

562:
563: igf_aw_fund_feeclas_pkg.get_fk_igf_aw_fund_mast(
564: old_references.fund_id);
565:
566: igf_aw_fund_unit_pkg.get_fk_igf_aw_fund_mast(
567: old_references.fund_id);
568:
569: igf_aw_fund_prg_pkg.get_fk_igf_aw_fund_mast(
570: old_references.fund_id);

Line 569: igf_aw_fund_prg_pkg.get_fk_igf_aw_fund_mast(

565:
566: igf_aw_fund_unit_pkg.get_fk_igf_aw_fund_mast(
567: old_references.fund_id);
568:
569: igf_aw_fund_prg_pkg.get_fk_igf_aw_fund_mast(
570: old_references.fund_id);
571:
572: igf_aw_fund_td_map_pkg.get_fk_igf_aw_fund_mast(
573: old_references.fund_id);

Line 572: igf_aw_fund_td_map_pkg.get_fk_igf_aw_fund_mast(

568:
569: igf_aw_fund_prg_pkg.get_fk_igf_aw_fund_mast(
570: old_references.fund_id);
571:
572: igf_aw_fund_td_map_pkg.get_fk_igf_aw_fund_mast(
573: old_references.fund_id);
574:
575: END check_child_existance;
576:

Line 592: FROM igf_aw_fund_mast_all

588: || (reverse chronological order - newest change first)
589: */
590: CURSOR cur_rowid IS
591: SELECT rowid
592: FROM igf_aw_fund_mast_all
593: WHERE fund_id = x_fund_id
594: FOR UPDATE NOWAIT;
595:
596: lv_rowid cur_rowid%RowType;

Line 625: l_org_id igf_aw_fund_mast_all.org_id%TYPE := igf_aw_gen.get_org_id;

621: || Change History :
622: || Who When What
623: || (reverse chronological order - newest change first)
624: */
625: l_org_id igf_aw_fund_mast_all.org_id%TYPE := igf_aw_gen.get_org_id;
626: CURSOR cur_rowid IS
627: SELECT rowid
628: FROM igf_aw_fund_mast_all
629: WHERE fund_code = x_fund_code

Line 628: FROM igf_aw_fund_mast_all

624: */
625: l_org_id igf_aw_fund_mast_all.org_id%TYPE := igf_aw_gen.get_org_id;
626: CURSOR cur_rowid IS
627: SELECT rowid
628: FROM igf_aw_fund_mast_all
629: WHERE fund_code = x_fund_code
630: AND NVL(org_id, NVL(l_org_id, -99)) = NVL(l_org_id, -99);
631:
632: lv_rowid cur_rowid%RowType;

Line 664: FROM igf_aw_fund_mast_all

660: || (reverse chronological order - newest change first)
661: */
662: CURSOR cur_rowid IS
663: SELECT rowid
664: FROM igf_aw_fund_mast_all
665: WHERE ((ci_cal_type = x_ci_cal_type) AND
666: (ci_sequence_number = x_ci_sequence_number));
667:
668: lv_rowid cur_rowid%RowType;

Line 699: FROM igf_aw_fund_mast

695: || (reverse chronological order - newest change first)
696: */
697: CURSOR cur_rowid IS
698: SELECT rowid
699: FROM igf_aw_fund_mast
700: WHERE ((credit_type_id = x_credit_type_id));
701:
702: lv_rowid cur_rowid%RowType;
703:

Line 863: || to the table 'IGF_AW_FUND_MAST_ALL'.

859: || museshad 14-Jul-2005 Build FA 140 - Changes relating to the
860: || addition of new columns.
861: || museshad 25-May-2005 Build# FA157 - Bug# 4382371.
862: || New column 'DISB_ROUNDING_CODE' has been added
863: || to the table 'IGF_AW_FUND_MAST_ALL'.
864: || Modified the TBH to include this.
865: || (reverse chronological order - newest change first)
866: */
867: BEGIN

Line 1176: || to the table 'IGF_AW_FUND_MAST_ALL'.

1172: || Who When What
1173: || museshad 14-Jul-2005 FA 140 - Changes relating to the addition of new columns
1174: || museshad 25-May-2005 Build# FA157 - Bug# 4382371.
1175: || New column 'DISB_ROUNDING_CODE' has been added
1176: || to the table 'IGF_AW_FUND_MAST_ALL'.
1177: || Modified the TBH to include this.
1178: || veramach 1-NOV-2003 FA 125 - Removed elig_criteria from assigments,insert statements
1179: || (reverse chronological order - newest change first)
1180: */

Line 1183: FROM igf_aw_fund_mast_all

1179: || (reverse chronological order - newest change first)
1180: */
1181: CURSOR c IS
1182: SELECT rowid
1183: FROM igf_aw_fund_mast_all
1184: WHERE fund_id = x_fund_id;
1185:
1186: x_last_update_date DATE;
1187: x_last_updated_by NUMBER;

Line 1193: l_org_id igf_aw_fund_mast_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

1189: x_request_id NUMBER;
1190: x_program_id NUMBER;
1191: x_program_application_id NUMBER;
1192: x_program_update_date DATE;
1193: l_org_id igf_aw_fund_mast_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
1194:
1195: BEGIN
1196:
1197: x_last_update_date := SYSDATE;

Line 1228: select IGF_AW_FUND_MAST_S.NEXTVAL into x_fund_id from dual ;

1224: igs_ge_msg_stack.add;
1225: app_exception.raise_exception;
1226: END IF;
1227:
1228: select IGF_AW_FUND_MAST_S.NEXTVAL into x_fund_id from dual ;
1229:
1230:
1231: before_dml(
1232: p_action => 'INSERT',

Line 1363: INSERT INTO igf_aw_fund_mast_all (

1359: x_status_after_decline => x_status_after_decline,
1360: x_fund_information_txt => x_fund_information_txt
1361: );
1362:
1363: INSERT INTO igf_aw_fund_mast_all (
1364: fund_id,
1365: fund_code,
1366: ci_cal_type,
1367: ci_sequence_number,

Line 1780: || to the table 'IGF_AW_FUND_MAST_ALL'.

1776: || museshad 14-Jul-2005 Build FA 140 - Changes relating to the addition
1777: || of new columns
1778: || museshad 25-May-2005 Build# FA157 - Bug# 4382371.
1779: || New column 'DISB_ROUNDING_CODE' has been added
1780: || to the table 'IGF_AW_FUND_MAST_ALL'.
1781: || Modified the TBH to include this.
1782: || veramach 1-NOV-2003 FA 125 - Removed elig_criteria from assigments,select statements
1783: || (reverse chronological order - newest change first)
1784: */

Line 1908: FROM igf_aw_fund_mast_all

1904: min_decrease_amt,
1905: allow_decln_post_accept_flag,
1906: status_after_decline,
1907: fund_information_txt
1908: FROM igf_aw_fund_mast_all
1909: WHERE rowid = x_rowid
1910: FOR UPDATE NOWAIT;
1911:
1912: tlinfo c1%ROWTYPE;

Line 2198: || to the table 'IGF_AW_FUND_MAST_ALL'.

2194: || museshad 14-Jul-2005 Build FA 140 - Changes relating to the
2195: || addition of new columns
2196: || museshad 25-May-2005 Build# FA157 - Bug# 4382371.
2197: || New column 'DISB_ROUNDING_CODE' has been added
2198: || to the table 'IGF_AW_FUND_MAST_ALL'.
2199: || Modified the TBH to include this.
2200: || veramach 1-NOV-2003 FA 125 - Removed elig_criteria from assigments,update statements
2201: || mesriniv 06-JUL-2001 Added code to calculate the
2202: || Committed Amount

Line 2396: UPDATE igf_aw_fund_mast_all

2392: - NVL(new_references.disbursed_amt,0) ;
2393:
2394:
2395:
2396: UPDATE igf_aw_fund_mast_all
2397: SET
2398: fund_code = new_references.fund_code,
2399: ci_cal_type = new_references.ci_cal_type,
2400: ci_sequence_number = new_references.ci_sequence_number,

Line 2678: FROM igf_aw_fund_mast_all

2674: || (reverse chronological order - newest change first)
2675: */
2676: CURSOR c1 IS
2677: SELECT rowid
2678: FROM igf_aw_fund_mast_all
2679: WHERE fund_id = x_fund_id;
2680:
2681: BEGIN
2682:

Line 2967: DELETE FROM igf_aw_fund_mast_all

2963: p_action => 'DELETE',
2964: x_rowid => x_rowid
2965: );
2966:
2967: DELETE FROM igf_aw_fund_mast_all
2968: WHERE rowid = x_rowid;
2969:
2970: IF (SQL%NOTFOUND) THEN
2971: RAISE NO_DATA_FOUND;

Line 2977: END igf_aw_fund_mast_pkg;

2973:
2974: END delete_row;
2975:
2976:
2977: END igf_aw_fund_mast_pkg;