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 439: -- l_line_rec oe_order_pub.line_rec_type; removed for 2525203

435:
436: Procedure Delete_Fulfillment_Set(p_line_id NUMBER,
437: p_set_id NUMBER) IS
438: l_return_status varchar2(30);
439: -- l_line_rec oe_order_pub.line_rec_type; removed for 2525203
440: --
441: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
442: --
443: BEGIN

Line 547: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

543:
544:
545: Procedure Process_Options IS
546: l_line_id NUMBER;
547: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
548: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
549: l_control_rec OE_GLOBALS.control_rec_type;
550: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
551: x_msg_count number;

Line 548: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

544:
545: Procedure Process_Options IS
546: l_line_id NUMBER;
547: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
548: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
549: l_control_rec OE_GLOBALS.control_rec_type;
550: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
551: x_msg_count number;
552: x_msg_data varchar2(2000);

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

741: END Process_Options;
742:
743:
744:
745: procedure Get_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
746: p_set_type IN VARCHAR2,
747: p_index IN NUMBER,
748: p_line_id IN NUMBER := NULL,
749: p_line_rec OE_ORDER_PUB.line_rec_type

Line 749: p_line_rec OE_ORDER_PUB.line_rec_type

745: procedure Get_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
746: p_set_type IN VARCHAR2,
747: p_index IN NUMBER,
748: p_line_id IN NUMBER := NULL,
749: p_line_rec OE_ORDER_PUB.line_rec_type
750: := OE_ORDER_PUB.g_miss_line_rec
751: ) IS
752: l_line_id NUMBER;
753: Cursor optiontbl IS

Line 750: := OE_ORDER_PUB.g_miss_line_rec

746: p_set_type IN VARCHAR2,
747: p_index IN NUMBER,
748: p_line_id IN NUMBER := NULL,
749: p_line_rec OE_ORDER_PUB.line_rec_type
750: := OE_ORDER_PUB.g_miss_line_rec
751: ) IS
752: l_line_id NUMBER;
753: Cursor optiontbl IS
754: Select Ordered_quantity,

Line 767: l_line_rec OE_ORDER_PUB.line_rec_type := p_line_rec;

763: order by line_id;
764: l_count number;
765: lexist boolean := FALSE;
766: l_return_status varchar2(1);
767: l_line_rec OE_ORDER_PUB.line_rec_type := p_line_rec;
768:
769: --
770: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
771: --

Line 880: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,

876:
877:
878:
879: Procedure Insert_Into_arrival_Set
880: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
881: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
882: X_Return_Status OUT NOCOPY VARCHAR2,
883:
884: x_msg_count OUT NOCOPY NUMBER,

Line 889: l_line_rec OE_ORDER_PUB.line_rec_type;

885:
886: x_msg_data OUT NOCOPY VARCHAR2
887:
888: )IS
889: l_line_rec OE_ORDER_PUB.line_rec_type;
890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 890: l_model_line_rec OE_ORDER_PUB.line_rec_type;

886: x_msg_data OUT NOCOPY VARCHAR2
887:
888: )IS
889: l_line_rec OE_ORDER_PUB.line_rec_type;
890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 891: l_header_rec OE_ORDER_PUB.header_rec_type;

887:
888: )IS
889: l_line_rec OE_ORDER_PUB.line_rec_type;
890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

Line 892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

888: )IS
889: l_line_rec OE_ORDER_PUB.line_rec_type;
890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

Line 893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

889: l_line_rec OE_ORDER_PUB.line_rec_type;
890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

890: l_model_line_rec OE_ORDER_PUB.line_rec_type;
891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

Line 895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

891: l_header_rec OE_ORDER_PUB.header_rec_type;
892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

892: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
900: l_control_rec OE_GLOBALS.control_rec_type;

Line 897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

893: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
900: l_control_rec OE_GLOBALS.control_rec_type;
901: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

894: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
900: l_control_rec OE_GLOBALS.control_rec_type;
901: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
902: l_return_status VARCHAR2(30);

Line 899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

895: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
900: l_control_rec OE_GLOBALS.control_rec_type;
901: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
902: l_return_status VARCHAR2(30);
903: l_query_clause VARCHAR2(2000);

Line 1588: l_line_rec OE_ORDER_PUB.line_rec_type;

1584:
1585: ) IS
1586:
1587: l_num_of_records NUMBER := p_record_count;
1588: l_line_rec OE_ORDER_PUB.line_rec_type;
1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;

1585: ) IS
1586:
1587: l_num_of_records NUMBER := p_record_count;
1588: l_line_rec OE_ORDER_PUB.line_rec_type;
1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1587: l_num_of_records NUMBER := p_record_count;
1588: l_line_rec OE_ORDER_PUB.line_rec_type;
1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1595: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';

Line 1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

1588: l_line_rec OE_ORDER_PUB.line_rec_type;
1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1595: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1596: l_line_id Number;

Line 1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1595: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1596: l_line_id Number;
1597: l_return_status VARCHAR2(30);

Line 1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1595: l_api_name CONSTANT VARCHAR2(30) := 'New_Process_sets';
1596: l_line_id Number;
1597: l_return_status VARCHAR2(30);
1598: l_header_id number := to_number(p_header_id);

Line 2028: l_header_rec OE_ORDER_PUB.Header_Rec_Type; -- Bug 14760471

2024:
2025: )IS
2026: l_set_id NUMBER;
2027: lcustpref varchar2(1) := 'A';
2028: l_header_rec OE_ORDER_PUB.Header_Rec_Type; -- Bug 14760471
2029: --
2030: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2031: --
2032: Begin

Line 2211: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,

2207:
2208: End Create_Set;
2209:
2210: Procedure Insert_Into_Set
2211: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
2212: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
2213: X_Return_Status OUT NOCOPY VARCHAR2,
2214:
2215: x_msg_count OUT NOCOPY NUMBER,

Line 2220: l_line_rec OE_ORDER_PUB.line_rec_type;

2216:
2217: x_msg_data OUT NOCOPY VARCHAR2
2218:
2219: )IS
2220: l_line_rec OE_ORDER_PUB.line_rec_type;
2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;

2217: x_msg_data OUT NOCOPY VARCHAR2
2218:
2219: )IS
2220: l_line_rec OE_ORDER_PUB.line_rec_type;
2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;

2218:
2219: )IS
2220: l_line_rec OE_ORDER_PUB.line_rec_type;
2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2223: l_header_rec OE_ORDER_PUB.header_rec_type;

2219: )IS
2220: l_line_rec OE_ORDER_PUB.line_rec_type;
2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

Line 2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2220: l_line_rec OE_ORDER_PUB.line_rec_type;
2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

Line 2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2221: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2222: l_model_line_rec OE_ORDER_PUB.line_rec_type;
2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

Line 2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;

2223: l_header_rec OE_ORDER_PUB.header_rec_type;
2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;

2224: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2232: l_control_rec OE_GLOBALS.control_rec_type;

Line 2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

2225: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2232: l_control_rec OE_GLOBALS.control_rec_type;
2233: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;

2226: l_sch_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2232: l_control_rec OE_GLOBALS.control_rec_type;
2233: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2234: l_return_status VARCHAR2(30);

Line 2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;

2227: l_set_request_tbl oe_order_pub.Request_Tbl_Type;
2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2232: l_control_rec OE_GLOBALS.control_rec_type;
2233: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2234: l_return_status VARCHAR2(30);
2235: l_query_clause VARCHAR2(2000);

Line 3103: l_line_rec OE_ORDER_PUB.line_rec_type;

3099: x_msg_data OUT NOCOPY VARCHAR2
3100:
3101: ) IS
3102: l_num_of_records NUMBER := p_record_count;
3103: l_line_rec OE_ORDER_PUB.line_rec_type;
3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;

3100:
3101: ) IS
3102: l_num_of_records NUMBER := p_record_count;
3103: l_line_rec OE_ORDER_PUB.line_rec_type;
3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3102: l_num_of_records NUMBER := p_record_count;
3103: l_line_rec OE_ORDER_PUB.line_rec_type;
3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3110: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';

Line 3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;

3103: l_line_rec OE_ORDER_PUB.line_rec_type;
3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3110: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3111: l_line_id NUMBER;

Line 3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;

3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3110: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3111: l_line_id NUMBER;
3112: l_return_status VARCHAR2(30);

Line 3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3110: l_api_name CONSTANT VARCHAR2(30) := 'Process_sets';
3111: l_line_id NUMBER;
3112: l_return_status VARCHAR2(30);
3113: l_header_id NUMBER := to_number(p_header_id);

Line 4023: l_line_rec OE_ORDER_PUB.line_rec_type;

4019: x_msg_count OUT NOCOPY NUMBER,
4020:
4021: x_msg_data OUT NOCOPY VARCHAR2) IS
4022:
4023: l_line_rec OE_ORDER_PUB.line_rec_type;
4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4026: l_control_rec OE_GLOBALS.control_rec_type;
4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';

Line 4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4020:
4021: x_msg_data OUT NOCOPY VARCHAR2) IS
4022:
4023: l_line_rec OE_ORDER_PUB.line_rec_type;
4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4026: l_control_rec OE_GLOBALS.control_rec_type;
4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4021: x_msg_data OUT NOCOPY VARCHAR2) IS
4022:
4023: l_line_rec OE_ORDER_PUB.line_rec_type;
4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4026: l_control_rec OE_GLOBALS.control_rec_type;
4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4029:

Line 4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4026: l_control_rec OE_GLOBALS.control_rec_type;
4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4029:
4030: l_return_status VARCHAR2(30);
4031: l_set_rec OE_ORDER_CACHE.set_rec_type;
4032: J number;

Line 4033: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

4029:
4030: l_return_status VARCHAR2(30);
4031: l_set_rec OE_ORDER_CACHE.set_rec_type;
4032: J number;
4033: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4034: l_set_name varchar2(240);
4035: l_set_id NUMBER;
4036: l_seq_id NUMBER;
4037: l_position NUMBER;

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

4119: stmt_str varchar2(2000);
4120: Parent_line_id Number ;
4121: column1 varchar2(240);
4122: column2 varchar2(240);
4123: TYPE test1 IS TABLE OF OE_ORDER_PUB.HEADER_REC_TYPE;
4124: --
4125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4126: --
4127: BEGIN

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

4154: -- This procedure is not being used. Commenting the same to fix bug
4155: -- 2935346
4156: END Update_Options;
4157:
4158: Procedure Get_Set_Id( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE,
4159: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4160: p_index IN number) IS
4161:
4162: l_set_id NUMBER;

Line 4159: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,

4155: -- 2935346
4156: END Update_Options;
4157:
4158: Procedure Get_Set_Id( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE,
4159: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4160: p_index IN number) IS
4161:
4162: l_set_id NUMBER;
4163: l_set_rec OE_ORDER_CACHE.set_rec_type;

Line 5152: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

5148:
5149:
5150: PROCEDURE Query_Set_Rows
5151: ( p_set_id IN NUMBER,
5152: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
5153: )
5154: IS
5155: l_line_rec OE_Order_PUB.Line_Rec_Type;
5156: l_header_id NUMBER;

Line 5155: l_line_rec OE_Order_PUB.Line_Rec_Type;

5151: ( p_set_id IN NUMBER,
5152: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
5153: )
5154: IS
5155: l_line_rec OE_Order_PUB.Line_Rec_Type;
5156: l_header_id NUMBER;
5157: CURSOR c1 is
5158: SELECT line_id
5159: FROM oe_order_lines

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

5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239:
5240: END Query_Set_Rows;
5241:
5242: PROCEDURE Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE
5243: ) IS
5244: l_set_id number;
5245: --
5246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315:
5316: END Create_Line_Set;
5317:
5318: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5319: ) IS
5320:
5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;

Line 5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5317:
5318: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5319: ) IS
5320:
5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5324: OE_ORDER_PUB.G_MISS_LINE_TBL;
5325: l_control_rec OE_GLOBALS.control_rec_type;

Line 5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;

5318: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
5319: ) IS
5320:
5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5324: OE_ORDER_PUB.G_MISS_LINE_TBL;
5325: l_control_rec OE_GLOBALS.control_rec_type;
5326: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';

Line 5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=

5319: ) IS
5320:
5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5324: OE_ORDER_PUB.G_MISS_LINE_TBL;
5325: l_control_rec OE_GLOBALS.control_rec_type;
5326: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5327:

Line 5324: OE_ORDER_PUB.G_MISS_LINE_TBL;

5320:
5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5324: OE_ORDER_PUB.G_MISS_LINE_TBL;
5325: l_control_rec OE_GLOBALS.control_rec_type;
5326: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5327:
5328: l_return_status VARCHAR2(30);

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

6153: /* This procedure is added for the new set scheduling functioanlity
6154: and it takes the responsibility of creating a set if a line is requested
6155: into a set and populate set id for scheduling to be sensitive to sets */
6156:
6157: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
6158: p_old_line_rec IN oe_order_pub.line_rec_type)
6159: IS
6160: l_set_id number;
6161: l_cascade_flag varchar2(1) := 'N';

Line 6158: p_old_line_rec IN oe_order_pub.line_rec_type)

6154: and it takes the responsibility of creating a set if a line is requested
6155: into a set and populate set id for scheduling to be sensitive to sets */
6156:
6157: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
6158: p_old_line_rec IN oe_order_pub.line_rec_type)
6159: IS
6160: l_set_id number;
6161: l_cascade_flag varchar2(1) := 'N';
6162: l_create_set varchar2(1) := 'N';

Line 6175: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

6171: l_ful_exists varchar2(1) := 'N';
6172: l_cust_pref varchar2(240);
6173: l_set_pref_type varchar2(240);
6174: l_fulfillment_set VARCHAR2(240);
6175: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6176: K NUMBER;
6177: l_old_set_id NUMBER;
6178: l_child_line_rec OE_ORDER_PUB.line_rec_type;
6179: l_action VARCHAR2(20);

Line 6178: l_child_line_rec OE_ORDER_PUB.line_rec_type;

6174: l_fulfillment_set VARCHAR2(240);
6175: l_x_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6176: K NUMBER;
6177: l_old_set_id NUMBER;
6178: l_child_line_rec OE_ORDER_PUB.line_rec_type;
6179: l_action VARCHAR2(20);
6180: l_operation VARCHAR2(30);
6181: l_entity_type VARCHAR2(30);
6182: l_auto_schedule_sets VARCHAR2(1):='Y' ; --4241385

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

7552:
7553: END Default_Line_Set;
7554:
7555: Procedure Validate_Fulfillment_Set
7556: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
7557: p_old_line_rec IN oe_order_pub.line_rec_type,
7558: p_system_set IN VARCHAR2 DEFAULT 'N'
7559: )
7560: IS

Line 7557: p_old_line_rec IN oe_order_pub.line_rec_type,

7553: END Default_Line_Set;
7554:
7555: Procedure Validate_Fulfillment_Set
7556: ( p_x_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
7557: p_old_line_rec IN oe_order_pub.line_rec_type,
7558: p_system_set IN VARCHAR2 DEFAULT 'N'
7559: )
7560: IS
7561: l_set_id number;

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

7707: PROCEDURE: Delete_Set
7708: DESCRIPTION:This api will delete set record from oe_sets table if
7709: the set is not associated with any line.
7710: */
7711: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
7712: x_return_status OUT NOCOPY VARCHAR2)
7713: IS
7714: l_dummy NUMBER;
7715: