DBA Data[Home] [Help]

APPS.JTF_PERZ_LF_PVT dependencies on JTF_PERZ_LF_PUB

Line 112: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

108: -- p_active_flag IN VARCHAR2 Optional
109:
110: -- p_object_type_id IN NUMBER Optional
111: -- p_object_type IN VARCHAR2 Optional
112: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
113: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
114: --
115: -- OUT :
116: -- x_object_id OUT NUMBER

Line 113: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional

109:
110: -- p_object_type_id IN NUMBER Optional
111: -- p_object_type IN VARCHAR2 Optional
112: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
113: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
114: --
115: -- OUT :
116: -- x_object_id OUT NUMBER
117: -- x_return_status OUT VARCHAR2(1)

Line 148: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

144:
145: p_object_type_id IN NUMBER,
146: p_object_type IN VARCHAR2 := NULL,
147:
148: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
149: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
150:
151: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
152: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 149: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

145: p_object_type_id IN NUMBER,
146: p_object_type IN VARCHAR2 := NULL,
147:
148: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
149: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
150:
151: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
152: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
153: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 184: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

180: -- p_object_type_id IN NUMBER Optional
181: -- p_object_type IN VARCHAR2 Required
182: -- p_active_flag IN VARCHAR2 Optional
183: -- Default = NO
184: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
185: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
186: -- p_commit IN VARCHAR2 Optional
187: --
188: -- OUT :

Line 185: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional

181: -- p_object_type IN VARCHAR2 Required
182: -- p_active_flag IN VARCHAR2 Optional
183: -- Default = NO
184: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
185: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
186: -- p_commit IN VARCHAR2 Optional
187: --
188: -- OUT :
189: -- x_object_id OUT NUMBER

Line 223: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

219: p_object_name IN VARCHAR2,
220: p_object_description IN VARCHAR2,
221:
222: p_active_flag IN VARCHAR2,
223: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
224: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
225:
226: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
227: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 224: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

220: p_object_description IN VARCHAR2,
221:
222: p_active_flag IN VARCHAR2,
223: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
224: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
225:
226: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
227: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 259: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

255:
256: -- p_object_type_id IN NUMBER Optional
257: -- p_object_type IN VARCHAR2 Optional
258:
259: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
260: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL
261:
262: -- OUT :
263: -- x_object_id OUT NUMBER

Line 260: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL

256: -- p_object_type_id IN NUMBER Optional
257: -- p_object_type IN VARCHAR2 Optional
258:
259: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
260: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL
261:
262: -- OUT :
263: -- x_object_id OUT NUMBER
264: -- x_return_status OUT VARCHAR2(1)

Line 294: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

290:
291: p_object_type_id IN NUMBER,
292: p_object_type IN VARCHAR2,
293:
294: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
295: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
296:
297: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
298: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 295: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

291: p_object_type_id IN NUMBER,
292: p_object_type IN VARCHAR2,
293:
294: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
295: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
296:
297: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
298: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
299: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 328: -- x_Object_Tbl OUT JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,

324: -- p_get_children_flag IN VARCHAR2 Optional
325: --
326: -- OUT :
327: -- x_object_id OUT NUMBER Optional
328: -- x_Object_Tbl OUT JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
329: -- x_return_status OUT VARCHAR2(1)
330: -- x_msg_count OUT NUMBER
331: -- x_msg_data OUT VARCHAR2(2000)
332: --

Line 354: x_Object_Tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,

350: P_Object_Id IN NUMBER,
351: p_Object_Name IN VARCHAR,
352: p_obj_active_flag IN VARCHAR2,
353: p_get_children_flag IN VARCHAR2,
354: x_Object_Tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
355: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
356: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
357: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
358: );

Line 383: -- x_attrib_rec_tbl OUT JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

379:
380: -- OUT :
381: -- x_object_type_id OUT NUMBER
382: -- x_object_type_desc OUT VARCHAR,
383: -- x_attrib_rec_tbl OUT JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
384: -- x_return_status OUT VARCHAR2(1)
385: -- x_msg_count OUT NUMBER
386: -- x_msg_data OUT VARCHAR2(2000)
387: --

Line 407: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,

403:
404: x_Object_type_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
405: x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
406:
407: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,
408: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
409: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
410: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
411: );

Line 434: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required

430: -- p_object_type_id IN NUMBER Optional
431: -- p_object_type IN VARCHAR2 Optional
432: -- p_object_type_desc IN VARCHAR2 Optional
433:
434: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required
435: --
436: -- OUT :
437: -- x_object_type_id OUT NUMBER
438: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE

Line 438: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE

434: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required
435: --
436: -- OUT :
437: -- x_object_type_id OUT NUMBER
438: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE
439: -- x_return_status OUT VARCHAR2
440: -- x_msg_count OUT NUMBER
441: -- x_msg_data OUT VARCHAR2(2000)
442: --

Line 460: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

456: p_object_type_id IN NUMBER,
457: p_object_type IN VARCHAR2,
458: p_object_type_desc IN VARCHAR2,
459:
460: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
461: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,
462:
463: x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
464: x_obj_type_map_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE,

Line 461: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,

457: p_object_type IN VARCHAR2,
458: p_object_type_desc IN VARCHAR2,
459:
460: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
461: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,
462:
463: x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
464: x_obj_type_map_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE,
465: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,