APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_LIST_HEADERS_B

Line 319: INSERT INTO qp_list_headers_b (

315: )
316: IS
317: BEGIN
318:
319: INSERT INTO qp_list_headers_b (
320: list_header_id,
321: creation_date,
322: created_by,
323: last_update_date,

Line 513: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)

509: p_attribute6, p_attribute7, p_attribute8, p_attribute9, p_attribute10,
510: p_attribute11, p_attribute12, p_attribute13, p_attribute14, p_attribute15
511: --ENH Upgrade BOAPI for orig_sys...ref RAVI
512: ,to_char(p_list_line_id)
513: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)
514: );
515:
516: EXCEPTION
517: WHEN OTHERS THEN

Line 665: SELECT QP_LIST_HEADERS_B_S.nextval

661: END;
662:
663: IF l_exists IS NULL THEN -- Price Modifier List Id does not already exist
664:
665: SELECT QP_LIST_HEADERS_B_S.nextval
666: INTO l_list_header_id
667: FROM DUAL;
668:
669: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(

Line 1283: SELECT QP_LIST_HEADERS_B_S.nextval

1279: LOOP
1280:
1281: IF so_rule_line_comp_values_cur%ROWCOUNT = 1 THEN
1282:
1283: SELECT QP_LIST_HEADERS_B_S.nextval
1284: INTO l_list_header_id
1285: FROM DUAL;
1286:
1287: --dbms_output.put_line(' list header '||l_list_header_id);