1 PACKAGE JTF_DisplayContext_GRP AUTHID CURRENT_USER AS
2 /* $Header: JTFGCTXS.pls 115.11 2004/07/09 18:49:33 applrt ship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30):='JTF_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 Default_deliverable_id NUMBER
17 );
18
19 TYPE display_context_tbl_type IS TABLE OF
20 display_context_rec_type INDEX BY BINARY_INTEGER;
21
22 PROCEDURE save_display_context(
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25 p_commit IN VARCHAR2 := FND_API.g_false,
26 x_return_status OUT VARCHAR2,
27 x_msg_count OUT NUMBER,
28 x_msg_data OUT VARCHAR2,
29 p_display_context_rec IN OUT DISPLAY_CONTEXT_REC_TYPE
30 );
31
32 PROCEDURE save_delete_display_context(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
35 p_commit IN VARCHAR2 := FND_API.g_false,
36 x_return_status OUT VARCHAR2,
37 x_msg_count OUT NUMBER,
38 x_msg_data OUT VARCHAR2,
39 p_display_context_tbl IN OUT DISPLAY_CONTEXT_TBL_TYPE
40 );
41 PROCEDURE delete_display_context(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
44 p_commit IN VARCHAR2 := FND_API.g_false,
45 x_return_status OUT VARCHAR2,
46 x_msg_count OUT NUMBER,
47 x_msg_data OUT VARCHAR2,
48 p_display_context_rec IN OUT DISPLAY_CONTEXT_REC_TYPE
49 );
50
51 PROCEDURE delete_deliverable(
52 p_deliverable_id IN NUMBER
53 );
54
55 procedure INSERT_ROW (
56 X_ROWID in out VARCHAR2,
57 X_CONTEXT_ID in NUMBER,
58 X_SECURITY_GROUP_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
71 procedure LOCK_ROW (
72 X_CONTEXT_ID in NUMBER,
73 X_SECURITY_GROUP_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_SECURITY_GROUP_ID in NUMBER,
85 X_OBJECT_VERSION_NUMBER in NUMBER,
86 X_ACCESS_NAME in VARCHAR2,
87 X_CONTEXT_TYPE_CODE in VARCHAR2,
88 X_ITEM_ID in NUMBER,
89 X_NAME in VARCHAR2,
90 X_DESCRIPTION in VARCHAR2,
91 X_LAST_UPDATE_DATE in DATE,
92 X_LAST_UPDATED_BY in NUMBER,
93 X_LAST_UPDATE_LOGIN in NUMBER
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
106 procedure LOAD_ROW (
107 X_CONTEXT_ID in NUMBER,
108 X_SECURITY_GROUP_ID in NUMBER,
109 X_OWNER in VARCHAR2,
110 X_OBJECT_VERSION_NUMBER in NUMBER,
111 X_ACCESS_NAME in VARCHAR2,
112 X_CONTEXT_TYPE_CODE in VARCHAR2,
113 X_ITEM_ID in NUMBER,
114 X_NAME in VARCHAR2,
115 X_DESCRIPTION in VARCHAR2);
116
117 PROCEDURE add_language;
118
119 END JTF_DisplayContext_GRP;
[Home] [Help]