[Home] [Help]
PACKAGE: APPS.MTL_CATEGORY_SETS_PKG
Source
1 package MTL_CATEGORY_SETS_PKG as
2 /* $Header: INVICSHS.pls 120.3 2006/06/05 12:06:46 lparihar ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_CATEGORY_SET_ID in NUMBER,
7 X_CATEGORY_SET_NAME in VARCHAR2,
8 X_DESCRIPTION in VARCHAR2,
9 X_STRUCTURE_ID in NUMBER,
10 X_VALIDATE_FLAG in VARCHAR2,
11 X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2,
12 X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
13 X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
14 X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
15 X_HIERARCHY_ENABLED IN VARCHAR2 DEFAULT NULL,
16 X_CONTROL_LEVEL in NUMBER,
17 X_DEFAULT_CATEGORY_ID in NUMBER,
18 X_LAST_UPDATE_DATE in DATE,
19 X_LAST_UPDATED_BY in NUMBER,
20 X_CREATION_DATE in DATE,
21 X_CREATED_BY in NUMBER,
22 X_LAST_UPDATE_LOGIN in NUMBER
23 -- X_REQUEST_ID in NUMBER,
24 );
25
26 procedure LOCK_ROW (
27 X_CATEGORY_SET_ID in NUMBER,
28 X_CATEGORY_SET_NAME in VARCHAR2,
29 X_DESCRIPTION in VARCHAR2,
30 X_STRUCTURE_ID in NUMBER,
31 X_VALIDATE_FLAG in VARCHAR2,
32 X_MULT_ITEM_CAT_ASSIGN_FLAG in VARCHAR2,
33 X_CONTROL_LEVEL in NUMBER,
34 X_DEFAULT_CATEGORY_ID in NUMBER
35 -- X_REQUEST_ID in NUMBER,
36 );
37
38 procedure UPDATE_ROW (
39 X_CATEGORY_SET_ID IN NUMBER,
40 X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
41 X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
42 X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43 X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44 X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45 X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
46 X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
47 X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
48 X_HIERARCHY_ENABLED IN VARCHAR2 DEFAULT NULL,
49 X_CONTROL_LEVEL IN NUMBER DEFAULT FND_API.G_MISS_NUM,
50 X_DEFAULT_CATEGORY_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51 X_LAST_UPDATE_DATE IN DATE,
52 X_LAST_UPDATED_BY IN NUMBER,
53 X_LAST_UPDATE_LOGIN IN NUMBER
54
55 );
56
57 procedure DELETE_ROW (
58 X_CATEGORY_SET_ID in NUMBER
59 );
60
61 procedure ADD_LANGUAGE;
62
63
64 -- ----------------------------------------------------------------------
65 -- PROCEDURE: Translate_Row
66 --
67 -- PARAMETERS:
68 -- x_<developer key>
69 -- x_<translated columns>
70 -- x_owner user owning the row (SEED or other)
71 --
72 -- COMMENT:
73 -- Called from the FNDLOAD config file in 'NLS' mode to upload
74 -- translations.
75 -- ----------------------------------------------------------------------
76
77 PROCEDURE Translate_Row
78 (
79 x_category_set_id IN NUMBER
80 , x_category_set_name IN VARCHAR2
81 , x_description IN VARCHAR2
82 , x_owner IN VARCHAR2
83 , x_custom_mode IN VARCHAR2
84 , x_lud IN DATE DEFAULT SYSDATE
85 );
86
87 -- ----------------------------------------------------------------------
88 -- PROCEDURE: Load_Row
89 --
90 -- PARAMETERS:
91 -- x_<developer key>
92 -- x_<table_data>
93 -- x_owner user owning the row (SEED or other)
94 --
95 -- COMMENT:
96 -- Called from the FNDLOAD config file in 'MLS' mode to upload a
97 -- multi-lingual entity.
98 -- ----------------------------------------------------------------------
99
100 PROCEDURE Load_Row
101 (
102 x_category_set_id IN NUMBER
103 , x_category_set_name IN VARCHAR2
104 , x_description IN VARCHAR2
105 , X_STRUCTURE_ID IN NUMBER
106 , X_VALIDATE_FLAG IN VARCHAR2
107 , X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2
108 , X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2
109 , X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2
110 , X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2
111 , X_HIERARCHY_ENABLED IN VARCHAR2
112 , X_CONTROL_LEVEL IN NUMBER
113 , X_DEFAULT_CATEGORY_ID IN NUMBER
114 , x_owner IN VARCHAR2
115 , x_custom_mode IN VARCHAR2
116 , x_msg_name OUT NOCOPY VARCHAR2
117 , x_lud IN DATE DEFAULT SYSDATE
118 );
119
120 -- ----------------------------------------------------------------------
121 -- PROCEDURE: Load_Row
122 --
123 --
124 -- COMMENT:
125 -- Overloaded procedure
126 -- ----------------------------------------------------------------------
127 PROCEDURE Load_Row
128 (
129 X_CATEGORY_SET_ID IN NUMBER
130 , X_CATEGORY_SET_NAME IN VARCHAR2
131 , X_DESCRIPTION IN VARCHAR2
132 , X_STRUCTURE_CODE IN VARCHAR2
133 , X_VALIDATE_FLAG IN VARCHAR2
134 , X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2
135 , X_CONTROL_LEVEL IN NUMBER
136 , X_DEFAULT_CATEGORY_CD IN VARCHAR2
137 , X_OWNER IN VARCHAR2
138 , X_LAST_UPDATE_DATE IN VARCHAR2
139 , X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2
140 , X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2
141 , X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2
142 , X_HIERARCHY_ENABLED IN VARCHAR2
143 );
144
145 end MTL_CATEGORY_SETS_PKG;