APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on JTF_PLSQL_API

Line 778: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

774:
775: -- Check_Resrc_Require_UK_Items
776: PROCEDURE Check_Resrc_Require_UK_Items (
777: p_resrc_Require_rec IN Resrc_Require_Rec_Type,
778: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
779: x_return_status OUT NOCOPY VARCHAR2
780: )
781: IS
782: l_valid_flag VARCHAR2(1);

Line 798: IF p_validation_mode = Jtf_Plsql_Api.g_create AND (p_resrc_Require_rec.OPERATION_RESOURCE_ID IS NULL OR p_resrc_Require_rec.OPERATION_RESOURCE_ID = FND_API.g_miss_num) THEN

794: Ahl_Debug_Pub.debug( ' OPERATION_RESOURCE_ID -->' ||p_resrc_Require_rec.OPERATION_RESOURCE_ID);
795: Ahl_Debug_Pub.debug( ' WORKORDER_OPERATION_ID -->' ||p_resrc_Require_rec.WORKORDER_OPERATION_ID);
796: END IF;
797:
798: IF p_validation_mode = Jtf_Plsql_Api.g_create AND (p_resrc_Require_rec.OPERATION_RESOURCE_ID IS NULL OR p_resrc_Require_rec.OPERATION_RESOURCE_ID = FND_API.g_miss_num) THEN
799: Ahl_Debug_Pub.debug( 'For create l_valid_flag -->' || l_valid_flag);
800: Ahl_Debug_Pub.debug( 'QUERY -->' || 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
801: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID);
802:

Line 847: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

843: --
844: ---------------------------------------------------------------------
845: PROCEDURE Check_Resrc_Require_Items (
846: p_resrc_Require_rec IN Resrc_Require_Rec_Type,
847: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
848: x_return_status OUT NOCOPY VARCHAR2
849: )
850: IS
851: BEGIN

Line 939: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

935: IF G_DEBUG='Y' THEN
936: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
937: END IF;
938:
939: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
940: Check_Resrc_Require_Items (
941: p_resrc_Require_rec => p_resrc_Require_rec,
942: p_validation_mode => Jtf_Plsql_Api.g_create,
943: x_return_status => l_return_status

Line 942: p_validation_mode => Jtf_Plsql_Api.g_create,

938:
939: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
940: Check_Resrc_Require_Items (
941: p_resrc_Require_rec => p_resrc_Require_rec,
942: p_validation_mode => Jtf_Plsql_Api.g_create,
943: x_return_status => l_return_status
944: );
945:
946: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN