APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_LIST_LINES

Line 323: select qp_list_lines_s.nextval

319: from mtl_system_items mtl
320: where mtl.inventory_item_id = l_item_tbl(l_index)
321: and mtl.organization_id = p_organization_id;
322:
323: select qp_list_lines_s.nextval
324: into l_list_line_id
325: from dual;
326:
327: insert

Line 328: into qp_list_lines

324: into l_list_line_id
325: from dual;
326:
327: insert
328: into qp_list_lines
329: (LIST_LINE_ID,
330: LIST_LINE_NO,
331: LAST_UPDATE_DATE,
332: CREATION_DATE,

Line 495: into qp_list_lines

491: and mtl.organization_id = p_organization_id;
492:
493:
494: insert
495: into qp_list_lines
496: (LIST_LINE_ID,
497: LIST_LINE_NO,
498: LAST_UPDATE_DATE,
499: CREATION_DATE,

Line 523: qp_list_lines_s.nextval,

519: QUALIFICATION_IND
520: -- Bug 5202021 RAVI
521: ,ORIG_SYS_LINE_REF)
522: values (
523: qp_list_lines_s.nextval,
524: qp_list_lines_s.currval,
525: -- Begin Bug No: 7281484
526: sysdate,
527: sysdate,

Line 524: qp_list_lines_s.currval,

520: -- Bug 5202021 RAVI
521: ,ORIG_SYS_LINE_REF)
522: values (
523: qp_list_lines_s.nextval,
524: qp_list_lines_s.currval,
525: -- Begin Bug No: 7281484
526: sysdate,
527: sysdate,
528: -- End -- Bug No: 7281484

Line 551: ,qp_list_lines_s.currval);

547: --220, --modified by dhgupta for bug 2113793
548: 'LINE',
549: l_qualification_ind
550: -- Bug 5202021 RAVI
551: ,qp_list_lines_s.currval);
552:
553: /*------------------------------------------------------------------------+
554: | Insert pricing attributes |
555: +-----------------------------------------------------------------------*/

Line 595: qp_list_lines_s.currval,

591: l_conc_program_application_id,
592: l_conc_program_id,
593: sysdate, -- Bug No: 7281484
594: l_conc_request_id,
595: qp_list_lines_s.currval,
596: p_price_list_id,
597: 1,
598: l_qualification_ind,
599: 'ITEM',

Line 627: from qp_list_lines

623: END IF;
624: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
625: select min(list_line_id), max(list_line_id)
626: into l_min_list_line_id, l_max_list_line_id
627: from qp_list_lines
628: where list_header_id = p_price_list_id;
629:
630: QP_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id(p_price_list_id, l_min_list_line_id, l_max_list_line_id);
631: QP_ATTR_GRP_PVT.update_pp_lines(p_price_list_id, l_min_list_line_id, l_max_list_line_id);