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_GEN dependencies on IGS_CA_INST_ALL

Line 143: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

139: -- batch year mappings table
140: --------------------------------------------------------------------------------------
141:
142:
143: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
144: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
145: p_process IN VARCHAR2)
146: RETURN VARCHAR2
147: IS

Line 144: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

140: --------------------------------------------------------------------------------------
141:
142:
143: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
144: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
145: p_process IN VARCHAR2)
146: RETURN VARCHAR2
147: IS
148:

Line 149: CURSOR cur_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

145: p_process IN VARCHAR2)
146: RETURN VARCHAR2
147: IS
148:
149: CURSOR cur_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
150: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
151: IS
152: SELECT dl_code,
153: pell_code,

Line 150: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE)

146: RETURN VARCHAR2
147: IS
148:
149: CURSOR cur_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
150: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
151: IS
152: SELECT dl_code,
153: pell_code,
154: ffel_code,

Line 1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1886: || Who When What
1887: || (reverse chronological order - newest change first)
1888: */
1889: PROCEDURE get_notification_status (
1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,

Line 1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

1887: || (reverse chronological order - newest change first)
1888: */
1889: PROCEDURE get_notification_status (
1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE

Line 1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1900: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1901: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1902: IS

Line 1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1900: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1901: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1902: IS
1903: SELECT TO_CHAR(MIN(status_order)) min_award_status, MAX(notification_status_date) notification_status_date

Line 1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1979: || Who When What
1980: || (reverse chronological order - newest change first)
1981: */
1982: PROCEDURE update_notification_status (
1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,

Line 1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

1980: || (reverse chronological order - newest change first)
1981: */
1982: PROCEDURE update_notification_status (
1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,

Line 1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2
1990: ) AS
1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1993: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1994: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1995: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1996: IS

Line 1993: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1989: p_called_from IN VARCHAR2
1990: ) AS
1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1993: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1994: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1995: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1996: IS
1997: SELECT

Line 2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2196: || (reverse chronological order - newest change first)
2197: */
2198: FUNCTION is_fund_locked_for_awd_period (
2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS

Line 2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

2197: */
2198: FUNCTION is_fund_locked_for_awd_period (
2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (

Line 2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE
2211: )

Line 2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE
2211: )
2212: IS