DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on QP_GLOBALS

Line 262: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

258: i := 2;
259: -- this method assumes that the pbh has been poopulated at index 1
260: FOR l_disLines IN c_disLines(cp_pbhListLineId => p_pbhListLineId) LOOP
261: l_pricing_attr_tbl.delete;
262: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
263: x_modifier_line_tbl(i).list_line_type_code := 'DIS';
264: x_modifier_line_tbl(i).start_date_active := null;
265: x_modifier_line_tbl(i).rltd_modifier_grp_type := 'PRICE BREAK';
266: x_modifier_line_tbl(i).rltd_modifier_grp_no := 1;

Line 432: x_limits_rec.operation := QP_GLOBALS.G_OPR_CREATE;

428:
429: x_limits_rec.amount := l_limits.amount ;
430: x_limits_rec.limit_hold_flag := l_limits.limit_hold_flag ;
431: x_limits_rec.organization_flag := l_limits.organization_flag ;
432: x_limits_rec.operation := QP_GLOBALS.G_OPR_CREATE;
433: x_limits_rec.limit_level_code := l_limits.limit_level_code ;
434: x_limits_rec.basis := l_limits.basis ;
435: x_limits_rec.limit_number := l_limits.limit_number ;
436: x_limits_rec.limit_exceed_action_code:= FND_PROFILE.value('QP_LIMIT_EXCEED_ACTION');

Line 634: px_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

630: --x_return_status := FND_API.G_RET_STS_SUCCESS;
631: IF nvl(px_qualifiers_tbl.count,0) > 0 THEN
632: FOR i in px_qualifiers_tbl.first .. px_qualifiers_tbl.last LOOP
633: IF px_qualifiers_tbl.exists(i) THEN
634: px_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
635: px_qualifiers_tbl(i).list_line_id := p_listLineId;
636: END IF;
637: END LOOP;
638: END IF;

Line 1014: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

1010: l_pricing_attr_tbl.delete;
1011: i := 1;
1012: FOR l_listLineDetails in c_listLineDetails(cp_listLineId => p_listLineId) LOOP
1013: l_pricing_attr_tbl.delete;
1014: x_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1015: x_modifier_line_tbl(i).automatic_flag := 'Y';
1016: OZF_VOLUME_OFFER_ADJ.populate_discounts
1017: (
1018: x_modifiers_rec => x_modifier_line_tbl(i)

Line 2355: px_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

2351: IF nvl(px_pricing_attr_tbl.count,0) > 0 THEN
2352: FOR i in px_pricing_attr_tbl.first .. px_pricing_attr_tbl.last LOOP
2353: IF px_pricing_attr_tbl.exists(i) THEN
2354: px_pricing_attr_tbl(i).list_line_id := p_toListLineId;
2355: px_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
2356: END IF;
2357: END LOOP;
2358: END IF;
2359: END processTdExclusion;

Line 3038: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

3034: x_return_status := FND_API.G_RET_STS_SUCCESS;
3035: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN
3036: FOR i in px_modifier_line_tbl.first .. px_modifier_line_tbl.last LOOP
3037: IF px_modifier_line_tbl.exists(i) THEN
3038: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
3039: px_modifier_line_tbl(i).list_line_type_code := 'RLTD';
3040: px_modifier_line_tbl(i).inactive_flag := 'Y';
3041: END IF;
3042: END LOOP;

Line 3271: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

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).list_line_type_code := 'DIS';
3273: px_modifier_line_tbl(i).inactive_flag := 'Y';
3274: --dbms_output.put_line('Dates :'||px_modifier_line_tbl(i).start_date_active||':'||px_modifier_line_tbl(i).end_date_active);
3275: END IF;

Line 3565: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

3561: IF px_modifier_line_tbl.exists(i) THEN
3562: OPEN c_endDate;
3563: FETCH c_endDate INTO l_endDate;
3564: CLOSE c_endDate;
3565: px_modifier_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
3566: px_modifier_line_tbl(i).start_date_active := getEffectiveDate(getAdjustmentId(p_offerAdjNewLineId => p_offerAdjNewLineId));
3567: px_modifier_line_tbl(i).end_date_active := TRUNC(l_endDate);
3568: END IF;
3569: END LOOP;

Line 3958: px_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;

3954: BEGIN
3955: x_return_status := FND_API.G_RET_STS_SUCCESS;
3956: i := 1;
3957: FOR l_offerDetails IN c_offerDetails(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
3958: px_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3959: px_modifier_line_rec.start_date_active := l_offerDetails.effective_date;
3960: px_modifier_line_rec.list_header_id := l_offerDetails.list_header_id;
3961: px_modifier_line_rec.accrual_flag := l_offerDetails.accrual_flag;
3962: -- x_modifiers_tbl(i).proration_type_code := l_advOpt.proration_type_code;

Line 4019: x_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

4015: x_pricing_attr_tbl(i).pricing_attribute_context := 'VOLUME'; --l_mtLines.pricing_attribute_context;
4016: x_pricing_attr_tbl(i).pricing_attribute := l_productAttributes.volume_type;
4017: x_pricing_attr_tbl(i).comparison_operator_code := 'BETWEEN';
4018: x_pricing_attr_tbl(i).modifiers_index := p_index;
4019: x_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
4020: x_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
4021: x_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;
4022: i := i + 1;
4023: END LOOP;

Line 4049: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;

4045:
4046: BEGIN
4047: x_return_status := FND_API.G_RET_STS_SUCCESS;
4048: FOR l_pbhData IN c_pbhData(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
4049: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
4050: x_modifier_line_rec.list_line_type_code := 'PBH';
4051: x_modifier_line_rec.automatic_flag := 'Y';
4052: -- x_modifiers_tbl(i).start_date_active := l_hdrLines.effective_date;
4053: x_modifier_line_rec.end_date_active := l_pbhData.end_date_active;

Line 4117: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;

4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: FOR l_discounts IN c_discounts(cp_offerAdjNewLineId => p_offerAdjNewLineId) LOOP
4116:
4117: x_modifier_line_rec.operation := QP_GLOBALS.G_OPR_CREATE;
4118: x_modifier_line_rec.list_line_type_code := l_discounts.tier_type;
4119: x_modifier_line_rec.automatic_flag := 'Y';
4120: x_modifier_line_rec.operand := l_discounts.discount;
4121: x_modifier_line_rec.arithmetic_operator := l_discounts.discount_type;

Line 4184: x_pricing_attr_rec.operation := QP_GLOBALS.G_OPR_CREATE;

4180: x_pricing_attr_rec.pricing_attr_value_from := l_pricingAttributes.volume_from;
4181: x_pricing_attr_rec.pricing_attr_value_to := l_pricingAttributes.volume_to;
4182: x_pricing_attr_rec.comparison_operator_code := 'BETWEEN';
4183: x_pricing_attr_rec.modifiers_index := p_index;
4184: x_pricing_attr_rec.operation := QP_GLOBALS.G_OPR_CREATE;
4185: END LOOP;
4186: END populateDisPricingAttributes;
4187:
4188:

Line 4684: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;

4680: l_modifier_rec.start_date_active := l_dates.effective_date;
4681: END IF;
4682: END IF;
4683: l_modifier_rec.qp_list_header_id := l_dates.list_header_id;
4684: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4685: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4686: l_modifier_rec.object_version_number := l_dates.object_version_number;
4687: l_offerType := l_dates.offer_type;
4688: OZF_OFFER_PVT.process_modifiers

Line 4685: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;

4681: END IF;
4682: END IF;
4683: l_modifier_rec.qp_list_header_id := l_dates.list_header_id;
4684: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4685: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4686: l_modifier_rec.object_version_number := l_dates.object_version_number;
4687: l_offerType := l_dates.offer_type;
4688: OZF_OFFER_PVT.process_modifiers
4689: (