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

Line 300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

296: -- g_sf_packaging VARCHAR2(1) := 'F';
297: g_sf_packaging VARCHAR2(1);
298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;
299: g_fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE;
300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;
302: g_sf_fund igf_aw_fund_mast_all.fund_id%TYPE;
303:
304: g_pell_tab igf_gr_pell_calc.pell_tab := igf_gr_pell_calc.pell_tab();

Line 301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;

297: g_sf_packaging VARCHAR2(1);
298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;
299: g_fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE;
300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;
302: g_sf_fund igf_aw_fund_mast_all.fund_id%TYPE;
303:
304: g_pell_tab igf_gr_pell_calc.pell_tab := igf_gr_pell_calc.pell_tab();
305:

Line 609: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

605: END get_prog_elig;
606:
607: FUNCTION get_term_start_date(
608: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
609: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
610: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE
611: )
612: RETURN DATE
613: IS

Line 610: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE

606:
607: FUNCTION get_term_start_date(
608: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
609: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
610: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE
611: )
612: RETURN DATE
613: IS
614: ------------------------------------------------------------------

Line 727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

723: --
724: --Change History:
725: --Who When What
726: -------------------------------------------------------------------
727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
729:
730: CURSOR c_awards IS
731: SELECT awd.ROWID row_id,

Line 728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

724: --Change History:
725: --Who When What
726: -------------------------------------------------------------------
727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
729:
730: CURSOR c_awards IS
731: SELECT awd.ROWID row_id,
732: awd.*

Line 4360: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

