APPS.QLTAUFLB dependencies on QA_PERFORMANCE_TEMP_PKG

Line 32: -- we will be using the qa_performance_temp_pkg package to

28: -- are condensed into one single SQL c_plan_chars to promote
29: -- code re-use and to avoid re-parsing.
30: --
31: -- Since a list of char_ids are expected, to avoid literals,
32: -- we will be using the qa_performance_temp_pkg package to
33: -- keep a list of char_ids temporarily.
34: --
35: -- The params to the cursor are:
36: --

Line 632: qa_performance_temp_pkg.purge_and_add_ids(

628: IF (x_copy_plan_id = 58) THEN
629:
630: -- Bug 4958757 SQL Repository tuning.
631: l_key := 'QLTAUFLB.C_MOBILE_INSPECT';
632: qa_performance_temp_pkg.purge_and_add_ids(
633: p_key => l_key,
634: p_id_list => qa_ss_const.QUANTITY || ',' ||
635: qa_ss_const.INSPECTION_RESULT || ',' ||
636: qa_ss_const.ITEM || ',' ||

Line 782: qa_performance_temp_pkg.purge_and_add_ids(

778: ELSE
779:
780: -- Bug 4958757 SQL Repository tuning.
781: l_key := 'QLTAUFLB.C5';
782: qa_performance_temp_pkg.purge_and_add_ids(
783: p_key => l_key,
784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||
785: qa_ss_const.QUANTITY || ',' ||
786: qa_ss_const.INSPECTION_RESULT || ',' ||

Line 991: qa_performance_temp_pkg.purge_and_add_ids(

987: i := 1;
988:
989: -- Bug 4958757 SQL Repository tuning.
990: l_key := 'QLTAUFLB.C1';
991: qa_performance_temp_pkg.purge_and_add_ids(
992: p_key => l_key,
993: p_id_list => qa_ss_const.VENDOR_NAME || ',' ||
994: qa_ss_const.PO_NUMBER);
995: