DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALUE_PUB dependencies on PV_ENTY_ATTR_VALUE_PVT

Line 58: l_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

54: x_enty_attr_val_id NUMBER;
55: x_object_version_number NUMBER;
56: l_attr_val_tbl attr_value_tbl_type := p_attr_val_tbl;
57: l_attr_val_rec attr_val_rec_type := g_miss_attr_val_rec;
58: l_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
59: l_version NUMBER := FND_API.G_MISS_NUM;
60:
61: l_decimal_pts NUMBER;
62: l_attribute_type VARCHAR2(30);

Line 73: l_lead_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

69: l_lov_string VARCHAR2(2000);
70: l_meaning VARCHAR2(80);
71: l_lead_record_exists VARCHAR2(1) := 'N';
72: l_index NUMBER :=0 ;
73: l_lead_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
74: l_curr_row1 NUMBER;
75: type cur_type IS REF CURSOR;
76: lc_lov_cursor cur_type;
77: l_lov_values_table JTF_VARCHAR2_TABLE_100;

Line 273: PV_Enty_Attr_Value_PVT.Delete_attr_value(

269: cv_entity_id => p_entity_id,
270: cv_entity => p_entity
271: )
272: loop
273: PV_Enty_Attr_Value_PVT.Delete_attr_value(
274:
275: p_api_version_number => p_api_version_number
276: ,p_init_msg_list => p_init_msg_list
277: ,p_commit => p_commit

Line 308: PV_Enty_Attr_Value_PVT.Delete_attr_value(

304: cv_entity_id => p_entity_id,
305: cv_entity => p_entity
306: )
307: loop
308: PV_Enty_Attr_Value_PVT.Delete_attr_value(
309:
310: p_api_version_number => p_api_version_number
311: ,p_init_msg_list => p_init_msg_list
312: ,p_commit => p_commit

Line 334: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

330: l_attr_val_rec := l_attr_val_tbl(l_curr_row);
331:
332:
333: --initialise it to null
334: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
335:
336: --initialising standard columns in the record
337: --initialising in parameters to record fields
338: l_lead_enty_attr_val_rec.entity := p_entity;

Line 346: PV_Enty_Attr_Value_PVT.Create_attr_value(

342: l_lead_enty_attr_val_rec.enabled_flag := 'Y';
343: l_lead_enty_attr_val_rec.entity_id := p_entity_id;
344:
345:
346: PV_Enty_Attr_Value_PVT.Create_attr_value(
347:
348: p_api_version_number => p_api_version_number
349: ,p_init_msg_list => p_init_msg_list
350: ,p_commit => p_commit

Line 379: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

375: l_attr_val_rec := l_attr_val_tbl(l_curr_row);
376:
377:
378: --initialise it to null
379: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
380:
381: --initialising standard columns in the record
382: --initialising in parameters to record fields
383: l_lead_enty_attr_val_rec.entity := p_entity;

Line 398: PV_Enty_Attr_Value_PVT.Create_attr_value(

394:
395:
396:
397:
398: PV_Enty_Attr_Value_PVT.Create_attr_value(
399:
400: p_api_version_number => p_api_version_number
401: ,p_init_msg_list => p_init_msg_list
402: ,p_commit => p_commit

Line 563: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

559: loop
560: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
561: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Updating loop');
562: END IF;
563: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
564:
565: --get all values from table and assign it to record and call update_attr_value of pv_enty_attr_value_pvt
566: l_enty_attr_val_rec.enty_attr_val_id := x.enty_attr_val_id;
567: l_enty_attr_val_rec.object_version_number := x.object_version_number;

Line 565: --get all values from table and assign it to record and call update_attr_value of pv_enty_attr_value_pvt

561: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Updating loop');
562: END IF;
563: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
564:
565: --get all values from table and assign it to record and call update_attr_value of pv_enty_attr_value_pvt
566: l_enty_attr_val_rec.enty_attr_val_id := x.enty_attr_val_id;
567: l_enty_attr_val_rec.object_version_number := x.object_version_number;
568: l_enty_attr_val_rec.entity := x.entity;
569: l_enty_attr_val_rec.attribute_id := x.attribute_id;

Line 584: PV_Enty_Attr_Value_PVT.Update_Attr_Value(

580:
581: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
582: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - before calling pvt update method');
583: END IF;
584: PV_Enty_Attr_Value_PVT.Update_Attr_Value(
585:
586: p_api_version_number => p_api_version_number
587: ,p_init_msg_list => p_init_msg_list
588: ,p_commit => p_commit

Line 980: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

976:
977: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
978: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Value Table Null or Zero length');
979: END IF;
980: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
981:
982: --initialising standard columns in the record
983: --l_enty_attr_val_rec.enty_attr_val_id := l_enty_attr_val_id;
984: /*l_enty_attr_val_rec.last_update_date := SYSDATE;

Line 1010: PV_Enty_Attr_Value_PVT.Create_Attr_Value(

1006:
1007:
1008:
1009: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value
1010: PV_Enty_Attr_Value_PVT.Create_Attr_Value(
1011: p_api_version_number => p_api_version_number
1012: ,p_init_msg_list => p_init_msg_list
1013: ,p_commit => p_commit
1014: ,p_validation_level => p_validation_level

Line 1082: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;

1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1079: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' VAlue Table Not Null ');
1080: END IF;
1081: --initialise it to null
1082: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
1083:
1084: --initialising standard columns in the record
1085: --l_enty_attr_val_rec.enty_attr_val_id := l_enty_attr_val_id;
1086: l_enty_attr_val_rec.last_update_date := SYSDATE;

Line 1112: PV_Enty_Attr_Value_PVT.Create_Attr_Value(

1108:
1109: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - after ');
1110:
1111: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value
1112: PV_Enty_Attr_Value_PVT.Create_Attr_Value(
1113: p_api_version_number => p_api_version_number
1114: ,p_init_msg_list => p_init_msg_list
1115: ,p_commit => p_commit
1116: ,p_validation_level => p_validation_level