[Home] [Help]
1: PACKAGE BODY JTF_CALENDAR_PUB AS
2: /* $Header: jtfclavb.pls 120.4 2005/12/12 03:18:58 sbarat ship $ */
3:
4: -- ************************************************************************
5: -- Start of Comments
27: -- 12/12/05 SBARAT Changed jtf_rs_resources_vl to jtf_task_resources_vl
28: -- due to MOAC change, bug# 4455792
29: -- End of Comments
30: -- ************************************************************************
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_CALENDAR_PUB';
32: G_EXC_REQUIRED_FIELDS_NULL EXCEPTION;
33: --G_EXC_NOT_VALID_RESOURCE EXCEPTION;
34: L_PARAMETERS VARCHAR2(200);
35: --
222:
223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: JTF_CALENDAR_PUB.Get_Available_Time
227: ( p_api_version => 1.0,
228: p_resource_id => p_resource_id,
229: p_resource_type => p_resource_type,
230: p_start_date => p_start_date_time,
751: l_api_version CONSTANT NUMBER := 1.0;
752: l_return_status VARCHAR2(1);
753: l_msg_count NUMBER;
754: l_msg_data VARCHAR2(250);
755: l_shift jtf_calendar_pub_24hr.SHIFT_TBL_TYPE;
756: v_start_date DATE;
757: v_end_date DATE;
758: v_slot_start_date DATE;
759: v_slot_end_date DATE;
787:
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: --
791: JTF_CALENDAR_PUB_24hr.Get_Available_Slot
792: ( p_api_version => l_api_version ,
793: p_init_msg_list => p_init_msg_list,
794: p_resource_id => p_resource_id,
795: p_resource_type => p_resource_type,
937: if not fnd_api.compatible_api_call
938: ( l_api_version
939: , p_api_version
940: , l_api_name
941: , JTF_CALENDAR_PUB.g_pkg_name )
942: then
943: raise fnd_api.g_exc_unexpected_error;
944: end if;
945:
949: fnd_msg_pub.initialize;
950: end if;
951:
952: -- call to check for required fields
953: if not JTF_CALENDAR_PUB.check_for_required_fields
954: ( p_resource_id => p_resource_id
955: , p_resource_type => p_resource_type
956: , p_start_date => p_start_date
957: , p_end_date => p_start_date )
1448: if not fnd_api.compatible_api_call
1449: ( l_api_version
1450: , p_api_version
1451: , l_api_name
1452: , JTF_CALENDAR_PUB.g_pkg_name )
1453: then
1454: raise fnd_api.g_exc_unexpected_error;
1455: end if;
1456:
1460: fnd_msg_pub.initialize;
1461: end if;
1462:
1463: -- call to check for required fields
1464: if not JTF_CALENDAR_PUB.check_for_required_fields
1465: ( p_resource_id => p_resource_id
1466: , p_resource_type => p_resource_type
1467: , p_start_date => p_start_date
1468: , p_end_date => p_start_date )
2564: End If;
2565:
2566: End Validate_Cal_Date;
2567:
2568: END JTF_CALENDAR_PUB;
2569: