[Home] [Help]
PACKAGE: APPS.IBC_LABELS_GRP
Source
1 PACKAGE Ibc_Labels_GRP AUTHID CURRENT_USER AS
2 /* $Header: ibcglabs.pls 115.2 2002/11/13 23:45:39 vicho ship $ */
3
4 -- Purpose: API to Populate Content Type.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- vicho 11/08/2002 Removed Default GMiss in Type Record
11
12
13 -- Package name : Ibc_Labels_GRP
14 -- Purpose :
15 -- History :
16 -- NOTE :
17 -- End of Comments
18
19
20 TYPE Label_Rec_Type IS RECORD(
21 Label_CODE VARCHAR2(100),
22 Label_NAME VARCHAR2(240),
23 CREATED_BY NUMBER,
24 CREATION_DATE DATE,
25 DESCRIPTION VARCHAR2(2000),
26 LAST_UPDATED_BY NUMBER,
27 LAST_UPDATE_DATE DATE,
28 LAST_UPDATE_LOGIN NUMBER,
29 OBJECT_VERSION_NUMBER NUMBER);
30
31 G_MISS_Label_REC Label_Rec_Type;
32
33 TYPE Label_Tbl_Type IS TABLE OF Label_Rec_Type
34 INDEX BY BINARY_INTEGER;
35
36 G_MISS_Label_Tbl Label_Tbl_Type;
37
38
39 -- *******************************************************
40 -- Start of Comments
41 -- *******************************************************
42 -- API Name: Create_Labels
43 -- Type : Group
44 -- Pre-Req :
45 -- Parameters:
46 -- IN
47 -- p_api_version_number IN NUMBER Required
48 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
49 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
50 -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
51 -- P_Label_Tbl IN Label_Tbl_Type Required
52 --
53 -- OUT:
54 -- x_return_status OUT VARCHAR2
55 -- x_msg_count OUT NUMBER
56 -- x_msg_data OUT VARCHAR2
57 --
58 -- End of Comments
59 --
60 PROCEDURE Create_Labels(
61 P_Api_Version_Number IN NUMBER,
62 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
63 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
64 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
66 x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
67 X_Return_Status OUT NOCOPY VARCHAR2,
68 X_Msg_Count OUT NOCOPY NUMBER,
69 X_Msg_Data OUT NOCOPY VARCHAR2
70 );
71
72
73
74 -- *******************************************************
75 -- Start of Comments
76 -- *******************************************************
77 -- API Name: Update_Labels
78 -- Type : Group
79 -- Pre-Req :
80 -- Parameters:
81 -- IN
82 -- p_api_version_number IN NUMBER Required
83 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- P_Label_Tbl IN Label_Tbl_Type Required
86 --
87 -- OUT:
88 -- x_return_status OUT VARCHAR2
89 -- x_msg_count OUT NUMBER
90 -- x_msg_data OUT VARCHAR2
91 --
92 -- End of Comments
93 --
94
95
96 PROCEDURE Update_Labels(
97 P_Api_Version_Number IN NUMBER,
98 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
100 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101 P_Label_Tbl IN Ibc_Labels_GRP.Label_Tbl_Type := Ibc_Labels_GRP.G_Miss_Label_Tbl,
102 x_Label_Tbl OUT NOCOPY Ibc_Labels_GRP.Label_Tbl_Type,
103 X_Return_Status OUT NOCOPY VARCHAR2,
104 X_Msg_Count OUT NOCOPY NUMBER,
105 X_Msg_Data OUT NOCOPY VARCHAR2
106 );
107
108 -- *******************************************************
109 -- Start of Comments
110 -- *******************************************************
111 -- API Name: Delete_Label
112 -- Type : Group
113 -- Pre-Req :
114 -- Parameters:
115 -- IN
116 -- p_api_version_number IN NUMBER Required
117 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119 -- P_Label_Code IN VARCHAR2 Required
120 --
121 -- OUT:
122 -- x_return_status OUT VARCHAR2
123 -- x_msg_count OUT NUMBER
124 -- x_msg_data OUT VARCHAR2
125 --
126 -- End of Comments
127 --
128
129 PROCEDURE delete_Label(
130 P_Api_Version_Number IN NUMBER,
131 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 P_Label_Code IN VARCHAR2,
135 X_Return_Status OUT NOCOPY VARCHAR2,
136 X_Msg_Count OUT NOCOPY NUMBER,
137 X_Msg_Data OUT NOCOPY VARCHAR2
138 );
139
140 END Ibc_Labels_GRP;