[Home] [Help]
2471: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2472:
2473: SELECT nvl(user_sourcing_method,seeded_sourcing_method)
2474: INTO l_sourcing_method
2475: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2476: WHERE c.prc_context_code = 'VOLUME'
2477: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2478: AND c.prc_context_id = s.prc_context_id
2479: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
2615: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
2616: IF(v_accum_context IS NOT NULL) AND
2617: (p_MODIFIERS_rec.accum_attribute IS NOT NULL) THEN
2618:
2619: UPDATE qp_pte_segments set used_in_setup='Y'
2620: WHERE nvl(used_in_setup,'N')='N'
2621: AND segment_id IN
2622: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2623: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2679: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2680:
2681: SELECT nvl(user_sourcing_method,seeded_sourcing_method)
2682: INTO l_sourcing_method
2683: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2684: WHERE c.prc_context_code = 'VOLUME'
2685: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2686: AND c.prc_context_id = s.prc_context_id
2687: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
2940: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
2941: IF(v_accum_context IS NOT NULL) AND
2942: (p_MODIFIERS_rec.accum_attribute IS NOT NULL) THEN
2943:
2944: UPDATE qp_pte_segments set used_in_setup='Y'
2945: WHERE nvl(used_in_setup,'N')='N'
2946: AND segment_id IN
2947: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2948: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute