[Home] [Help]
PACKAGE: APPS.HXC_LOAD_PKG
Source
1 PACKAGE hxc_load_pkg AUTHID CURRENT_USER AS
2 /* $Header: hxcload.pkh 120.0 2005/05/29 04:36:49 appldev noship $ */
3
4 g_package varchar2(33) := ' hxc_load_pkg.'; -- Global package name
5
6 FUNCTION get_pref_def_name ( p_pref_definition_id NUMBER ) RETURN VARCHAR2;
7 FUNCTION chk_tc_ref_integrity ( p_time_category_id NUMBER ) RETURN BOOLEAN ;
8
9 FUNCTION get_attribute ( p_attribute_category VARCHAR2
10 , p_attribute VARCHAR2
11 , p_attribute_name IN VARCHAR2 DEFAULT null
12 ) RETURN VARCHAR2 ;
13
14 FUNCTION get_parent ( p_pref_top_node VARCHAR2
15 , p_pref_node VARCHAR2
16 , p_pref_level NUMBER
17 , p_count NUMBER ) RETURN VARCHAR2 ;
18
19 FUNCTION get_value_set_sql
20 (p_flex_value_set_id IN NUMBER,
21 p_session_date IN DATE ) RETURN LONG;
22
23 FUNCTION get_flex_value ( p_flex_value_set_id NUMBER
24 , p_id VARCHAR2 ) RETURN VARCHAR2;
25 PROCEDURE upgrade_custom_tcs ( p_time_category_id NUMBER ) ;
26
27 CURSOR csr_chk_ref_integ ( p_time_category_id NUMBER ) IS
28 SELECT DISTINCT ter.time_entry_rule_id
29 , dfcu.application_column_name
30 FROM fnd_descr_flex_column_usages dfcu
31 , hxc_time_entry_rules ter
32 WHERE ter.formula_id IS NOT NULL
33 AND
34 dfcu.application_id = 809 AND
35 dfcu.descriptive_flex_context_code = ter.attribute_category AND
36 UPPER(dfcu.end_user_column_name) like 'TIME_CATEGORY%'
37 AND
38 DECODE ( dfcu.application_column_name,
39 'ATTRIBUTE1', ter.attribute1,
40 'ATTRIBUTE2', ter.attribute2,
41 'ATTRIBUTE3', ter.attribute3,
42 'ATTRIBUTE4', ter.attribute4,
43 'ATTRIBUTE5', ter.attribute5,
44 'ATTRIBUTE6', ter.attribute6,
45 'ATTRIBUTE7', ter.attribute7,
46 'ATTRIBUTE8', ter.attribute8,
47 'ATTRIBUTE9', ter.attribute9,
48 'ATTRIBUTE10', ter.attribute10,
49 'ATTRIBUTE11', ter.attribute11,
50 'ATTRIBUTE12', ter.attribute12,
51 'ATTRIBUTE13', ter.attribute13,
52 'ATTRIBUTE14', ter.attribute14,
53 'ATTRIBUTE15', ter.attribute15,
54 'ATTRIBUTE16', ter.attribute16,
55 'ATTRIBUTE17', ter.attribute17,
56 'ATTRIBUTE18', ter.attribute18,
57 'ATTRIBUTE19', ter.attribute19,
58 'ATTRIBUTE20', ter.attribute20,
59 'ATTRIBUTE21', ter.attribute21,
60 'ATTRIBUTE22', ter.attribute22,
61 'ATTRIBUTE23', ter.attribute23,
62 'ATTRIBUTE24', ter.attribute24,
63 'ATTRIBUTE25', ter.attribute25,
64 'ATTRIBUTE26', ter.attribute26,
65 'ATTRIBUTE27', ter.attribute27,
66 'ATTRIBUTE28', ter.attribute28,
67 'ATTRIBUTE29', ter.attribute29,
68 'ATTRIBUTE30', ter.attribute30, 'zZz' ) = TO_CHAR(p_time_category_id);
69
70
71
72 TYPE r_ter_record IS RECORD ( ter_id hxc_time_entry_rules.time_entry_rule_id%TYPE
73 ,attribute varchar2(20) );
74
75 TYPE t_ter_table IS TABLE OF r_ter_record INDEX BY BINARY_INTEGER;
76 FUNCTION get_tc_ref_integrity_list ( p_time_category_id NUMBER ) RETURN t_ter_table;
77
78 Procedure get_node_data
79 (
80 p_preference_full_name in varchar2
81 ,p_name in varchar2
82 ,p_business_group_id in number
83 ,p_legislation_code in varchar2
84 ,p_mode out nocopy varchar2
85 ,p_pref_hierarchy_id out nocopy number
86 ,p_parent_pref_hierarchy_id out nocopy number
87 ,p_object_version_number out nocopy number
88 ) ;
89
90
91 FUNCTION get_ter_attributes(p_formula_id IN NUMBER,
92 p_attribute_name IN VARCHAR2,
93 p_attrubute_val IN VARCHAR2
94 )
95 RETURN VARCHAR2;
96
97 FUNCTION get_id_set_sql
98 (p_flex_value_set_id IN NUMBER,
99 p_session_date IN DATE ) RETURN LONG;
100
101 FUNCTION get_ter_attribute_id(p_formula_name IN VARCHAR2,
102 p_attribute_name IN VARCHAR2,
103 p_attrubute_val IN VARCHAR2
104 )
105 RETURN VARCHAR2;
106
107 PROCEDURE set_dynamic_sql_string ( p_time_category_id NUMBER );
108
109 END hxc_load_pkg;
110
111
112