APPS.PV_ATTRIBUTE_PKG dependencies on PV_ATTRIBUTES_B

Line 81: INSERT INTO PV_ATTRIBUTES_B(

77:
78: px_object_version_number := 1;
79:
80:
81: INSERT INTO PV_ATTRIBUTES_B(
82: attribute_id,
83: last_update_date,
84: last_updated_by,
85: creation_date,

Line 226: Update PV_ATTRIBUTES_B

222: )
223:
224: IS
225: BEGIN
226: Update PV_ATTRIBUTES_B
227: SET
228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 314: from PV_ATTRIBUTES_B

310: IS
311:
312: cursor c_updated_by is
313: select last_updated_by, display_style, attribute_category
314: from PV_ATTRIBUTES_B
315: where attribute_id = p_ATTRIBUTE_ID;
316:
317: l_last_updated_by number;
318:

Line 340: Update PV_ATTRIBUTES_B

336:
337:
338: if( l_last_updated_by = 1) then
339:
340: Update PV_ATTRIBUTES_B
341: SET
342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 392: Update PV_ATTRIBUTES_B

388: END IF;
389:
390: else
391:
392: Update PV_ATTRIBUTES_B
393: SET
394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 429: Update PV_ATTRIBUTES_B

425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: if(l_display_style is null or l_display_style = '') then
429: Update PV_ATTRIBUTES_B
430: SET
431: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style)
432: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
433: end if;

Line 436: Update PV_ATTRIBUTES_B

432: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
433: end if;
434:
435: if(l_attribute_category is null or l_attribute_category = '') then
436: Update PV_ATTRIBUTES_B
437: SET
438: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category)
439: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
440: end if;

Line 484: DELETE FROM PV_ATTRIBUTES_B

480: PROCEDURE Delete_Row(
481: p_ATTRIBUTE_ID NUMBER)
482: IS
483: BEGIN
484: DELETE FROM PV_ATTRIBUTES_B
485: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
486:
487: If (SQL%NOTFOUND) then
488: RAISE NO_DATA_FOUND;

Line 557: FROM PV_ATTRIBUTES_B

553:
554: IS
555: CURSOR C IS
556: SELECT *
557: FROM PV_ATTRIBUTES_B
558: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
559: FOR UPDATE of ATTRIBUTE_ID NOWAIT;
560: Recinfo C%ROWTYPE;
561: BEGIN

Line 676: from PV_ATTRIBUTES_B B

672: begin
673: delete from PV_ATTRIBUTES_TL T
674: where not exists
675: (select NULL
676: from PV_ATTRIBUTES_B B
677: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
678: );
679:
680: update PV_ATTRIBUTES_TL T set (

Line 800: from PV_ATTRIBUTES_B

796: l_attribute_id number;
797:
798: cursor c_obj_verno is
799: select object_version_number
800: from PV_ATTRIBUTES_B
801: where attribute_id = p_ATTRIBUTE_ID;
802:
803: cursor c_chk_attrib_exists is
804: select 'x'

Line 805: from PV_ATTRIBUTES_B

801: where attribute_id = p_ATTRIBUTE_ID;
802:
803: cursor c_chk_attrib_exists is
804: select 'x'
805: from PV_ATTRIBUTES_B
806: where attribute_id = p_ATTRIBUTE_ID;
807:
808: BEGIN
809: