DBA Data[Home] [Help]

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_LIST_LINES_S

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 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',