[Home] [Help]
703: FROM
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
729: FROM
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
2209: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
2210: --dbms_output.put_line('............2............');
2211: OPEN l_request_type_codes_new FOR
2212: SELECT DISTINCT request_type_code
2213: FROM QP_PTE_REQUEST_TYPES_B
2214: WHERE ENABLED_FLAG = 'Y'; -- 5365644, 5365968
2215:
2216: IF Qp_Code_Control.Get_Code_Release_Level > '110509' THEN
2217: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then --Follow Non-HVOP Path',1);
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
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
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
4456: FROM
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
4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4694: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4695: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4696: l_successful BOOLEAN := TRUE;
4697: l_err_count BINARY_INTEGER := 0;
4698:
4716: FROM
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'
4744: FROM
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'