APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on JTF_PLSQL_API

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

761:
762: -- Check_Resrc_Require_UK_Items
763: PROCEDURE Check_Resrc_Require_UK_Items (
764: p_resrc_Require_rec IN Resrc_Require_Rec_Type,
765: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
766: x_return_status OUT NOCOPY VARCHAR2
767: )
768: IS
769: l_valid_flag VARCHAR2(1);

Line 785: 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

781: Ahl_Debug_Pub.debug( ' OPERATION_RESOURCE_ID -->' ||p_resrc_Require_rec.OPERATION_RESOURCE_ID);
782: Ahl_Debug_Pub.debug( ' WORKORDER_OPERATION_ID -->' ||p_resrc_Require_rec.WORKORDER_OPERATION_ID);
783: END IF;
784:
785: 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
786: Ahl_Debug_Pub.debug( 'For create l_valid_flag -->' || l_valid_flag);
787: Ahl_Debug_Pub.debug( 'QUERY -->' || 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
788: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID);
789:

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

830: --
831: ---------------------------------------------------------------------
832: PROCEDURE Check_Resrc_Require_Items (
833: p_resrc_Require_rec IN Resrc_Require_Rec_Type,
834: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
835: x_return_status OUT NOCOPY VARCHAR2
836: )
837: IS
838: BEGIN

Line 926: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

922: IF G_DEBUG='Y' THEN
923: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
924: END IF;
925:
926: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
927: Check_Resrc_Require_Items (
928: p_resrc_Require_rec => p_resrc_Require_rec,
929: p_validation_mode => Jtf_Plsql_Api.g_create,
930: x_return_status => l_return_status

Line 929: p_validation_mode => Jtf_Plsql_Api.g_create,

925:
926: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
927: Check_Resrc_Require_Items (
928: p_resrc_Require_rec => p_resrc_Require_rec,
929: p_validation_mode => Jtf_Plsql_Api.g_create,
930: x_return_status => l_return_status
931: );
932:
933: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN