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 IGS_CA_INST_ALL

Line 25: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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,
29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE

Line 26: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

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,
29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE
30: )

Line 27: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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,
29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE
30: )
31: RETURN BOOLEAN IS

Line 28: p_to_sequence_number IN igs_ca_inst_all.sequence_number%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,
29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE
30: )
31: RETURN BOOLEAN IS
32: --------------------------------------------------------------------------------

Line 78: CURSOR c_get_td_number( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

74: AND NVL(career_item,'N') = 'Y';
75:
76:
77: --Cursor to fetch the todo number of an item code for the To Award Year
78: CURSOR c_get_td_number( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
79: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
80: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
81: ) IS
82: SELECT todo_number

Line 79: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

75:
76:
77: --Cursor to fetch the todo number of an item code for the To Award Year
78: CURSOR c_get_td_number( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
79: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
80: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
81: ) IS
82: SELECT todo_number
83: FROM igf_ap_td_item_mst_all

Line 392: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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: )
396: RETURN BOOLEAN IS

Line 393: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

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: )
396: RETURN BOOLEAN IS
397: --------------------------------------------------------------------------------

Line 414: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

410: FROM igf_aw_fund_excl_all excl
411: WHERE excl.fund_id = cp_ref_fund_id;
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

Line 415: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

411: WHERE excl.fund_id = cp_ref_fund_id;
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

Line 463: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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: )
467: RETURN BOOLEAN IS

Line 464: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

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: )
467: RETURN BOOLEAN IS
468: --------------------------------------------------------------------------------

Line 485: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

481: FROM igf_aw_fund_incl_all incl
482: WHERE incl.fund_id = cp_ref_fund_id;
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

Line 486: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

482: WHERE incl.fund_id = cp_ref_fund_id;
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

Line 534: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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
538: --------------------------------------------------------------------------------

Line 535: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

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
538: --------------------------------------------------------------------------------
539: -- Created by : ridas, Oracle India

Line 548: CURSOR c_fund_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

544: --
545: --------------------------------------------------------------------------------
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

Line 549: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

545: --------------------------------------------------------------------------------
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

Line 582: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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
586: --------------------------------------------------------------------------------

Line 583: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

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
586: --------------------------------------------------------------------------------
587: -- Created by : ridas, Oracle India

Line 741: PROCEDURE rollover_fund_attributes ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

737:
738:
739:
740: -- Procedure to rollover fund attributes
741: PROCEDURE rollover_fund_attributes ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
742: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
743: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
744: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
745: )

Line 742: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

738:
739:
740: -- Procedure to rollover fund attributes
741: PROCEDURE rollover_fund_attributes ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
742: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
743: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
744: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
745: )
746: IS

Line 743: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

739:
740: -- Procedure to rollover fund attributes
741: PROCEDURE rollover_fund_attributes ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
742: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
743: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
744: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
745: )
746: IS
747: --------------------------------------------------------------------------------

Line 744: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

740: -- Procedure to rollover fund attributes
741: PROCEDURE rollover_fund_attributes ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
742: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
743: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
744: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
745: )
746: IS
747: --------------------------------------------------------------------------------
748: -- Created by : ridas, Oracle India

Line 757: CURSOR c_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

753: --
754: --------------------------------------------------------------------------------
755:
756: -- Get the funds for the source award year
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

Line 758: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

754: --------------------------------------------------------------------------------
755:
756: -- Get the funds for the source award year
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

Line 944: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

940:
941:
942: -- Function to check mapping (Award Year/ Term/ Teaching Period)
943: -- IF exists return TRUE, else return FALSE
944: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
945: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
946: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
948: )

Line 945: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

941:
942: -- Function to check mapping (Award Year/ Term/ Teaching Period)
943: -- IF exists return TRUE, else return FALSE
944: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
945: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
946: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
948: )
949: RETURN BOOLEAN IS

Line 946: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

942: -- Function to check mapping (Award Year/ Term/ Teaching Period)
943: -- IF exists return TRUE, else return FALSE
944: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
945: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
946: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
948: )
949: RETURN BOOLEAN IS
950:

Line 947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE

943: -- IF exists return TRUE, else return FALSE
944: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
945: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
946: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
948: )
949: RETURN BOOLEAN IS
950:
951: CURSOR c_map_details( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 951: CURSOR c_map_details( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

947: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
948: )
949: RETURN BOOLEAN IS
950:
951: CURSOR c_map_details( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
952: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
953: ) IS
954: SELECT cr_cal_type,
955: sc_sequence_number

Line 952: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

948: )
949: RETURN BOOLEAN IS
950:
951: CURSOR c_map_details( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
952: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
953: ) IS
954: SELECT cr_cal_type,
955: sc_sequence_number
956: FROM igf_aw_cal_rel_all

Line 988: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

984:
985: -- Function to check the existence of the rate based setup in the target award year
986: -- IF exists return TRUE, else return FALSE
987: FUNCTION rate_setup_exists ( p_item_code IN igf_aw_coa_rate_det.item_code%TYPE,
988: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
989: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
990: )
991: RETURN BOOLEAN IS
992: --------------------------------------------------------------------------------

Line 989: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

985: -- Function to check the existence of the rate based setup in the target award year
986: -- IF exists return TRUE, else return FALSE
987: FUNCTION rate_setup_exists ( p_item_code IN igf_aw_coa_rate_det.item_code%TYPE,
988: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
989: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
990: )
991: RETURN BOOLEAN IS
992: --------------------------------------------------------------------------------
993: -- Created by : ridas, Oracle India

Line 1002: CURSOR c_item_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

998: --
999: --------------------------------------------------------------------------------
1000:
1001: -- check whether the item code is present or not
1002: CURSOR c_item_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1003: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1004: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1005: ) IS
1006: SELECT 'X' exist

Line 1003: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

999: --------------------------------------------------------------------------------
1000:
1001: -- check whether the item code is present or not
1002: CURSOR c_item_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1003: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1004: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1005: ) IS
1006: SELECT 'X' exist
1007: FROM igf_aw_coa_rate_det item

Line 1036: PROCEDURE rollover_rate_setups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1032: END rate_setup_exists;
1033:
1034:
1035: -- Procedure to rollover Cost of Attendance Rate Table Setup
1036: PROCEDURE rollover_rate_setups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1037: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1038: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1039: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1040: )

Line 1037: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1033:
1034:
1035: -- Procedure to rollover Cost of Attendance Rate Table Setup
1036: PROCEDURE rollover_rate_setups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1037: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1038: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1039: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1040: )
1041: IS

Line 1038: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1034:
1035: -- Procedure to rollover Cost of Attendance Rate Table Setup
1036: PROCEDURE rollover_rate_setups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1037: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1038: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1039: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1040: )
1041: IS
1042: --------------------------------------------------------------------------------

Line 1039: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1035: -- Procedure to rollover Cost of Attendance Rate Table Setup
1036: PROCEDURE rollover_rate_setups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1037: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1038: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1039: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1040: )
1041: IS
1042: --------------------------------------------------------------------------------
1043: -- Created by : ridas, Oracle India

Line 1052: CURSOR c_get_itm_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1048: --
1049: --------------------------------------------------------------------------------
1050:
1051: -- Get distinct item code from the source award year
1052: CURSOR c_get_itm_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1053: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1054: ) IS
1055: SELECT item_code
1056: FROM igf_aw_coa_rate_det

Line 1053: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

1049: --------------------------------------------------------------------------------
1050:
1051: -- Get distinct item code from the source award year
1052: CURSOR c_get_itm_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1053: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1054: ) IS
1055: SELECT item_code
1056: FROM igf_aw_coa_rate_det
1057: WHERE ci_cal_type = cp_frm_cal_type

Line 1064: CURSOR c_rate_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1060: ORDER BY item_code;
1061:
1062:
1063: -- Get the rate table setup details for the source award year
1064: CURSOR c_rate_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1065: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1066: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1067: ) IS
1068: SELECT rate.*

Line 1065: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1061:
1062:
1063: -- Get the rate table setup details for the source award year
1064: CURSOR c_rate_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1065: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1066: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1067: ) IS
1068: SELECT rate.*
1069: FROM igf_aw_coa_rate_det rate

Line 1074: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

1070: WHERE rate.ci_cal_type = cp_frm_cal_type
1071: AND rate.ci_sequence_number = cp_frm_sequence_number
1072: AND rate.item_code = cp_item_code;
1073:
1074: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1075: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1076: l_rowid VARCHAR2(25);
1077: E_SKIP_ITEM EXCEPTION;
1078: l_error_occurred VARCHAR2(1) := 'N';

Line 1075: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1071: AND rate.ci_sequence_number = cp_frm_sequence_number
1072: AND rate.item_code = cp_item_code;
1073:
1074: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1075: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1076: l_rowid VARCHAR2(25);
1077: E_SKIP_ITEM EXCEPTION;
1078: l_error_occurred VARCHAR2(1) := 'N';
1079:

Line 1203: PROCEDURE rollover_inst_applications ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1199:
1200:
1201:
1202: -- Procedure to rollover Institutional Application Setup
1203: PROCEDURE rollover_inst_applications ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1204: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1205: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1206: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1207: )

Line 1204: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1200:
1201:
1202: -- Procedure to rollover Institutional Application Setup
1203: PROCEDURE rollover_inst_applications ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1204: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1205: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1206: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1207: )
1208: IS

Line 1205: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1201:
1202: -- Procedure to rollover Institutional Application Setup
1203: PROCEDURE rollover_inst_applications ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1204: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1205: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1206: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1207: )
1208: IS
1209: --------------------------------------------------------------------------------

Line 1206: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1202: -- Procedure to rollover Institutional Application Setup
1203: PROCEDURE rollover_inst_applications ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1204: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1205: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1206: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1207: )
1208: IS
1209: --------------------------------------------------------------------------------
1210: -- Created by : ridas, Oracle India

Line 1219: CURSOR c_get_appln_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1215: --
1216: --------------------------------------------------------------------------------
1217:
1218: -- Get distinct Application Code from the source award year
1219: CURSOR c_get_appln_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1220: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1221: ) IS
1222: SELECT appln.application_code
1223: FROM igf_ap_appl_setup_all appln

Line 1220: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

1216: --------------------------------------------------------------------------------
1217:
1218: -- Get distinct Application Code from the source award year
1219: CURSOR c_get_appln_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1220: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1221: ) IS
1222: SELECT appln.application_code
1223: FROM igf_ap_appl_setup_all appln
1224: WHERE appln.ci_cal_type = cp_frm_cal_type

Line 1232: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1228: ORDER BY appln.application_code;
1229:
1230:
1231: -- Get the institutional application setup details for the source award year
1232: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1233: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1234: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1235: ) IS
1236: SELECT appln.*

Line 1233: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1229:
1230:
1231: -- Get the institutional application setup details for the source award year
1232: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1233: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1234: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1235: ) IS
1236: SELECT appln.*
1237: FROM igf_ap_appl_setup_all appln

Line 1246: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

1242: ORDER BY appln.question_id;
1243:
1244:
1245: -- Check whether the application exists or not
1246: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1247: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1248: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1249: ) IS
1250: SELECT 'X' exist

Line 1247: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1243:
1244:
1245: -- Check whether the application exists or not
1246: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1247: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1248: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1249: ) IS
1250: SELECT 'X' exist
1251: FROM igf_ap_appl_setup_all appln

Line 1262: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

1258:
1259: l_rowid VARCHAR2(25);
1260: E_SKIP_APPLICATION EXCEPTION;
1261: l_error_occurred VARCHAR2(1) := 'N';
1262: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1263: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1264:
1265: BEGIN
1266: fnd_file.new_line(fnd_file.log,1);

Line 1263: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1259: l_rowid VARCHAR2(25);
1260: E_SKIP_APPLICATION EXCEPTION;
1261: l_error_occurred VARCHAR2(1) := 'N';
1262: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1263: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1264:
1265: BEGIN
1266: fnd_file.new_line(fnd_file.log,1);
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );

Line 1415: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1411:
1412:
1413: -- Procedure to create a new award distribution plan for the target award year
1414: FUNCTION create_new_plan ( p_plan_rec IN igf_aw_awd_dist_plans%ROWTYPE,
1415: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1416: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1417: )
1418: RETURN igf_aw_awd_dist_plans.adplans_id%TYPE IS
1419: --------------------------------------------------------------------------------

Line 1416: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1412:
1413: -- Procedure to create a new award distribution plan for the target award year
1414: FUNCTION create_new_plan ( p_plan_rec IN igf_aw_awd_dist_plans%ROWTYPE,
1415: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1416: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1417: )
1418: RETURN igf_aw_awd_dist_plans.adplans_id%TYPE IS
1419: --------------------------------------------------------------------------------
1420: -- Created by : ridas, Oracle India

Line 1457: p_to_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1453:
1454: -- Procedure to create a new distribution plan term for the target award year
1455: FUNCTION create_new_plan_term ( p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1456: p_plan_term_rec IN igf_aw_dp_terms%ROWTYPE,
1457: p_to_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1458: p_to_ld_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1459: )
1460: RETURN igf_aw_dp_terms.adterms_id%TYPE IS
1461: --------------------------------------------------------------------------------

Line 1458: p_to_ld_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1454: -- Procedure to create a new distribution plan term for the target award year
1455: FUNCTION create_new_plan_term ( p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1456: p_plan_term_rec IN igf_aw_dp_terms%ROWTYPE,
1457: p_to_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1458: p_to_ld_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1459: )
1460: RETURN igf_aw_dp_terms.adterms_id%TYPE IS
1461: --------------------------------------------------------------------------------
1462: -- Created by : ridas, Oracle India

Line 1497: p_to_tp_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1493:
1494: -- Procedure to create a new distribution plan teaching period for the target award year
1495: FUNCTION create_new_plan_tp ( p_adterms_id IN igf_aw_dp_terms.adterms_id%TYPE,
1496: p_plan_tp_rec IN igf_aw_dp_teach_prds%ROWTYPE,
1497: p_to_tp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1498: p_to_tp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1499: )
1500: RETURN igf_aw_dp_teach_prds.adteach_id%TYPE IS
1501: --------------------------------------------------------------------------------

Line 1498: p_to_tp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1494: -- Procedure to create a new distribution plan teaching period for the target award year
1495: FUNCTION create_new_plan_tp ( p_adterms_id IN igf_aw_dp_terms.adterms_id%TYPE,
1496: p_plan_tp_rec IN igf_aw_dp_teach_prds%ROWTYPE,
1497: p_to_tp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1498: p_to_tp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1499: )
1500: RETURN igf_aw_dp_teach_prds.adteach_id%TYPE IS
1501: --------------------------------------------------------------------------------
1502: -- Created by : ridas, Oracle India

Line 1537: PROCEDURE rollover_distribution_plans ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1533: END create_new_plan_tp;
1534:
1535:
1536: -- Procedure to rollover Award Distribution Plan Setup
1537: PROCEDURE rollover_distribution_plans ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1538: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1539: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1540: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1541: )

Line 1538: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1534:
1535:
1536: -- Procedure to rollover Award Distribution Plan Setup
1537: PROCEDURE rollover_distribution_plans ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1538: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1539: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1540: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1541: )
1542: IS

Line 1539: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1535:
1536: -- Procedure to rollover Award Distribution Plan Setup
1537: PROCEDURE rollover_distribution_plans ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1538: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1539: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1540: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1541: )
1542: IS
1543: --------------------------------------------------------------------------------

Line 1540: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1536: -- Procedure to rollover Award Distribution Plan Setup
1537: PROCEDURE rollover_distribution_plans ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1538: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1539: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1540: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1541: )
1542: IS
1543: --------------------------------------------------------------------------------
1544: -- Created by : ridas, Oracle India

Line 1553: CURSOR c_distb_plan_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1549: --
1550: --------------------------------------------------------------------------------
1551:
1552: -- Get the Award Distribution Plans for the source award year
1553: CURSOR c_distb_plan_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1554: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1555: ) IS
1556: SELECT plan.*
1557: FROM igf_aw_awd_dist_plans plan

Line 1554: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

1550: --------------------------------------------------------------------------------
1551:
1552: -- Get the Award Distribution Plans for the source award year
1553: CURSOR c_distb_plan_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1554: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1555: ) IS
1556: SELECT plan.*
1557: FROM igf_aw_awd_dist_plans plan
1558: WHERE plan.cal_type = cp_frm_cal_type

Line 1563: CURSOR c_plan_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

1559: AND plan.sequence_number = cp_frm_sequence_number
1560: ORDER BY plan.awd_dist_plan_cd;
1561:
1562: -- Check whether the fund already exists or not
1563: CURSOR c_plan_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1564: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1565: cp_awd_dist_plan_cd igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE
1566: ) IS
1567: SELECT 'X' exist

Line 1564: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1560: ORDER BY plan.awd_dist_plan_cd;
1561:
1562: -- Check whether the fund already exists or not
1563: CURSOR c_plan_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1564: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1565: cp_awd_dist_plan_cd igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE
1566: ) IS
1567: SELECT 'X' exist
1568: FROM igf_aw_awd_dist_plans plan

Line 1593: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

1589: WHERE plan_tp.adterms_id = cp_adterms_id
1590: ORDER BY plan_tp.adteach_id;
1591:
1592:
1593: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;
1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1597: l_rowid VARCHAR2(25);

Line 1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1590: ORDER BY plan_tp.adteach_id;
1591:
1592:
1593: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;
1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1597: l_rowid VARCHAR2(25);
1598: l_new_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;

Line 1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;

1591:
1592:
1593: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;
1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1597: l_rowid VARCHAR2(25);
1598: l_new_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
1599: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;

Line 1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1592:
1593: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;
1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1597: l_rowid VARCHAR2(25);
1598: l_new_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
1599: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;
1600: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;

