DBA Data[Home] [Help]

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on QP_LIST_LINES_S

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