APPS.IGF_SL_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 452: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

448:
449: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
450: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
451: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
452: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
453: RETURN VARCHAR2
454: AS
455: /*************************************************************
456: Created By : venagara

Line 1272: PROCEDURE get_associated_org (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1268: app_exception.raise_exception;
1269:
1270: END check_rel;
1271:
1272: PROCEDURE get_associated_org (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1273: x_org_unit_cd OUT NOCOPY hz_parties.party_number%TYPE,
1274: x_org_party_id OUT NOCOPY hz_parties.party_id%TYPE,
1275: x_module OUT NOCOPY VARCHAR2,
1276: x_return_status OUT NOCOPY VARCHAR2,

Line 1363: FROM igf_ap_fa_base_rec_all fa,

1359: SELECT fa.assoc_org_num,
1360: hz.party_number,
1361: hz.party_name,
1362: hz.party_id
1363: FROM igf_ap_fa_base_rec_all fa,
1364: hz_parties hz
1365: WHERE fa.base_id = p_base_id
1366: AND fa.assoc_org_num = hz.party_id;
1367: c_get_assoc_org_rec c_get_assoc_org%ROWTYPE;

Line 1498: PROCEDURE get_stu_fao_code (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1494: This procedure does not through any exceptions but returns success status 'S' for SUCCESS
1495: or 'E' for ERROR. The calling procedure should error out based on x_return_status. Also
1496: x_msg_data contains the proper error message if x_return_status is 'E'
1497: */
1498: PROCEDURE get_stu_fao_code (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1499: p_office_type IN igs_lookups_view.lookup_code%TYPE,
1500: x_office_cd OUT NOCOPY igs_or_org_alt_ids.org_alternate_id_type%TYPE,
1501: x_return_status OUT NOCOPY VARCHAR2,
1502: x_msg_data OUT NOCOPY VARCHAR2)

Line 1960: (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1956:
1957: END update_cl_chg_status;
1958:
1959: PROCEDURE get_stu_ant_fao_code
1960: (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1961: p_office_type IN igs_lookups_view.lookup_code%TYPE,
1962: x_office_cd OUT NOCOPY igs_or_org_alt_ids.org_alternate_id_type%TYPE,
1963: x_return_status OUT NOCOPY VARCHAR2,
1964: x_msg_data OUT NOCOPY VARCHAR2)

Line 1990: CURSOR c_ant_data_curr_term(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1986:
1987: -- This cursor gets the anticipated data for all the terms
1988: -- We then loop thru all the terms to find out if anticipated
1989: -- data is available for the current term
1990: CURSOR c_ant_data_curr_term(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1991: IS
1992: SELECT fant.*
1993: FROM igf_ap_fa_ant_data fant
1994: WHERE fant.base_id = cp_base_id;

Line 2001: CURSOR c_ant_data_all_terms(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1997:
1998: -- Scans all the terms (starting from the earliest) in the student's
1999: -- award year for a valid anticipated Org Unit.
2000: -- This would be used if the current term does not have anticipated data.
2001: CURSOR c_ant_data_all_terms(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
2002: IS
2003: SELECT ant_data.*
2004: FROM
2005: igf_aw_awd_ld_cal_v awd_year_terms,

Line 2020: CURSOR c_get_ant_org_unit(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

2016:
2017: -- Scans all the terms (starting from the earliest) in the student's
2018: -- award year for a valid anticipated key prgram and version. Returns the
2019: -- Org Unit corresponding to the anticipated key prog and version
2020: CURSOR c_get_ant_org_unit(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
2021: IS
2022: SELECT prog.*
2023: FROM
2024: igf_aw_awd_ld_cal_v awd_year_terms,