eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_HEADERS_TL

Line 381: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)

377: FROM qp_rltd_modifiers
378: WHERE from_rltd_modifier_id = a_list_line_id;
379:
380: --bug#6636843
381: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)
382: IS
383: SELECT name, description, version_no
384: FROM qp_list_headers_tl
385: WHERE list_header_id = a_list_hdr_id;

Line 384: FROM qp_list_headers_tl

380: --bug#6636843
381: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)
382: IS
383: SELECT name, description, version_no
384: FROM qp_list_headers_tl
385: WHERE list_header_id = a_list_hdr_id;
386:
387:
388: BEGIN

Line 538: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl

534: p_instance_pk1 => l_new_discount_header_id,
535: x_return_status => x_result);
536: -- End addition for Object Security
537:
538: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
539: -- for the list being copied since there might be multiple rows in this
540: -- table for that list header.
541: FOR l_qp_list_headers_tl_rec IN
542: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)

Line 541: FOR l_qp_list_headers_tl_rec IN

537:
538: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
539: -- for the list being copied since there might be multiple rows in this
540: -- table for that list header.
541: FOR l_qp_list_headers_tl_rec IN
542: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)
543: LOOP
544:
545: -- query is commented to fix bug 6636843

Line 542: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)

538: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
539: -- for the list being copied since there might be multiple rows in this
540: -- table for that list header.
541: FOR l_qp_list_headers_tl_rec IN
542: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)
543: LOOP
544:
545: -- query is commented to fix bug 6636843
546: -- SELECT name, description, version_no

Line 549: --FROM qp_list_headers_tl

545: -- query is commented to fix bug 6636843
546: -- SELECT name, description, version_no
547: -- INTO l_name, l_description, l_version_no
548: --fix for bug 4673872
549: --FROM qp_list_headers_tl
550: --WHERE list_header_id = qp_from_discounts_rec.list_header_id;
551:
552: INSERT INTO qp_list_headers_tl
553: (last_update_login,

Line 552: INSERT INTO qp_list_headers_tl

548: --fix for bug 4673872
549: --FROM qp_list_headers_tl
550: --WHERE list_header_id = qp_from_discounts_rec.list_header_id;
551:
552: INSERT INTO qp_list_headers_tl
553: (last_update_login,
554: name,
555: description,
556: creation_date,

Line 568: l_qp_list_headers_tl_rec.name || to_char(l_new_discount_header_id), --bug#6636843.

564: )
565: SELECT
566: p_conc_login_id,
567: --l_name || to_char(l_new_discount_header_id),
568: l_qp_list_headers_tl_rec.name || to_char(l_new_discount_header_id), --bug#6636843.
569: --l_description,
570: l_qp_list_headers_tl_rec.description, --bug#6636843.
571: sysdate,
572: p_user_id,

Line 570: l_qp_list_headers_tl_rec.description, --bug#6636843.

566: p_conc_login_id,
567: --l_name || to_char(l_new_discount_header_id),
568: l_qp_list_headers_tl_rec.name || to_char(l_new_discount_header_id), --bug#6636843.
569: --l_description,
570: l_qp_list_headers_tl_rec.description, --bug#6636843.
571: sysdate,
572: p_user_id,
573: sysdate,
574: p_user_id,

Line 579: l_qp_list_headers_tl_rec.version_no --bug#6636843.

575: l_new_discount_header_id,
576: l.language_code,
577: userenv('LANG'),
578: --l_version_no
579: l_qp_list_headers_tl_rec.version_no --bug#6636843.
580: FROM fnd_languages l
581: WHERE l.installed_flag IN ('I', 'B')
582: AND NOT EXISTS (SELECT NULL
583: FROM qp_list_headers_tl t

Line 583: FROM qp_list_headers_tl t

579: l_qp_list_headers_tl_rec.version_no --bug#6636843.
580: FROM fnd_languages l
581: WHERE l.installed_flag IN ('I', 'B')
582: AND NOT EXISTS (SELECT NULL
583: FROM qp_list_headers_tl t
584: WHERE t.list_header_id = l_new_discount_header_id
585: AND t.language = l.language_code);
586:
587:

Line 1635: INSERT INTO qp_list_headers_tl

1631: -- End addition for Object Security
1632:
1633:
1634:
1635: INSERT INTO qp_list_headers_tl
1636: (last_update_login,
1637: name,
1638: description,
1639: creation_date,

Line 1664: FROM qp_list_headers_tl t

1660:
1661: FROM fnd_languages l
1662: WHERE l.installed_flag IN ('I', 'B')
1663: AND NOT EXISTS (SELECT NULL
1664: FROM qp_list_headers_tl t
1665: WHERE t.list_header_id = l_new_list_header_id
1666: AND t.language = l.language_code);
1667:
1668: