APPS.QP_ATTR_MAPPING_PUB dependencies on QP_PTE_SEGMENTS

Line 475: UPDATE qp_pte_segments

471: END IF;
472:
473: v_count := 1;
474:
475: UPDATE qp_pte_segments
476: SET sourcing_status = 'N',
477: used_in_setup = 'N'
478: WHERE sourcing_status = 'Y' OR used_in_setup = 'Y';
479: LOOP

Line 483: UPDATE qp_pte_segments

479: LOOP
480:
481: EXIT WHEN v_count > G_Segment_Ctr.COUNT;
482: v_segment_id := G_Segment_Ctr(v_count);
483: UPDATE qp_pte_segments
484: SET sourcing_status = 'Y',
485: used_in_setup = 'Y'
486: WHERE segment_id = v_segment_id;
487:

Line 708: qp_pte_segments qppseg

704: qp_segments_b qpseg,
705: qp_attribute_sourcing qpsour,
706: qp_prc_contexts_b qpcon,
707: qp_pte_request_types_b qpreq,
708: qp_pte_segments qppseg
709: WHERE
710: qpsour.segment_id = qpseg.segment_id
711: AND qpsour.attribute_sourcing_level = p_sourcing_level
712: AND qpsour.enabled_flag = 'Y'

Line 734: qp_pte_segments qppseg

730: qp_segments_b qpseg,
731: qp_attribute_sourcing qpsour,
732: qp_prc_contexts_b qpcon,
733: qp_pte_request_types_b qpreq,
734: qp_pte_segments qppseg
735: WHERE
736: qpsour.segment_id = qpseg.segment_id
737: AND qpsour.attribute_sourcing_level = p_sourcing_level
738: AND qpsour.enabled_flag = 'Y'

Line 3558: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3554: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3555: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3556: qpcon.prc_context_code, qpcon.prc_context_type
3557: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3558: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3559: WHERE qpseg.segment_id = qppteseg.segment_id AND
3560: qpseg.segment_mapping_column = p_pricing_attr AND
3561: qpseg.prc_context_id = qpcon.prc_context_id AND
3562: qpcon.enabled_flag = 'Y' AND

Line 3735: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3731: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3732: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3733: qpcon.prc_context_code, qpcon.prc_context_type
3734: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3735: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3736: WHERE qpseg.segment_id = qppteseg.segment_id AND
3737: qpseg.segment_mapping_column = p_pricing_attr AND
3738: qpseg.prc_context_id = qpcon.prc_context_id AND
3739: qpcon.enabled_flag = 'Y' AND

Line 3914: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3910:
3911: CURSOR l_non_sourced_contexts IS
3912: SELECT DISTINCT qpcon.prc_context_code, qpcon.prc_context_type
3913: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3914: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3915: WHERE qpseg.segment_id = qppteseg.segment_id AND
3916: qpseg.prc_context_id = qpcon.prc_context_id AND
3917: qpcon.enabled_flag = 'Y' AND
3918: qpcon.PRC_CONTEXT_TYPE IN ('PRICING_ATTRIBUTE', 'PRODUCT') AND

Line 4461: qp_pte_segments qppseg

4457: qp_segments_b qpseg,
4458: qp_attribute_sourcing qpsour,
4459: qp_prc_contexts_b qpcon,
4460: qp_pte_request_types_b qpreq,
4461: qp_pte_segments qppseg
4462: WHERE
4463: qpsour.segment_id = qpseg.segment_id
4464: AND qpsour.attribute_sourcing_level = p_sourcing_level
4465: AND qpsour.enabled_flag = 'Y'

Line 4721: qp_pte_segments qppseg

4717: qp_segments_b qpseg,
4718: qp_attribute_sourcing qpsour,
4719: qp_prc_contexts_b qpcon,
4720: qp_pte_request_types_b qpreq,
4721: qp_pte_segments qppseg
4722: WHERE
4723: qpsour.segment_id = qpseg.segment_id
4724: AND qppseg.user_sourcing_method = 'ATTRIBUTE MAPPING'
4725: AND qpseg.prc_context_id = qpcon.prc_context_id

Line 4749: qp_pte_segments qppseg

4745: qp_segments_b qpseg,
4746: qp_attribute_sourcing qpsour,
4747: qp_prc_contexts_b qpcon,
4748: qp_pte_request_types_b qpreq,
4749: qp_pte_segments qppseg
4750: WHERE
4751: qpsour.segment_id = qpseg.segment_id
4752: AND qppseg.user_sourcing_method = 'ATTRIBUTE MAPPING'
4753: AND qpsour.request_type_code = p_request_type_code