PACKAGE: APPS.HXC_RESOURCE_RULES_UTILS

Source

1 Package hxc_resource_rules_utils AUTHID CURRENT_USER as
2 /* $Header: hxchrrutl.pkh 115.5 2004/01/12 06:27:04 avramach noship $ */
3 
4 g_scl_num_of_segs NUMBER(2) := NULL;
5 g_scl_delimiter   varchar2(1) := NULL;
6 g_scl_id_flex_num NUMBER(15) := NULL;
7 
8 g_people_num_of_segs NUMBER(2) := NULL;
9 g_people_delimiter   varchar2(1) := NULL;
10 g_people_id_flex_num NUMBER(15) := NULL;
11 
12 g_grade_num_of_segs NUMBER(2) := NULL;
13 g_grade_delimiter   varchar2(1) := NULL;
14 g_grade_id_flex_num NUMBER(15) := NULL;
15 
16 
17 TYPE r_flex_valid IS RECORD (
18      segment1 varchar2(60),
19      segment2 varchar2(60),
20      segment3 varchar2(60),
21      segment4 varchar2(60),
22      segment5 varchar2(60),
23      segment6 varchar2(60),
24      segment7 varchar2(60),
25      segment8 varchar2(60),
26      segment9 varchar2(60),
27      segment10 varchar2(60),
28      segment11 varchar2(60),
29      segment12 varchar2(60),
30      segment13 varchar2(60),
31      segment14 varchar2(60),
32      segment15 varchar2(60),
33      segment16 varchar2(60),
34      segment17 varchar2(60),
35      segment18 varchar2(60),
36      segment19 varchar2(60),
37      segment20 varchar2(60),
38      segment21 varchar2(60),
39      segment22 varchar2(60),
40      segment23 varchar2(60),
41      segment24 varchar2(60),
42      segment25 varchar2(60),
43      segment26 varchar2(60),
44      segment27 varchar2(60),
45      segment28 varchar2(60),
46      segment29 varchar2(60),
47      segment30 varchar2(60)
48     );
49 
50 TYPE t_flex_valid IS TABLE OF r_flex_valid INDEX BY BINARY_INTEGER;
51 
52 g_flex_valid_scl_ct t_flex_valid;
53 g_flex_valid_people_ct t_flex_valid;
54 g_flex_valid_grade_ct t_flex_valid;
55 
56 PROCEDURE get_value_set_sql ( 	p_flex_Field_name 	varchar2
57 			,	p_legislation_code	varchar2 );
58 
59 FUNCTION get_sequence ( p_type varchar2
60 		,	p_id_flex_num number default null ) RETURN NUMBER;
61 
62 FUNCTION get_meaning (  p_type  VARCHAR2
63 		,	p_value VARCHAR2
64 		,	p_business_group_id NUMBER default null
65 		,	p_legislation_code  VARCHAR2 ) RETURN VARCHAR2;
66 
67 FUNCTION get_criteria_meaning ( p_type varchar2
68 			,	p_business_group_id number ) RETURN VARCHAR2;
69 
70 FUNCTION chk_flex_valid ( p_type	VARCHAR2
71 		,	 p_flex_id	NUMBER
72 		,	 p_segment	VARCHAR2
73 		,	 p_value	VARCHAR2 ) RETURN NUMBER;
74 
75 -- Bug 3322725
76 FUNCTION chk_criteria_exists ( p_eligibility_criteria_type VARCHAR2,
77 			       p_eligibility_criteria_id VARCHAR2) RETURN BOOLEAN;
78 
79 END hxc_resource_rules_utils;