1: PACKAGE BODY JTF_CALENDAR_PUB AS
2: /* $Header: jtfclavb.pls 120.4.12010000.3 2009/09/18 08:23:40 anangupt 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,
793: l_api_version CONSTANT NUMBER := 1.0;
794: l_return_status VARCHAR2(1);
795: l_msg_count NUMBER;
796: l_msg_data VARCHAR2(250);
797: l_shift jtf_calendar_pub_24hr.SHIFT_TBL_TYPE;
798: v_start_date DATE;
799: v_end_date DATE;
800: v_slot_start_date DATE;
801: v_slot_end_date DATE;
829:
830: -- Initialize API return status to success
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832: --
833: JTF_CALENDAR_PUB_24hr.Get_Available_Slot
834: ( p_api_version => l_api_version ,
835: p_init_msg_list => p_init_msg_list,
836: p_resource_id => p_resource_id,
837: p_resource_type => p_resource_type,
979: if not fnd_api.compatible_api_call
980: ( l_api_version
981: , p_api_version
982: , l_api_name
983: , JTF_CALENDAR_PUB.g_pkg_name )
984: then
985: raise fnd_api.g_exc_unexpected_error;
986: end if;
987:
991: fnd_msg_pub.initialize;
992: end if;
993:
994: -- call to check for required fields
995: if not JTF_CALENDAR_PUB.check_for_required_fields
996: ( p_resource_id => p_resource_id
997: , p_resource_type => p_resource_type
998: , p_start_date => p_start_date
999: , p_end_date => p_start_date )
1493: if not fnd_api.compatible_api_call
1494: ( l_api_version
1495: , p_api_version
1496: , l_api_name
1497: , JTF_CALENDAR_PUB.g_pkg_name )
1498: then
1499: raise fnd_api.g_exc_unexpected_error;
1500: end if;
1501:
1505: fnd_msg_pub.initialize;
1506: end if;
1507:
1508: -- call to check for required fields
1509: if not JTF_CALENDAR_PUB.check_for_required_fields
1510: ( p_resource_id => p_resource_id
1511: , p_resource_type => p_resource_type
1512: , p_start_date => p_start_date
1513: , p_end_date => p_start_date )
2627: End If;
2628:
2629: End Validate_Cal_Date;
2630:
2631: END JTF_CALENDAR_PUB;
2632: