[Home] [Help]
2866: BEGIN
2867: select 'Y' into l_hierarchy_enabled
2868: from dual
2869: where exists(select 'X'
2870: from qp_segments_b qs,qp_prc_contexts_b qpc
2871: where
2872: qs.prc_context_id = qpc.prc_context_id and
2873: qpc.prc_context_code = p_qualifier_rec.qualifier_context(I) and
2874: qs.segment_mapping_column = p_qualifier_rec.qualifier_attribute(I) and
3272: IF p_qualifier_rec.process_status_flag(I) ='P' THEN --IS NOT NULL THEN
3273: BEGIN
3274: SELECT f.segment_level
3275: INTO l_seg_level
3276: FROM qp_prc_contexts_b d,
3277: qp_segments_b e, qp_pte_segments f
3278: WHERE d.prc_context_code =p_qualifier_rec.qualifier_context(I)
3279: AND e.segment_mapping_column = p_qualifier_rec.qualifier_attribute(I)
3280: AND d.prc_context_id = e.prc_context_id
4039: p_pricing_attr_rec.pricing_attribute(I) IS NOT NULL THEN
4040: BEGIN
4041: select s.availability_in_basic
4042: into l_availability_in_basic
4043: from qp_segments_b s, qp_prc_contexts_b c
4044: where s.prc_context_id = c.prc_context_id
4045: and c.prc_context_code = p_pricing_attr_rec.pricing_attribute_context(I)
4046: and s.segment_mapping_column = p_pricing_attr_rec.pricing_attribute(I)
4047: and s.availability_in_basic = 'Y';
4059: p_pricing_attr_rec.product_attribute(I) IS NOT NULL THEN
4060: BEGIN
4061: select s.availability_in_basic
4062: into l_availability_in_basic
4063: from qp_segments_b s, qp_prc_contexts_b c
4064: where s.prc_context_id = c.prc_context_id
4065: and c.prc_context_code = p_pricing_attr_rec.product_attribute_context(I)
4066: and s.segment_mapping_column = p_pricing_attr_rec.product_attribute(I)
4067: and s.availability_in_basic = 'Y';
4284: l_exist := 0;
4285: begin
4286: SELECT 1
4287: into l_exist
4288: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,
4289: qp_segments_b e, qp_pte_segments f
4290: WHERE orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
4291: AND b.product_attribute_context = d.prc_context_code
4292: AND b.product_attribute = e.segment_mapping_column
5892: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5893: AND NOT EXISTS (
5894: SELECT 'x'
5895: FROM qp_interface_qualifiers b,
5896: qp_prc_contexts_b d,
5897: qp_segments_b e,
5898: qp_pte_segments f
5899: WHERE b.qualifier_context = d.prc_context_code
5900: AND b.qualifier_attribute = e.segment_mapping_column
5926: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5927: AND NOT EXISTS (
5928: SELECT 'x'
5929: FROM qp_interface_qualifiers b,
5930: qp_prc_contexts_b d,
5931: qp_segments_b e,
5932: qp_pte_segments f
5933: WHERE b.qualifier_context = d.prc_context_code
5934: and e.segment_code = b.qualifier_attribute_code
5958: AND qpiq.qualifier_attribute_code is null
5959: AND NOT EXISTS (
5960: SELECT 'x'
5961: FROM qp_interface_qualifiers b,
5962: qp_prc_contexts_b d,
5963: qp_segments_b e,
5964: qp_pte_segments f
5965: WHERE b.qualifier_context = d.prc_context_code
5966: AND b.qualifier_attribute = e.segment_mapping_column
6467: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
6468: AND qpip.pricing_attribute_context IS NULL
6469: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6470: AND EXISTS ( SELECT 'x'
6471: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6472: WHERE b.product_attribute_context = d.prc_context_code
6473: AND b.product_attribute = e.segment_mapping_column
6474: and e.segment_code = b.product_attr_code
6475: AND d.prc_context_id = e.prc_context_id
6479: AND f.segment_level <> 'LINE'
6480: AND qpip.rowid = b.rowid
6481: union
6482: SELECT 'x'
6483: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6484: WHERE b.product_attribute_context = d.prc_context_code
6485: AND b.product_attribute is NULL and e.segment_code = b.product_attr_code
6486: AND d.prc_context_id = e.prc_context_id
6487: AND d.prc_context_type = 'PRODUCT'
6519: AND qpip.product_attr_code IS NOT NULL
6520: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6521: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6522: AND NOT EXISTS ( SELECT 'x'
6523: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6524: WHERE b.product_attribute_context = d.prc_context_code
6525: AND b.product_attribute = e.segment_mapping_column
6526: and e.segment_code = b.product_attr_code
6527: AND d.prc_context_id = e.prc_context_id
6552: AND qpip.product_attr_code IS NOT NULL
6553: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6554: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6555: AND NOT EXISTS ( SELECT 'x'
6556: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6557: WHERE b.product_attribute_context = d.prc_context_code
6558: and e.segment_code = b.product_attr_code
6559: AND d.prc_context_id = e.prc_context_id
6560: AND d.prc_context_type = 'PRODUCT'
6583: AND qpip.product_attribute IS NOT NULL
6584: AND qpip.product_attr_code IS NULL
6585: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6586: AND NOT EXISTS ( SELECT 'x'
6587: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6588: WHERE b.product_attribute_context = d.prc_context_code
6589: AND b.product_attribute = e.segment_mapping_column
6590: AND d.prc_context_id = e.prc_context_id
6591: AND d.prc_context_type = 'PRODUCT'
6621: AND qpip.pricing_attr_code IS NOT NULL
6622: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6623: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6624: AND NOT EXISTS ( SELECT 'x'
6625: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6626: WHERE b.pricing_attribute_context = d.prc_context_code
6627: AND b.pricing_attribute = e.segment_mapping_column
6628: and e.segment_code = b.pricing_attr_code
6629: AND d.prc_context_id = e.prc_context_id
6654: AND qpip.pricing_attr_code IS NOT NULL
6655: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6656: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6657: AND NOT EXISTS ( SELECT 'x'
6658: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6659: WHERE b.pricing_attribute_context = d.prc_context_code
6660: and e.segment_code = b.pricing_attr_code
6661: AND d.prc_context_id = e.prc_context_id
6662: AND d.prc_context_type = 'PRICING_ATTRIBUTE'
6685: AND qpip.pricing_attribute IS NOT NULL
6686: AND qpip.pricing_attr_code IS NULL
6687: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6688: AND NOT EXISTS ( SELECT 'x'
6689: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6690: WHERE b.pricing_attribute_context = d.prc_context_code
6691: AND b.pricing_attribute = e.segment_mapping_column
6692: AND d.prc_context_id = e.prc_context_id
6693: AND d.prc_context_type = 'PRICING_ATTRIBUTE'