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_ROLLOVER dependencies on IGF_AW_FUND_MAST_ALL

Line 23: FUNCTION create_fund_todo (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

19: | |
20: *=======================================================================*/
21:
22: --Create fund todo items for the target award year
23: FUNCTION create_fund_todo (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
24: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
25: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
26: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
27: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 24: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

20: *=======================================================================*/
21:
22: --Create fund todo items for the target award year
23: FUNCTION create_fund_todo (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
24: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
25: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
26: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
27: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

Line 210: FUNCTION create_pay_feeclass(p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

206: END create_fund_todo;
207:
208:
209: --Create pay feeclass for the target award year
210: FUNCTION create_pay_feeclass(p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
211: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
212: p_fee_class OUT NOCOPY igf_aw_fund_feeclas_all.fee_class%TYPE
213: )
214: RETURN BOOLEAN IS

Line 211: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

207:
208:
209: --Create pay feeclass for the target award year
210: FUNCTION create_pay_feeclass(p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
211: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
212: p_fee_class OUT NOCOPY igf_aw_fund_feeclas_all.fee_class%TYPE
213: )
214: RETURN BOOLEAN IS
215: --------------------------------------------------------------------------------

Line 262: FUNCTION create_pay_unit (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

258: END create_pay_feeclass;
259:
260:
261: --Create pay units for the target award year
262: FUNCTION create_pay_unit (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
263: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
264: p_pay_unit OUT NOCOPY igf_aw_fund_unit_all.unit_cd%TYPE
265: )
266: RETURN BOOLEAN IS

Line 263: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

259:
260:
261: --Create pay units for the target award year
262: FUNCTION create_pay_unit (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
263: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
264: p_pay_unit OUT NOCOPY igf_aw_fund_unit_all.unit_cd%TYPE
265: )
266: RETURN BOOLEAN IS
267: --------------------------------------------------------------------------------

Line 326: FUNCTION create_pay_program (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

322:
323:
324:
325: --Create pay programs for the target award year
326: FUNCTION create_pay_program (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
327: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
328: p_pay_program OUT NOCOPY igf_aw_fund_prg_all.course_cd%TYPE
329: )
330: RETURN BOOLEAN IS

Line 327: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

323:
324:
325: --Create pay programs for the target award year
326: FUNCTION create_pay_program (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
327: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
328: p_pay_program OUT NOCOPY igf_aw_fund_prg_all.course_cd%TYPE
329: )
330: RETURN BOOLEAN IS
331: --------------------------------------------------------------------------------

Line 390: FUNCTION create_exclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

386:
387:
388:
389: --Create exclusive fund for the target award year
390: FUNCTION create_exclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
391: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
392: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
393: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
394: p_exclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE

Line 391: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

387:
388:
389: --Create exclusive fund for the target award year
390: FUNCTION create_exclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
391: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
392: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
393: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
394: p_exclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE
395: )

Line 394: p_exclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE

390: FUNCTION create_exclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
391: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
392: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
393: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
394: p_exclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE
395: )
396: RETURN BOOLEAN IS
397: --------------------------------------------------------------------------------
398: -- Created by : ridas, Oracle India

Line 416: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE

412:
413: -- check whether the fund is a discontinued fund or not
414: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
415: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
416: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
417: ) IS
418: SELECT discontinue_fund
419: FROM igf_aw_fund_mast_all fnd
420: WHERE fnd.ci_cal_type = cp_frm_cal_type

Line 419: FROM igf_aw_fund_mast_all fnd

415: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
416: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
417: ) IS
418: SELECT discontinue_fund
419: FROM igf_aw_fund_mast_all fnd
420: WHERE fnd.ci_cal_type = cp_frm_cal_type
421: AND fnd.ci_sequence_number = cp_frm_sequence_number
422: AND fnd.fund_code = cp_fund_code;
423:

Line 424: l_discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE;

420: WHERE fnd.ci_cal_type = cp_frm_cal_type
421: AND fnd.ci_sequence_number = cp_frm_sequence_number
422: AND fnd.fund_code = cp_fund_code;
423:
424: l_discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE;
425: l_rowid VARCHAR2(25);
426:
427: BEGIN
428: FOR l_fund_excl_rec IN c_fund_excl( p_ref_fund_id ) LOOP

Line 461: FUNCTION create_inclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

457: END create_exclusive_fund;
458:
459:
460: --Create inclusive fund for the target award year
461: FUNCTION create_inclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
462: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
463: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
464: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
465: p_inclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE

Line 462: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

458:
459:
460: --Create inclusive fund for the target award year
461: FUNCTION create_inclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
462: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
463: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
464: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
465: p_inclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE
466: )

Line 465: p_inclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE

461: FUNCTION create_inclusive_fund (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
462: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
463: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
464: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
465: p_inclusive_fund OUT NOCOPY igf_aw_fund_mast_all.fund_code%TYPE
466: )
467: RETURN BOOLEAN IS
468: --------------------------------------------------------------------------------
469: -- Created by : ridas, Oracle India

Line 487: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE

483:
484: -- check whether the fund is a discontinued fund or not
485: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
486: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
487: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
488: ) IS
489: SELECT discontinue_fund
490: FROM igf_aw_fund_mast_all fnd
491: WHERE fnd.ci_cal_type = cp_frm_cal_type

