DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on OE_CONFIG_PVT

Line 830: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;

826: oe_debug_pub.ADD('LINE ID : '||p_x_line_rec.line_id,2);
827: end if;
828: p_x_line_rec.explosion_date := null;
829: l_count := l_count + 1;
830: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;
831: END IF;
832:
833: END IF; -- End if phase is fulfillment
834: -- END QUOTING changes

Line 1180: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count)

1176: if l_debug_level > 0 then
1177: oe_debug_pub.ADD('freeze inc items ' || l_freeze_method,2);
1178: end if;
1179: l_count := l_count + 1;
1180: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count)
1181: := p_x_line_rec.line_id;
1182: END IF;
1183: END IF; -- End if phase is fulfillment
1184: -- END QUOTING changes

Line 1558: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;

1554: p_x_line_rec.line_id = p_x_line_rec.top_model_line_id))
1555: THEN
1556: p_x_line_rec.explosion_date := null;
1557: l_count := l_count + 1;
1558: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;
1559: END IF;
1560:
1561: END IF; -- End if phase is fulfillment
1562: -- END QUOTING changes

Line 4044: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;

4040: p_x_line_rec.line_id = p_x_line_rec.top_model_line_id))
4041: THEN
4042: p_x_line_rec.explosion_date := null;
4043: l_count := l_count + 1;
4044: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(l_count):= p_x_line_rec.line_id;
4045: END IF;
4046:
4047: -- log request to calculate commitment
4048: IF p_x_line_rec.commitment_id IS NOT NULL THEN

Line 4415: and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))

4411:
4412:
4413: IF ((OE_GLOBALS.G_UI_FLAG)
4414: and OE_GLOBALS.G_DEFER_PRICING='N'
4415: and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))
4416: THEN
4417:
4418: l_Price_Control_Rec.pricing_event := 'PRICE';
4419: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

Line 4486: and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))

