APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_LIST_LINES

Line 439: select qp_list_lines_s.nextval

435: from mtl_system_items mtl
436: where mtl.inventory_item_id = l_item_tbl(l_index)
437: and mtl.organization_id = p_organization_id;
438:
439: select qp_list_lines_s.nextval
440: into l_list_line_id
441: from dual;
442: -- 10185331
443: SELECT orig_system_header_ref INTO

Line 449: into qp_list_lines

445: FROM qp_list_headers_all_b
446: WHERE list_header_id = p_price_list_id;
447: -- 10185331
448: insert
449: into qp_list_lines
450: (LIST_LINE_ID,
451: LIST_LINE_NO,
452: LAST_UPDATE_DATE,
453: CREATION_DATE,

Line 625: into qp_list_lines

621: WHERE list_header_id = p_price_list_id;
622: -- 10185331
623:
624: insert
625: into qp_list_lines
626: (LIST_LINE_ID,
627: LIST_LINE_NO,
628: LAST_UPDATE_DATE,
629: CREATION_DATE,

Line 654: qp_list_lines_s.nextval,

650: -- Bug 5202021 RAVI
651: ,ORIG_SYS_LINE_REF
652: ,ORIG_SYS_HEADER_REF) -- 10185331
653: values (
654: qp_list_lines_s.nextval,
655: qp_list_lines_s.currval,
656: -- Begin Bug No: 7281484
657: sysdate,
658: sysdate,

Line 655: qp_list_lines_s.currval,

651: ,ORIG_SYS_LINE_REF
652: ,ORIG_SYS_HEADER_REF) -- 10185331
653: values (
654: qp_list_lines_s.nextval,
655: qp_list_lines_s.currval,
656: -- Begin Bug No: 7281484
657: sysdate,
658: sysdate,
659: -- End -- Bug No: 7281484

Line 682: ,qp_list_lines_s.CURRVAL

678: --220, --modified by dhgupta for bug 2113793
679: 'LINE',
680: l_qualification_ind
681: -- Bug 5202021 RAVI
682: ,qp_list_lines_s.CURRVAL
683: ,l_orig_sys_header_ref); -- 10185331
684:
685: /*------------------------------------------------------------------------+
686: | Insert pricing attributes |

Line 728: qp_list_lines_s.currval,

724: l_conc_program_application_id,
725: l_conc_program_id,
726: sysdate, -- Bug No: 7281484
727: l_conc_request_id,
728: qp_list_lines_s.currval,
729: p_price_list_id,
730: 1,
731: l_qualification_ind,
732: 'ITEM',

Line 761: from qp_list_lines

757: END IF;
758: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
759: select min(list_line_id), max(list_line_id)
760: into l_min_list_line_id, l_max_list_line_id
761: from qp_list_lines
762: where list_header_id = p_price_list_id;
763:
764: QP_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id(p_price_list_id, l_min_list_line_id, l_max_list_line_id);
765: QP_ATTR_GRP_PVT.update_pp_lines(p_price_list_id, l_min_list_line_id, l_max_list_line_id);

Line 772: from qp_list_lines

768: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
769: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
770: select min(list_line_id), max(list_line_id)
771: into l_min_list_line_id, l_max_list_line_id
772: from qp_list_lines
773: where list_header_id = p_price_list_id;
774:
775: QP_PS_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id(p_price_list_id, l_min_list_line_id, l_max_list_line_id);
776: QP_PS_ATTR_GRP_PVT.update_pp_lines(p_price_list_id, l_min_list_line_id, l_max_list_line_id);