APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_SALES_TRANSACTIONS

Line 174: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type

170: ,p_commit IN VARCHAR2
171: ,x_return_status OUT NOCOPY VARCHAR2
172: ,x_msg_count OUT NOCOPY NUMBER
173: ,x_msg_data OUT NOCOPY VARCHAR2
174: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
175: ,p_qp_list_header_id IN NUMBER
176: ,p_offer_id IN NUMBER
177: ,p_indirect_flag IN VARCHAR2
178: ,p_sign IN NUMBER

Line 1049: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type

1045: ,p_commit IN VARCHAR2
1046: ,x_return_status OUT NOCOPY VARCHAR2
1047: ,x_msg_count OUT NOCOPY NUMBER
1048: ,x_msg_data OUT NOCOPY VARCHAR2
1049: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
1050: ,p_qp_list_header_id IN NUMBER
1051: ,x_apply_discount OUT NOCOPY VARCHAR2
1052: ,p_use_vol_smry_stg_tbl IN VARCHAR2 DEFAULT 'F'
1053: ,p_resale_batch_id IN NUMBER DEFAULT NULL

Line 1097: l_volume_detail_rec ozf_sales_transactions_pvt.sales_transaction_rec_type;

1093: FROM ozf_offer_discount_lines
1094: WHERE offer_id = l_offer_id;
1095: l_offer_uom_code VARCHAR2(10);
1096: l_uom_ratio NUMBER := 1;
1097: l_volume_detail_rec ozf_sales_transactions_pvt.sales_transaction_rec_type;
1098: -- Catch Weight ER - end
1099:
1100: l_offer_id NUMBER;
1101: l_qp_list_header_id NUMBER;

Line 1961: FROM ozf_sales_transactions

1957: WHERE line_id = p_order_line_id;
1958:
1959: CURSOR c_resale_detail IS
1960: SELECT quantity, amount, sold_from_cust_account_id, sold_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, transaction_date
1961: FROM ozf_sales_transactions
1962: WHERE line_id = p_order_line_id;
1963:
1964: CURSOR c_interface_detail IS
1965: SELECT quantity, quantity * selling_price, sold_from_cust_account_id, bill_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, date_ordered