DBA Data[Home] [Help]

APPS.QP_COPY_PRICELIST_PVT dependencies on QP_PRICE_LIST_UTIL

Line 405: l_new_orig_system_hrd_Ref := QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id);

401: INTO l_new_discount_header_id
402: FROM dual;
403:
404: --bug#6636843
405: l_new_orig_system_hrd_Ref := QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id);
406:
407: --Discount Header Information
408:
409: INSERT INTO qp_list_headers_all_b

Line 521: --,nvl(ORIG_SYSTEM_HEADER_REF,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id))

517: ask_for_flag,
518: currency_header_id, -- Multi-Currency SunilPandey
519: pte_code -- Attribute Manager, Giri
520: --ENH Upgrade BOAPI for orig_sys...ref RAVI
521: --,nvl(ORIG_SYSTEM_HEADER_REF,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id))
522: -- Bug 5201918
523: --bug#6636843. Moving this function call to before the query and storing the value in a
524: --variable and then using it.
525: --,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id)

Line 525: --,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id)

521: --,nvl(ORIG_SYSTEM_HEADER_REF,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id))
522: -- Bug 5201918
523: --bug#6636843. Moving this function call to before the query and storing the value in a
524: --variable and then using it.
525: --,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id)
526: ,l_new_orig_system_hrd_Ref
527: --fix for bug 4673872
528: FROM qp_list_headers_b
529: WHERE list_header_id = qp_from_discounts_rec.list_header_id;