4356: END IF;
4357: END actualDisbExist;
4358:
4359: FUNCTION awardsExist(
4360: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4361: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4362: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4363: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4364: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

Line 4361: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

4357: END actualDisbExist;
4358:
4359: FUNCTION awardsExist(
4360: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4361: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4362: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4363: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4364: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4365: ) RETURN BOOLEAN AS

Line 4519: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

4515: RETURN l_verif_status;
4516: END getFedVerifStatus;
4517:
4518: FUNCTION doesAwardSpanOutsideAP(
4519: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4520: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4521: p_award_id igf_aw_award_all.award_id%TYPE,
4522: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4523: ) RETURN BOOLEAN AS

Line 4520: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

4516: END getFedVerifStatus;
4517:
4518: FUNCTION doesAwardSpanOutsideAP(
4519: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4520: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4521: p_award_id igf_aw_award_all.award_id%TYPE,
4522: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4523: ) RETURN BOOLEAN AS
4524: ------------------------------------------------------------------

Line 4857: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

4853:
4854: END merge_funds;
4855:
4856: PROCEDURE load_awards(
4857: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4858: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4859: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4860: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4861: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

Line 4858: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

4854: END merge_funds;
4855:
4856: PROCEDURE load_awards(
4857: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4858: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4859: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4860: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4861: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4862: p_lock_award_flag igf_aw_fund_mast_all.lock_award_flag%TYPE,

Line 4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

4882: -------------------------------------------------------------------
4883: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
4884: -- Get awards from a fund
4885: CURSOR c_awds(
4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4888: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4889: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4890: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE

Line 4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

4883: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
4884: -- Get awards from a fund
4885: CURSOR c_awds(
4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4888: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4889: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4890: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
4891: ) IS

Line 5733: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

5729: l_party_id igf_sl_cl_setup.party_id%TYPE;
5730: l_alt_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5731:
5732: CURSOR c_dp_ap(
5733: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5734: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
5737: ) IS

Line 5734: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

5730: l_alt_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5731:
5732: CURSOR c_dp_ap(
5733: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5734: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
5737: ) IS
5738: SELECT 'x'

Line 5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:
5789: -- Returns the fund source of the given fund
5790: CURSOR c_get_fund_source(

Line 5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;

5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:
5789: -- Returns the fund source of the given fund
5790: CURSOR c_get_fund_source(
5791: cp_fund_code IGF_AW_FUND_CAT_ALL.FUND_CODE%TYPE

Line 5803: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

5799: -- Scans the terms (starting from the earliest) in the awarding period
5800: -- for a valid key program. The first term that has a valid anticipated
5801: -- key program data is taken into consideration.
5802: CURSOR c_get_ant_prog(
5803: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5804: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
5805: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5806: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
5807: )

Line 5804: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

5800: -- for a valid key program. The first term that has a valid anticipated
5801: -- key program data is taken into consideration.
5802: CURSOR c_get_ant_prog(
5803: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5804: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
5805: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5806: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
5807: )
5808: IS

Line 5814: igs_ca_inst_all cal_inst,

5810: ant_data.ld_cal_type load_cal_type,
5811: ant_data.ld_sequence_number load_seq_num
5812: FROM
5813: igf_aw_awd_prd_term awd_per,
5814: igs_ca_inst_all cal_inst,
5815: igf_ap_fa_ant_data ant_data,
5816: igs_ps_ver prog
5817: WHERE
5818: awd_per.ld_cal_type = cal_inst.cal_type AND

Line 7533: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

7529: RETURN l_css_id;
7530: END hasActiveProfile;
7531:
7532: FUNCTION get_award_process_status(
7533: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
7534: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
7535: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
7536: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7537: ) RETURN VARCHAR2 AS

Line 7534: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

7530: END hasActiveProfile;
7531:
7532: FUNCTION get_award_process_status(
7533: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
7534: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
7535: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
7536: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7537: ) RETURN VARCHAR2 AS
7538: ------------------------------------------------------------------

Line 8253: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

8249:
8250: END stud_run;
8251:
8252: FUNCTION isPhaseInParticipant(
8253: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
8254: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
8255: ) RETURN BOOLEAN AS
8256: ------------------------------------------------------------------
8257: --Created by : veramach, Oracle India

Line 8254: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE

8250: END stud_run;
8251:
8252: FUNCTION isPhaseInParticipant(
8253: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
8254: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
8255: ) RETURN BOOLEAN AS
8256: ------------------------------------------------------------------
8257: --Created by : veramach, Oracle India
8258: --Date created: 25-Oct-2004

Line 8271: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

8267: -------------------------------------------------------------------
8268:
8269: -- Get pell participation type
8270: CURSOR c_pell_particip(
8271: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
8272: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
8273: ) IS
8274: SELECT pell_participant_code
8275: FROM igf_ap_batch_aw_map_all

Line 8272: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE

8268:
8269: -- Get pell participation type
8270: CURSOR c_pell_particip(
8271: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
8272: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
8273: ) IS
8274: SELECT pell_participant_code
8275: FROM igf_ap_batch_aw_map_all
8276: WHERE ci_cal_type = cp_ci_cal_type

Line 8825: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

8821:
8822: -- Get first disb date for a term
8823: CURSOR c_first_disb_dt(
8824: cp_award_id igf_aw_award_all.award_id%TYPE,
8825: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
8826: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
8827: ) IS
8828: SELECT disb_date,
8829: tp_cal_type,

Line 8826: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

8822: -- Get first disb date for a term
8823: CURSOR c_first_disb_dt(
8824: cp_award_id igf_aw_award_all.award_id%TYPE,
8825: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
8826: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
8827: ) IS
8828: SELECT disb_date,
8829: tp_cal_type,
8830: tp_sequence_number

Line 12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

12122:
12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code
12130: FROM igf_aw_award_t awdt

Line 12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code
12130: FROM igf_aw_award_t awdt
12131: WHERE process_id = l_process_id

Line 12803: p_cal_type IN igs_ca_inst.cal_type%TYPE,

12799:
12800: FUNCTION get_date_instance(
12801: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
12802: p_dt_alias IN igs_ca_da.dt_alias%TYPE,
12803: p_cal_type IN igs_ca_inst.cal_type%TYPE,
12804: p_cal_sequence IN igs_ca_inst.sequence_number%TYPE
12805: ) RETURN DATE IS
12806: /*
12807: || Created By : skoppula

Line 12804: p_cal_sequence IN igs_ca_inst.sequence_number%TYPE

12800: FUNCTION get_date_instance(
12801: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
12802: p_dt_alias IN igs_ca_da.dt_alias%TYPE,
12803: p_cal_type IN igs_ca_inst.cal_type%TYPE,
12804: p_cal_sequence IN igs_ca_inst.sequence_number%TYPE
12805: ) RETURN DATE IS
12806: /*
12807: || Created By : skoppula
12808: || Created On : 02-JAN-2002

Line 13047: FROM igs_ca_inst_all

13043: CURSOR c_alternate_code(
13044: cp_award_year VARCHAR2
13045: ) IS
13046: SELECT alternate_code
13047: FROM igs_ca_inst_all
13048: WHERE cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13049: AND sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13050:
13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

13047: FROM igs_ca_inst_all
13048: WHERE cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13049: AND sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13050:
13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
13052:
13053: -- Get get group description for group_id
13054: CURSOR c_person_group(
13055: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE