APPS.QP_PS_ATTR_GRP_PVT dependencies on QP_PTE_SEGMENTS

Line 757: update qp_pte_segments

753: --Added for PL/SQL Pattern Search
754: select hsecs into l_end_time from v$timer;
755: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
756: IF p_list_header_id IS NULL THEN
757: update qp_pte_segments
758: set used_in_search ='Y'
759: where NVL(used_in_search,'N') ='N'
760: and segment_id in
761: ( select DISTINCT segment_id

Line 763: update qp_pte_segments

759: where NVL(used_in_search,'N') ='N'
760: and segment_id in
761: ( select DISTINCT segment_id
762: from qp_patterns );
763: update qp_pte_segments
764: set used_in_search ='N'
765: where NVL(used_in_search,'Y') ='Y'
766: and segment_id not in
767: ( select DISTINCT segment_id

Line 769: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments

765: where NVL(used_in_search,'Y') ='Y'
766: and segment_id not in
767: ( select DISTINCT segment_id
768: from qp_patterns );
769: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments
770: SET used_in_search = 'Y'
771: WHERE NVL(used_in_search,'N') = 'N'
772: AND segment_id in
773: (select pricing_segment_id

Line 795: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments

791: --list_header_id = nvl(p_list_header_id, list_header_id)
792: comparison_operator_code <> '='
793: and segment_id is not null);
794: ELSE
795: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments
796: SET used_in_search = 'Y'
797: WHERE NVL(used_in_search,'N') = 'N'
798: AND segment_id in
799: (select pricing_segment_id

Line 4526: /* update qp_pte_segments

4522:
4523: set HEADER_QUALS_EXIST_FLAG = l_QUAL_EXISTS
4524: where list_header_id = p_list_header_id;
4525:
4526: /* update qp_pte_segments
4527: set used_in_search ='Y'
4528: where NVL(used_in_search,'N') ='N'
4529: and segment_id in
4530: ( select DISTINCT segment_id

Line 4534: update qp_pte_segments

4530: ( select DISTINCT segment_id
4531: from qp_patterns );
4532:
4533:
4534: update qp_pte_segments
4535: set used_in_search ='N'
4536: where NVL(used_in_search,'Y') ='Y'
4537: and segment_id not in
4538: ( select DISTINCT segment_id

Line 4541: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments

4537: and segment_id not in
4538: ( select DISTINCT segment_id
4539: from qp_patterns ); */
4540:
4541: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments
4542: SET used_in_search = 'Y'
4543: WHERE NVL(used_in_search,'N') = 'N'
4544: AND segment_id in
4545: (select pricing_segment_id

Line 4776: /* update qp_pte_segments

4772: update_pp_lines(p_list_header_id, p_list_line_id, p_list_line_id);
4773: end if;
4774:
4775: --------- Added for PL/SQL Pattern Search
4776: /* update qp_pte_segments
4777: set used_in_search ='Y'
4778: where NVL(used_in_search,'N') ='N'
4779: and segment_id in
4780: (select DISTINCT segment_id

Line 4784: update qp_pte_segments

4780: (select DISTINCT segment_id
4781: from qp_patterns );
4782:
4783:
4784: update qp_pte_segments
4785: set used_in_search ='N'
4786: where NVL(used_in_search,'Y') ='Y'
4787: and segment_id not in
4788: (select DISTINCT segment_id

Line 4791: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments

4787: and segment_id not in
4788: (select DISTINCT segment_id
4789: from qp_patterns );*/
4790:
4791: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments
4792: SET used_in_search = 'Y'
4793: WHERE NVL(used_in_search,'N') = 'N'
4794: AND segment_id in
4795: (select pricing_segment_id

Line 4942: /* update qp_pte_segments

4938: end if; -- p_setup_action = 'UD'
4939:
4940: --------- Added for PL/SQL Pattern Search
4941:
4942: /* update qp_pte_segments
4943: set used_in_search ='Y'
4944: where NVL(used_in_search,'N') ='N'
4945: and segment_id in
4946: (select DISTINCT segment_id

Line 4950: update qp_pte_segments

4946: (select DISTINCT segment_id
4947: from qp_patterns );
4948:
4949:
4950: update qp_pte_segments
4951: set used_in_search ='N'
4952: where NVL(used_in_search,'Y') ='Y'
4953: and segment_id not in
4954: ( select DISTINCT segment_id

Line 4958: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments

4954: ( select DISTINCT segment_id
4955: from qp_patterns );*/
4956:
4957:
4958: UPDATE /*+ index (QP_PTE_SEGMENTS QP_PTE_SEGMENTS_U2) */ qp_pte_segments
4959: SET used_in_search = 'Y'
4960: WHERE NVL(used_in_search,'N') = 'N'
4961: AND segment_id in
4962: (select pricing_segment_id