APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACTPRODUCT_PVT

Line 1651: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;

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:
1653: CURSOR c_excluded_products(l_act_prod_id NUMBER) IS
1654: SELECT *
1655: FROM ams_act_products

Line 2477: ams_ActProduct_PVT.Create_Act_Product(p_api_version => p_api_version

2473: l_act_product_rec.scan_value := l_act_product.scan_value;
2474: l_act_product_rec.scan_unit_forecast := l_act_product.scan_unit_forecast;
2475: l_act_product_rec.adjustment_flag := l_act_product.adjustment_flag;
2476:
2477: ams_ActProduct_PVT.Create_Act_Product(p_api_version => p_api_version
2478: ,p_init_msg_list => p_init_msg_list
2479: ,p_commit => p_commit
2480: ,p_validation_level => p_validation_level
2481: ,x_return_status => x_return_status

Line 2534: ams_ActProduct_PVT.Create_Act_Product(p_api_version => p_api_version

2530: l_act_product_rec.quantity := l_excluded_product.quantity;
2531: l_act_product_rec.scan_value := l_excluded_product.scan_value;
2532: l_act_product_rec.scan_unit_forecast := l_excluded_product.scan_unit_forecast;
2533: l_act_product_rec.adjustment_flag := l_excluded_product.adjustment_flag;
2534: ams_ActProduct_PVT.Create_Act_Product(p_api_version => p_api_version
2535: ,p_init_msg_list => p_init_msg_list
2536: ,p_commit => p_commit
2537: ,p_validation_level => p_validation_level
2538: ,x_return_status => x_return_status