DBA Data[Home] [Help]

PACKAGE: APPS.IBE_DISPLAYCONTEXT_GRP

Source


1 PACKAGE IBE_DisplayContext_GRP AUTHID CURRENT_USER AS
2   /* $Header: IBEGCTXS.pls 120.1 2005/06/10 03:47:06 appldev  $ */
3 
4 g_pkg_name   CONSTANT VARCHAR2(30):='IBE_DisplayContext_GRP';
5 g_api_version CONSTANT NUMBER       := 1.0;
6 
7 
8 TYPE display_context_rec_type  IS RECORD (
9   Context_delete          VARCHAR2(1),
10   Object_Version_Number   NUMBER,
11   Context_id              NUMBER,
12   Access_name             VARCHAR2(40),
13   Display_name            VARCHAR2(80),
14   Description             VARCHAR2(240),
15   Context_type            VARCHAR2(30),
16   Component_type_code     VARCHAR2(30),
17   Default_deliverable_id  NUMBER
18                                          );
19 
20 TYPE display_context_tbl_type  IS TABLE OF
21   display_context_rec_type INDEX BY BINARY_INTEGER;
22 
23 PROCEDURE save_display_context(
24                                p_api_version           IN  NUMBER,
25                                p_init_msg_list    IN   VARCHAR2 := FND_API.g_false,
26   p_commit                IN  VARCHAR2  := FND_API.g_false,
27   x_return_status          OUT NOCOPY VARCHAR2,
28   x_msg_count           OUT NOCOPY  NUMBER,
29   x_msg_data            OUT NOCOPY  VARCHAR2,
30   p_display_context_rec   IN OUT NOCOPY DISPLAY_CONTEXT_REC_TYPE
31                               );
32 
33 PROCEDURE save_delete_display_context(
34                                       p_api_version         IN  NUMBER,
35                                       p_init_msg_list       IN   VARCHAR2 := FND_API.g_false,
36   p_commit              IN  VARCHAR2  := FND_API.g_false,
37   x_return_status       OUT NOCOPY VARCHAR2,
38   x_msg_count           OUT NOCOPY  NUMBER,
39   x_msg_data            OUT NOCOPY  VARCHAR2,
40   p_display_context_tbl IN OUT NOCOPY DISPLAY_CONTEXT_TBL_TYPE
41                                      );
42 PROCEDURE delete_display_context(
43                                  p_api_version         IN  NUMBER,
44                                  p_init_msg_list       IN  VARCHAR2 := FND_API.g_false,
45   p_commit              IN  VARCHAR2 := FND_API.g_false,
46   x_return_status       OUT NOCOPY VARCHAR2,
47   x_msg_count           OUT NOCOPY  NUMBER,
48   x_msg_data            OUT NOCOPY  VARCHAR2,
49   p_display_context_rec IN OUT NOCOPY DISPLAY_CONTEXT_REC_TYPE
50                                 );
51 
52 PROCEDURE delete_deliverable(
53                              p_deliverable_id      IN  NUMBER
54                             );
55 
56 procedure INSERT_ROW (
57                       X_ROWID                   in out NOCOPY   VARCHAR2,
58                       X_CONTEXT_ID                      in      NUMBER,
59                       X_OBJECT_VERSION_NUMBER   in      NUMBER,
60                       X_ACCESS_NAME             in      VARCHAR2,
61                       X_CONTEXT_TYPE_CODE               in      VARCHAR2,
62                       X_ITEM_ID                         in      NUMBER,
63                       X_NAME                    in      VARCHAR2,
64                       X_DESCRIPTION             in      VARCHAR2,
65                       X_CREATION_DATE           in      DATE,
66                       X_CREATED_BY                      in      NUMBER,
67                       X_LAST_UPDATE_DATE                in      DATE,
68                       X_LAST_UPDATED_BY                 in      NUMBER,
69                       X_LAST_UPDATE_LOGIN               in      NUMBER,
70                                   X_COMPONENT_TYPE_CODE in VARCHAR2 DEFAULT NULL);
71 
72 procedure LOCK_ROW (
73                     X_CONTEXT_ID                        in      NUMBER,
74                     X_OBJECT_VERSION_NUMBER     in      NUMBER,
75                     X_ACCESS_NAME               in      VARCHAR2,
76                     X_CONTEXT_TYPE_CODE                 in      VARCHAR2,
77                     X_ITEM_ID                   in      NUMBER,
78                     X_NAME                      in      VARCHAR2,
79                     X_DESCRIPTION               in      VARCHAR2
80                    );
81 
82 procedure UPDATE_ROW (
83                       X_CONTEXT_ID              in      NUMBER,
84                       X_OBJECT_VERSION_NUMBER   in      NUMBER,
85                       X_ACCESS_NAME             in      VARCHAR2,
86                       X_CONTEXT_TYPE_CODE       in      VARCHAR2,
87                       X_ITEM_ID                 in      NUMBER,
88                       X_NAME                    in      VARCHAR2,
89                       X_DESCRIPTION             in      VARCHAR2,
90                       X_LAST_UPDATE_DATE        in      DATE,
91                       X_LAST_UPDATED_BY         in      NUMBER,
92                       X_LAST_UPDATE_LOGIN       in      NUMBER,
93                       X_COMPONENT_TYPE_CODE     in      VARCHAR2 DEFAULT NULL
94                      );
95 
96 procedure DELETE_ROW (
97                       X_CONTEXT_ID in NUMBER
98                      );
99 
100 procedure TRANSLATE_ROW (
101                          X_CONTEXT_ID           in      NUMBER,
102                          X_OWNER                in      VARCHAR2,
103                          X_NAME                 in      VARCHAR2,
104                          X_DESCRIPTION          in      VARCHAR2,
105                          X_LAST_UPDATE_DATE     in      VARCHAR2,
106                          X_CUSTOM_MODE          in      VARCHAR2);
107 
108 procedure LOAD_ROW (
109                     X_CONTEXT_ID                in      NUMBER,
110                     X_OWNER                     in      VARCHAR2,
111                     X_OBJECT_VERSION_NUMBER     in      NUMBER,
112                     X_ACCESS_NAME               in      VARCHAR2,
113                     X_CONTEXT_TYPE_CODE         in      VARCHAR2,
114                     X_ITEM_ID                   in      NUMBER,
115                     X_NAME                      in      VARCHAR2,
116                     X_DESCRIPTION               in      VARCHAR2,
117                     X_LAST_UPDATE_DATE          in      VARCHAR2,
118                     X_CUSTOM_MODE               in      VARCHAR2,
119                     X_COMPONENT_TYPE_CODE       in      VARCHAR2 DEFAULT NULL);
120 
121 Procedure LOAD_SEED_ROW(
122                         X_CONTEXT_ID                  in VARCHAR2,
123                         X_OWNER                       in VARCHAR2,
124                         X_OBJECT_VERSION_NUMBER       in VARCHAR2,
125                         X_ACCESS_NAME                 in VARCHAR2,
126                         X_CONTEXT_TYPE_CODE           in VARCHAR2,
127                         X_ITEM_ID                     in VARCHAR2,
128                         X_NAME                        in VARCHAR2,
129                         X_DESCRIPTION                 in VARCHAR2,
130                         X_COMPONENT_TYPE_CODE         in VARCHAR2,
131                         X_LAST_UPDATE_DATE            in VARCHAR2,
132                         X_CUSTOM_MODE                 in VARCHAR2,
133                         X_UPLOAD_MODE                 in VARCHAR2);
134 
135 PROCEDURE add_language;
136 
137 END IBE_DisplayContext_GRP;