1644: l_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;
1645:
1646: CURSOR c_act_products IS
1647: SELECT *
1648: FROM ams_act_products
1649: WHERE arc_act_product_used_by = 'OFFR'
1650: AND act_product_used_by_id = p_source_object_id;
1651: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1652:
1651: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1652:
1653: CURSOR c_excluded_products(l_act_prod_id NUMBER) IS
1654: SELECT *
1655: FROM ams_act_products
1656: WHERE arc_act_product_used_by = 'PROD'
1657: AND act_product_used_by_id = l_act_prod_id;
1658:
1659: CURSOR c_offer_lines IS