DBA Data[Home] [Help]

APPS.MTL_CATEGORY_SETS_PKG dependencies on FND_API

Line 204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

200: -- ----------------------------------------------------------------------
201:
202: procedure UPDATE_ROW (
203: X_CATEGORY_SET_ID IN NUMBER,
204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

201:
202: procedure UPDATE_ROW (
203: X_CATEGORY_SET_ID IN NUMBER,
204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,

Line 206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

202: procedure UPDATE_ROW (
203: X_CATEGORY_SET_ID IN NUMBER,
204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
210: X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,

Line 207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

203: X_CATEGORY_SET_ID IN NUMBER,
204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
210: X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
211: X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,

Line 208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

204: X_CATEGORY_SET_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: X_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: X_STRUCTURE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
207: X_VALIDATE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: X_MULT_ITEM_CAT_ASSIGN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
210: X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
211: X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
212: X_HIERARCHY_ENABLED IN VARCHAR2 DEFAULT NULL,

Line 213: X_CONTROL_LEVEL IN NUMBER DEFAULT FND_API.G_MISS_NUM,

209: X_CONTROL_LEVEL_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
210: X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
211: X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
212: X_HIERARCHY_ENABLED IN VARCHAR2 DEFAULT NULL,
213: X_CONTROL_LEVEL IN NUMBER DEFAULT FND_API.G_MISS_NUM,
214: X_DEFAULT_CATEGORY_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
215: X_LAST_UPDATE_DATE IN DATE,
216: X_LAST_UPDATED_BY IN NUMBER,
217: X_LAST_UPDATE_LOGIN IN NUMBER

Line 214: X_DEFAULT_CATEGORY_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

210: X_MULT_ITEM_CAT_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
211: X_VALIDATE_FLAG_UPDT_FLAG IN VARCHAR2 DEFAULT NULL,
212: X_HIERARCHY_ENABLED IN VARCHAR2 DEFAULT NULL,
213: X_CONTROL_LEVEL IN NUMBER DEFAULT FND_API.G_MISS_NUM,
214: X_DEFAULT_CATEGORY_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
215: X_LAST_UPDATE_DATE IN DATE,
216: X_LAST_UPDATED_BY IN NUMBER,
217: X_LAST_UPDATE_LOGIN IN NUMBER
218:

Line 220: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

216: X_LAST_UPDATED_BY IN NUMBER,
217: X_LAST_UPDATE_LOGIN IN NUMBER
218:
219: ) IS
220: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
221: l_miss_num NUMBER := FND_API.G_MISS_NUM;
222: BEGIN
223:
224: update MTL_CATEGORY_SETS_B set

Line 221: l_miss_num NUMBER := FND_API.G_MISS_NUM;

217: X_LAST_UPDATE_LOGIN IN NUMBER
218:
219: ) IS
220: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
221: l_miss_num NUMBER := FND_API.G_MISS_NUM;
222: BEGIN
223:
224: update MTL_CATEGORY_SETS_B set
225: STRUCTURE_ID = DECODE(X_STRUCTURE_ID,l_miss_num,STRUCTURE_ID,X_STRUCTURE_ID),