APPS.OTA_COI_BUS dependencies on OTA_CHATS_B

Line 352: FROM ota_chats_b

348:
349: CURSOR csr_chat_start_end_date IS
350: SELECT start_date_active,
351: nvl(end_date_active, to_date ('31-12-4712', 'DD-MM-YYYY'))
352: FROM ota_chats_b
353: WHERE chat_id = p_chat_id;
354:
355:
356: --

Line 368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

364: Begin
365: hr_utility.set_location(' Entering:' || l_proc,10);
366: --
367: IF hr_multi_message.no_exclusive_error
368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
370: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
371: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
372: ) THEN

Line 369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

365: hr_utility.set_location(' Entering:' || l_proc,10);
366: --
367: IF hr_multi_message.no_exclusive_error
368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
370: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
371: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
372: ) THEN
373: --

Line 370: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

366: --
367: IF hr_multi_message.no_exclusive_error
368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
370: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
371: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
372: ) THEN
373: --
374: OPEN csr_cat_start_end_date;

Line 371: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

367: IF hr_multi_message.no_exclusive_error
368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
370: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
371: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
372: ) THEN
373: --
374: OPEN csr_cat_start_end_date;
375: FETCH csr_cat_start_end_date into l_cat_start_date, l_cat_end_date;

Line 401: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

397: hr_utility.set_location(' Leaving:' || l_proc,10);
398: Exception
399: when app_exception.application_exception then
400: IF hr_multi_message.exception_add
401: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
402: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
403: ) THEN
404: hr_utility.set_location(' Leaving:'|| l_proc,20);
405: raise;

Line 402: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

398: Exception
399: when app_exception.application_exception then
400: IF hr_multi_message.exception_add
401: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
402: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
403: ) THEN
404: hr_utility.set_location(' Leaving:'|| l_proc,20);
405: raise;
406: END IF;