APPS.OTA_CTU_BUS dependencies on OTA_OFFERINGS

Line 711: ota_offerings off

707: CURSOR cur_off_dates is
708: select start_date,
709: end_date
710: from
711: ota_offerings off
712: where
713: off.delivery_mode_id = p_category_usage_id;
714:
715: -- Variables for API Boolean parameters

Line 717: v_start_date ota_offerings.start_date%TYPE;

713: off.delivery_mode_id = p_category_usage_id;
714:
715: -- Variables for API Boolean parameters
716: l_proc varchar2(72) := g_package ||'Chk_Off_Start_End_Date';
717: v_start_date ota_offerings.start_date%TYPE;
718: v_end_date ota_offerings.end_date%TYPE;
719: l_obj_dm VARCHAR2(80);
720: l_obj_off VARCHAR2(80);
721:

Line 718: v_end_date ota_offerings.end_date%TYPE;

714:
715: -- Variables for API Boolean parameters
716: l_proc varchar2(72) := g_package ||'Chk_Off_Start_End_Date';
717: v_start_date ota_offerings.start_date%TYPE;
718: v_end_date ota_offerings.end_date%TYPE;
719: l_obj_dm VARCHAR2(80);
720: l_obj_off VARCHAR2(80);
721:
722: Begin

Line 798: From ota_offerings off

794: -- Cursor to get value if parent category is already exits in child hierarchy of base category
795:
796: CURSOR cur_dm_offerings is
797: select 'Y'
798: From ota_offerings off
799: where off.delivery_mode_id = p_category_usage_id;
800:
801: -- Variables for API Boolean parameters
802: l_proc varchar2(72) := g_package ||'Chk_Sync_Online_Flag';

Line 1410: From ota_offerings off

1406: -- Cursor to get value if parent category is already exits in child hierarchy of base category
1407:
1408: CURSOR cur_dm_offerings is
1409: select 'Y'
1410: From ota_offerings off
1411: where off.delivery_mode_id = p_category_usage_id;
1412:
1413: -- Variables for API Boolean parameters
1414: l_proc varchar2(72) := g_package ||'Chk_offering_association';