DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on QP_GLOBALS

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

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;

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

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');

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

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;

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

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)

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

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;

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

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;

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

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;

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).start_date_active := getEffectiveDate(getAdjustmentId(p_offerAdjNewLineId => p_offerAdjNewLineId));
3273: END IF;
3274: END LOOP;
3275: END IF;

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

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;

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

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;

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

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;

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

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;

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

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:

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

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

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

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: (