PACKAGE: APPS.HZ_DSS_UTIL_PUB

Source

1 PACKAGE HZ_DSS_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARHPDSUS.pls 120.5 2005/10/30 04:21:58 appldev noship $ */
3 
4  TYPE dss_group_rec IS RECORD (
5        dss_group_code   VARCHAR2(30) ,
6        entity_id        NUMBER
7   );
8 
9   TYPE dss_group_tbl_type IS TABLE of dss_group_rec INDEX BY BINARY_INTEGER;
10 
11   FUNCTION test_instance (
12      p_operation_code     IN    VARCHAR2,
13      p_db_object_name     IN    VARCHAR2,
14      p_instance_pk1_value IN    VARCHAR2,
15      p_instance_pk2_value IN    VARCHAR2 DEFAULT NULL,
16      p_instance_pk3_value IN    VARCHAR2 DEFAULT NULL,
17      p_instance_pk4_value IN    VARCHAR2 DEFAULT NULL,
18      p_instance_pk5_value IN    VARCHAR2 DEFAULT NULL,
19      p_user_name          IN    VARCHAR2 DEFAULT NULL,
20      x_return_status      OUT NOCOPY VARCHAR2,
21      x_msg_count          OUT NOCOPY NUMBER,
22      x_msg_data           OUT NOCOPY VARCHAR2,
23      p_init_msg_list      IN    VARCHAR2 DEFAULT NULL
24      ) RETURN VARCHAR2;
25 
26    PROCEDURE get_granted_groups (
27      p_user_name         IN    VARCHAR2,
28      p_operation_code    IN    VARCHAR2,
29      x_granted_groups    OUT NOCOPY   dss_group_tbl_type,
30      x_return_status     OUT NOCOPY VARCHAR2,
31      x_msg_count         OUT NOCOPY NUMBER,
32      x_msg_data          OUT NOCOPY VARCHAR2);
33 
34  FUNCTION determine_dss_group(
35    p_db_object_name     IN VARCHAR2,
36    p_object_pk1         IN VARCHAR2,
37    p_object_pk2         IN VARCHAR2  DEFAULT NULL,
38    p_object_pk3         IN VARCHAR2  DEFAULT NULL,
39    p_object_pk4         IN VARCHAR2  DEFAULT NULL,
40    p_object_pk5         IN VARCHAR2  DEFAULT NULL,
41    p_root_db_object_name IN VARCHAR2 DEFAULT NULL,
42    p_root_object_pk1     IN VARCHAR2 DEFAULT NULL,
43    p_root_object_pk2     IN VARCHAR2 DEFAULT NULL,
44    p_root_object_pk3     IN VARCHAR2 DEFAULT NULL,
45    p_root_object_pk4     IN VARCHAR2 DEFAULT NULL,
46    p_root_object_pk5     IN VARCHAR2 DEFAULT NULL
47    ) RETURN VARCHAR2 ;
48 
49   PROCEDURE  assign_dss_group(
50    p_db_object_name      IN VARCHAR2,
51    p_object_pk1          IN VARCHAR2,
52    p_object_pk2          IN VARCHAR2,
53    p_object_pk3          IN VARCHAR2,
54    p_object_pk4          IN VARCHAR2,
55    p_object_pk5          IN VARCHAR2,
56    p_root_db_object_name IN VARCHAR2,
57    p_root_object_pk1     IN VARCHAR2,
58    p_root_object_pk2     IN VARCHAR2,
59    p_root_object_pk3     IN VARCHAR2,
60    p_root_object_pk4     IN VARCHAR2,
61    p_root_object_pk5     IN VARCHAR2,
62    p_process_subentities_flag IN VARCHAR2);
63 
64 
65 
66 PROCEDURE switch_context (p_user_name IN VARCHAR2,
67                            x_return_status    OUT NOCOPY VARCHAR2,
68                            x_msg_count        OUT NOCOPY NUMBER,
69                            x_msg_data         OUT NOCOPY VARCHAR2);
70 
71 
72  PROCEDURE generate_predicate(
73    p_dss_group_code     IN VARCHAR2,
74    p_entity_id          IN NUMBER,
75    x_predicate          OUT NOCOPY VARCHAR2,
76    x_return_status      OUT NOCOPY VARCHAR2,
77    x_msg_count          OUT NOCOPY NUMBER,
78    x_msg_data           OUT NOCOPY VARCHAR2);
79 
80 
81 /**
82  * FUNCTION
83  *          get_display_name
84  *
85  * DESCRIPTION
86  *          return the display name of an object or an object instance set.
87  *
88  *
89  * SCOPE - PUBLIC
90  *
91  * EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
92  *
93  * ARGUMENTS  : IN:
94  *                 p_object_name           object name
95  *                 p_object_instance_name  object instance name
96  *
97  * RETURNS    : NONE
98  *
99  * NOTES
100  *
101  * MODIFICATION HISTORY -
102  *
103  */
104 
105 FUNCTION get_display_name (
106     p_object_name                 IN     VARCHAR2,
107     p_object_instance_name        IN     VARCHAR2
108 ) RETURN VARCHAR2;
109 PRAGMA RESTRICT_REFERENCES(get_display_name, WNDS, WNPS);
110 
111 END HZ_DSS_UTIL_PUB;