1 PACKAGE igs_ad_gen_016 AS
2 /* $Header: IGSAD99S.pls 120.0 2005/06/01 17:02:48 appldev noship $ */
3 /* ------------------------------------------------------------------------------------------------------------------------
4 ||Created By : knag
5 ||Date Created By : 05-NOV-2003
6 ||Purpose:
7 ||Known limitations,enhancements,remarks:
8 ||Change History
9 ||Who When What
10 rbezawad 30-Oct-2004 Added check_security_exception procedure to verity if there is any Security Policy error
11 IGS_SC_POLICY_EXCEPTION or IGS_SC_POLICY_UPD_DEL_EXCEP is set in message stack w.r.t. bug fix 3919112.
12 ||-----------------------------------------------------------------------------------------------------------------------*/
13
14 -- Lookups
15 FUNCTION get_lookup (p_lookup_type IN VARCHAR2,
16 p_lookup_code IN VARCHAR2,
17 p_application_id IN NUMBER,
18 p_enabled_flag IN VARCHAR2 DEFAULT NULL)
19 RETURN VARCHAR2; -- Returns TRUE/FALSE
20
21 FUNCTION get_lkup_meaning (p_lookup_type IN VARCHAR2,
22 p_lookup_code IN VARCHAR2,
23 p_application_id IN NUMBER)
24 RETURN VARCHAR2; -- Returns meaning
25
26 TYPE g_lktype_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
27 g_hash_lookup_type_tab g_lktype_table;
28
29 TYPE g_lkcode_record IS RECORD (
30 lookup_code fnd_lookup_values.lookup_code%TYPE,
31 enabled_flag fnd_lookup_values.enabled_flag%TYPE,
32 meaning fnd_lookup_values.meaning%TYPE);
33 TYPE g_lkcode_table IS TABLE OF g_lkcode_record INDEX BY BINARY_INTEGER;
34 g_hash_lookup_code_tab g_lkcode_table;
35
36 -- Messages
37 FUNCTION is_err_msg (p_message_name IN VARCHAR2,
38 p_application_short_name IN VARCHAR2)
39 RETURN VARCHAR2; -- Returns TRUE/FALSE
40
41 TYPE g_msg_type_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
42 g_hash_msg_type_tab g_msg_type_table;
43
44 -- Import process source categories
45 FUNCTION chk_src_cat (p_source_type_id IN NUMBER,
46 p_category IN VARCHAR2)
47 RETURN BOOLEAN;
48
49 FUNCTION find_source_cat_rule (p_source_type_id IN NUMBER,
50 p_category IN VARCHAR2)
51 RETURN VARCHAR2 ;
52
53 FUNCTION get_srccat (p_source_type_id IN NUMBER,
54 p_category_name IN VARCHAR2,
55 p_include_ind IN VARCHAR2 DEFAULT NULL)
56 RETURN VARCHAR2; -- Returns TRUE/FALSE
57
58 FUNCTION get_srccat (p_source_type_id IN NUMBER,
59 p_category_name IN VARCHAR2,
60 p_include_ind IN VARCHAR2 DEFAULT NULL,
61 p_detail_level_ind IN OUT NOCOPY VARCHAR2,
62 p_discrepancy_rule_cd OUT NOCOPY VARCHAR2)
63 RETURN VARCHAR2; -- Returns TRUE/FALSE
64
65 TYPE g_stypeid_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
66 g_hash_stypeid_tab g_stypeid_table;
67
68 TYPE g_srccat_record IS RECORD (
69 category_name igs_ad_source_cat_all.category_name%TYPE,
70 include_ind igs_ad_source_cat_all.include_ind%TYPE,
71 detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE,
72 discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE);
73 TYPE g_srccat_table IS TABLE OF g_srccat_record INDEX BY BINARY_INTEGER;
74 g_hash_srccat_tab g_srccat_table;
75
76 -- Code Classes
77 FUNCTION get_codeclass (p_class IN VARCHAR2,
78 p_code_id IN NUMBER)
79 RETURN VARCHAR2; -- Returns TRUE/FALSE
80
81 FUNCTION get_codeclass (p_class IN VARCHAR2,
82 p_name IN VARCHAR2)
83 RETURN VARCHAR2; -- Returns TRUE/FALSE
84
85 FUNCTION get_codeclass (p_class IN VARCHAR2,
86 p_code_id IN OUT NOCOPY NUMBER,
87 p_name IN OUT NOCOPY VARCHAR2)
88 RETURN VARCHAR2; -- Returns TRUE/FALSE
89
90 FUNCTION get_def_code (p_class IN VARCHAR2,
91 p_code_id OUT NOCOPY NUMBER,
92 p_name OUT NOCOPY VARCHAR2,
93 p_system_status IN VARCHAR2)
94 RETURN VARCHAR2; -- Returns TRUE/FALSE
95
96 FUNCTION get_codeclass (p_class IN VARCHAR2,
97 p_code_id IN OUT NOCOPY NUMBER,
98 p_name IN OUT NOCOPY VARCHAR2,
99 p_system_status IN OUT NOCOPY VARCHAR2,
100 p_closed_ind IN VARCHAR2 DEFAULT NULL)
101 RETURN VARCHAR2; -- Returns TRUE/FALSE
102
103 TYPE g_cclass_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
104 g_hash_cclass_tab g_cclass_table;
105
106 TYPE g_ccodeid_hashidx_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
107 g_hash_name_cc_id_hashidx_tab g_ccodeid_hashidx_table;
108 g_hash_dflt_cc_id_hashidx_tab g_ccodeid_hashidx_table;
109
110 TYPE g_ccode_record IS RECORD (
111 code_id igs_ad_code_classes.code_id%TYPE,
112 name igs_ad_code_classes.name%TYPE,
113 system_status igs_ad_code_classes.system_status%TYPE,
114 closed_ind igs_ad_code_classes.closed_ind%TYPE,
115 system_default igs_ad_code_classes.system_default%TYPE);
116 TYPE g_ccode_table IS TABLE OF g_ccode_record INDEX BY BINARY_INTEGER;
117 g_hash_ccode_tab g_ccode_table;
118
119 -- Application Type to Admission Process Category
120 FUNCTION get_appl_type_apc (p_application_type IN VARCHAR2)
121 RETURN VARCHAR2; -- Returns TRUE/FALSE
122
123 FUNCTION get_appl_type_apc (p_application_type IN VARCHAR2,
124 p_admission_cat OUT NOCOPY VARCHAR2,
125 p_s_admission_process_type OUT NOCOPY VARCHAR2)
126 RETURN VARCHAR2; -- Returns TRUE/FALSE
127
128 TYPE g_appl_type_apc_record IS RECORD (
129 admission_cat igs_ad_prcs_cat_step_all.admission_cat%TYPE,
130 s_admission_process_type igs_ad_prcs_cat_step_all.s_admission_process_type%TYPE);
131 TYPE g_appl_type_apc_table IS TABLE OF g_appl_type_apc_record INDEX BY BINARY_INTEGER;
132 g_hash_appl_type_apc_tab g_appl_type_apc_table;
133
134 -- Admission Process Category Steps
135 FUNCTION get_apcs (p_admission_cat IN VARCHAR2,
136 p_s_admission_process_type IN VARCHAR2,
137 p_s_admission_step_type IN VARCHAR2)
138 RETURN VARCHAR2; -- Returns TRUE/FALSE
139
140 FUNCTION get_apcs_mnd (p_admission_cat IN VARCHAR2,
141 p_s_admission_process_type IN VARCHAR2,
142 p_s_admission_step_type IN VARCHAR2)
143 RETURN VARCHAR2; -- Returns TRUE/FALSE
144
145 FUNCTION get_apcs (p_admission_cat IN VARCHAR2,
146 p_s_admission_process_type IN VARCHAR2,
147 p_s_admission_step_type IN VARCHAR2,
148 p_mandatory_step_ind IN OUT NOCOPY VARCHAR2)
149 RETURN VARCHAR2; -- Returns TRUE/FALSE
150
151 FUNCTION get_apcs (p_admission_cat IN VARCHAR2,
152 p_s_admission_process_type IN VARCHAR2,
153 p_s_admission_step_type IN VARCHAR2,
154 p_mandatory_step_ind IN OUT NOCOPY VARCHAR2,
155 p_step_type_restriction_num OUT NOCOPY NUMBER)
156 RETURN VARCHAR2; -- Returns TRUE/FALSE
157
158 TYPE g_apc_record IS RECORD (
159 admission_cat igs_ad_prcs_cat_step_all.admission_cat%TYPE,
160 s_admission_process_type igs_ad_prcs_cat_step_all.s_admission_process_type%TYPE);
161 TYPE g_apc_table IS TABLE OF g_apc_record INDEX BY BINARY_INTEGER;
162 g_hash_apc_tab g_apc_table;
163
164 TYPE g_apcs_record IS RECORD (
165 s_admission_step_type igs_ad_prcs_cat_step_all.s_admission_step_type%TYPE,
166 mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE,
167 step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE);
168 TYPE g_apcs_table IS TABLE OF g_apcs_record INDEX BY BINARY_INTEGER;
169 g_hash_apcs_tab g_apcs_table;
170
171 -- Extract message from stack
172 PROCEDURE extract_msg_from_stack (p_msg_at_index NUMBER,
173 p_return_status OUT NOCOPY VARCHAR2,
174 p_msg_count OUT NOCOPY NUMBER,
175 p_msg_data OUT NOCOPY VARCHAR2,
176 p_hash_msg_name_text_type_tab OUT NOCOPY igs_ad_gen_016.g_msg_name_text_type_table);
177
178 TYPE g_msg_name_text_type_record IS RECORD (
179 appl fnd_application.application_short_name%TYPE,
180 type VARCHAR2(1),
181 name fnd_new_messages.message_name%TYPE,
182 text fnd_new_messages.message_text%TYPE);
183 TYPE g_msg_name_text_type_table IS TABLE OF g_msg_name_text_type_record INDEX BY BINARY_INTEGER;
184
185 PROCEDURE check_security_exception;
186
187 END igs_ad_gen_016;