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 FND_API

Line 8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;

4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
11: G_Set_Recursive_Flag BOOLEAN := FALSE;
12:

Line 9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;

5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
11: G_Set_Recursive_Flag BOOLEAN := FALSE;
12:
13: --Bug 4080531

Line 18: Line_id number := FND_api.g_miss_num,

14: g_set_rec OE_ORDER_CACHE.set_rec_type;
15:
16: Type Set_rec IS RECORD
17: (
18: Line_id number := FND_api.g_miss_num,
19: Set_name varchar2(80) := FND_Api.g_miss_char,
20: set_type varchar2(30),
21: process_flag varchar2(1):= 'N',
22: operation varchar2(1):= 'U');

Line 19: Set_name varchar2(80) := FND_Api.g_miss_char,

15:
16: Type Set_rec IS RECORD
17: (
18: Line_id number := FND_api.g_miss_num,
19: Set_name varchar2(80) := FND_Api.g_miss_char,
20: set_type varchar2(30),
21: process_flag varchar2(1):= 'N',
22: operation varchar2(1):= 'U');
23:

Line 26: Line_id number := FND_api.g_miss_num,

22: operation varchar2(1):= 'U');
23:
24: Type Set_opt_rec IS RECORD
25: (
26: Line_id number := FND_api.g_miss_num,
27: Set_id number := FND_Api.g_miss_num,
28: set_type varchar2(30));
29:
30: Type auto_set_rec IS RECORD

Line 27: Set_id number := FND_Api.g_miss_num,

23:
24: Type Set_opt_rec IS RECORD
25: (
26: Line_id number := FND_api.g_miss_num,
27: Set_id number := FND_Api.g_miss_num,
28: set_type varchar2(30));
29:
30: Type auto_set_rec IS RECORD
31: (

Line 32: Line_id number := FND_api.g_miss_num);

28: set_type varchar2(30));
29:
30: Type auto_set_rec IS RECORD
31: (
32: Line_id number := FND_api.g_miss_num);
33:
34: Type Set_opt_line_Tbl IS TABLE OF set_opt_rec
35: index by binary_integer;
36:

Line 64: p_header_id IN NUMBER := FND_API.G_MISS_NUM)

60:
61: -- Function to find if set exists for a set id
62:
63: FUNCTION Set_Exist(p_set_id IN NUMBER,
64: p_header_id IN NUMBER := FND_API.G_MISS_NUM)
65: RETURN BOOLEAN;
66:
67: -- This procedure is first thing to get called in Lines procedure
68: -- to figure out if there are any set requests and populate the

Line 84: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

80: Procedure Process_Sets
81: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, --R12.MOAC
82: p_record_count IN NUMBER,
83: p_set_name IN VARCHAR2,
84: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_operation IN VARCHAR2,
86: p_header_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: x_Set_Id OUT NOCOPY NUMBER,
88:

Line 86: p_header_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

82: p_record_count IN NUMBER,
83: p_set_name IN VARCHAR2,
84: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_operation IN VARCHAR2,
86: p_header_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: x_Set_Id OUT NOCOPY NUMBER,
88:
89: x_return_status OUT NOCOPY VARCHAR2,
90:

Line 126: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,

122: -- This dependes on the customer preference set code
123:
124: Procedure Insert_Into_Set
125: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
126: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
127: X_Return_Status OUT NOCOPY VARCHAR2,
128:
129: x_msg_count OUT NOCOPY NUMBER,
130:

Line 154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,

150: -- Update set is called from scheduling when any of the set attributes
151: -- changes and result in cascading on the lines of the set.
152: Procedure Update_Set
153: (p_Set_Id IN NUMBER,
154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,

151: -- changes and result in cascading on the lines of the set.
152: Procedure Update_Set
153: (p_Set_Id IN NUMBER,
154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,

152: Procedure Update_Set
153: (p_Set_Id IN NUMBER,
154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,

153: (p_Set_Id IN NUMBER,
154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: X_Return_Status OUT NOCOPY VARCHAR2,

Line 158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

154: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162:

Line 159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

155: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162:
163: x_msg_count OUT NOCOPY NUMBER,

Line 160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

156: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
157: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
158: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162:
163: x_msg_count OUT NOCOPY NUMBER,
164:

Line 176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,

172:
173: -- This api checks if all the set attributes on the set are same
174:
175: PROCEDURE Validate_set_attributes(p_set_id IN NUMBER ,
176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,

173: -- This api checks if all the set attributes on the set are same
174:
175: PROCEDURE Validate_set_attributes(p_set_id IN NUMBER ,
176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,

174:
175: PROCEDURE Validate_set_attributes(p_set_id IN NUMBER ,
176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,

175: PROCEDURE Validate_set_attributes(p_set_id IN NUMBER ,
176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: X_Return_Status OUT NOCOPY VARCHAR2);

Line 180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

176: p_Ship_From_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: X_Return_Status OUT NOCOPY VARCHAR2);
184:

Line 181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,

177: p_Ship_To_Org_Id IN NUMBER := FND_API.G_MISS_NUM,
178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: X_Return_Status OUT NOCOPY VARCHAR2);
184:
185:

Line 182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

178: p_Schedule_Ship_Date IN DATE := FND_API.G_MISS_DATE,
179: p_Schedule_Arrival_Date IN DATE := FND_API.G_MISS_DATE,
180: p_Freight_Carrier_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: X_Return_Status OUT NOCOPY VARCHAR2);
184:
185:
186: -- This is to check if an arrival set already exists in a ship set and

Line 196: Procedure Update_Options(p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM,

192:
193:
194: -- Updates the options if a model is changed
195:
196: Procedure Update_Options(p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_config_line_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_set_id IN NUMBER,
199: p_set_type IN VARCHAR2 );
200:

Line 197: p_config_line_id IN NUMBER := FND_API.G_MISS_NUM,

193:
194: -- Updates the options if a model is changed
195:
196: Procedure Update_Options(p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_config_line_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_set_id IN NUMBER,
199: p_set_type IN VARCHAR2 );
200:
201: -- To query all the lines in the set