APPS.PV_ATTRIBUTE_USAGE_PVT dependencies on JTF_PLSQL_API

Line 139: ,p_validation_mode => JTF_PLSQL_API.g_create

135: Validate_attribute_usage(
136: p_api_version_number => 1.0
137: ,p_init_msg_list => FND_API.G_FALSE
138: ,p_validation_level => p_validation_level
139: ,p_validation_mode => JTF_PLSQL_API.g_create
140: ,p_attribute_usage_rec => l_attribute_usage_rec
141: ,x_return_status => x_return_status
142: ,x_msg_count => x_msg_count
143: ,x_msg_data => x_msg_data

Line 367: ,p_validation_mode => JTF_PLSQL_API.g_update

363: Validate_attribute_usage(
364: p_api_version_number => 1.0
365: ,p_init_msg_list => FND_API.G_FALSE
366: ,p_validation_level => p_validation_level
367: ,p_validation_mode => JTF_PLSQL_API.g_update
368: ,p_attribute_usage_rec => p_attribute_usage_rec
369: ,x_return_status => x_return_status
370: ,x_msg_count => x_msg_count
371: ,x_msg_data => x_msg_data

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

717:
718:
719: PROCEDURE check_uk_items(
720: p_attribute_usage_rec IN attribute_usage_rec_type
721: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
722: ,x_return_status OUT NOCOPY VARCHAR2)
723: IS
724: l_valid_flag VARCHAR2(1);
725:

Line 728: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

724: l_valid_flag VARCHAR2(1);
725:
726: BEGIN
727: x_return_status := FND_API.g_ret_sts_success;
728: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
729: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
730: 'PV_ATTRIBUTE_USAGES',
731: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||''''
732: );

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

752: END check_uk_items;
753:
754: PROCEDURE check_req_items(
755: p_attribute_usage_rec IN attribute_usage_rec_type
756: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
757: ,x_return_status OUT NOCOPY VARCHAR2
758: )
759: IS
760: BEGIN

Line 763: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

759: IS
760: BEGIN
761: x_return_status := FND_API.g_ret_sts_success;
762: --DBMS_OUTPUT.PUT_LINE('p_validation_mode = '||p_validation_mode);
763: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
764:
765: --DBMS_OUTPUT.PUT_LINE('BEfore calling attribute_usage_id');
766: --DBMS_OUTPUT.PUT_LINE('p_attribute_usage_rec.attribute_usage_id = '||
767: -- TO_CHAR(p_attribute_usage_rec.attribute_usage_id));

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

1184: PROCEDURE Validate_Attribute_Usage(
1185: p_api_version_number IN NUMBER
1186: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1188: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1189: ,p_attribute_usage_rec IN attribute_usage_rec_type
1190: ,x_return_status OUT NOCOPY VARCHAR2
1191: ,x_msg_count OUT NOCOPY NUMBER
1192: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1219: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1215: IF FND_API.to_Boolean( p_init_msg_list )
1216: THEN
1217: FND_MSG_PUB.initialize;
1218: END IF;
1219: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1220: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_Attr_Usage_Items' );
1221: Check_Attr_Usage_Items(
1222: p_attribute_usage_rec => p_attribute_usage_rec
1223: ,p_validation_mode => p_validation_mode

Line 1239: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1235: p_attribute_usage_rec => p_attribute_usage_rec
1236: ,x_complete_rec => l_attribute_usage_rec
1237: );
1238:
1239: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1240: Validate_Attr_Usage_Rec(
1241: p_api_version_number => 1.0
1242: ,p_init_msg_list => FND_API.G_FALSE
1243: ,x_return_status => x_return_status

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

1322: ,x_return_status OUT NOCOPY VARCHAR2
1323: ,x_msg_count OUT NOCOPY NUMBER
1324: ,x_msg_data OUT NOCOPY VARCHAR2
1325: ,p_attribute_usage_rec IN attribute_usage_rec_type
1326: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
1327: )
1328: IS
1329: BEGIN
1330: -- Initialize message list if p_init_msg_list is set to TRUE.