Line 490: FROM igf_aw_fund_mast_all fnd

486: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
487: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
488: ) IS
489: SELECT discontinue_fund
490: FROM igf_aw_fund_mast_all fnd
491: WHERE fnd.ci_cal_type = cp_frm_cal_type
492: AND fnd.ci_sequence_number = cp_frm_sequence_number
493: AND fnd.fund_code = cp_fund_code;
494:

Line 495: l_discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE;

491: WHERE fnd.ci_cal_type = cp_frm_cal_type
492: AND fnd.ci_sequence_number = cp_frm_sequence_number
493: AND fnd.fund_code = cp_fund_code;
494:
495: l_discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE;
496: l_rowid VARCHAR2(25);
497:
498: BEGIN
499: FOR l_fund_incl_rec IN c_fund_incl( p_ref_fund_id )

Line 533: FUNCTION fund_exists ( p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,

529:
530:
531: -- Function to check the existence of the fund in the target award year
532: -- IF exists return TRUE, else return FALSE
533: FUNCTION fund_exists ( p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
534: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
535: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
536: )
537: RETURN BOOLEAN IS

Line 550: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE

546:
547: -- check whether the fund already present
548: CURSOR c_fund_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
549: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
550: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
551: ) IS
552: SELECT 'X' exist
553: FROM igf_aw_fund_mast_all fnd
554: WHERE fnd.ci_cal_type = cp_to_cal_type

Line 553: FROM igf_aw_fund_mast_all fnd

549: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
550: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE
551: ) IS
552: SELECT 'X' exist
553: FROM igf_aw_fund_mast_all fnd
554: WHERE fnd.ci_cal_type = cp_to_cal_type
555: AND fnd.ci_sequence_number = cp_to_sequence_number
556: AND fnd.fund_code = cp_fund_code;
557:

Line 581: FUNCTION create_new_fund ( p_fund_rec IN igf_aw_fund_mast_all%ROWTYPE,

577: END fund_exists;
578:
579:
580: -- Procedure to create a new fund for the target award year
581: FUNCTION create_new_fund ( p_fund_rec IN igf_aw_fund_mast_all%ROWTYPE,
582: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
583: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
584: )
585: RETURN igf_aw_fund_mast_all.fund_id%TYPE IS

Line 585: RETURN igf_aw_fund_mast_all.fund_id%TYPE IS

581: FUNCTION create_new_fund ( p_fund_rec IN igf_aw_fund_mast_all%ROWTYPE,
582: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
583: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
584: )
585: RETURN igf_aw_fund_mast_all.fund_id%TYPE IS
586: --------------------------------------------------------------------------------
587: -- Created by : ridas, Oracle India
588: -- Date created: 16-MAY-2005
589:

Line 593: -- have got added to igf_aw_fund_mast_all.

589:
590: -- Change History:
591: -- Who When What
592: -- museshad 14-Jul-2005 Build FA 140: Modified TBH call, since new columns
593: -- have got added to igf_aw_fund_mast_all.
594: --------------------------------------------------------------------------------
595:
596: l_rowid VARCHAR2(25):= NULL;
597: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;

Line 597: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;

593: -- have got added to igf_aw_fund_mast_all.
594: --------------------------------------------------------------------------------
595:
596: l_rowid VARCHAR2(25):= NULL;
597: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;
598:
599: BEGIN
600: igf_aw_fund_mast_pkg.insert_row(
601: x_rowid => l_rowid,

Line 761: FROM igf_aw_fund_mast_all fnd,igf_aw_fund_cat_all fcat

757: CURSOR c_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
758: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
759: ) IS
760: SELECT fnd.*
761: FROM igf_aw_fund_mast_all fnd,igf_aw_fund_cat_all fcat
762: WHERE fnd.ci_cal_type = cp_frm_cal_type
763: AND fnd.ci_sequence_number = cp_frm_sequence_number
764: AND fnd.fund_code = fcat.fund_code
765: AND fcat.sys_fund_type <> 'SPONSOR'

Line 768: l_new_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;

764: AND fnd.fund_code = fcat.fund_code
765: AND fcat.sys_fund_type <> 'SPONSOR'
766: ORDER BY fnd.fund_id;
767:
768: l_new_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;
769: E_SKIP_FUND EXCEPTION;
770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;

Line 774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;

770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
776: l_discontinued_flg VARCHAR2(1) := 'N';
777:
778: BEGIN

Line 775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;

771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
776: l_discontinued_flg VARCHAR2(1) := 'N';
777:
778: BEGIN
779:

Line 2291: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

2287:
2288:
2289: --Function to return fund code
2290: FUNCTION get_fund_cd (
2291: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
2292: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2293: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2294: )
2295: RETURN igf_aw_fund_mast_all.fund_code%TYPE AS

Line 2295: RETURN igf_aw_fund_mast_all.fund_code%TYPE AS

2291: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
2292: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2293: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2294: )
2295: RETURN igf_aw_fund_mast_all.fund_code%TYPE AS
2296: ------------------------------------------------------------------
2297: --Created by : ridas, Oracle India
2298: --Date created: 24-MAY-2005
2299: --

Line 2311: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

2307: -------------------------------------------------------------------
2308:
2309: -- Get get fund code
2310: CURSOR c_fund(
2311: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
2312: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2313: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2314: ) IS
2315: SELECT fund_code

Line 2316: FROM igf_aw_fund_mast_all

2312: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2313: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2314: ) IS
2315: SELECT fund_code
2316: FROM igf_aw_fund_mast_all
2317: WHERE fund_id = cp_fund_id
2318: AND ci_cal_type = cp_cal_type
2319: AND ci_sequence_number = cp_sequence_number;
2320:

Line 2413: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE

2409: CURSOR c_fund_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2410: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2411: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2412: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2413: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
2414: ) IS
2415: SELECT fnd.fund_id
2416: FROM igf_aw_fund_mast_all fnd
2417: WHERE fnd.ci_cal_type = cp_to_cal_type

Line 2416: FROM igf_aw_fund_mast_all fnd

2412: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2413: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
2414: ) IS
2415: SELECT fnd.fund_id
2416: FROM igf_aw_fund_mast_all fnd
2417: WHERE fnd.ci_cal_type = cp_to_cal_type
2418: AND fnd.ci_sequence_number = cp_to_sequence_number
2419: AND fnd.fund_code IN
2420: ( SELECT fnd_cd.fund_code

Line 2421: FROM igf_aw_fund_mast_all fnd_cd

2417: WHERE fnd.ci_cal_type = cp_to_cal_type
2418: AND fnd.ci_sequence_number = cp_to_sequence_number
2419: AND fnd.fund_code IN
2420: ( SELECT fnd_cd.fund_code
2421: FROM igf_aw_fund_mast_all fnd_cd
2422: WHERE fnd_cd.ci_cal_type = cp_frm_cal_type
2423: AND fnd_cd.ci_sequence_number = cp_frm_sequence_number
2424: AND fnd_cd.fund_id = cp_fund_id
2425: );