[Home] [Help]
636: FROM
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
662: FROM
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
2139: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
2140: --dbms_output.put_line('............2............');
2141: OPEN l_request_type_codes_new FOR
2142: SELECT DISTINCT request_type_code
2143: FROM QP_PTE_REQUEST_TYPES_B
2144: WHERE ENABLED_FLAG = 'Y'; -- 5365644, 5365968
2145:
2146: IF Qp_Code_Control.Get_Code_Release_Level > '110509' THEN
2147: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then --Follow Non-HVOP Path',1);
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
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
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
4183: FROM
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
4417: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4423: l_successful BOOLEAN := TRUE;
4424: l_err_count BINARY_INTEGER := 0;
4425:
4443: FROM
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'
4471: FROM
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'