175: l_parent_type VARCHAR2(10);
176:
177: CURSOR c_csch_id (obj_id NUMBER) IS
178: SELECT schedule_id
179: FROM ams_campaign_schedules_b
180: WHERE related_event_id = obj_id;
181:
182:
183: BEGIN
1709: l_parent_type VARCHAR2(10);
1710:
1711: CURSOR c_csch_id (obj_id NUMBER) IS
1712: SELECT schedule_id
1713: FROM ams_campaign_schedules_b
1714: WHERE related_event_id = obj_id;
1715:
1716:
1717: BEGIN
2133: l_parent_type VARCHAR2(10);
2134:
2135: CURSOR c_csch_id (obj_id NUMBER) IS
2136: SELECT schedule_id
2137: FROM ams_campaign_schedules_b
2138: WHERE related_event_id = obj_id;
2139:
2140:
2141: Cursor cancel_get_offer_details( l_event_offer_id NUMBER
3157: l_parent_type VARCHAR2(10);
3158:
3159: CURSOR c_csch_id (obj_id NUMBER) IS
3160: SELECT schedule_id
3161: FROM ams_campaign_schedules_b
3162: WHERE related_event_id = obj_id;
3163:
3164:
3165: BEGIN