1 PACKAGE IGS_PE_PERS_IMP_001 AS
2 /* $Header: IGSPE15S.pls 120.1 2006/04/27 07:38:06 prbhardw noship $ */
3
4 /*************************************************************
5 Created By :pkpatel
6 Date Created By :29-APR-2003
7 Purpose :
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 (reverse chronological order - newest change first)
12
13 nsidana 9/23/2003 ADMISSIONS Import process enhancements.
14 Lookups caching.
15 Added new function validate_lookup_type_code(...)
16
17 ***************************************************************/
18 PROCEDURE prc_pe_category(
19 p_batch_id IN NUMBER,
20 p_source_type_id IN NUMBER,
21 p_match_set_id IN NUMBER,
22 p_interface_run_id IN NUMBER
23 );
24
25
26 /*************************************************************
27 Created By :pkpatel
28 Date Created By :29-APR-2003
29 Purpose :
30 Know limitations, enhancements or remarks
31 Change History
32 Who When What
33 (reverse chronological order - newest change first)
34 ***************************************************************/
35
36 PROCEDURE DEL_CMPLD_PE_RECORDS(
37 p_batch_id IN NUMBER
38 );
39
40
41 /*************************************************************
42 Created By :pkpatel
43 Date Created By :29-APR-2003
44 Purpose :
45 Know limitations, enhancements or remarks
46 Change History
47 Who When What
48 (reverse chronological order - newest change first)
49 ***************************************************************/
50
51 PROCEDURE set_stat_matc_rvw_pers_rcds (
52 p_source_type_id IN NUMBER,
53 p_batch_id IN NUMBER
54 );
55
56 PROCEDURE prc_pe_imp_record_sts(
57 p_interface_id IN igs_ad_interface_all.interface_id%TYPE
58 );
59
60
61 --< nsidana 9/23/2003 Admissions Import process enhancements : Lookups caching >
62
63 FUNCTION validate_lookup_type_code(p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
64 p_lookup_code IN fnd_lookup_values.lookup_type%TYPE,
65 p_application_id IN NUMBER)
66 RETURN BOOLEAN;
67 /*****************************************************************
68 Created By : nsidana
69
70 Creation date : 9/23/2003
71
72 Purpose : This function is to validate the lookup type and lookup
73 code combination. It checks if the lookup type and lookup code combination
74 is a valid one. It uses PL/SQL table to evaluate this.
75
76 Know limitations, enhancements or remarks
77
78 Change History
79 Who When What
80
81 (reverse chronological order - newest change first)
82 ***************************************************************/
83
84 TYPE l_lookups_table_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER; -- PL/SQL table type.
85
86 l_lookups_tab l_lookups_table_type; -- PL/SQL table to store the hash code for the lookup_type.
87 l_lookup_type_tab l_lookups_table_type; -- PL/SQL table to store the hash code for the (lookup_type+lookup_code).
88
89
90 PROCEDURE pe_cat_stats(p_source_category IN VARCHAR2);
91
92 PROCEDURE validate_ucas_id(p_api_id IN VARCHAR2,
93 p_person_id IN NUMBER,
94 p_api_type IN VARCHAR2,
95 p_action OUT NOCOPY VARCHAR2,
96 p_error_code OUT NOCOPY VARCHAR2);
97
98 -- change for country code inconsistency bug 3738488
99 FUNCTION validate_country_code(p_country_code IN VARCHAR2)
100 RETURN BOOLEAN;
101
102 END igs_pe_pers_imp_001;