2486:
2487: CURSOR l_line_cur IS
2488: SELECT line_index
2489: FROM qp_npreq_lines_tmp
2490: WHERE line_type_code = Qp_Preq_Pub.G_LINE_LEVEL
2491: AND price_flag IN (Qp_Preq_Pub.G_YES, Qp_Preq_Pub.G_PHASE);
2492:
2493: CURSOR l_order_cur IS
2494: SELECT line_index
2487: CURSOR l_line_cur IS
2488: SELECT line_index
2489: FROM qp_npreq_lines_tmp
2490: WHERE line_type_code = Qp_Preq_Pub.G_LINE_LEVEL
2491: AND price_flag IN (Qp_Preq_Pub.G_YES, Qp_Preq_Pub.G_PHASE);
2492:
2493: CURSOR l_order_cur IS
2494: SELECT line_index
2495: FROM qp_npreq_lines_tmp
2492:
2493: CURSOR l_order_cur IS
2494: SELECT line_index
2495: FROM qp_npreq_lines_tmp
2496: WHERE line_type_code = Qp_Preq_Pub.G_ORDER_LEVEL
2497: AND price_flag IN (Qp_Preq_Pub.G_YES, Qp_Preq_Pub.G_PHASE);
2498:
2499:
2500:
2493: CURSOR l_order_cur IS
2494: SELECT line_index
2495: FROM qp_npreq_lines_tmp
2496: WHERE line_type_code = Qp_Preq_Pub.G_ORDER_LEVEL
2497: AND price_flag IN (Qp_Preq_Pub.G_YES, Qp_Preq_Pub.G_PHASE);
2498:
2499:
2500:
2501: l_price_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2754: K := K + 1;
2755:
2756: l_line_index_tbl(K) := p_line_index;
2757: IF l_price_contexts_result_tbl(i).context_name =
2758: Qp_Preq_Pub.G_ITEM_CONTEXT
2759: THEN
2760: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
2761: ELSE
2762: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
2756: l_line_index_tbl(K) := p_line_index;
2757: IF l_price_contexts_result_tbl(i).context_name =
2758: Qp_Preq_Pub.G_ITEM_CONTEXT
2759: THEN
2760: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
2761: ELSE
2762: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
2763: END IF;
2764: l_context_tbl(K) := l_price_contexts_result_tbl(i).context_name;
2758: Qp_Preq_Pub.G_ITEM_CONTEXT
2759: THEN
2760: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
2761: ELSE
2762: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
2763: END IF;
2764: l_context_tbl(K) := l_price_contexts_result_tbl(i).context_name;
2765: l_attribute_tbl(K) := l_price_contexts_result_tbl(i).attribute_name;
2766: l_value_from_tbl(K) := l_price_contexts_result_tbl(i).attribute_value;
2766: l_value_from_tbl(K) := l_price_contexts_result_tbl(i).attribute_value;
2767:
2768: l_validated_flag_tbl(K) := 'N';
2769: /************** Defaulting for Java Engine ********************/
2770: l_ATTRIBUTE_LEVEL_tbl(K) := Qp_Preq_Pub.G_LINE_LEVEL;
2771: l_LIST_HEADER_ID_tbl(K) := NULL;
2772: l_LIST_LINE_ID_tbl(K) := NULL;
2773: l_SETUP_VALUE_FROM_tbl(K) := NULL;
2774: l_SETUP_VALUE_TO_tbl(K) := NULL;
2774: l_SETUP_VALUE_TO_tbl(K) := NULL;
2775: l_GROUPING_NUMBER_tbl(K) := NULL;
2776: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
2777: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
2778: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
2779: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2780: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2781: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2782: l_DATATYPE_tbl(K) := NULL;
2775: l_GROUPING_NUMBER_tbl(K) := NULL;
2776: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
2777: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
2778: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
2779: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2780: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2781: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2782: l_DATATYPE_tbl(K) := NULL;
2783: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
2779: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2780: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2781: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2782: l_DATATYPE_tbl(K) := NULL;
2783: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
2784: l_QUALIFIER_TYPE_tbl(K) := NULL;
2785: l_PRODUCT_UOM_CODE_tbl(K) := NULL;
2786: l_EXCLUDER_FLAG_tbl(K) := NULL;
2787: l_PRICING_PHASE_ID_tbl(K) := NULL;
2796: LOOP
2797: --sourcing qualifier attributes
2798: K := K + 1;
2799: l_line_index_tbl(K) := p_line_index;
2800: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_QUALIFIER_TYPE;
2801: l_context_tbl(K) := l_qual_contexts_result_tbl(i).context_name;
2802: l_attribute_tbl(K) := l_qual_contexts_result_tbl(i).attribute_name;
2803: l_value_from_tbl(K) := l_qual_contexts_result_tbl(i).attribute_value;
2804:
2802: l_attribute_tbl(K) := l_qual_contexts_result_tbl(i).attribute_name;
2803: l_value_from_tbl(K) := l_qual_contexts_result_tbl(i).attribute_value;
2804:
2805: /************** Defaulting for Java Engine ********************/
2806: l_ATTRIBUTE_LEVEL_tbl(K) := Qp_Preq_Pub.G_LINE_LEVEL;
2807: l_LIST_HEADER_ID_tbl(K) := NULL;
2808: l_LIST_LINE_ID_tbl(K) := NULL;
2809: l_SETUP_VALUE_FROM_tbl(K) := NULL;
2810: l_SETUP_VALUE_TO_tbl(K) := NULL;
2810: l_SETUP_VALUE_TO_tbl(K) := NULL;
2811: l_GROUPING_NUMBER_tbl(K) := NULL;
2812: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
2813: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
2814: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
2815: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2816: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2817: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2818: l_DATATYPE_tbl(K) := NULL;
2811: l_GROUPING_NUMBER_tbl(K) := NULL;
2812: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
2813: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
2814: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
2815: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2816: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2817: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2818: l_DATATYPE_tbl(K) := NULL;
2819: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
2815: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
2816: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
2817: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
2818: l_DATATYPE_tbl(K) := NULL;
2819: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
2820: l_QUALIFIER_TYPE_tbl(K) := NULL;
2821: l_PRODUCT_UOM_CODE_tbl(K) := NULL;
2822: l_EXCLUDER_FLAG_tbl(K) := NULL;
2823: l_PRICING_PHASE_ID_tbl(K) := NULL;
3002: K := K + 1;
3003:
3004: l_line_index_tbl(K) := p_line_index;
3005: IF l_price_contexts_result_tbl(i).context_name =
3006: Qp_Preq_Pub.G_ITEM_CONTEXT
3007: THEN
3008: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
3009: ELSE
3010: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
3004: l_line_index_tbl(K) := p_line_index;
3005: IF l_price_contexts_result_tbl(i).context_name =
3006: Qp_Preq_Pub.G_ITEM_CONTEXT
3007: THEN
3008: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
3009: ELSE
3010: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
3011: END IF;
3012: l_context_tbl(K) := l_price_contexts_result_tbl(i).context_name;
3006: Qp_Preq_Pub.G_ITEM_CONTEXT
3007: THEN
3008: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRODUCT_TYPE;
3009: ELSE
3010: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_PRICING_TYPE;
3011: END IF;
3012: l_context_tbl(K) := l_price_contexts_result_tbl(i).context_name;
3013: l_attribute_tbl(K) := l_price_contexts_result_tbl(i).attribute_name;
3014: l_value_from_tbl(K) := l_price_contexts_result_tbl(i).attribute_value;
3013: l_attribute_tbl(K) := l_price_contexts_result_tbl(i).attribute_name;
3014: l_value_from_tbl(K) := l_price_contexts_result_tbl(i).attribute_value;
3015: l_validated_flag_tbl(K) := 'N';
3016: /************** Defaulting for Java Engine ********************/
3017: l_ATTRIBUTE_LEVEL_tbl(K) := Qp_Preq_Pub.G_LINE_LEVEL;
3018: l_LIST_HEADER_ID_tbl(K) := NULL;
3019: l_LIST_LINE_ID_tbl(K) := NULL;
3020: l_SETUP_VALUE_FROM_tbl(K) := NULL;
3021: l_SETUP_VALUE_TO_tbl(K) := NULL;
3021: l_SETUP_VALUE_TO_tbl(K) := NULL;
3022: l_GROUPING_NUMBER_tbl(K) := NULL;
3023: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
3024: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
3025: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
3026: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3027: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3028: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3029: l_DATATYPE_tbl(K) := NULL;
3022: l_GROUPING_NUMBER_tbl(K) := NULL;
3023: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
3024: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
3025: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
3026: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3027: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3028: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3029: l_DATATYPE_tbl(K) := NULL;
3030: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
3026: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3027: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3028: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3029: l_DATATYPE_tbl(K) := NULL;
3030: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
3031: l_QUALIFIER_TYPE_tbl(K) := NULL;
3032: l_PRODUCT_UOM_CODE_tbl(K) := NULL;
3033: l_EXCLUDER_FLAG_tbl(K) := NULL;
3034: l_PRICING_PHASE_ID_tbl(K) := NULL;
3043: LOOP
3044: --sourcing qualifier attributes
3045: K := K + 1;
3046: l_line_index_tbl(K) := p_line_index;
3047: l_attribute_type_tbl(K) := Qp_Preq_Pub.G_QUALIFIER_TYPE;
3048: l_context_tbl(K) := l_qual_contexts_result_tbl(i).context_name;
3049: l_attribute_tbl(K) := l_qual_contexts_result_tbl(i).attribute_name;
3050: l_value_from_tbl(K) := l_qual_contexts_result_tbl(i).attribute_value;
3051:
3049: l_attribute_tbl(K) := l_qual_contexts_result_tbl(i).attribute_name;
3050: l_value_from_tbl(K) := l_qual_contexts_result_tbl(i).attribute_value;
3051:
3052: /************** Defaulting for Java Engine ********************/
3053: l_ATTRIBUTE_LEVEL_tbl(K) := Qp_Preq_Pub.G_LINE_LEVEL;
3054: l_LIST_HEADER_ID_tbl(K) := NULL;
3055: l_LIST_LINE_ID_tbl(K) := NULL;
3056: l_SETUP_VALUE_FROM_tbl(K) := NULL;
3057: l_SETUP_VALUE_TO_tbl(K) := NULL;
3057: l_SETUP_VALUE_TO_tbl(K) := NULL;
3058: l_GROUPING_NUMBER_tbl(K) := NULL;
3059: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
3060: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
3061: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
3062: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3063: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3064: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3065: l_DATATYPE_tbl(K) := NULL;
3058: l_GROUPING_NUMBER_tbl(K) := NULL;
3059: l_NO_QUALIFIERS_IN_GRP_tbl(K) := NULL;
3060: l_COMPARISON_OPERATOR_TYPE_tbl(K) := NULL;
3061: l_APPLIED_FLAG_tbl(K) := Qp_Preq_Pub.G_LIST_NOT_APPLIED;
3062: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3063: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3064: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3065: l_DATATYPE_tbl(K) := NULL;
3066: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
3062: l_PRICING_STATUS_CODE_tbl(K) := Qp_Preq_Pub.G_STATUS_UNCHANGED;
3063: l_PRICING_STATUS_TEXT_tbl(K) := NULL;
3064: l_QUALIFIER_PRECEDENCE_tbl(K) := NULL;
3065: l_DATATYPE_tbl(K) := NULL;
3066: l_PRICING_ATTR_FLAG_tbl(K) := Qp_Preq_Pub.G_YES;
3067: l_QUALIFIER_TYPE_tbl(K) := NULL;
3068: l_PRODUCT_UOM_CODE_tbl(K) := NULL;
3069: l_EXCLUDER_FLAG_tbl(K) := NULL;
3070: l_PRICING_PHASE_ID_tbl(K) := NULL;
3140: pricing_status_code,
3141: pricing_attr_flag
3142: )
3143: VALUES (l_line_index_tbl(i),
3144: Qp_Preq_Pub.G_LINE_LEVEL,
3145: l_attribute_type_tbl(i),
3146: l_context_tbl(i),
3147: l_attribute_tbl(i),
3148: l_value_from_tbl(i),
3146: l_context_tbl(i),
3147: l_attribute_tbl(i),
3148: l_value_from_tbl(i),
3149: l_validated_flag_tbl(i),
3150: Qp_Preq_Pub.G_LIST_NOT_APPLIED,
3151: Qp_Preq_Pub.G_STATUS_UNCHANGED,
3152: Qp_Preq_Pub.G_YES
3153: );
3154: ELSE -- Java Engine path added by yangli
3147: l_attribute_tbl(i),
3148: l_value_from_tbl(i),
3149: l_validated_flag_tbl(i),
3150: Qp_Preq_Pub.G_LIST_NOT_APPLIED,
3151: Qp_Preq_Pub.G_STATUS_UNCHANGED,
3152: Qp_Preq_Pub.G_YES
3153: );
3154: ELSE -- Java Engine path added by yangli
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3148: l_value_from_tbl(i),
3149: l_validated_flag_tbl(i),
3150: Qp_Preq_Pub.G_LIST_NOT_APPLIED,
3151: Qp_Preq_Pub.G_STATUS_UNCHANGED,
3152: Qp_Preq_Pub.G_YES
3153: );
3154: ELSE -- Java Engine path added by yangli
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3156: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3156: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3157: END IF;
3158: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3159: QP_PREQ_PUB.G_LINE_LEVEL,
3160: l_attribute_type_tbl,
3161: l_context_tbl,
3162: l_attribute_tbl,
3163: l_value_from_tbl,
3161: l_context_tbl,
3162: l_attribute_tbl,
3163: l_value_from_tbl,
3164: l_validated_flag_tbl,
3165: QP_PREQ_PUB.G_LIST_NOT_APPLIED,
3166: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3167: QP_PREQ_PUB.G_YES,
3168: l_status_code ,
3169: l_status_text );
3162: l_attribute_tbl,
3163: l_value_from_tbl,
3164: l_validated_flag_tbl,
3165: QP_PREQ_PUB.G_LIST_NOT_APPLIED,
3166: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3167: QP_PREQ_PUB.G_YES,
3168: l_status_code ,
3169: l_status_text );
3170: */
3163: l_value_from_tbl,
3164: l_validated_flag_tbl,
3165: QP_PREQ_PUB.G_LIST_NOT_APPLIED,
3166: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3167: QP_PREQ_PUB.G_YES,
3168: l_status_code ,
3169: l_status_text );
3170: */
3171: