APPS.QP_ATTR_MAPPING_PUB dependencies on QP_PTE_SEGMENTS

Line 447: UPDATE qp_pte_segments

443: END IF;
444:
445: v_count := 1;
446:
447: UPDATE qp_pte_segments
448: SET sourcing_status = 'N',
449: used_in_setup = 'N'
450: WHERE sourcing_status = 'Y' OR used_in_setup = 'Y';
451: LOOP

Line 455: UPDATE qp_pte_segments

451: LOOP
452:
453: EXIT WHEN v_count > G_Segment_Ctr.COUNT;
454: v_segment_id := G_Segment_Ctr(v_count);
455: UPDATE qp_pte_segments
456: SET sourcing_status = 'Y',
457: used_in_setup = 'Y'
458: WHERE segment_id = v_segment_id;
459:

Line 641: qp_pte_segments qppseg

637: qp_segments_b qpseg,
638: qp_attribute_sourcing qpsour,
639: qp_prc_contexts_b qpcon,
640: qp_pte_request_types_b qpreq,
641: qp_pte_segments qppseg
642: WHERE
643: qpsour.segment_id = qpseg.segment_id
644: AND qpsour.attribute_sourcing_level = p_sourcing_level
645: AND qpsour.enabled_flag = 'Y'

Line 667: qp_pte_segments qppseg

663: qp_segments_b qpseg,
664: qp_attribute_sourcing qpsour,
665: qp_prc_contexts_b qpcon,
666: qp_pte_request_types_b qpreq,
667: qp_pte_segments qppseg
668: WHERE
669: qpsour.segment_id = qpseg.segment_id
670: AND qpsour.attribute_sourcing_level = p_sourcing_level
671: AND qpsour.enabled_flag = 'Y'

Line 3300: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3296: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3297: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3298: qpcon.prc_context_code, qpcon.prc_context_type
3299: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3300: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3301: WHERE qpseg.segment_id = qppteseg.segment_id AND
3302: qpseg.segment_mapping_column = p_pricing_attr AND
3303: qpseg.prc_context_id = qpcon.prc_context_id AND
3304: qpcon.enabled_flag = 'Y' AND

Line 3477: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3473: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3474: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3475: qpcon.prc_context_code, qpcon.prc_context_type
3476: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3477: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3478: WHERE qpseg.segment_id = qppteseg.segment_id AND
3479: qpseg.segment_mapping_column = p_pricing_attr AND
3480: qpseg.prc_context_id = qpcon.prc_context_id AND
3481: qpcon.enabled_flag = 'Y' AND

Line 3656: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq

3652:
3653: CURSOR l_non_sourced_contexts IS
3654: SELECT DISTINCT qpcon.prc_context_code, qpcon.prc_context_type
3655: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3656: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3657: WHERE qpseg.segment_id = qppteseg.segment_id AND
3658: qpseg.prc_context_id = qpcon.prc_context_id AND
3659: qpcon.enabled_flag = 'Y' AND
3660: qpcon.PRC_CONTEXT_TYPE IN ('PRICING_ATTRIBUTE', 'PRODUCT') AND

Line 4188: qp_pte_segments qppseg

4184: qp_segments_b qpseg,
4185: qp_attribute_sourcing qpsour,
4186: qp_prc_contexts_b qpcon,
4187: qp_pte_request_types_b qpreq,
4188: qp_pte_segments qppseg
4189: WHERE
4190: qpsour.segment_id = qpseg.segment_id
4191: AND qpsour.attribute_sourcing_level = p_sourcing_level
4192: AND qpsour.enabled_flag = 'Y'

Line 4448: qp_pte_segments qppseg

4444: qp_segments_b qpseg,
4445: qp_attribute_sourcing qpsour,
4446: qp_prc_contexts_b qpcon,
4447: qp_pte_request_types_b qpreq,
4448: qp_pte_segments qppseg
4449: WHERE
4450: qpsour.segment_id = qpseg.segment_id
4451: AND qppseg.user_sourcing_method = 'ATTRIBUTE MAPPING'
4452: AND qpseg.prc_context_id = qpcon.prc_context_id

Line 4476: qp_pte_segments qppseg

4472: qp_segments_b qpseg,
4473: qp_attribute_sourcing qpsour,
4474: qp_prc_contexts_b qpcon,
4475: qp_pte_request_types_b qpreq,
4476: qp_pte_segments qppseg
4477: WHERE
4478: qpsour.segment_id = qpseg.segment_id
4479: AND qppseg.user_sourcing_method = 'ATTRIBUTE MAPPING'
4480: AND qpsour.request_type_code = p_request_type_code