APPS.OTA_TIMEZONE_UPGRADE dependencies on OTA_CHATS_B

Line 459: UPDATE ota_chats_b

455: FOR chats_row IN csr_chats(p_event_id)
456: LOOP
457: BEGIN
458:
459: UPDATE ota_chats_b
460: SET timezone_code = p_time_zone
461: WHERE chat_id = chats_row.chat_id
462: AND timezone_code IS NULL;
463:

Line 467: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_chats_b',

463:
464: EXCEPTION
465: WHEN others THEN
466: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
467: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_chats_b',
468: p_business_group_id => NULL,
469: p_source_primary_key => chats_row.chat_id,
470: p_object_value => l_upgrade_name,
471: p_message_text => l_err_msg,

Line 515: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',

511: BEGIN
512: l_others_msg := 'Error occurred while upgrading the timezone of category chats ';
513:
514: IF p_default_timezone IS NULL THEN
515: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',
516: p_business_group_id => NULL,
517: p_source_primary_key => -1,
518: p_object_value => 'Timezone',
519: p_message_text => l_default_msg,

Line 533: UPDATE ota_chats_b

529: FOR cat_chat_bkng_row IN csr_cat_chat_bkng
530: LOOP
531: BEGIN
532:
533: UPDATE ota_chats_b
534: SET timezone_code = l_time_zone
535: WHERE chat_id = cat_chat_bkng_row.chat_id
536: AND timezone_code IS NULL;
537:

Line 541: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',

537:
538: EXCEPTION
539: WHEN others THEN
540: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_others_msg);
541: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',
542: p_business_group_id => NULL,
543: p_source_primary_key => cat_chat_bkng_row.chat_id,
544: p_object_value => l_upgrade_name,
545: p_message_text => l_err_msg,