APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

Line 911: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

907: END create_ssn;
908:
909: PROCEDURE create_fa_base_record(
910: pn_css_id igf_ap_css_interface_all.css_id%TYPE,
911: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
912: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
913: ) IS
914:
915: /*

Line 912: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

908:
909: PROCEDURE create_fa_base_record(
910: pn_css_id igf_ap_css_interface_all.css_id%TYPE,
911: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
912: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
913: ) IS
914:
915: /*
916: || Created By : Meghana

Line 1560: pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,

1556:
1557:
1558: PROCEDURE create_person_record(
1559: pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1560: pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
1561: pv_mesg_data OUT NOCOPY VARCHAR2,
1562: p_called_from VARCHAR2
1563: )IS
1564:

Line 1723: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE

1719: END create_person_record;
1720:
1721:
1722: PROCEDURE create_person_addr_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1723: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1724: ) IS
1725:
1726: /*
1727: || Created By : Meghana

Line 2338: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

2334:
2335: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
2336: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
2337: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
2338: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
2339: )RETURN BOOLEAN IS
2340:
2341: /*
2342: || Created By : Meghana

Line 3145: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

3141: app_exception.raise_exception;
3142: END update_css_interface;
3143:
3144: PROCEDURE create_admission_rec(
3145: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
3146: p_batch_year igf_ap_css_interface_all.academic_year%TYPE
3147: ) IS
3148:
3149: /*

Line 4286: FROM igf_ap_fa_base_rec_all

4282: --cursor to get the person_id from base_id
4283: CURSOR cur_get_person_id(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)
4284: IS
4285: SELECT person_id
4286: FROM igf_ap_fa_base_rec_all
4287: WHERE base_id = cp_base_id ;
4288:
4289: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;
4290:

Line 4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

4480: WHERE match_code = cp_match_code;
4481:
4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;

Line 4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

4481:
4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;
4489: