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

Line 10: g_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Lot_Serial';
7:
8: -- Global variables holding cached record.
9:
10: g_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
11: g_db_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
11: g_db_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Lot_Serial

Line 16: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Lot_Serial
16: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: PROCEDURE Get_Lot_Serial

Line 23: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

19:
20: PROCEDURE Get_Lot_Serial
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_lot_serial_id IN NUMBER
23: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
24: );
25:
26: PROCEDURE Clear_Lot_Serial;
27:

Line 30: g_opr__tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

26: PROCEDURE Clear_Lot_Serial;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

93: , x_lot_serial OUT NOCOPY VARCHAR2
94:
95: )
96: IS
97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;

94:
95: )
96: IS
97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

95: )
96: IS
97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);

Line 100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

96: IS
97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: --

Line 101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

97: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: --
105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 133: l_x_Lot_Serial_rec:=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

129: -- Load IN parameters if any exist
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'LOT_SERIAL LINE_ID'||P_LINE_ID , 1 ) ;
132: END IF;
133: l_x_Lot_Serial_rec:=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
134: l_x_Old_Lot_Serial_Tbl(1):=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
135: l_x_Lot_Serial_rec.line_id := p_line_id;
136:
137: -- Defaulting of flex values is currently done by the form.

Line 134: l_x_Old_Lot_Serial_Tbl(1):=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'LOT_SERIAL LINE_ID'||P_LINE_ID , 1 ) ;
132: END IF;
133: l_x_Lot_Serial_rec:=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
134: l_x_Old_Lot_Serial_Tbl(1):=OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
135: l_x_Lot_Serial_rec.line_id := p_line_id;
136:
137: -- Defaulting of flex values is currently done by the form.
138: -- Set flex attributes to NULL in order to avoid defaulting them.

Line 387: l_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

383: , x_lot_serial OUT NOCOPY VARCHAR2
384:
385: )
386: IS
387: l_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);

Line 388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;

384:
385: )
386: IS
387: l_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);
392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

385: )
386: IS
387: l_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);
392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
393: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);
392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
393: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
394: --
395: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
396: --

Line 393: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);
392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
393: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
394: --
395: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
396: --
397: BEGIN

Line 858: l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

854: , x_lock_control OUT NOCOPY NUMBER
855:
856: )
857: IS
858: l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
860: l_control_rec OE_GLOBALS.Control_Rec_Type;
861: l_return_status VARCHAR2(1);
862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

855:
856: )
857: IS
858: l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
860: l_control_rec OE_GLOBALS.Control_Rec_Type;
861: l_return_status VARCHAR2(1);
862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
863: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

858: l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
860: l_control_rec OE_GLOBALS.Control_Rec_Type;
861: l_return_status VARCHAR2(1);
862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
863: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
864: --
865: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
866: --

Line 863: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
860: l_control_rec OE_GLOBALS.Control_Rec_Type;
861: l_return_status VARCHAR2(1);
862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
863: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
864: --
865: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
866: --
867: BEGIN

Line 1066: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1062:
1063: , p_lot_serial_id IN NUMBER
1064: )
1065: IS
1066: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1067: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1068: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1069: l_control_rec OE_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);

Line 1067: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1063: , p_lot_serial_id IN NUMBER
1064: )
1065: IS
1066: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1067: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1068: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1069: l_control_rec OE_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: --

Line 1068: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1064: )
1065: IS
1066: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1067: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1068: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1069: l_control_rec OE_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

1209:
1210: )
1211: IS
1212: l_return_status VARCHAR2(1);
1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1211: IS
1212: l_return_status VARCHAR2(1);
1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1212: l_return_status VARCHAR2(1);
1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1219: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1220: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1221: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1222: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1223: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

1224: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

1225: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */

Line 1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

1226: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1234: --

Line 1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1227: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1234: --
1235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1228: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1234: --
1235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1236: --

Line 1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */

1229: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1230: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1231: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1232: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1233: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1234: --
1235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1236: --
1237: BEGIN

Line 1381: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1377: , p_lock_control IN NUMBER
1378: )
1379: IS
1380: l_return_status VARCHAR2(1);
1381: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1382: --
1383: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1384: --
1385: BEGIN

Line 1452: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type

1448:
1449: -- Procedures maintaining Lot_Serial record cache.
1450:
1451: PROCEDURE Write_Lot_Serial
1452: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1453: , p_db_record IN BOOLEAN := FALSE
1454: )
1455: IS
1456: --

Line 1482: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

1478:
1479: PROCEDURE Get_Lot_Serial
1480: ( p_db_record IN BOOLEAN := FALSE
1481: , p_lot_serial_id IN NUMBER
1482: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1483: )
1484: IS
1485: --
1486: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1534: g_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;

1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531: --
1532: BEGIN
1533:
1534: g_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;
1535: g_db_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;
1536:
1537: END Clear_Lot_Serial;
1538:

Line 1535: g_db_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;

1531: --
1532: BEGIN
1533:
1534: g_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;
1535: g_db_Lot_Serial_rec := OE_Order_PUB.G_MISS_LOT_SERIAL_REC;
1536:
1537: END Clear_Lot_Serial;
1538:
1539: END OE_OE_Form_Lot_Serial;