Line 1758: PROCEDURE rollover_coa_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1754:
1755:
1756:
1757: -- Procedure to rollover Cost of Attendance Group Setup
1758: PROCEDURE rollover_coa_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1759: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1760: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1761: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1762: )

Line 1759: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1755:
1756:
1757: -- Procedure to rollover Cost of Attendance Group Setup
1758: PROCEDURE rollover_coa_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1759: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1760: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1761: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1762: )
1763: IS

Line 1760: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1756:
1757: -- Procedure to rollover Cost of Attendance Group Setup
1758: PROCEDURE rollover_coa_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1759: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1760: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1761: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1762: )
1763: IS
1764: --------------------------------------------------------------------------------

Line 1761: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1757: -- Procedure to rollover Cost of Attendance Group Setup
1758: PROCEDURE rollover_coa_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1759: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1760: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1761: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1762: )
1763: IS
1764: --------------------------------------------------------------------------------
1765: -- Created by : ridas, Oracle India

Line 1774: CURSOR c_coa_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1770: --
1771: --------------------------------------------------------------------------------
1772:
1773: -- Get the Cost of Attendance Group Setup for the source award year
1774: CURSOR c_coa_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1775: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1776: ) IS
1777: SELECT coa.*
1778: FROM igf_aw_coa_group_all coa

Line 1775: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

1771: --------------------------------------------------------------------------------
1772:
1773: -- Get the Cost of Attendance Group Setup for the source award year
1774: CURSOR c_coa_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1775: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1776: ) IS
1777: SELECT coa.*
1778: FROM igf_aw_coa_group_all coa
1779: WHERE coa.ci_cal_type = cp_frm_cal_type

Line 1784: CURSOR c_coa_grp_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

1780: AND coa.ci_sequence_number = cp_frm_sequence_number
1781: ORDER BY coa.coa_code;
1782:
1783: -- check the existence of the COA Group in the target award year
1784: CURSOR c_coa_grp_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1785: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1786: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1787: ) IS
1788: SELECT 'X' exist

Line 1785: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1781: ORDER BY coa.coa_code;
1782:
1783: -- check the existence of the COA Group in the target award year
1784: CURSOR c_coa_grp_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1785: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1786: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1787: ) IS
1788: SELECT 'X' exist
1789: FROM igf_aw_coa_group_all coa

Line 1798: CURSOR c_coa_item( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1794: l_coa_grp_exists c_coa_grp_exists%ROWTYPE;
1795:
1796:
1797: -- Get the COA Items attached to the COA Group
1798: CURSOR c_coa_item( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1799: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1800: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1801: ) IS
1802: SELECT coa_item.*

Line 1799: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1795:
1796:
1797: -- Get the COA Items attached to the COA Group
1798: CURSOR c_coa_item( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1799: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1800: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1801: ) IS
1802: SELECT coa_item.*
1803: FROM igf_aw_coa_grp_item_all coa_item

Line 1812: CURSOR c_coa_itm_exists (cp_cal_type igs_ca_inst_all.cal_type%TYPE,

1808: ORDER BY coa_item.item_code;
1809:
1810:
1811: --Check the existence of the COA Item in the rate table
1812: CURSOR c_coa_itm_exists (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1813: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1814: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1815: ) IS
1816: SELECT 'X' exist

Line 1813: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1809:
1810:
1811: --Check the existence of the COA Item in the rate table
1812: CURSOR c_coa_itm_exists (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1813: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1814: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1815: ) IS
1816: SELECT 'X' exist
1817: FROM igf_aw_coa_rate_det

Line 1828: CURSOR c_ld_coa ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1824: l_to_coa_itm_exists c_coa_itm_exists%ROWTYPE;
1825:
1826:
1827: -- Get the load percentage split up attached to the COA Group
1828: CURSOR c_ld_coa ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1829: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1830: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1831: ) IS
1832: SELECT ld_coa.*

Line 1829: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1825:
1826:
1827: -- Get the load percentage split up attached to the COA Group
1828: CURSOR c_ld_coa ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1829: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1830: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1831: ) IS
1832: SELECT ld_coa.*
1833: FROM igf_aw_coa_ld_all ld_coa

Line 1840: CURSOR c_overridden_item ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

1836: AND ld_coa.coa_code = cp_coa_code;
1837:
1838:
1839: -- Get the overridden items attached to the COA Group
1840: CURSOR c_overridden_item ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1841: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1842: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1843: ) IS
1844: SELECT over.*

Line 1841: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1837:
1838:
1839: -- Get the overridden items attached to the COA Group
1840: CURSOR c_overridden_item ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1841: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1842: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1843: ) IS
1844: SELECT over.*
1845: FROM igf_aw_cit_ld_ovrd_all over

Line 1852: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

1848: AND over.coa_code = cp_coa_code;
1849:
1850:
1851: l_rowid VARCHAR2(25):= NULL;
1852: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1853: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1854: l_coald_id igf_aw_coa_ld_all.coald_id%TYPE := NULL;
1855: l_cldo_id igf_aw_cit_ld_ovrd_all.cldo_id%TYPE := NULL;
1856: E_SKIP_COA_GRP EXCEPTION;

Line 1853: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1849:
1850:
1851: l_rowid VARCHAR2(25):= NULL;
1852: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1853: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1854: l_coald_id igf_aw_coa_ld_all.coald_id%TYPE := NULL;
1855: l_cldo_id igf_aw_cit_ld_ovrd_all.cldo_id%TYPE := NULL;
1856: E_SKIP_COA_GRP EXCEPTION;
1857: l_error_occurred VARCHAR2(1) := 'N';

Line 2086: PROCEDURE rollover_todo_items ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2082: END rollover_coa_groups;
2083:
2084:
2085: -- Procedure to rollover To Do Item Setup
2086: PROCEDURE rollover_todo_items ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2087: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2088: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2089: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2090: )

Line 2087: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2083:
2084:
2085: -- Procedure to rollover To Do Item Setup
2086: PROCEDURE rollover_todo_items ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2087: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2088: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2089: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2090: )
2091: IS

Line 2088: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2084:
2085: -- Procedure to rollover To Do Item Setup
2086: PROCEDURE rollover_todo_items ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2087: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2088: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2089: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2090: )
2091: IS
2092: --------------------------------------------------------------------------------

Line 2089: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

2085: -- Procedure to rollover To Do Item Setup
2086: PROCEDURE rollover_todo_items ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2087: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2088: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2089: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2090: )
2091: IS
2092: --------------------------------------------------------------------------------
2093: -- Created by : ridas, Oracle India

Line 2102: CURSOR c_todo_item_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2098: --
2099: --------------------------------------------------------------------------------
2100:
2101: -- Get the To Do Item details for the source award year
2102: CURSOR c_todo_item_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2103: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2104: ) IS
2105: SELECT todo.*
2106: FROM igf_ap_td_item_mst_all todo

Line 2103: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

2099: --------------------------------------------------------------------------------
2100:
2101: -- Get the To Do Item details for the source award year
2102: CURSOR c_todo_item_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2103: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2104: ) IS
2105: SELECT todo.*
2106: FROM igf_ap_td_item_mst_all todo
2107: WHERE todo.ci_cal_type = cp_frm_cal_type

Line 2112: CURSOR c_todo_exists(cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

2108: AND todo.ci_sequence_number = cp_frm_sequence_number
2109: ORDER BY todo.item_code;
2110:
2111: -- Check whether the todo item already got rolled over or not
2112: CURSOR c_todo_exists(cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2113: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2114: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
2115: ) IS
2116: SELECT 'X' exist

Line 2113: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2109: ORDER BY todo.item_code;
2110:
2111: -- Check whether the todo item already got rolled over or not
2112: CURSOR c_todo_exists(cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2113: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2114: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
2115: ) IS
2116: SELECT 'X' exist
2117: FROM igf_ap_td_item_mst_all todo

Line 2124: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

2120: AND todo.item_code = cp_item_code;
2121:
2122: l_todo_exists c_todo_exists%ROWTYPE;
2123:
2124: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2125: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2126: l_rowid VARCHAR2(25):= NULL;
2127: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE;
2128: E_SKIP_TODO EXCEPTION;

Line 2125: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2121:
2122: l_todo_exists c_todo_exists%ROWTYPE;
2123:
2124: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2125: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2126: l_rowid VARCHAR2(25):= NULL;
2127: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE;
2128: E_SKIP_TODO EXCEPTION;
2129: lv_return_flg VARCHAR2(1);

Line 2249: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2245:
2246: --Function to return Award Distribution Plan Code
2247: FUNCTION get_plan_cd(
2248: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
2249: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2250: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2251: )
2252: RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE AS
2253: ------------------------------------------------------------------

Line 2250: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

2246: --Function to return Award Distribution Plan Code
2247: FUNCTION get_plan_cd(
2248: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
2249: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2250: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2251: )
2252: RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE AS
2253: ------------------------------------------------------------------
2254: --Created by : ridas, Oracle India

Line 2269: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

2265:
2266: -- Get plan code
2267: CURSOR c_plan(
2268: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
2269: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2270: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2271: ) IS
2272: SELECT awd_dist_plan_cd
2273: FROM igf_aw_awd_dist_plans

Line 2270: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE

2266: -- Get plan code
2267: CURSOR c_plan(
2268: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
2269: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2270: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2271: ) IS
2272: SELECT awd_dist_plan_cd
2273: FROM igf_aw_awd_dist_plans
2274: WHERE adplans_id = cp_adplans_id

Line 2292: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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
2296: ------------------------------------------------------------------

Line 2293: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

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
2296: ------------------------------------------------------------------
2297: --Created by : ridas, Oracle India

Line 2312: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

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
2316: FROM igf_aw_fund_mast_all

Line 2313: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE

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
2316: FROM igf_aw_fund_mast_all
2317: WHERE fund_id = cp_fund_id

Line 2333: PROCEDURE rollover_award_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2329: END get_fund_cd;
2330:
2331:
2332: -- Procedure to rollover Award Group Setup
2333: PROCEDURE rollover_award_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2334: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2335: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2336: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2337: )

Line 2334: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2330:
2331:
2332: -- Procedure to rollover Award Group Setup
2333: PROCEDURE rollover_award_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2334: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2335: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2336: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2337: )
2338: IS

Line 2335: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2331:
2332: -- Procedure to rollover Award Group Setup
2333: PROCEDURE rollover_award_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2334: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2335: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2336: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2337: )
2338: IS
2339: --------------------------------------------------------------------------------

Line 2336: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

2332: -- Procedure to rollover Award Group Setup
2333: PROCEDURE rollover_award_groups ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2334: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2335: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2336: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2337: )
2338: IS
2339: --------------------------------------------------------------------------------
2340: -- Created by : ridas, Oracle India

Line 2349: CURSOR c_award_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2345: --
2346: --------------------------------------------------------------------------------
2347:
2348: -- Get the Award Group details for the source award year
2349: CURSOR c_award_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2350: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2351: ) IS
2352: SELECT grp.*
2353: FROM igf_aw_target_grp_all grp

Line 2350: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

2346: --------------------------------------------------------------------------------
2347:
2348: -- Get the Award Group details for the source award year
2349: CURSOR c_award_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2350: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2351: ) IS
2352: SELECT grp.*
2353: FROM igf_aw_target_grp_all grp
2354: WHERE grp.cal_type = cp_frm_cal_type

Line 2360: CURSOR c_grp_exists (cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

2356: ORDER BY grp.group_cd;
2357:
2358:
2359: -- Check whether the award group already got rolled over or not
2360: CURSOR c_grp_exists (cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2361: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2362: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2363: ) IS
2364: SELECT 'X' exist

Line 2361: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2357:
2358:
2359: -- Check whether the award group already got rolled over or not
2360: CURSOR c_grp_exists (cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2361: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2362: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2363: ) IS
2364: SELECT 'X' exist
2365: FROM igf_aw_target_grp_all grp

Line 2374: CURSOR c_formula_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2370: l_grp_exists c_grp_exists%ROWTYPE;
2371:
2372:
2373: -- Get the sequence of funds attached to the formulas for the source award year
2374: CURSOR c_formula_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2375: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2376: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2377: ) IS
2378: SELECT frm.*

Line 2375: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2371:
2372:
2373: -- Get the sequence of funds attached to the formulas for the source award year
2374: CURSOR c_formula_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2375: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2376: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2377: ) IS
2378: SELECT frm.*
2379: FROM igf_aw_awd_frml_det_all frm

Line 2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2383: ORDER BY frm.adplans_id;
2384:
2385:
2386: -- Check whether the Distribution Plan got rolled over
2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

Line 2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2384:
2385:
2386: -- Check whether the Distribution Plan got rolled over
2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
2392: ) IS

Line 2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

2385:
2386: -- Check whether the Distribution Plan got rolled over
2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
2392: ) IS
2393: SELECT plan.adplans_id

Line 2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2386: -- Check whether the Distribution Plan got rolled over
2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
2392: ) IS
2393: SELECT plan.adplans_id
2394: FROM igf_aw_awd_dist_plans plan

Line 2409: CURSOR c_fund_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2405: l_plan_exists c_plan_exists%ROWTYPE;
2406:
2407:
2408: -- Check whether the Funds got rolled over
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

Line 2410: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2406:
2407:
2408: -- Check whether the Funds got rolled over
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

Line 2411: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

2407:
2408: -- Check whether the Funds got rolled over
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

Line 2412: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2408: -- Check whether the Funds got rolled over
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

Line 2430: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

2426:
2427: l_fund_exists c_fund_exists%ROWTYPE;
2428:
2429:
2430: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2431: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2432: l_rowid VARCHAR2(25):= NULL;
2433: l_tgrp_id igf_aw_target_grp_all.tgrp_id%TYPE;
2434: E_SKIP_AWARD_GRP EXCEPTION;

Line 2431: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2427: l_fund_exists c_fund_exists%ROWTYPE;
2428:
2429:
2430: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2431: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2432: l_rowid VARCHAR2(25):= NULL;
2433: l_tgrp_id igf_aw_target_grp_all.tgrp_id%TYPE;
2434: E_SKIP_AWARD_GRP EXCEPTION;
2435: l_error_occurred VARCHAR2(1) := 'N';

Line 2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2651: END rollover_award_groups;
2652:
2653:
2654: -- Procedure to rollover Institutional Application Setup attached to TO DO item
2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE

Line 2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2652:
2653:
2654: -- Procedure to rollover Institutional Application Setup attached to TO DO item
2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
2660: )

Line 2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2653:
2654: -- Procedure to rollover Institutional Application Setup attached to TO DO item
2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
2660: )
2661: RETURN VARCHAR IS

Line 2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2654: -- Procedure to rollover Institutional Application Setup attached to TO DO item
2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
2660: )
2661: RETURN VARCHAR IS
2662: --------------------------------------------------------------------------------

Line 2672: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2668: --
2669: --------------------------------------------------------------------------------
2670:
2671: -- Get the institutional application setup details for the source award year
2672: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2673: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2674: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2675: ) IS
2676: SELECT appln.*

Line 2673: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2669: --------------------------------------------------------------------------------
2670:
2671: -- Get the institutional application setup details for the source award year
2672: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2673: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2674: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2675: ) IS
2676: SELECT appln.*
2677: FROM igf_ap_appl_setup_all appln

Line 2686: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,

2682: ORDER BY appln.question_id;
2683:
2684:
2685: -- Check whether the application exists or not
2686: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2687: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2688: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2689: ) IS
2690: SELECT 'X' exist

Line 2687: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2683:
2684:
2685: -- Check whether the application exists or not
2686: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2687: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2688: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2689: ) IS
2690: SELECT 'X' exist
2691: FROM igf_ap_appl_setup_all appln

Line 2702: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

2698:
2699: l_rowid VARCHAR2(25);
2700: E_SKIP_APPLICATION EXCEPTION;
2701: l_error_occurred VARCHAR2(1) := 'N';
2702: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2703: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2704:
2705: BEGIN
2706:

Line 2703: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2699: l_rowid VARCHAR2(25);
2700: E_SKIP_APPLICATION EXCEPTION;
2701: l_error_occurred VARCHAR2(1) := 'N';
2702: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2703: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2704:
2705: BEGIN
2706:
2707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2849: CURSOR c_get_to_awdyr( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,

2845: --
2846: --------------------------------------------------------------------------------
2847:
2848: --Cursor to fetch To Award Year
2849: CURSOR c_get_to_awdyr( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2850: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2851: ) IS
2852: SELECT sc_cal_type,
2853: sc_sequence_number,

Line 2850: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE

2846: --------------------------------------------------------------------------------
2847:
2848: --Cursor to fetch To Award Year
2849: CURSOR c_get_to_awdyr( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2850: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2851: ) IS
2852: SELECT sc_cal_type,
2853: sc_sequence_number,
2854: sc_alternate_code

Line 2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;

2858: AND NVL(active,'N') = 'Y';
2859:
2860: l_get_to_awdyr c_get_to_awdyr%ROWTYPE;
2861:
2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;
2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;
2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;

Line 2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2859:
2860: l_get_to_awdyr c_get_to_awdyr%ROWTYPE;
2861:
2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;
2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;
2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;
2867: to_awdyr_exception EXCEPTION;

Line 2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;

2860: l_get_to_awdyr c_get_to_awdyr%ROWTYPE;
2861:
2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;
2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;
2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;
2867: to_awdyr_exception EXCEPTION;
2868:

Line 2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2861:
2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;
2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;
2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;
2867: to_awdyr_exception EXCEPTION;
2868:
2869: BEGIN

Line 2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;

2862: lv_frm_cal_type igs_ca_inst_all.cal_type%TYPE;
2863: ln_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2864: lv_to_cal_type igs_ca_inst_all.cal_type%TYPE;
2865: ln_to_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2866: lv_to_award_year igs_ca_inst_all.alternate_code%TYPE;
2867: to_awdyr_exception EXCEPTION;
2868:
2869: BEGIN
2870: