1186: ,requested_discount_currency
1187: ,product_cost_currency
1188: ,end_customer_currency
1189: ,approved_discount_currency
1190: FROM ozf_sd_request_lines_all
1191: WHERE request_line_id = p_request_line_id;
1192:
1193: CURSOR c_reqest_lines_seq IS
1194: SELECT ozf_sd_request_lines_all_s.nextval
1190: FROM ozf_sd_request_lines_all
1191: WHERE request_line_id = p_request_line_id;
1192:
1193: CURSOR c_reqest_lines_seq IS
1194: SELECT ozf_sd_request_lines_all_s.nextval
1195: FROM dual;
1196:
1197: l_get_sdr_line c_get_sdr_line%ROWTYPE;
1198: l_listLineId c_listLineId%ROWTYPE;
3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,
3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS
3612: SELECT ozf_sd_request_lines_all_s.nextval
3613: FROM dual;
3614:
3615: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
3616: SELECT custom_setup_id