4482: oe_debug_pub.ADD('Logging delayed request for pricing');
4483: end if;
4484: IF ((OE_GLOBALS.G_UI_FLAG)
4485: and OE_GLOBALS.G_DEFER_PRICING='N'
4486: and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))
4487: OR (p_x_line_rec.item_type_code = 'INCLUDED' and OE_GLOBALS.G_DEFER_PRICING='N')
4488: --RT
4489: and nvl(p_x_line_rec.retrobill_request_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
4490: if l_debug_level > 0 then

Line 9553: OE_Config_Pvt.Delete_Config

9549:
9550: -- Keep all your dependencies in Delete Dependents Procedure
9551: -- If model is deleted, delete from SPC tables
9552: IF l_line.item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
9553: OE_Config_Pvt.Delete_Config
9554: ( p_config_hdr_id => l_line.config_header_id,
9555: p_config_rev_nbr => l_line.config_rev_nbr,
9556: x_return_status => l_return_status );
9557: END IF;

Line 9745: OE_Config_Pvt.Delete_Config

9741: IF p_header_id = FND_API.G_MISS_NUM THEN
9742: -- we already have l_line_rec
9743:
9744: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
9745: OE_Config_Pvt.Delete_Config
9746: ( p_config_hdr_id => l_line_rec.config_header_id,
9747: p_config_rev_nbr => l_line_rec.config_rev_nbr,
9748: x_return_status => l_return_status );
9749: END IF;

Line 16236: (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N') THEN

16232: p_x_line_rec.Ordered_Quantity <> FND_API.G_MISS_NUM THEN
16233:
16234: IF (OE_GLOBALS.G_UI_FLAG) and
16235: OE_GLOBALS.G_DEFER_PRICING='N' and
16236: (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N') THEN
16237: if l_debug_level > 0 then
16238: oe_debug_pub.add('ui mode - delete');
16239: end if;
16240: IF p_x_line_rec.booked_flag='Y' THEN --2442012

Line 17647: I := OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.FIRST;

17643:
17644: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
17645: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
17646:
17647: I := OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.FIRST;
17648: WHILE I is not null
17649: LOOP
17650: if l_debug_level > 0 then
17651: oe_debug_pub.add(I || ' freeze inc items call looping '||p_x_line_rec.line_id, 4);

Line 17653: IF p_x_line_rec.line_id = OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(I)

17649: LOOP
17650: if l_debug_level > 0 then
17651: oe_debug_pub.add(I || ' freeze inc items call looping '||p_x_line_rec.line_id, 4);
17652: end if;
17653: IF p_x_line_rec.line_id = OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL(I)
17654: THEN
17655: if l_debug_level > 0 then
17656: oe_debug_pub.add('PO: Calling freeze_inc_items call', 2);
17657: end if;

Line 17670: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE(I);

17666: end if;
17667:
17668: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
17669:
17670: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE(I);
17671:
17672: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
17673:
17674: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;

Line 17674: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;

17670: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE(I);
17671:
17672: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
17673:
17674: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;
17675: RAISE FND_API.G_EXC_ERROR;
17676:
17677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
17678:

Line 17679: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;

17675: RAISE FND_API.G_EXC_ERROR;
17676:
17677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
17678:
17679: OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;
17680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
17681:
17682: END IF;
17683:

Line 17686: I := OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.NEXT(I);

17682: END IF;
17683:
17684: END IF;
17685:
17686: I := OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.NEXT(I);
17687:
17688: END LOOP;
17689:
17690: ------------------------------------------------------------------------

Line 18159: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN

18155: RAISE FND_API.G_EXC_ERROR;
18156: END IF;
18157:
18158:
18159: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN
18160: oe_debug_pub.add('calling modufy inc items', 3);
18161: OE_Config_Pvt.Modify_Included_Items
18162: (x_return_status => l_return_status);
18163: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;

Line 18161: OE_Config_Pvt.Modify_Included_Items

18157:
18158:
18159: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN
18160: oe_debug_pub.add('calling modufy inc items', 3);
18161: OE_Config_Pvt.Modify_Included_Items
18162: (x_return_status => l_return_status);
18163: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;
18164:
18165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 18163: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;

18159: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN
18160: oe_debug_pub.add('calling modufy inc items', 3);
18161: OE_Config_Pvt.Modify_Included_Items
18162: (x_return_status => l_return_status);
18163: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;
18164:
18165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
18166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
18167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 19583: oe_debug_pub.add('validate: ' || OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 3);

19579: oe_debug_pub.add('new sch sts: ' || p_x_line_rec.schedule_status_code,3);
19580: oe_debug_pub.add('old sch sts: ' || p_old_line_rec.schedule_status_code,3);
19581: oe_debug_pub.add('open flag: ' || p_x_line_rec.open_flag,3);
19582: oe_debug_pub.add('cascade: ' || oe_config_util.CASCADE_CHANGES_FLAG, 3);
19583: oe_debug_pub.add('validate: ' || OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 3);
19584: oe_debug_pub.add('ui: ' || OE_CONFIG_UTIL.G_CONFIG_UI_USED, 3);
19585:
19586: oe_debug_pub.add('old qty2: ' || p_old_line_rec.ordered_quantity2, 3); -- INVCONV
19587: oe_debug_pub.add('new qty2: ' || p_x_line_rec.ordered_quantity2, 3);

Line 19833: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y') OR

19829: IF p_x_line_rec.ato_line_id is NOT NULL AND
19830: p_x_line_rec.ato_line_id <> p_x_line_rec.line_id AND
19831: p_x_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND
19832: ((oe_config_util.CASCADE_CHANGES_FLAG = 'N' AND
19833: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y') OR
19834: OE_CONFIG_UTIL.G_CONFIG_UI_USED = 'Y') AND
19835: l_flag AND
19836: nvl(p_x_line_rec.split_action_code, 'X') <> 'SPLIT' AND -- split update
19837: NOT (p_x_line_rec.split_from_line_id is NOT NULL AND

Line 20187: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN

20183: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
20184: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
20185: p_x_line_rec.line_id <> p_x_line_rec.top_model_line_id)) AND
20186: p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE AND
20187: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
20188:
20189: IF l_model_open_flag = 'N' THEN
20190: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
20191: FND_MESSAGE.Set_Token('MODEL', l_model_item);

Line 20247: oe_debug_pub.add('validate flag: '||OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 1);

20243: ---------------- update/create-------------------------------------
20244:
20245: if l_debug_level > 0 then
20246: oe_debug_pub.add('item_type_code: '||p_x_line_rec.item_type_code, 1);
20247: oe_debug_pub.add('validate flag: '||OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 1);
20248: end if;
20249:
20250: l_flag := FALSE;
20251:

Line 20287: IF l_flag AND OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN

20283: l_config_rev_change := 'Y';
20284: l_flag := TRUE;
20285: END IF;
20286:
20287: IF l_flag AND OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
20288:
20289: if l_debug_level > 0 then
20290: oe_debug_pub.add('p_x_line_rec.operation' || p_x_line_rec.operation, 1);
20291: oe_debug_pub.add

Line 20882: IF NOT OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.EXISTS(l_num) THEN

20878: end if;
20879:
20880: l_num := p_x_line_rec.line_id;
20881:
20882: IF NOT OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.EXISTS(l_num) THEN
20883: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20884: := FND_API.G_MISS_NUM;
20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;

Line 20883: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1

20879:
20880: l_num := p_x_line_rec.line_id;
20881:
20882: IF NOT OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.EXISTS(l_num) THEN
20883: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20884: := FND_API.G_MISS_NUM;
20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;
20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;

Line 20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2

20881:
20882: IF NOT OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.EXISTS(l_num) THEN
20883: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20884: := FND_API.G_MISS_NUM;
20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;
20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;
20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;
20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5

Line 20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;

20883: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20884: := FND_API.G_MISS_NUM;
20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;
20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;
20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;
20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20890: := FND_API.G_MISS_NUM;
20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6

Line 20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;

20884: := FND_API.G_MISS_NUM;
20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;
20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;
20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;
20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20890: := FND_API.G_MISS_NUM;
20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20892: := FND_API.G_MISS_NUM;

Line 20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5

20885: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20886: := FND_API.G_MISS_NUM;
20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;
20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;
20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20890: := FND_API.G_MISS_NUM;
20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20892: := FND_API.G_MISS_NUM;
20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7

Line 20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6

20887: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3 := null;
20888: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4 := null;
20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20890: := FND_API.G_MISS_NUM;
20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20892: := FND_API.G_MISS_NUM;
20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7
20894: := FND_API.G_MISS_NUM;
20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8

Line 20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7

20889: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20890: := FND_API.G_MISS_NUM;
20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20892: := FND_API.G_MISS_NUM;
20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7
20894: := FND_API.G_MISS_NUM;
20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8
20896: := FND_API.G_MISS_NUM;
20897: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9

Line 20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8

20891: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20892: := FND_API.G_MISS_NUM;
20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7
20894: := FND_API.G_MISS_NUM;
20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8
20896: := FND_API.G_MISS_NUM;
20897: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9
20898: := FND_API.G_MISS_NUM;
20899: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1

Line 20897: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9

20893: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7
20894: := FND_API.G_MISS_NUM;
20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8
20896: := FND_API.G_MISS_NUM;
20897: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9
20898: := FND_API.G_MISS_NUM;
20899: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1
20900: := FND_API.G_MISS_DATE;
20901: END IF;

Line 20899: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1

20895: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8
20896: := FND_API.G_MISS_NUM;
20897: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9
20898: := FND_API.G_MISS_NUM;
20899: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1
20900: := FND_API.G_MISS_DATE;
20901: END IF;
20902:
20903: IF p_x_line_rec.operation <> OE_GLOBALS.G_OPR_CREATE AND

Line 20918: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1 =

20914:
20915: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ordered_quantity,
20916: p_old_line_rec.ordered_quantity) THEN
20917:
20918: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1 =
20919: FND_API.G_MISS_NUM THEN
20920: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20921: := p_old_line_rec.ordered_quantity;
20922: if l_debug_level > 0 then

Line 20920: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1

20916: p_old_line_rec.ordered_quantity) THEN
20917:
20918: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1 =
20919: FND_API.G_MISS_NUM THEN
20920: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param1
20921: := p_old_line_rec.ordered_quantity;
20922: if l_debug_level > 0 then
20923: oe_debug_pub.add('qty changed 1st time ' || l_param1, 4);
20924: end if;

Line 20927: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2

20923: oe_debug_pub.add('qty changed 1st time ' || l_param1, 4);
20924: end if;
20925: END IF;
20926:
20927: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20928: := p_x_line_rec.ordered_quantity;
20929: -- new qty
20930:
20931: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3

Line 20931: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3

20927: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param2
20928: := p_x_line_rec.ordered_quantity;
20929: -- new qty
20930:
20931: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3
20932: := p_x_line_rec.change_reason;
20933: -- change_reason
20934:
20935: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4

Line 20935: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4

20931: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param3
20932: := p_x_line_rec.change_reason;
20933: -- change_reason
20934:
20935: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param4
20936: := p_x_line_rec.change_comments;
20937: -- change_comments
20938:
20939: if l_debug_level > 0 then

Line 20949: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5

20945:
20946: END IF;
20947:
20948: IF NOT OE_GLOBALS.Equal(p_x_line_rec.project_id,p_old_line_rec.project_id) THEN
20949: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param5
20950: := p_x_line_rec.project_id;
20951: if l_debug_level > 0 then
20952: oe_debug_pub.add('model/ATO subconfig,project changed: '||l_param5,1);
20953: end if;

Line 20960: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6

20956:
20957:
20958: IF NOT OE_GLOBALS.Equal(p_x_line_rec.task_id,p_old_line_rec.task_id)
20959: THEN
20960: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param6
20961: := p_x_line_rec.task_id;
20962: if l_debug_level > 0 then
20963: oe_debug_pub.add('model /ATO subconfig,task changed: '||l_param6,1);
20964: end if;

Line 20972: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7

20968:
20969: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_tolerance_above,
20970: p_old_line_rec.ship_tolerance_above)
20971: THEN
20972: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param7
20973: := p_x_line_rec.ship_tolerance_above;
20974: l_modify_included_items := TRUE;
20975: END IF;
20976:

Line 20980: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8

20976:
20977: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_tolerance_below,
20978: p_old_line_rec.ship_tolerance_below)
20979: THEN
20980: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param8
20981: := p_x_line_rec.ship_tolerance_below;
20982: l_modify_included_items := TRUE;
20983: END IF;
20984:

Line 20989: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9

20985: IF OE_GLOBALS.G_CHANGE_CFG_FLAG = 'Y' THEN
20986: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
20987: p_old_line_rec.ship_to_org_id)
20988: THEN
20989: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param9
20990: := p_x_line_rec.ship_to_org_id;
20991: l_modify_included_items := TRUE;
20992: END IF;
20993:

Line 20997: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1

20993:
20994: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,
20995: p_old_line_rec.request_date)
20996: THEN
20997: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).date_param1
20998: := p_x_line_rec.request_date;
20999: l_modify_included_items := TRUE;
21000: END IF;
21001: END IF;

Line 21015: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param10 :=

21011: if l_debug_level > 0 then
21012: oe_debug_pub.add('something changed'|| p_x_line_rec.operation, 2);
21013: end if;
21014:
21015: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param10 :=
21016: p_x_line_rec.operation;
21017:
21018: IF OE_Sales_Can_Util.G_Require_Reason THEN
21019: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'Y';

Line 21019: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'Y';

21015: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param10 :=
21016: p_x_line_rec.operation;
21017:
21018: IF OE_Sales_Can_Util.G_Require_Reason THEN
21019: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'Y';
21020: ELSE
21021: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'N';
21022: END IF;
21023:

Line 21021: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'N';

21017:
21018: IF OE_Sales_Can_Util.G_Require_Reason THEN
21019: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'Y';
21020: ELSE
21021: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'N';
21022: END IF;
21023:
21024: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param12 :=
21025: p_x_line_rec.line_id;

Line 21024: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param12 :=

21020: ELSE
21021: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param11 := 'N';
21022: END IF;
21023:
21024: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param12 :=
21025: p_x_line_rec.line_id;
21026:
21027: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param13 :=
21028: p_x_line_rec.top_model_line_id;

Line 21027: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param13 :=

21023:
21024: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param12 :=
21025: p_x_line_rec.line_id;
21026:
21027: OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL(l_num).param13 :=
21028: p_x_line_rec.top_model_line_id;
21029: END IF;
21030:
21031: x_return_status := l_return_status;