APPS.PV_ATTRIBUTE_CODE_PKG dependencies on PV_ATTRIBUTE_CODES_B

Line 60: INSERT INTO PV_ATTRIBUTE_CODES_B(

56:
57: px_object_version_number := 1;
58:
59:
60: INSERT INTO PV_ATTRIBUTE_CODES_B(
61: attr_code_id,
62: attr_code,
63: last_update_date,
64: last_updated_by,

Line 152: Update PV_ATTRIBUTE_CODES_B

148: p_description VARCHAR2 )
149:
150: IS
151: BEGIN
152: Update PV_ATTRIBUTE_CODES_B
153: SET
154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 229: from PV_ATTRIBUTE_CODES_B

225: IS
226:
227: cursor c_updated_by is
228: select last_updated_by
229: from PV_ATTRIBUTE_CODES_B
230: WHERE attr_code_id = p_ATTR_CODE_ID;
231:
232: l_last_updated_by number;
233:

Line 248: Update PV_ATTRIBUTE_CODES_B

244: -- Else we will update enabled_flag and description
245:
246: if( l_last_updated_by = 1) then
247:
248: Update PV_ATTRIBUTE_CODES_B
249: SET
250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 292: Update PV_ATTRIBUTE_CODES_B

288:
289: ELSE
290:
291:
292: Update PV_ATTRIBUTE_CODES_B
293: SET
294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 359: DELETE FROM PV_ATTRIBUTE_CODES_B

355: PROCEDURE Delete_Row(
356: p_ATTR_CODE_ID NUMBER)
357: IS
358: BEGIN
359: DELETE FROM PV_ATTRIBUTE_CODES_B
360: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID;
361: If (SQL%NOTFOUND) then
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;

Line 407: FROM PV_ATTRIBUTE_CODES_B

403:
404: IS
405: CURSOR C IS
406: SELECT *
407: FROM PV_ATTRIBUTE_CODES_B
408: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
409: FOR UPDATE of ATTR_CODE_ID NOWAIT;
410: Recinfo C%ROWTYPE;
411:

Line 488: from PV_ATTRIBUTE_CODES_B B

484: begin
485: delete from PV_ATTRIBUTE_CODES_TL T
486: where not exists
487: (select NULL
488: from PV_ATTRIBUTE_CODES_B B
489: where B.ATTR_CODE_ID = T.ATTR_CODE_ID
490: );
491:
492: update PV_ATTRIBUTE_CODES_TL T set (

Line 581: from PV_ATTRIBUTE_CODES_B

577: l_attr_code_id number := p_ATTR_CODE_ID;
578:
579: cursor c_obj_verno is
580: select object_version_number
581: from PV_ATTRIBUTE_CODES_B
582: where attr_code_id = p_ATTR_CODE_ID;
583:
584: cursor c_chk_attrib_exists is
585: select 'x'

Line 586: from PV_ATTRIBUTE_CODES_B

582: where attr_code_id = p_ATTR_CODE_ID;
583:
584: cursor c_chk_attrib_exists is
585: select 'x'
586: from PV_ATTRIBUTE_CODES_B
587: where attr_code_id = p_ATTR_CODE_ID;
588:
589: BEGIN
590: