256: i := 2;
257: -- this method assumes that the pbh has been poopulated at index 1
258: FOR l_disLines IN c_disLines(cp_pbhListLineId => p_pbhListLineId) LOOP
259: l_pricing_attr_tbl.delete;
260: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
261: x_modifier_line_tbl(i).list_line_type_code := 'DIS';
262: x_modifier_line_tbl(i).start_date_active := null;
263: x_modifier_line_tbl(i).rltd_modifier_grp_type := 'PRICE BREAK';
264: x_modifier_line_tbl(i).rltd_modifier_grp_no := 1;
426:
427: x_limits_rec.amount := l_limits.amount ;
428: x_limits_rec.limit_hold_flag := l_limits.limit_hold_flag ;
429: x_limits_rec.organization_flag := l_limits.organization_flag ;
430: x_limits_rec.operation := QP_GLOBALS.G_OPR_CREATE;
431: x_limits_rec.limit_level_code := l_limits.limit_level_code ;
432: x_limits_rec.basis := l_limits.basis ;
433: x_limits_rec.limit_number := l_limits.limit_number ;
434: x_limits_rec.limit_exceed_action_code:= FND_PROFILE.value('QP_LIMIT_EXCEED_ACTION');
628: --x_return_status := FND_API.G_RET_STS_SUCCESS;
629: IF nvl(px_qualifiers_tbl.count,0) > 0 THEN
630: FOR i in px_qualifiers_tbl.first .. px_qualifiers_tbl.last LOOP
631: IF px_qualifiers_tbl.exists(i) THEN
632: px_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
633: px_qualifiers_tbl(i).list_line_id := p_listLineId;
634: END IF;
635: END LOOP;
636: END IF;
1008: l_pricing_attr_tbl.delete;
1009: i := 1;
1010: FOR l_listLineDetails in c_listLineDetails(cp_listLineId => p_listLineId) LOOP
1011: l_pricing_attr_tbl.delete;
1012: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1013: x_modifier_line_tbl(i).automatic_flag := 'Y';
1014: OZF_VOLUME_OFFER_ADJ.populate_discounts
1015: (
1016: x_modifiers_rec => x_modifier_line_tbl(i)
2067: IF nvl(px_pricing_attr_tbl.count,0) > 0 THEN
2068: FOR i in px_pricing_attr_tbl.first .. px_pricing_attr_tbl.last LOOP
2069: IF px_pricing_attr_tbl.exists(i) THEN
2070: px_pricing_attr_tbl(i).list_line_id := p_toListLineId;
2071: px_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
2072: END IF;
2073: END LOOP;
2074: END IF;
2075: END processTdExclusion;
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN
2752: FOR i in px_modifier_line_tbl.first .. px_modifier_line_tbl.last LOOP
2753: IF px_modifier_line_tbl.exists(i) THEN
2754: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
2755: px_modifier_line_tbl(i).list_line_type_code := 'RLTD';
2756: px_modifier_line_tbl(i).inactive_flag := 'Y';
2757: END IF;
2758: END LOOP;
2983: x_return_status := FND_API.G_RET_STS_SUCCESS;
2984: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN
2985: FOR i in px_modifier_line_tbl.first .. px_modifier_line_tbl.last LOOP
2986: IF px_modifier_line_tbl.exists(i) THEN
2987: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
2988: px_modifier_line_tbl(i).list_line_type_code := 'DIS';
2989: px_modifier_line_tbl(i).inactive_flag := 'Y';
2990: --dbms_output.put_line('Dates :'||px_modifier_line_tbl(i).start_date_active||':'||px_modifier_line_tbl(i).end_date_active);
2991: END IF;
3267: x_return_status := FND_API.G_RET_STS_SUCCESS;
3268: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN
3269: FOR i IN px_modifier_line_tbl.first .. px_modifier_line_tbl.last LOOP
3270: IF px_modifier_line_tbl.exists(i) THEN
3271: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
3272: px_modifier_line_tbl(i).start_date_active := getEffectiveDate(getAdjustmentId(p_offerAdjNewLineId => p_offerAdjNewLineId));
3273: END IF;
3274: END LOOP;
3275: END IF;
3408: BEGIN
3409: x_return_status := FND_API.G_RET_STS_SUCCESS;
3410: i := 1;
3411: FOR l_offerDetails IN c_offerDetails(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
3412: px_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3413: px_modifier_line_rec.start_date_active := l_offerDetails.effective_date;
3414: px_modifier_line_rec.list_header_id := l_offerDetails.list_header_id;
3415: px_modifier_line_rec.accrual_flag := l_offerDetails.accrual_flag;
3416: -- x_modifiers_tbl(i).proration_type_code := l_advOpt.proration_type_code;
3469: x_pricing_attr_tbl(i).pricing_attribute_context := 'VOLUME'; --l_mtLines.pricing_attribute_context;
3470: x_pricing_attr_tbl(i).pricing_attribute := l_productAttributes.volume_type;
3471: x_pricing_attr_tbl(i).comparison_operator_code := 'BETWEEN';
3472: x_pricing_attr_tbl(i).modifiers_index := p_index;
3473: x_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
3474: x_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
3475: x_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;
3476: i := i + 1;
3477: END LOOP;
3499:
3500: BEGIN
3501: x_return_status := FND_API.G_RET_STS_SUCCESS;
3502: FOR l_pbhData IN c_pbhData(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
3503: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3504: x_modifier_line_rec.list_line_type_code := 'PBH';
3505: x_modifier_line_rec.automatic_flag := 'Y';
3506: -- x_modifiers_tbl(i).start_date_active := l_hdrLines.effective_date;
3507: x_modifier_line_rec.end_date_active := l_pbhData.end_date_active;
3567: BEGIN
3568: x_return_status := FND_API.G_RET_STS_SUCCESS;
3569: FOR l_discounts IN c_discounts(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
3570:
3571: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3572: x_modifier_line_rec.list_line_type_code := l_discounts.tier_type;
3573: x_modifier_line_rec.automatic_flag := 'Y';
3574: x_modifier_line_rec.operand := l_discounts.discount;
3575: x_modifier_line_rec.arithmetic_operator := l_discounts.discount_type;
3634: x_pricing_attr_rec.pricing_attr_value_from := l_pricingAttributes.volume_from;
3635: x_pricing_attr_rec.pricing_attr_value_to := l_pricingAttributes.volume_to;
3636: x_pricing_attr_rec.comparison_operator_code := 'BETWEEN';
3637: x_pricing_attr_rec.modifiers_index := p_index;
3638: x_pricing_attr_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3639: END LOOP;
3640: END populateDisPricingAttributes;
3641:
3642:
4132: l_modifier_rec.start_date_active := l_dates.effective_date;
4133: END IF;
4134: END IF;
4135: l_modifier_rec.qp_list_header_id := l_dates.list_header_id;
4136: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4137: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4138: l_modifier_rec.object_version_number := l_dates.object_version_number;
4139: l_offerType := l_dates.offer_type;
4140: OZF_OFFER_PVT.process_modifiers
4133: END IF;
4134: END IF;
4135: l_modifier_rec.qp_list_header_id := l_dates.list_header_id;
4136: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4137: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4138: l_modifier_rec.object_version_number := l_dates.object_version_number;
4139: l_offerType := l_dates.offer_type;
4140: OZF_OFFER_PVT.process_modifiers
4141: (