[Home] [Help]
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 ;