[Home] [Help]
2400: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2401:
2402: SELECT nvl(seeded_sourcing_method, user_sourcing_method)
2403: INTO l_sourcing_method
2404: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2405: WHERE c.prc_context_code = 'VOLUME'
2406: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2407: AND c.prc_context_id = s.prc_context_id
2408: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
2542: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
2543: IF(v_accum_context IS NOT NULL) AND
2544: (p_MODIFIERS_rec.accum_attribute IS NOT NULL) THEN
2545:
2546: UPDATE qp_pte_segments set used_in_setup='Y'
2547: WHERE nvl(used_in_setup,'N')='N'
2548: AND segment_id IN
2549: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2550: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2606: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2607:
2608: SELECT nvl(seeded_sourcing_method, user_sourcing_method)
2609: INTO l_sourcing_method
2610: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2611: WHERE c.prc_context_code = 'VOLUME'
2612: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2613: AND c.prc_context_id = s.prc_context_id
2614: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute
2863: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
2864: IF(v_accum_context IS NOT NULL) AND
2865: (p_MODIFIERS_rec.accum_attribute IS NOT NULL) THEN
2866:
2867: UPDATE qp_pte_segments set used_in_setup='Y'
2868: WHERE nvl(used_in_setup,'N')='N'
2869: AND segment_id IN
2870: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2871: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute