DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_FA_BASE_REC

Line 5: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

1: PACKAGE igf_ap_profile_matching_pkg AS
2: /* $Header: IGFAP16S.pls 120.0 2005/06/01 15:01:20 appldev noship $ */
3:
4: PROCEDURE create_fa_base_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
5: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
6: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
7: ) ;
8:
9: PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

Line 6: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

2: /* $Header: IGFAP16S.pls 120.0 2005/06/01 15:01:20 appldev noship $ */
3:
4: PROCEDURE create_fa_base_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
5: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
6: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
7: ) ;
8:
9: PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
10: pn_cssp_id igf_ap_css_profile.cssp_id%TYPE

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

10: pn_cssp_id igf_ap_css_profile.cssp_id%TYPE
11: ) ;
12:
13: PROCEDURE create_person_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
14: pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
15: pv_mesg_data OUT NOCOPY VARCHAR2,
16: p_called_from VARCHAR2
17: ) ;
18:

Line 20: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE

16: p_called_from VARCHAR2
17: ) ;
18:
19: PROCEDURE create_person_addr_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
20: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE
21: ) ;
22:
23: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
24: pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,

Line 33: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

29:
30: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
31: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
32: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
33: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
34: ) RETURN BOOLEAN ;
35:
36: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
37: pv_record_status igf_ap_css_interface_all.record_status%TYPE,

Line 64: PROCEDURE create_admission_rec(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

60: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE );
61:
62: PROCEDURE unmatched_rec (p_apm_id igf_ap_person_match_all.apm_id%TYPE);
63:
64: PROCEDURE create_admission_rec(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
65: p_batch_year igf_ap_css_interface_all.academic_year%TYPE);
66:
67:
68: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,

Line 72: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE);

68: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,
69: pv_record_status igf_ap_person_match.record_status%TYPE
70: ) ;
71:
72: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE);
73:
74:
75: FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)
76: RETURN VARCHAR2;