DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on OE_ORDER_CACHE

Line 549: l_set_rec OE_ORDER_CACHE.set_rec_type;

545: l_inc_tbl OE_Order_PUB.Line_Tbl_Type;
546: l_sales_order_id NUMBER := Null;
547: l_line_rec OE_Order_PUB.Line_Rec_type;
548: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
549: l_set_rec OE_ORDER_CACHE.set_rec_type;
550: l_quantity_to_reserve NUMBER;
551: l_quantity2_to_reserve NUMBER; -- INVCONV
552: l_rsv_update BOOLEAN := FALSE;
553:

Line 705: l_set_rec := OE_ORDER_CACHE.Load_Set

701: x_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
702:
703: IF (x_line_tbl(I).arrival_set_id is not null) THEN
704:
705: l_set_rec := OE_ORDER_CACHE.Load_Set
706: ( x_line_tbl(I).arrival_set_id);
707: x_line_tbl(I).arrival_set := l_set_rec.set_name;
708:
709: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN

Line 711: l_set_rec := OE_ORDER_CACHE.Load_Set

707: x_line_tbl(I).arrival_set := l_set_rec.set_name;
708:
709: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN
710:
711: l_set_rec := OE_ORDER_CACHE.Load_Set
712: ( x_line_tbl(I).Ship_set_id);
713: x_line_tbl(I).ship_set := l_set_rec.set_name;
714:
715: ELSIF (x_line_tbl(I).ship_model_complete_flag ='Y') THEN

Line 940: l_set_rec := OE_ORDER_CACHE.Load_Set

936: x_line_tbl(I) := l_line_rec;
937: x_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
938:
939: IF (x_line_tbl(I).arrival_set_id is not null) THEN
940: l_set_rec := OE_ORDER_CACHE.Load_Set
941: ( x_line_tbl(I).arrival_set_id);
942: x_line_tbl(I).arrival_set := l_set_rec.set_name;
943: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN
944: l_set_rec := OE_ORDER_CACHE.Load_Set

Line 944: l_set_rec := OE_ORDER_CACHE.Load_Set

940: l_set_rec := OE_ORDER_CACHE.Load_Set
941: ( x_line_tbl(I).arrival_set_id);
942: x_line_tbl(I).arrival_set := l_set_rec.set_name;
943: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN
944: l_set_rec := OE_ORDER_CACHE.Load_Set
945: ( x_line_tbl(I).ship_set_id);
946: x_line_tbl(I).ship_set := l_set_rec.set_name;
947: ELSIF (x_line_tbl(I).ship_model_complete_flag ='Y') THEN
948: x_line_tbl(I).ship_set := x_line_tbl(I).top_model_line_id;

Line 1020: l_set_rec := OE_ORDER_CACHE.Load_Set

1016: x_line_tbl(I) := l_line_rec;
1017: -- x_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
1018:
1019: IF (x_line_tbl(I).arrival_set_id is not null) THEN
1020: l_set_rec := OE_ORDER_CACHE.Load_Set
1021: ( x_line_tbl(I).arrival_set_id);
1022: x_line_tbl(I).arrival_set := l_set_rec.set_name;
1023: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN
1024: l_set_rec := OE_ORDER_CACHE.Load_Set

Line 1024: l_set_rec := OE_ORDER_CACHE.Load_Set

1020: l_set_rec := OE_ORDER_CACHE.Load_Set
1021: ( x_line_tbl(I).arrival_set_id);
1022: x_line_tbl(I).arrival_set := l_set_rec.set_name;
1023: ELSIF (x_line_tbl(I).ship_set_id is not null) THEN
1024: l_set_rec := OE_ORDER_CACHE.Load_Set
1025: ( x_line_tbl(I).ship_set_id);
1026: x_line_tbl(I).ship_set := l_set_rec.set_name;
1027: ELSIF (x_line_tbl(I).ship_model_complete_flag ='Y') THEN
1028: x_line_tbl(I).ship_set := x_line_tbl(I).top_model_line_id;

Line 3660: l_set_rec OE_ORDER_CACHE.set_rec_type;

3656:
3657: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3658: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3659: l_line_id_tbl number_arr;
3660: l_set_rec OE_ORDER_CACHE.set_rec_type;
3661:
3662: --
3663: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3664: --

Line 3773: l_set_rec := OE_ORDER_CACHE.Load_Set

3769: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
3770: l_line_tbl(I).schedule_action_code := p_sch_action;
3771:
3772: IF (l_line_tbl(I).arrival_set_id is not null) THEN
3773: l_set_rec := OE_ORDER_CACHE.Load_Set
3774: (l_line_tbl(I).arrival_set_id);
3775: l_line_tbl(I).arrival_set := l_set_rec.set_name;
3776: ELSIF (l_line_tbl(I).ship_set_id is not null) THEN
3777: l_set_rec := OE_ORDER_CACHE.Load_Set

Line 3777: l_set_rec := OE_ORDER_CACHE.Load_Set

3773: l_set_rec := OE_ORDER_CACHE.Load_Set
3774: (l_line_tbl(I).arrival_set_id);
3775: l_line_tbl(I).arrival_set := l_set_rec.set_name;
3776: ELSIF (l_line_tbl(I).ship_set_id is not null) THEN
3777: l_set_rec := OE_ORDER_CACHE.Load_Set
3778: (l_line_tbl(I).ship_set_id);
3779: l_line_tbl(I).ship_set := l_set_rec.set_name;
3780: ELSIF (l_line_tbl(I).ship_model_complete_flag ='Y') THEN
3781: l_line_tbl(I).ship_set := l_line_tbl(I).top_model_line_id;

Line 3998: l_set_rec OE_ORDER_CACHE.set_rec_type;

3994: l_type_code VARCHAR2(30);-- 3564302(issue#1)
3995: --3564310
3996: l_ship_set_id NUMBER;
3997: l_arrival_set_id NUMBER;
3998: l_set_rec OE_ORDER_CACHE.set_rec_type;
3999: l_log_error BOOLEAN := FALSE;
4000: l_part_of_set VARCHAR2(1) :='Y'; --4405004
4001:
4002: -- 3870895

Line 4424: l_set_rec := OE_ORDER_CACHE.Load_Set

4420: l_type_code := oe_schedule_util.Get_Date_Type(l_header_id);
4421:
4422: IF l_arrival_set_id is not null THEN
4423:
4424: l_set_rec := OE_ORDER_CACHE.Load_Set
4425: (l_arrival_set_id);
4426:
4427: ELSIF l_ship_set_id is not null THEN
4428:

Line 4429: l_set_rec := OE_ORDER_CACHE.Load_Set

4425: (l_arrival_set_id);
4426:
4427: ELSIF l_ship_set_id is not null THEN
4428:
4429: l_set_rec := OE_ORDER_CACHE.Load_Set
4430: (l_Ship_set_id);
4431: END IF;
4432:
4433: l_log_error := FALSE;

Line 4860: l_set_rec OE_ORDER_CACHE.set_rec_type;

4856: l_line_rec OE_ORDER_PUB.line_rec_type;
4857: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4858: l_msg_count NUMBER;
4859: l_msg_data VARCHAR2(2000);
4860: l_set_rec OE_ORDER_CACHE.set_rec_type;
4861: l_set_name VARCHAR2(30);
4862: l_set_id NUMBER := null;
4863: l_ship_set_id NUMBER := null;
4864: l_arrival_set_id NUMBER := null;

Line 5089: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id); --3878494

5085:
5086: -- Bypass if required.
5087:
5088: IF nvl(p_request_rec.param12,'N') = 'N' THEN
5089: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id); --3878494
5090:
5091: FOR I IN 1..l_line_tbl.count LOOP
5092:
5093: IF l_line_tbl(I).schedule_status_code IS NULL OR

Line 5292: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);

5288: -- END 1282873
5289: END LOOP;
5290: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5291:
5292: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5293: l_set_name := l_set_rec.set_name;
5294:
5295: FOR I IN 1..l_line_tbl.count LOOP
5296:

Line 5443: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);

5439:
5440: IF l_entity_type =
5441: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5442:
5443: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5444: l_set_name := l_set_rec.set_name;
5445:
5446: /* Added for Bug 6250075 */
5447: /*

Line 5966: l_set_rec OE_ORDER_CACHE.set_rec_type;

5962: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
5963: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
5964: l_sch_line_tbl OE_ORDER_PUB.line_Tbl_type;
5965: l_count NUMBER := 0;
5966: l_set_rec OE_ORDER_CACHE.set_rec_type;
5967: l_msg_count NUMBER;
5968: l_msg_data VARCHAR2(2000);
5969: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5970: l_set_exists VARCHAR2(1);

Line 6120: l_set_rec := OE_ORDER_CACHE.Load_Set

6116:
6117:
6118: IF (l_line_tbl(J).arrival_set_id is not null) THEN
6119:
6120: l_set_rec := OE_ORDER_CACHE.Load_Set
6121: ( l_line_tbl(J).arrival_set_id);
6122: l_sch_line_tbl(l_count).arrival_set := l_set_rec.set_name;
6123: -- 4188166
6124: IF p_sch_set_tbl(I).param5 IS NOT NULL THEN --5151954

Line 6130: l_set_rec := OE_ORDER_CACHE.Load_Set

6126: END IF;
6127:
6128: ELSIF (l_line_tbl(J).ship_set_id is not null) THEN
6129:
6130: l_set_rec := OE_ORDER_CACHE.Load_Set
6131: ( l_line_tbl(J).Ship_set_id);
6132: l_sch_line_tbl(l_count).ship_set := l_set_rec.set_name;
6133: -- 4188166
6134: IF p_sch_set_tbl(I).param5 IS NOT NULL THEN --5151954