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 390: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)

386: FROM qp_rltd_modifiers
387: WHERE from_rltd_modifier_id = a_list_line_id;
388:
389: --bug#6636843
390: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)
391: IS
392: SELECT name, description, version_no
393: FROM qp_list_headers_tl
394: WHERE list_header_id = a_list_hdr_id;

Line 393: FROM qp_list_headers_tl

389: --bug#6636843
390: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)
391: IS
392: SELECT name, description, version_no
393: FROM qp_list_headers_tl
394: WHERE list_header_id = a_list_hdr_id;
395:
396:
397: BEGIN

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

543: p_instance_pk1 => l_new_discount_header_id,
544: x_return_status => x_result);
545: -- End addition for Object Security
546:
547: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
548: -- for the list being copied since there might be multiple rows in this
549: -- table for that list header.
550: FOR l_qp_list_headers_tl_rec IN
551: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)

Line 550: FOR l_qp_list_headers_tl_rec IN

546:
547: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
548: -- for the list being copied since there might be multiple rows in this
549: -- table for that list header.
550: FOR l_qp_list_headers_tl_rec IN
551: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)
552: LOOP
553:
554: -- query is commented to fix bug 6636843

Line 551: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)

547: --bug#6636843. Loop is added to traverse through table qp_list_headers_tl
548: -- for the list being copied since there might be multiple rows in this
549: -- table for that list header.
550: FOR l_qp_list_headers_tl_rec IN
551: qp_list_headers_tl_cur(qp_from_discounts_rec.list_header_id)
552: LOOP
553:
554: -- query is commented to fix bug 6636843
555: -- SELECT name, description, version_no

Line 558: --FROM qp_list_headers_tl

554: -- query is commented to fix bug 6636843
555: -- SELECT name, description, version_no
556: -- INTO l_name, l_description, l_version_no
557: --fix for bug 4673872
558: --FROM qp_list_headers_tl
559: --WHERE list_header_id = qp_from_discounts_rec.list_header_id;
560:
561: INSERT INTO qp_list_headers_tl
562: (last_update_login,

Line 561: INSERT INTO qp_list_headers_tl

557: --fix for bug 4673872
558: --FROM qp_list_headers_tl
559: --WHERE list_header_id = qp_from_discounts_rec.list_header_id;
560:
561: INSERT INTO qp_list_headers_tl
562: (last_update_login,
563: name,
564: description,
565: creation_date,

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

573: )
574: SELECT
575: p_conc_login_id,
576: --l_name || to_char(l_new_discount_header_id),
577: l_qp_list_headers_tl_rec.name || to_char(l_new_discount_header_id), --bug#6636843.
578: --l_description,
579: l_qp_list_headers_tl_rec.description, --bug#6636843.
580: sysdate,
581: p_user_id,

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

575: p_conc_login_id,
576: --l_name || to_char(l_new_discount_header_id),
577: l_qp_list_headers_tl_rec.name || to_char(l_new_discount_header_id), --bug#6636843.
578: --l_description,
579: l_qp_list_headers_tl_rec.description, --bug#6636843.
580: sysdate,
581: p_user_id,
582: sysdate,
583: p_user_id,

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

584: l_new_discount_header_id,
585: l.language_code,
586: userenv('LANG'),
587: --l_version_no
588: l_qp_list_headers_tl_rec.version_no --bug#6636843.
589: FROM fnd_languages l
590: WHERE l.installed_flag IN ('I', 'B')
591: AND NOT EXISTS (SELECT NULL
592: FROM qp_list_headers_tl t

Line 592: FROM qp_list_headers_tl t

588: l_qp_list_headers_tl_rec.version_no --bug#6636843.
589: FROM fnd_languages l
590: WHERE l.installed_flag IN ('I', 'B')
591: AND NOT EXISTS (SELECT NULL
592: FROM qp_list_headers_tl t
593: WHERE t.list_header_id = l_new_discount_header_id
594: AND t.language = l.language_code);
595:
596:

Line 1818: INSERT INTO qp_list_headers_tl

1814: -- End addition for Object Security
1815:
1816:
1817:
1818: INSERT INTO qp_list_headers_tl
1819: (last_update_login,
1820: name,
1821: description,
1822: creation_date,

Line 1847: FROM qp_list_headers_tl t

1843:
1844: FROM fnd_languages l
1845: WHERE l.installed_flag IN ('I', 'B')
1846: AND NOT EXISTS (SELECT NULL
1847: FROM qp_list_headers_tl t
1848: WHERE t.list_header_id = l_new_list_header_id
1849: AND t.language = l.language_code);
1850:
1851: