eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_GROUP_SCH_UTIL dependencies on OE_ORDER_PUB

Line 62: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

58: we will perform scheduling on lines on hold. If it is
59: set to 'N', we will not perform scheduling.
60: --------------------------------------------------------------------- */
61: Procedure Validate_Group_Line
62: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
63: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
64: IS
65: l_msg_count NUMBER;
66: l_msg_data VARCHAR2(2000);

Line 255: (p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

251: Description : Validate Group calls Validate Line and if the call is success
252: then and pass the record back to the caller. If it is a expected error, then ignore the record and if it is a unexpected error raise the error and stop the process.
253: --------------------------------------------------------------------- */
254: Procedure Validate_Group
255: (p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
256: p_sch_action IN VARCHAR2,
257: p_validate_action IN VARCHAR2 DEFAULT 'PARTIAL', --for bug 3590437
258: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
259: IS

Line 262: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

258: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
259: IS
260: l_return_status VARCHAR2(30);
261: J NUMBER := 0;
262: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
263: --
264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
265: --
266: BEGIN

Line 426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

422: with the existing l_line_tbl plsql Table
423: Bug Number:2319608
424:
425: Procedure Check_Merge_Line(
426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
428: := OE_Order_PUB.G_MISS_LINE_TBL,
429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type
430: := OE_Order_PUB.G_MISS_LINE_REC)

Line 427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

423: Bug Number:2319608
424:
425: Procedure Check_Merge_Line(
426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
428: := OE_Order_PUB.G_MISS_LINE_TBL,
429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type
430: := OE_Order_PUB.G_MISS_LINE_REC)
431: IS

Line 428: := OE_Order_PUB.G_MISS_LINE_TBL,

424:
425: Procedure Check_Merge_Line(
426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
428: := OE_Order_PUB.G_MISS_LINE_TBL,
429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type
430: := OE_Order_PUB.G_MISS_LINE_REC)
431: IS
432: J NUMBER;

Line 429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type

425: Procedure Check_Merge_Line(
426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
428: := OE_Order_PUB.G_MISS_LINE_TBL,
429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type
430: := OE_Order_PUB.G_MISS_LINE_REC)
431: IS
432: J NUMBER;
433: l_option_exists VARCHAR2(1) := 'N';

Line 430: := OE_Order_PUB.G_MISS_LINE_REC)

426: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
427: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
428: := OE_Order_PUB.G_MISS_LINE_TBL,
429: p_line_rec IN OE_ORDER_PUB.Line_rec_Type
430: := OE_Order_PUB.G_MISS_LINE_REC)
431: IS
432: J NUMBER;
433: l_option_exists VARCHAR2(1) := 'N';
434:

Line 495: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

491: exist in the line table else FALSE
492: Added for Bug-2454163
493: ------------------------------------------------------------------*/
494:
495: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
496: p_line_id IN NUMBER)
497: Return BOOLEAN
498: IS
499: --

Line 541: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

537: ---------------------------------------------------------------------*/
538: PROCEDURE Query_Lines
539: ( p_header_id IN NUMBER,
540: p_sch_action IN VARCHAR2,
541: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
542: )
543: IS
544: I NUMBER;
545: l_inc_tbl OE_Order_PUB.Line_Tbl_Type;

Line 545: l_inc_tbl OE_Order_PUB.Line_Tbl_Type;

541: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
542: )
543: IS
544: I NUMBER;
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;

Line 547: l_line_rec OE_Order_PUB.Line_Rec_type;

543: IS
544: I NUMBER;
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

Line 1423: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

1419: ----------------------------------------------------------------- */
1420: PROCEDURE Query_Schedule_Lines
1421: ( p_selected_tbl IN OE_GLOBALS.Selected_record_Tbl, --R12.MOAC
1422: p_sch_action IN VARCHAR2,
1423: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1424: )
1425: IS
1426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1427: l_line_rec OE_Order_PUB.Line_rec_Type;

Line 1426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1422: p_sch_action IN VARCHAR2,
1423: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1424: )
1425: IS
1426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1427: l_line_rec OE_Order_PUB.Line_rec_Type;
1428: l_line_id NUMBER;
1429: l_arrival_set_id NUMBER;
1430: l_ship_set_id NUMBER;

Line 1427: l_line_rec OE_Order_PUB.Line_rec_Type;

1423: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1424: )
1425: IS
1426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1427: l_line_rec OE_Order_PUB.Line_rec_Type;
1428: l_line_id NUMBER;
1429: l_arrival_set_id NUMBER;
1430: l_ship_set_id NUMBER;
1431: l_top_model_line_id NUMBER;

Line 1800: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

1796: ----------------------------------------------------------------- */
1797: PROCEDURE Query_Unschedule_Lines
1798: ( p_selected_tbl IN OE_GLOBALS.Selected_record_Tbl, --R12.MOAC
1799: p_sch_action IN VARCHAR2,
1800: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1801: )
1802: IS
1803: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1804: l_line_rec OE_Order_PUB.Line_rec_Type;

Line 1803: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1799: p_sch_action IN VARCHAR2,
1800: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1801: )
1802: IS
1803: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1804: l_line_rec OE_Order_PUB.Line_rec_Type;
1805: l_line_id NUMBER;
1806: l_arrival_set_id NUMBER;
1807: l_ship_set_id NUMBER;

Line 1804: l_line_rec OE_Order_PUB.Line_rec_Type;

1800: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1801: )
1802: IS
1803: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1804: l_line_rec OE_Order_PUB.Line_rec_Type;
1805: l_line_id NUMBER;
1806: l_arrival_set_id NUMBER;
1807: l_ship_set_id NUMBER;
1808: l_top_model_line_id NUMBER;

Line 2202: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2198: ----------------------------------------------------------------- */
2199: PROCEDURE Query_Unreserve_Lines
2200: ( p_selected_tbl IN OE_GLOBALS.Selected_record_Tbl, --R12.MOAC
2201: p_sch_action IN VARCHAR2,
2202: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2203: )
2204: IS
2205: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2206: l_line_rec OE_Order_PUB.Line_rec_Type;

Line 2205: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2201: p_sch_action IN VARCHAR2,
2202: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2203: )
2204: IS
2205: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2206: l_line_rec OE_Order_PUB.Line_rec_Type;
2207: l_line_id NUMBER;
2208: l_arrival_set_id NUMBER;
2209: l_ship_set_id NUMBER;

Line 2206: l_line_rec OE_Order_PUB.Line_rec_Type;

2202: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2203: )
2204: IS
2205: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2206: l_line_rec OE_Order_PUB.Line_rec_Type;
2207: l_line_id NUMBER;
2208: l_arrival_set_id NUMBER;
2209: l_ship_set_id NUMBER;
2210: l_top_model_line_id NUMBER;

Line 2531: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2527: ------------------------------------------------------------------*/
2528: PROCEDURE Query_Reserve_Lines
2529: ( p_selected_tbl IN OE_GLOBALS.Selected_record_Tbl, --R12.MOAC
2530: p_sch_action IN VARCHAR2,
2531: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2532: )
2533: IS
2534: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2535: l_line_rec OE_Order_PUB.Line_rec_Type;

Line 2534: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2530: p_sch_action IN VARCHAR2,
2531: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2532: )
2533: IS
2534: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2535: l_line_rec OE_Order_PUB.Line_rec_Type;
2536: l_line_id NUMBER;
2537: l_arrival_set_id NUMBER;
2538: l_ship_set_id NUMBER;

Line 2535: l_line_rec OE_Order_PUB.Line_rec_Type;

2531: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2532: )
2533: IS
2534: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2535: l_line_rec OE_Order_PUB.Line_rec_Type;
2536: l_line_id NUMBER;
2537: l_arrival_set_id NUMBER;
2538: l_ship_set_id NUMBER;
2539: l_top_model_line_id NUMBER;

Line 3115: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

3111: ------------------------------------------------------------------*/
3112: PROCEDURE Query_ATP_CHECK_Lines
3113: ( p_selected_tbl IN OE_GLOBALS.Selected_record_Tbl, --R12.MOAC
3114: p_sch_action IN VARCHAR2,
3115: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3116: )
3117: IS
3118: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3119: l_line_rec OE_Order_PUB.Line_rec_Type;

Line 3118: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3114: p_sch_action IN VARCHAR2,
3115: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3116: )
3117: IS
3118: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3119: l_line_rec OE_Order_PUB.Line_rec_Type;
3120: l_line_id NUMBER;
3121: l_arrival_set_id NUMBER;
3122: l_ship_set_id NUMBER;

Line 3119: l_line_rec OE_Order_PUB.Line_rec_Type;

3115: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3116: )
3117: IS
3118: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3119: l_line_rec OE_Order_PUB.Line_rec_Type;
3120: l_line_id NUMBER;
3121: l_arrival_set_id NUMBER;
3122: l_ship_set_id NUMBER;
3123: l_top_model_line_id NUMBER;

Line 3479: l_line_tbl OE_ORDER_PUB.Line_tbl_type;

3475: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3476: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3477: IS
3478:
3479: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
3480: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
3481: l_return_status VARCHAR2(1);
3482: l_msg_count NUMBER;
3483: l_msg_data VARCHAR2(2000);

Line 3480: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;

3476: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3477: IS
3478:
3479: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
3480: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
3481: l_return_status VARCHAR2(1);
3482: l_msg_count NUMBER;
3483: l_msg_data VARCHAR2(2000);
3484:

Line 3657: l_line_tbl OE_ORDER_PUB.line_tbl_type;

3653: --l_record_ids VARCHAR2(32000) := p_line_list || ',';
3654:
3655: l_line_id NUMBER;
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:

Line 3658: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

3654:
3655: l_line_id NUMBER;
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: --

Line 3976: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

3972: Changes have been made to copy override_atp flag from model/class/
3973: kit to it's included items when the flag is set.
3974: -------------------------------------------------------------------*/
3975: Procedure Schedule_set_lines
3976: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
3977: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3978: IS
3979: l_line_rec OE_ORDER_PUB.line_rec_type;
3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;

Line 3979: l_line_rec OE_ORDER_PUB.line_rec_type;

3975: Procedure Schedule_set_lines
3976: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
3977: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3978: IS
3979: l_line_rec OE_ORDER_PUB.line_rec_type;
3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
3981: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
3982: l_request_rec OE_ORDER_PUB.request_rec_type;
3983: l_old_set_tbl set_tbl_type;

Line 3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;

3976: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
3977: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3978: IS
3979: l_line_rec OE_ORDER_PUB.line_rec_type;
3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
3981: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
3982: l_request_rec OE_ORDER_PUB.request_rec_type;
3983: l_old_set_tbl set_tbl_type;
3984: l_sales_order_id NUMBER;

Line 3981: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;

3977: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3978: IS
3979: l_line_rec OE_ORDER_PUB.line_rec_type;
3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
3981: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
3982: l_request_rec OE_ORDER_PUB.request_rec_type;
3983: l_old_set_tbl set_tbl_type;
3984: l_sales_order_id NUMBER;
3985: l_line_exists VARCHAR2(1) := 'N';

Line 3982: l_request_rec OE_ORDER_PUB.request_rec_type;

3978: IS
3979: l_line_rec OE_ORDER_PUB.line_rec_type;
3980: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
3981: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
3982: l_request_rec OE_ORDER_PUB.request_rec_type;
3983: l_old_set_tbl set_tbl_type;
3984: l_sales_order_id NUMBER;
3985: l_line_exists VARCHAR2(1) := 'N';
3986: l_iline_tbl OE_ORDER_PUB.line_Tbl_type;

Line 3986: l_iline_tbl OE_ORDER_PUB.line_Tbl_type;

3982: l_request_rec OE_ORDER_PUB.request_rec_type;
3983: l_old_set_tbl set_tbl_type;
3984: l_sales_order_id NUMBER;
3985: l_line_exists VARCHAR2(1) := 'N';
3986: l_iline_tbl OE_ORDER_PUB.line_Tbl_type;
3987: l_item_type_code VARCHAR2(30);
3988: l_link_to_line_id NUMBER;
3989: l_top_model_line_id NUMBER;
3990: l_ato_line_id NUMBER;

Line 4169: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

4165:
4166: IF l_debug_level > 0 THEN
4167: oe_debug_pub.add( 'LINE IS SELECTED FOR PROCESSING ' || P_SCH_SET_TBL ( I ) .ENTITY_ID , 1 ) ;
4168: END IF;
4169: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
4170: OE_LINE_UTIL.Lock_Row(p_line_id => p_sch_set_tbl(I).entity_id,
4171: p_x_line_rec => l_line_rec,
4172: x_return_status => x_return_status);
4173:

Line 4851: Procedure Schedule_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,

4847: Changes have been made to copy override_atp flag from model/class/
4848: kit to it's included items when the flag is set. Code has been added to
4849: cascade the override_atp flag to all the line in an ato model.
4850: ---------------------------------------------------------------*/
4851: Procedure Schedule_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
4852: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4853: IS
4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;

4850: ---------------------------------------------------------------*/
4851: Procedure Schedule_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
4852: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4853: IS
4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_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;

Line 4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

4851: Procedure Schedule_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
4852: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4853: IS
4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_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);

Line 4856: l_line_rec OE_ORDER_PUB.line_rec_type;

4852: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4853: IS
4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_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;

Line 4857: l_old_line_rec OE_ORDER_PUB.line_rec_type;

4853: IS
4854: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4855: l_old_line_tbl OE_ORDER_PUB.line_tbl_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);

Line 5959: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

5955:
5956: ****************************************************/
5957:
5958: Procedure Group_Schedule_sets
5959: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
5960: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5961: IS
5962: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
5963: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;

Line 5962: l_line_tbl OE_ORDER_PUB.line_Tbl_type;

5958: Procedure Group_Schedule_sets
5959: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
5960: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5961: IS
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;

Line 5963: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;

5959: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
5960: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5961: IS
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;

Line 5964: l_sch_line_tbl OE_ORDER_PUB.line_Tbl_type;

5960: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5961: IS
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);