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_SET_UTIL dependencies on OE_ORDER_PUB

Line 11: g_old_line_tbl OE_ORDER_PUB.Line_tbl_Type;

7: --Bug4080531
8: --g_set_rec OE_ORDER_CACHE.set_rec_type;
9:
10: g_cust_pref_set boolean := FALSE;
11: g_old_line_tbl OE_ORDER_PUB.Line_tbl_Type;
12: g_process_options boolean := TRUE;
13: g_old_arrival_set_path boolean := FALSE;
14:
15: Procedure Validate_Fulfillment_Set

Line 16: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,

12: g_process_options boolean := TRUE;
13: g_old_arrival_set_path boolean := FALSE;
14:
15: Procedure Validate_Fulfillment_Set
16: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
17: p_old_line_rec IN oe_order_pub.line_rec_type,
18: p_system_set IN VARCHAR2 DEFAULT 'N'
19: );
20:

Line 17: p_old_line_rec IN oe_order_pub.line_rec_type,

13: g_old_arrival_set_path boolean := FALSE;
14:
15: Procedure Validate_Fulfillment_Set
16: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
17: p_old_line_rec IN oe_order_pub.line_rec_type,
18: p_system_set IN VARCHAR2 DEFAULT 'N'
19: );
20:
21: FUNCTION IS_SET_CLOSED(p_set_id number)

Line 108: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

104: End Get_Fulfillment_Set;
105:
106:
107: Procedure Validate_ShipSet
108: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
109: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
110: ,x_return_status OUT NOCOPY VARCHAR2
111: )
112: IS

Line 109: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

105:
106:
107: Procedure Validate_ShipSet
108: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
109: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
110: ,x_return_status OUT NOCOPY VARCHAR2
111: )
112: IS
113: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 214: Function Is_Service_Eligible (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

210: END IF;
211: END Validate_Shipset;
212:
213:
214: Function Is_Service_Eligible (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
215: RETURN BOOLEAN
216: IS
217: l_header_id Number;
218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 403: -- l_line_rec oe_order_pub.line_rec_type; removed for 2525203

399:
400: Procedure Delete_Fulfillment_Set(p_line_id NUMBER,
401: p_set_id NUMBER) IS
402: l_return_status varchar2(30);
403: -- l_line_rec oe_order_pub.line_rec_type; removed for 2525203
404: --
405: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
406: --
407: BEGIN

Line 511: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

507:
508:
509: Procedure Process_Options IS
510: l_line_id NUMBER;
511: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
512: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
513: l_control_rec OE_GLOBALS.control_rec_type;
514: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
515: x_msg_count number;

Line 512: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

508:
509: Procedure Process_Options IS
510: l_line_id NUMBER;
511: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
512: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
513: l_control_rec OE_GLOBALS.control_rec_type;
514: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
515: x_msg_count number;
516: x_msg_data varchar2(2000);

Line 709: procedure Get_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

705: END Process_Options;
706:
707:
708:
709: procedure Get_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
710: p_set_type IN VARCHAR2,
711: p_index IN NUMBER,
712: p_line_id IN NUMBER := NULL,
713: p_line_rec OE_ORDER_PUB.line_rec_type

Line 713: p_line_rec OE_ORDER_PUB.line_rec_type

709: procedure Get_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
710: p_set_type IN VARCHAR2,
711: p_index IN NUMBER,
712: p_line_id IN NUMBER := NULL,
713: p_line_rec OE_ORDER_PUB.line_rec_type
714: := OE_ORDER_PUB.g_miss_line_rec
715: ) IS
716: l_line_id NUMBER;
717: Cursor optiontbl IS

Line 714: := OE_ORDER_PUB.g_miss_line_rec

710: p_set_type IN VARCHAR2,
711: p_index IN NUMBER,
712: p_line_id IN NUMBER := NULL,
713: p_line_rec OE_ORDER_PUB.line_rec_type
714: := OE_ORDER_PUB.g_miss_line_rec
715: ) IS
716: l_line_id NUMBER;
717: Cursor optiontbl IS
718: Select Ordered_quantity,

Line 731: l_line_rec OE_ORDER_PUB.line_rec_type := p_line_rec;

727: order by line_id;
728: l_count number;
729: lexist boolean := FALSE;
730: l_return_status varchar2(1);
731: l_line_rec OE_ORDER_PUB.line_rec_type := p_line_rec;
732:
733: --
734: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
735: --

Line 844: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,

840:
841:
842:
843: Procedure Insert_Into_arrival_Set
844: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
845: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
846: X_Return_Status OUT NOCOPY VARCHAR2,
847:
848: x_msg_count OUT NOCOPY NUMBER,

Line 853: l_line_rec OE_ORDER_PUB.line_rec_type;

849:
850: x_msg_data OUT NOCOPY VARCHAR2
851:
852: )IS
853: l_line_rec OE_ORDER_PUB.line_rec_type;
854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 854: l_model_line_rec OE_ORDER_PUB.line_rec_type;

850: x_msg_data OUT NOCOPY VARCHAR2
851:
852: )IS
853: l_line_rec OE_ORDER_PUB.line_rec_type;
854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 855: l_header_rec OE_ORDER_PUB.header_rec_type;

851:
852: )IS
853: l_line_rec OE_ORDER_PUB.line_rec_type;
854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

Line 856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

852: )IS
853: l_line_rec OE_ORDER_PUB.line_rec_type;
854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

Line 857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

853: l_line_rec OE_ORDER_PUB.line_rec_type;
854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

854: l_model_line_rec OE_ORDER_PUB.line_rec_type;
855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

Line 859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

855: l_header_rec OE_ORDER_PUB.header_rec_type;
856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

856: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
864: l_control_rec OE_GLOBALS.control_rec_type;

Line 861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

857: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
864: l_control_rec OE_GLOBALS.control_rec_type;
865: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

858: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
864: l_control_rec OE_GLOBALS.control_rec_type;
865: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
866: l_return_status VARCHAR2(30);

Line 863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

859: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
864: l_control_rec OE_GLOBALS.control_rec_type;
865: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
866: l_return_status VARCHAR2(30);
867: l_query_clause VARCHAR2(2000);

Line 1552: l_line_rec OE_ORDER_PUB.line_rec_type;

1548:
1549: ) IS
1550:
1551: l_num_of_records NUMBER := p_record_count;
1552: l_line_rec OE_ORDER_PUB.line_rec_type;
1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;

1549: ) IS
1550:
1551: l_num_of_records NUMBER := p_record_count;
1552: l_line_rec OE_ORDER_PUB.line_rec_type;
1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1551: l_num_of_records NUMBER := p_record_count;
1552: l_line_rec OE_ORDER_PUB.line_rec_type;
1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1559: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';

Line 1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

1552: l_line_rec OE_ORDER_PUB.line_rec_type;
1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1559: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1560: l_line_id Number;

Line 1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1559: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1560: l_line_id Number;
1561: l_return_status VARCHAR2(30);

Line 1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1559: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1560: l_line_id Number;
1561: l_return_status VARCHAR2(30);
1562: l_header_id number := to_number(p_header_id);

Line 2158: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,

2154:
2155: End Create_Set;
2156:
2157: Procedure Insert_Into_Set
2158: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
2159: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
2160: X_Return_Status OUT NOCOPY VARCHAR2,
2161:
2162: x_msg_count OUT NOCOPY NUMBER,

Line 2167: l_line_rec OE_ORDER_PUB.line_rec_type;

2163:
2164: x_msg_data OUT NOCOPY VARCHAR2
2165:
2166: )IS
2167: l_line_rec OE_ORDER_PUB.line_rec_type;
2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;

2164: x_msg_data OUT NOCOPY VARCHAR2
2165:
2166: )IS
2167: l_line_rec OE_ORDER_PUB.line_rec_type;
2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;

2165:
2166: )IS
2167: l_line_rec OE_ORDER_PUB.line_rec_type;
2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2170: l_header_rec OE_ORDER_PUB.header_rec_type;

2166: )IS
2167: l_line_rec OE_ORDER_PUB.line_rec_type;
2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

Line 2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2167: l_line_rec OE_ORDER_PUB.line_rec_type;
2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

Line 2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2168: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2169: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

Line 2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

2170: l_header_rec OE_ORDER_PUB.header_rec_type;
2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

2171: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2179: l_control_rec OE_GLOBALS.control_rec_type;

Line 2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

2172: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2179: l_control_rec OE_GLOBALS.control_rec_type;
2180: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

2173: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2179: l_control_rec OE_GLOBALS.control_rec_type;
2180: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2181: l_return_status VARCHAR2(30);

Line 2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

2174: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2179: l_control_rec OE_GLOBALS.control_rec_type;
2180: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2181: l_return_status VARCHAR2(30);
2182: l_query_clause VARCHAR2(2000);

Line 3050: l_line_rec OE_ORDER_PUB.line_rec_type;

3046: x_msg_data OUT NOCOPY VARCHAR2
3047:
3048: ) IS
3049: l_num_of_records NUMBER := p_record_count;
3050: l_line_rec OE_ORDER_PUB.line_rec_type;
3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;

3047:
3048: ) IS
3049: l_num_of_records NUMBER := p_record_count;
3050: l_line_rec OE_ORDER_PUB.line_rec_type;
3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3049: l_num_of_records NUMBER := p_record_count;
3050: l_line_rec OE_ORDER_PUB.line_rec_type;
3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3057: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';

Line 3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

3050: l_line_rec OE_ORDER_PUB.line_rec_type;
3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3057: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3058: l_line_id NUMBER;

Line 3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3057: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3058: l_line_id NUMBER;
3059: l_return_status VARCHAR2(30);

Line 3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3057: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3058: l_line_id NUMBER;
3059: l_return_status VARCHAR2(30);
3060: l_header_id NUMBER := to_number(p_header_id);

Line 3966: l_line_rec OE_ORDER_PUB.line_rec_type;

3962: x_msg_count OUT NOCOPY NUMBER,
3963:
3964: x_msg_data OUT NOCOPY VARCHAR2) IS
3965:
3966: l_line_rec OE_ORDER_PUB.line_rec_type;
3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3969: l_control_rec OE_GLOBALS.control_rec_type;
3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';

Line 3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3963:
3964: x_msg_data OUT NOCOPY VARCHAR2) IS
3965:
3966: l_line_rec OE_ORDER_PUB.line_rec_type;
3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3969: l_control_rec OE_GLOBALS.control_rec_type;
3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3964: x_msg_data OUT NOCOPY VARCHAR2) IS
3965:
3966: l_line_rec OE_ORDER_PUB.line_rec_type;
3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3969: l_control_rec OE_GLOBALS.control_rec_type;
3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3972:

Line 3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3969: l_control_rec OE_GLOBALS.control_rec_type;
3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3972:
3973: l_return_status VARCHAR2(30);
3974: l_set_rec OE_ORDER_CACHE.set_rec_type;
3975: J number;

Line 3976: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

3972:
3973: l_return_status VARCHAR2(30);
3974: l_set_rec OE_ORDER_CACHE.set_rec_type;
3975: J number;
3976: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
3977: l_set_name varchar2(240);
3978: l_set_id NUMBER;
3979: l_seq_id NUMBER;
3980: l_position NUMBER;

Line 4066: TYPE test1 IS TABLE OF OE_ORDER_PUB.HEADER_REC_TYPE;

4062: stmt_str varchar2(2000);
4063: Parent_line_id Number ;
4064: column1 varchar2(240);
4065: column2 varchar2(240);
4066: TYPE test1 IS TABLE OF OE_ORDER_PUB.HEADER_REC_TYPE;
4067: --
4068: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4069: --
4070: BEGIN

Line 4101: Procedure Get_Set_Id( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE,

4097: -- This procedure is not being used. Commenting the same to fix bug
4098: -- 2935346
4099: END Update_Options;
4100:
4101: Procedure Get_Set_Id( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE,
4102: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4103: p_index IN number) IS
4104:
4105: l_set_id NUMBER;

Line 4102: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,

4098: -- 2935346
4099: END Update_Options;
4100:
4101: Procedure Get_Set_Id( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE,
4102: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4103: p_index IN number) IS
4104:
4105: l_set_id NUMBER;
4106: l_set_rec OE_ORDER_CACHE.set_rec_type;

Line 5095: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

5091:
5092:
5093: PROCEDURE Query_Set_Rows
5094: ( p_set_id IN NUMBER,
5095: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
5096: )
5097: IS
5098: l_line_rec OE_Order_PUB.Line_Rec_Type;
5099: l_header_id NUMBER;

Line 5098: l_line_rec OE_Order_PUB.Line_Rec_Type;

5094: ( p_set_id IN NUMBER,
5095: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
5096: )
5097: IS
5098: l_line_rec OE_Order_PUB.Line_Rec_Type;
5099: l_header_id NUMBER;
5100: CURSOR c1 is
5101: SELECT line_id
5102: FROM oe_order_lines

Line 5185: PROCEDURE Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE

5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5182:
5183: END Query_Set_Rows;
5184:
5185: PROCEDURE Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE
5186: ) IS
5187: l_set_id number;
5188: --
5189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5261: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258:
5259: END Create_Line_Set;
5260:
5261: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5262: ) IS
5263:
5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;

Line 5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5260:
5261: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5262: ) IS
5263:
5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5267: OE_ORDER_PUB.G_MISS_LINE_TBL;
5268: l_control_rec OE_GLOBALS.control_rec_type;

Line 5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;

5261: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5262: ) IS
5263:
5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5267: OE_ORDER_PUB.G_MISS_LINE_TBL;
5268: l_control_rec OE_GLOBALS.control_rec_type;
5269: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=

5262: ) IS
5263:
5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5267: OE_ORDER_PUB.G_MISS_LINE_TBL;
5268: l_control_rec OE_GLOBALS.control_rec_type;
5269: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5270:

Line 5267: OE_ORDER_PUB.G_MISS_LINE_TBL;

5263:
5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5267: OE_ORDER_PUB.G_MISS_LINE_TBL;
5268: l_control_rec OE_GLOBALS.control_rec_type;
5269: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5270:
5271: l_return_status VARCHAR2(30);

Line 6100: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,

6096: /* This procedure is added for the new set scheduling functioanlity
6097: and it takes the responsibility of creating a set if a line is requested
6098: into a set and populate set id for scheduling to be sensitive to sets */
6099:
6100: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
6101: p_old_line_rec IN oe_order_pub.line_rec_type)
6102: IS
6103: l_set_id number;
6104: l_cascade_flag varchar2(1) := 'N';

Line 6101: p_old_line_rec IN oe_order_pub.line_rec_type)

6097: and it takes the responsibility of creating a set if a line is requested
6098: into a set and populate set id for scheduling to be sensitive to sets */
6099:
6100: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
6101: p_old_line_rec IN oe_order_pub.line_rec_type)
6102: IS
6103: l_set_id number;
6104: l_cascade_flag varchar2(1) := 'N';
6105: l_create_set varchar2(1) := 'N';

Line 6118: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

6114: l_ful_exists varchar2(1) := 'N';
6115: l_cust_pref varchar2(240);
6116: l_set_pref_type varchar2(240);
6117: l_fulfillment_set VARCHAR2(240);
6118: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6119: K NUMBER;
6120: l_old_set_id NUMBER;
6121: l_child_line_rec OE_ORDER_PUB.line_rec_type;
6122: l_action VARCHAR2(20);

Line 6121: l_child_line_rec OE_ORDER_PUB.line_rec_type;

6117: l_fulfillment_set VARCHAR2(240);
6118: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6119: K NUMBER;
6120: l_old_set_id NUMBER;
6121: l_child_line_rec OE_ORDER_PUB.line_rec_type;
6122: l_action VARCHAR2(20);
6123: l_operation VARCHAR2(30);
6124: l_entity_type VARCHAR2(30);
6125:

Line 7074: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,

7070:
7071: END Default_Line_Set;
7072:
7073: Procedure Validate_Fulfillment_Set
7074: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
7075: p_old_line_rec IN oe_order_pub.line_rec_type,
7076: p_system_set IN VARCHAR2 DEFAULT 'N'
7077: )
7078: IS

Line 7075: p_old_line_rec IN oe_order_pub.line_rec_type,

7071: END Default_Line_Set;
7072:
7073: Procedure Validate_Fulfillment_Set
7074: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
7075: p_old_line_rec IN oe_order_pub.line_rec_type,
7076: p_system_set IN VARCHAR2 DEFAULT 'N'
7077: )
7078: IS
7079: l_set_id number;

Line 7229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,

7225: PROCEDURE: Delete_Set
7226: DESCRIPTION:This api will delete set record from oe_sets table if
7227: the set is not associated with any line.
7228: */
7229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
7230: x_return_status OUT NOCOPY VARCHAR2)
7231: IS
7232: l_dummy NUMBER;
7233: