PACKAGE: APPS.HZ_DSS_SETUP_PUB

Source

1 PACKAGE HZ_DSS_SETUP_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARHPDSTS.pls 115.4 2002/11/21 20:51:53 sponnamb noship $ */
3 
4 --------------------------------------
5 -- declaration of record type
6 --------------------------------------
7 
8 TYPE dss_entity_profile_type IS RECORD (
9     entity_id			hz_dss_entities.entity_id%TYPE,
10     object_id			hz_dss_entities.object_id%TYPE,
11     instance_set_id		hz_dss_entities.instance_set_id%TYPE,
12     parent_entity_id		hz_dss_entities.parent_entity_id%TYPE,
13     status		        hz_dss_entities.status%TYPE DEFAULT 'A',
14     parent_fk_column1		hz_dss_entities.parent_fk_column1%TYPE,
15     parent_fk_column2		hz_dss_entities.parent_fk_column2%TYPE,
16     parent_fk_column3		hz_dss_entities.parent_fk_column3%TYPE,
17     parent_fk_column4		hz_dss_entities.parent_fk_column4%TYPE,
18     parent_fk_column5		hz_dss_entities.parent_fk_column5%TYPE,
19     group_assignment_level	hz_dss_entities.group_assignment_level%TYPE
20 
21 );
22 
23 TYPE dss_scheme_function_type IS RECORD (
24     security_scheme_code hz_dss_scheme_functions.security_scheme_code%TYPE,
25     data_operation_code  hz_dss_scheme_functions.data_operation_code%TYPE,
26     function_id          hz_dss_scheme_functions.function_id%TYPE,
27     status               hz_dss_scheme_functions.status%TYPE  DEFAULT 'A'
28 );
29 
30 --------------------------------------
31 --------------------------------------
32 -- declaration of procedures
33 --------------------------------------
34 --------------------------------------
35 
36 
37 -------------------------------------
38 -- CREATE_ENTITY_PROFILE - Signature
39 -------------------------------------
40 
41 PROCEDURE create_entity_profile (
42 -- input parameters
43     p_init_msg_list		IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
44     p_dss_entity_profile	IN  dss_entity_profile_type,
45 -- output parameters
46     x_entity_id			OUT NOCOPY NUMBER,
47     x_return_status		OUT NOCOPY VARCHAR2,
48     x_msg_count			OUT NOCOPY NUMBER,
49     x_msg_data			OUT NOCOPY VARCHAR2
50 );
51 
52 
53 -------------------------------------
54 -- UPDATE_ENTITY_PROFILE - Signature
55 -------------------------------------
56 PROCEDURE update_entity_profile (
57 -- input parameters
58   p_init_msg_list		IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
59   p_dss_entity_profile		IN  dss_entity_profile_type,
60 -- in/out parameters
61   x_object_version_number	IN OUT NOCOPY NUMBER,
62 -- output parameters
63   x_return_status		OUT NOCOPY VARCHAR2,
64   x_msg_count			OUT NOCOPY NUMBER,
65   x_msg_data			OUT NOCOPY VARCHAR2
66 );
67 
68 
69 
70 -------------------------------------
71 -- CREATE_SCHEME_FUNCTION - Signature
72 -------------------------------------
73 
74 PROCEDURE create_scheme_function (
75 -- input parameters
76     p_init_msg_list			IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
77     p_dss_scheme_function		IN  dss_scheme_function_type,
78 -- output parameters
79     x_return_status			OUT NOCOPY VARCHAR2,
80     x_msg_count				OUT NOCOPY NUMBER,
81     x_msg_data				OUT NOCOPY VARCHAR2
82 );
83 
84 
85 -------------------------------------
86 -- UPDATE_SCHEME_FUNCTION - Signature
87 -------------------------------------
88 
89 PROCEDURE update_scheme_function (
90 -- input parameters
91   p_init_msg_list          IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
92   p_dss_scheme_function    IN  dss_scheme_function_type,
93 -- in/out parameters
94   x_object_version_number  IN OUT NOCOPY NUMBER,
95 -- output parameters
96   x_return_status          OUT NOCOPY VARCHAR2,
97   x_msg_count              OUT NOCOPY NUMBER,
98   x_msg_data               OUT NOCOPY VARCHAR2
99 );
100 
101 
102 
103 END HZ_DSS_SETUP_PUB ;