1 PACKAGE IGS_AD_IMP_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD79S.pls 115.25 2003/12/09 14:26:17 pbondugu ship $ */
3 /*************************************************************
4 Created By :
5 Date Created By :
6 Purpose :
7 Know limitations, enhancements or remarks
8 Change History
9 Who When What
10 (reverse chronological order - newest change first)
11 ssaleem 13-OCT-2003 Bug : 3130316
12 Included a new variable g_enable_log
13 for Import Process Enhancements
14 asbala 4-NOV-2003 Bug 3130316 (added the parameter P_ENABLE_LOG)
15 pkpatel 6-NOV-2003 Added procedures print_stats and logerrormessage
16 ***************************************************************/
17 --- SWS Import Process Enhancements
18 g_interface_run_id IGS_AD_INTERFACE_CTL.interface_run_id%TYPE;
19 g_enable_log VARCHAR2(1) := 'N';
20
21 PROCEDURE logerrormessage(p_record IN VARCHAR2,
22 p_error IN VARCHAR2,
23 p_entity_name IN VARCHAR2 DEFAULT NULL,
24 p_match_ind IN VARCHAR2 DEFAULT NULL);
25
26 PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE);
27
28 PROCEDURE set_message(p_name IN VARCHAR2,
29 p_token_name IN VARCHAR2 DEFAULT NULL,
30 p_token_value IN VARCHAR2 DEFAULT NULL);
31
32 PROCEDURE logHeader(p_proc_name VARCHAR2);
33
34 PROCEDURE logDetail(p_debug_msg VARCHAR2);
35
36 PROCEDURE update_parent_record_status (p_source_type_id IN NUMBER,
37 p_batch_id IN NUMBER,
38 p_interface_run_id IN NUMBER);
39
40 TYPE g_category_entity_type_record IS RECORD (
41 category_name fnd_lookup_values.lookup_code%TYPE,
42 entity_name user_tables.table_name%TYPE);
43
44 TYPE g_category_entity_type_table IS TABLE OF g_category_entity_type_record INDEX BY BINARY_INTEGER;
45
46 PROCEDURE store_stats (p_source_type_id IN NUMBER,
47 p_batch_id IN NUMBER,
48 p_interface_run_id IN NUMBER,
49 p_category_entity_table IN g_category_entity_type_table);
50
51 FUNCTION import_legacy_data (
52 p_batch_id NUMBER,
53 p_source_type_id NUMBER,
54 p_interface_run_id NUMBER) RETURN BOOLEAN;
55
56 PROCEDURE imp_adm_data(
57 ERRBUF OUT NOCOPY VARCHAR2,
58 RETCODE OUT NOCOPY NUMBER ,
59 P_BATCH_ID IN NUMBER,
60 P_SOURCE_TYPE_ID IN NUMBER,
61 P_MATCH_SET_ID IN NUMBER,
62 P_LEGACY_IND IN VARCHAR2 DEFAULT 'N',
63 P_ENABLE_LOG IN VARCHAR2 DEFAULT 'Y',
64 P_ACAD_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
65 P_ACAD_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
66 P_ADM_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
67 P_ADM_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
68 P_ADMISSION_CAT IN VARCHAR2 DEFAULT NULL,
69 P_S_ADMISSION_PROCESS_TYPE IN VARCHAR2 DEFAULT NULL,
70 P_INTERFACE_RUN_ID IN NUMBER DEFAULT NULL,
71 P_ORG_ID IN NUMBER DEFAULT NULL
72 );
73
74 FUNCTION find_source_cat_rule(p_source_type_id in number,
75 p_category in varchar2)
76 RETURN VARCHAR2 ;
77
78 END igs_ad_imp_001;