APPS.OTA_TEA_BUS dependencies on HR_API

Line 28: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);

24: l_dummy integer;
25: --
26: procedure chkp is
27: begin
28: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
29: hr_api.mandatory_arg_error(g_package,'Customer_id',p_customer_id);
30: end chkp;
31: -------------
32: begin

Line 29: hr_api.mandatory_arg_error(g_package,'Customer_id',p_customer_id);

25: --
26: procedure chkp is
27: begin
28: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
29: hr_api.mandatory_arg_error(g_package,'Customer_id',p_customer_id);
30: end chkp;
31: -------------
32: begin
33: --

Line 646: (evt.course_start_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))

642: or evt.activity_version_id = vsp.vendor_supply_id )
643: and ple.price_basis = 'C'
644: and p_customer_total_delegates between ple.minimum_attendees and ple.maximum_attendees
645: and (
646: (evt.course_start_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))
647: or
648: (evt.course_start_date is null and
649: p_session_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))
650: );

Line 649: p_session_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))

645: and (
646: (evt.course_start_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))
647: or
648: (evt.course_start_date is null and
649: p_session_date between ple.start_date and nvl(ple.end_date,hr_api.g_eot))
650: );
651: --
652: l_price number;
653: -----------

Line 656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);

652: l_price number;
653: -----------
654: procedure chkp is
655: begin
656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);
658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);
659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);
660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);

Line 657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);

653: -----------
654: procedure chkp is
655: begin
656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);
658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);
659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);
660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);
661: end chkp;

Line 658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);

654: procedure chkp is
655: begin
656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);
658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);
659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);
660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);
661: end chkp;
662: -----------

Line 659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);

655: begin
656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);
658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);
659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);
660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);
661: end chkp;
662: -----------
663: begin

Line 660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);

656: hr_api.mandatory_arg_error(g_package,'Event_id',p_event_id);
657: hr_api.mandatory_arg_error(g_package,'Business group',p_business_group_id);
658: hr_api.mandatory_arg_error(g_package,'Currency code',p_currency_code);
659: hr_api.mandatory_arg_error(g_package,'Number of delegates',p_customer_total_delegates);
660: hr_api.mandatory_arg_error(g_package,'Session date',p_session_date);
661: end chkp;
662: -----------
663: begin
664: --