APPS.PV_ENTY_ATTR_VALUE_PVT dependencies on JTF_PLSQL_API

Line 166: ,p_validation_mode => JTF_PLSQL_API.g_create

162: Validate_attr_value(
163: p_api_version_number => 1.0
164: ,p_init_msg_list => FND_API.G_FALSE
165: ,p_validation_level => p_validation_level
166: ,p_validation_mode => JTF_PLSQL_API.g_create
167: ,p_enty_attr_val_rec => l_enty_attr_val_rec
168: ,x_return_status => x_return_status
169: ,x_msg_count => x_msg_count
170: ,x_msg_data => x_msg_data

Line 458: ,p_validation_mode => JTF_PLSQL_API.g_update

454: Validate_attr_value(
455: p_api_version_number => 1.0
456: ,p_init_msg_list => FND_API.G_FALSE
457: ,p_validation_level => p_validation_level
458: ,p_validation_mode => JTF_PLSQL_API.g_update
459: ,p_enty_attr_val_rec => p_enty_attr_val_rec
460: ,x_return_status => x_return_status
461: ,x_msg_count => x_msg_count
462: ,x_msg_data => x_msg_data

Line 808: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

804:
805:
806: PROCEDURE check_uk_items(
807: p_enty_attr_val_rec IN enty_attr_val_rec_type
808: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
809: ,x_return_status OUT NOCOPY VARCHAR2)
810: IS
811: l_valid_flag VARCHAR2(1);
812:

Line 818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

814:
815: --DBMS_OUTPUT.PUT_LINE ('entering check_uk_items');
816:
817: x_return_status := FND_API.g_ret_sts_success;
818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
819: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
820: 'PV_ENTY_ATTR_VALUES'
821: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||''''
822: );

Line 848: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

844: END check_uk_items;
845:
846: PROCEDURE check_req_items(
847: p_enty_attr_val_rec IN enty_attr_val_rec_type
848: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
849: ,x_return_status OUT NOCOPY VARCHAR2
850: )
851: IS
852: BEGIN

Line 855: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

851: IS
852: BEGIN
853: x_return_status := FND_API.g_ret_sts_success;
854: --DBMS_OUTPUT.PUT_LINE('check_req_items::p_validation_mode = '||p_validation_mode);
855: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
856:
857: --DBMS_OUTPUT.PUT_LINE('Before calling enty_attr_val_id');
858: --DBMS_OUTPUT.PUT_LINE('p_enty_attr_val_rec.enty_attr_val_id = '||
859: -- TO_CHAR(p_enty_attr_val_rec.enty_attr_val_id));

Line 1395: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE

1391: PROCEDURE Validate_attr_value(
1392: p_api_version_number IN NUMBER
1393: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1394: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1395: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1396: ,p_enty_attr_val_rec IN enty_attr_val_rec_type
1397: ,x_return_status OUT NOCOPY VARCHAR2
1398: ,x_msg_count OUT NOCOPY NUMBER
1399: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1427: IF FND_API.to_Boolean( p_init_msg_list )
1428: THEN
1429: FND_MSG_PUB.initialize;
1430: END IF;
1431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1432:
1433: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_attr_value_Items' );
1434:
1435: Check_attr_value_Items(

Line 1456: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1452: p_enty_attr_val_rec => p_enty_attr_val_rec
1453: ,x_complete_rec => l_pv_enty_attr_val_rec
1454: );
1455:
1456: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1457: Validate_attr_val_rec(
1458: p_api_version_number => 1.0
1459: ,p_init_msg_list => FND_API.G_FALSE
1460: ,x_return_status => x_return_status

Line 1539: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE

1535: ,x_return_status OUT NOCOPY VARCHAR2
1536: ,x_msg_count OUT NOCOPY NUMBER
1537: ,x_msg_data OUT NOCOPY VARCHAR2
1538: ,p_enty_attr_val_rec IN enty_attr_val_rec_type
1539: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1540: )
1541: IS
1542: BEGIN
1543: -- Initialize message list if p_init_msg_list is set to TRUE.