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_SP_AWARD dependencies on IGS_CA_INST

Line 164: CURSOR c_ca_inst( cp_c_cal_type igs_ca_inst.cal_type%TYPE,

160: (reverse chronological order - newest change first)
161: ----------------------------------------------------------------------------*/
162:
163: -- Cursor to select the details for the award year or term calendar passed to the process
164: CURSOR c_ca_inst( cp_c_cal_type igs_ca_inst.cal_type%TYPE,
165: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE)
166: IS
167: SELECT alternate_code,
168: start_dt,

Line 165: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE)

161: ----------------------------------------------------------------------------*/
162:
163: -- Cursor to select the details for the award year or term calendar passed to the process
164: CURSOR c_ca_inst( cp_c_cal_type igs_ca_inst.cal_type%TYPE,
165: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE)
166: IS
167: SELECT alternate_code,
168: start_dt,
169: end_dt

Line 170: FROM igs_ca_inst

166: IS
167: SELECT alternate_code,
168: start_dt,
169: end_dt
170: FROM igs_ca_inst
171: WHERE cal_type = cp_c_cal_type
172: AND sequence_number = cp_n_sequence_number;
173: -- cursor variable for c_igs_ca_inst
174: l_v_ca_inst c_ca_inst%ROWTYPE;

Line 173: -- cursor variable for c_igs_ca_inst

169: end_dt
170: FROM igs_ca_inst
171: WHERE cal_type = cp_c_cal_type
172: AND sequence_number = cp_n_sequence_number;
173: -- cursor variable for c_igs_ca_inst
174: l_v_ca_inst c_ca_inst%ROWTYPE;
175: BEGIN
176: OPEN c_ca_inst(p_c_cal_type, p_n_seq_number);
177: FETCH c_ca_inst INTO l_v_ca_inst;

Line 517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

513: -- cursor to check forprg attempt
514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt
521: WHERE person_id = cp_person_id

Line 518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt
521: WHERE person_id = cp_person_id
522: AND course_cd = cp_course_cd

Line 544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;

540: l_msg_count NUMBER;
541: l_msg_data VARCHAR2(2000);
542: l_status BOOLEAN;
543:
544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

Line 545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;

541: l_msg_data VARCHAR2(2000);
542: l_status BOOLEAN;
543:
544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

Line 1371: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1367:
1368: -- cursor to see the value for the manual update
1369: CURSOR c_manual_update (cp_base_id igf_sp_stdnt_rel.base_id%TYPE,
1370: cp_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
1371: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1373: )
1374: IS
1375: SELECT NVL(manual_update,'N'), award_id

Line 1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1368: -- cursor to see the value for the manual update
1369: CURSOR c_manual_update (cp_base_id igf_sp_stdnt_rel.base_id%TYPE,
1370: cp_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
1371: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1373: )
1374: IS
1375: SELECT NVL(manual_update,'N'), award_id
1376: FROM igf_aw_award awd

Line 2007: p_cal_type IN igs_ca_inst.cal_type%TYPE,

2003: RAISE;
2004: END loop_thru_spnsr_dtl_pvt;
2005:
2006: PROCEDURE loop_thru_spnsr_dtl (p_person_id IN igs_pe_person.person_id%TYPE,
2007: p_cal_type IN igs_ca_inst.cal_type%TYPE,
2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2009: p_award_type IN VARCHAR2,
2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

2004: END loop_thru_spnsr_dtl_pvt;
2005:
2006: PROCEDURE loop_thru_spnsr_dtl (p_person_id IN igs_pe_person.person_id%TYPE,
2007: p_cal_type IN igs_ca_inst.cal_type%TYPE,
2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2009: p_award_type IN VARCHAR2,
2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
2012: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE)

Line 2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

2007: p_cal_type IN igs_ca_inst.cal_type%TYPE,
2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2009: p_award_type IN VARCHAR2,
2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
2012: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE)
2013: AS
2014: ------------------------------------------------------------------------------------
2015: --Created by : smanglm ( Oracle IDC)

Line 2012: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE)

2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2009: p_award_type IN VARCHAR2,
2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
2012: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE)
2013: AS
2014: ------------------------------------------------------------------------------------
2015: --Created by : smanglm ( Oracle IDC)
2016: --Date created: 2002/01/11

Line 2039: cp_awd_cal_type igs_ca_inst.cal_type%TYPE,

2035: -- parameters to the procedure.
2036: -------------------------------------------------------------------------------------
2037: -- cursor to get all the sponsor detail for the person id
2038: CURSOR c_sp_std_dtls (cp_person_id igs_pe_person.person_id%TYPE,
2039: cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
2040: cp_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2041: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2042: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE) IS
2043: SELECT rel.*,

Line 2040: cp_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

2036: -------------------------------------------------------------------------------------
2037: -- cursor to get all the sponsor detail for the person id
2038: CURSOR c_sp_std_dtls (cp_person_id igs_pe_person.person_id%TYPE,
2039: cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
2040: cp_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2041: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2042: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE) IS
2043: SELECT rel.*,
2044: fund.fund_code,

Line 2223: l_cal_type igs_ca_inst.cal_type%TYPE;

2219: -- term calendar was provided as parameter to the process
2220: -------------------------------------------------------------------------------------
2221:
2222: -- variables to store cal type and seq num passed by award year
2223: l_cal_type igs_ca_inst.cal_type%TYPE;
2224: l_sequence_number igs_ca_inst.sequence_number%TYPE;
2225: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
2227:

Line 2224: l_sequence_number igs_ca_inst.sequence_number%TYPE;

2220: -------------------------------------------------------------------------------------
2221:
2222: -- variables to store cal type and seq num passed by award year
2223: l_cal_type igs_ca_inst.cal_type%TYPE;
2224: l_sequence_number igs_ca_inst.sequence_number%TYPE;
2225: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
2227:
2228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

Line 2225: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

2221:
2222: -- variables to store cal type and seq num passed by award year
2223: l_cal_type igs_ca_inst.cal_type%TYPE;
2224: l_sequence_number igs_ca_inst.sequence_number%TYPE;
2225: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
2227:
2228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
2229:

Line 2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;

2222: -- variables to store cal type and seq num passed by award year
2223: l_cal_type igs_ca_inst.cal_type%TYPE;
2224: l_sequence_number igs_ca_inst.sequence_number%TYPE;
2225: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
2227:
2228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
2229:
2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter

Line 2233: cp_cal_type igs_ca_inst.cal_type%TYPE,

2229:
2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
2231: -- This cursor definition is public to this package body;
2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS

Line 2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
2231: -- This cursor definition is public to this package body;
2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS
2238: SELECT fmast.*