1 Package hxc_public_temp_group_comp_api AUTHID CURRENT_USER as
2 /* $Header: hxcptgapi.pkh 120.1 2005/10/04 05:41:45 sechandr noship $ */
3
4
5 -- --------------------------------------------------------------
6 -- |-------------<Insert Of Public Template Group>---------------|
7 -- --------------------------------------------------------------
8 PROCEDURE get_entity_group_id(
9 p_name IN VARCHAR2
10 ,p_entity_type IN VARCHAR2
11 ,p_entity_group_id OUT NOCOPY NUMBER
12 ,p_description IN VARCHAR2
13 ,p_business_group_id IN NUMBER
14 ,p_legislation_code IN VARCHAR2
15 );
16
17 -- --------------------------------------------------------------
18 -- |-------------<Insert Of Public Template Group Comps>---------|
19 -- --------------------------------------------------------------
20
21 PROCEDURE insert_public_temp_grp_comp(
22 p_entity_group_id IN NUMBER
23 ,p_entity_id IN NUMBER
24 ,p_attribute1 IN VARCHAR2
25 ,p_attribute_category IN VARCHAR2
26 );
27
28
29 -- --------------------------------------------------------------
30 -- |-------------<Delete Of Public Template Group >-------------|
31 -- --------------------------------------------------------------
32
33 PROCEDURE del_entity_group_rec(
34 p_entity_group_id IN NUMBER,
35 p_business_group_id IN NUMBER,
36 p_attached_pref_name OUT NOCOPY VARCHAR2
37 );
38
39
40
41 -- --------------------------------------------------------------
42 -- |-------------<Delete Of Public Template Group Comps>--------|
43 -- --------------------------------------------------------------
44
45 PROCEDURE del_entity_group_comp_rec(
46 p_entity_group_id IN NUMBER
47 ,p_entity_id IN VARCHAR2
48 );
49
50
51 -- --------------------------------------------------------------
52 -- |------------<Update Of Public Template Group Comps>---------|
53 -- --------------------------------------------------------------
54
55 PROCEDURE update_public_temp_grp_comp(
56 p_entity_group_id IN NUMBER
57 ,p_entity_id IN HXC_TEMPLATE_ID_TABLE
58 );
59
60
61
62 -- --------------------------------------------------------------
63 -- |-------------<Update Of Public Template Group >-------------|
64 -- --------------------------------------------------------------
65
66 PROCEDURE update_entity_group_rec(
67 p_entity_group_id IN OUT NOCOPY NUMBER
68 ,p_name IN VARCHAR2
69 ,p_description IN VARCHAR2
70 );
71
72
73 -- --------------------------------------------------------------
74 -- |----------<Create API Of Public Template Group Comp >-------|
75 -- --------------------------------------------------------------
76
77 PROCEDURE create_public_temp_grp_comp(
78 p_entity_group_id IN NUMBER
79 ,p_entity_id IN HXC_TEMPLATE_ID_TABLE
80 );
81
82
83 -- --------------------------------------------------------------------
84 -- |----------<List of Preferences in which group is attached >-------|
85 -- --------------------------------------------------------------------
86
87 FUNCTION public_temp_group_list(
88 p_public_template_group_id IN NUMBER,
89 p_business_group_id IN NUMBER
90 )
91 RETURN VARCHAR2;
92
93 -- ----------------------------------------------------------------------------------
94 -- |----------< Checks whether deletion of public template is allowed >-------|
95 -- ----------------------------------------------------------------------------------
96
97 FUNCTION can_delete_public_template (p_template_id in hxc_time_building_blocks.time_building_block_id%type
98 ) RETURN VARCHAR2;
99
100 END hxc_public_temp_group_comp_api;