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

Line 12: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
13: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
15: )
16: IS

Line 13: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
13: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
15: )
16: IS
17: l_index NUMBER := 0;

Line 14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
13: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
15: )
16: IS
17: l_index NUMBER := 0;
18: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 321: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

317:
318: -- Procedure Apply_Attribute_Changes
319:
320: PROCEDURE Apply_Attribute_Changes
321: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
322: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
323: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
324: )
325: IS

Line 322: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=

318: -- Procedure Apply_Attribute_Changes
319:
320: PROCEDURE Apply_Attribute_Changes
321: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
322: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
323: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
324: )
325: IS
326: l_serial_validation_flag VARCHAR2(1) := 'N';

Line 323: OE_Order_PUB.G_MISS_LOT_SERIAL_REC

319:
320: PROCEDURE Apply_Attribute_Changes
321: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
322: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
323: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
324: )
325: IS
326: l_serial_validation_flag VARCHAR2(1) := 'N';
327: x_prefix VARCHAR2(80);

Line 517: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

513:
514: -- Procedure Complete_Record
515:
516: PROCEDURE Complete_Record
517: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
518: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
519: )
520: IS
521: BEGIN

Line 518: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type

514: -- Procedure Complete_Record
515:
516: PROCEDURE Complete_Record
517: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
518: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
519: )
520: IS
521: BEGIN
522:

Line 654: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

650:
651: -- Procedure Convert_Miss_To_Null
652:
653: PROCEDURE Convert_Miss_To_Null
654: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
655: )
656: IS
657: BEGIN
658:

Line 823: ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

819:
820: -- Procedure Update_Row
821:
822: PROCEDURE Update_Row
823: ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
824: )
825: IS
826: l_lock_control NUMBER;
827: /* jolin start*/

Line 829: l_lot_serial_rec OE_Order_PUB.Lot_serial_Rec_Type;

825: IS
826: l_lock_control NUMBER;
827: /* jolin start*/
828: --added for notification framework
829: l_lot_serial_rec OE_Order_PUB.Lot_serial_Rec_Type;
830: l_index NUMBER;
831: l_return_status VARCHAR2(1);
832: /* jolin end*/
833:

Line 940: ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

936:
937: -- Procedure Insert_Row
938:
939: PROCEDURE Insert_Row
940: ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
941: )
942: IS
943: l_lock_control NUMBER := 1;
944: /* jolin start*/

Line 1072: l_line_rec oe_order_pub.line_rec_type;

1068:
1069: FUNCTION Is_Last_In_Line_Set(p_line_id NUMBER)
1070: RETURN BOOLEAN
1071: IS
1072: l_line_rec oe_order_pub.line_rec_type;
1073: l_line_set_id NUMBER;
1074: dummy NUMBER;
1075: BEGIN
1076:

Line 1109: l_line_rec OE_ORDER_PUB.line_rec_type;

1105: , p_line_id IN NUMBER := fnd_api.g_miss_num
1106:
1107: )
1108: IS
1109: l_line_rec OE_ORDER_PUB.line_rec_type;
1110: /* jolin start*/
1111: -- added for notification framework
1112: l_old_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1113: l_new_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1112: l_old_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1108: IS
1109: l_line_rec OE_ORDER_PUB.line_rec_type;
1110: /* jolin start*/
1111: -- added for notification framework
1112: l_old_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1113: l_new_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1114: l_index NUMBER;
1115: l_return_status VARCHAR2(1);
1116:

Line 1113: l_new_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1109: l_line_rec OE_ORDER_PUB.line_rec_type;
1110: /* jolin start*/
1111: -- added for notification framework
1112: l_old_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1113: l_new_lot_serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1114: l_index NUMBER;
1115: l_return_status VARCHAR2(1);
1116:
1117: CURSOR line_set IS

Line 1272: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

1268: -- Procedure Query_Row
1269:
1270: PROCEDURE Query_Row
1271: ( p_lot_serial_id IN NUMBER
1272: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1273: )
1274: IS
1275: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1276: BEGIN

Line 1275: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1271: ( p_lot_serial_id IN NUMBER
1272: , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1273: )
1274: IS
1275: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1276: BEGIN
1277:
1278: Query_Rows
1279: ( p_lot_serial_id => p_lot_serial_id

Line 1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type

1293: , p_line_id IN NUMBER :=
1294: FND_API.G_MISS_NUM
1295: , p_line_set_id IN NUMBER :=
1296: FND_API.G_MISS_NUM
1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
1298: )
1299: IS
1300: l_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1301: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1300: l_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1296: FND_API.G_MISS_NUM
1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
1298: )
1299: IS
1300: l_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1301: l_line_rec OE_Order_PUB.Line_Rec_Type;
1302: l_line_id NUMBER := p_line_id;
1303: l_line_set_id NUMBER := p_line_set_id;
1304: l_count NUMBER; --6052770

Line 1301: l_line_rec OE_Order_PUB.Line_Rec_Type;

1297: , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
1298: )
1299: IS
1300: l_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1301: l_line_rec OE_Order_PUB.Line_Rec_Type;
1302: l_line_id NUMBER := p_line_id;
1303: l_line_set_id NUMBER := p_line_set_id;
1304: l_count NUMBER; --6052770
1305: CURSOR l_Lot_Serial_csr IS

Line 1555: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

1551:
1552: PROCEDURE Lock_Row
1553: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1554: , p_lot_serial_id IN NUMBER := FND_API.G_MISS_NUM
1555: , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1556: )
1557: IS
1558:
1559: l_lot_serial_id NUMBER;

Line 1683: , x_lot_serial_tbl OUT NOCOPY OE_Order_PUB.Lot_serial_Tbl_Type

1679: ( p_lot_serial_id IN NUMBER :=
1680: FND_API.G_MISS_NUM
1681: , p_line_id IN NUMBER :=
1682: FND_API.G_MISS_NUM
1683: , x_lot_serial_tbl OUT NOCOPY OE_Order_PUB.Lot_serial_Tbl_Type
1684: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1685: )
1686: IS
1687: CURSOR lock_lot_serial(p_line_id NUMBER) IS

Line 1806: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type

1802:
1803: -- Function Get_Values
1804:
1805: FUNCTION Get_Values
1806: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1810: IS

Line 1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=

1803: -- Function Get_Values
1804:
1805: FUNCTION Get_Values
1806: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1810: IS
1811: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;

Line 1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC

1804:
1805: FUNCTION Get_Values
1806: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1810: IS
1811: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
1812: BEGIN

Line 1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type

1805: FUNCTION Get_Values
1806: ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1810: IS
1811: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
1812: BEGIN
1813:

Line 1811: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;

1807: , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
1808: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
1809: ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1810: IS
1811: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
1812: BEGIN
1813:
1814: NULL;
1815:

Line 1823: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type

1819:
1820: -- Function Get_Ids
1821:
1822: PROCEDURE Get_Ids
1823: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1824: , p_Lot_Serial_val_rec IN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1825: )
1826: IS
1827: BEGIN

Line 1824: , p_Lot_Serial_val_rec IN OE_Order_PUB.Lot_Serial_Val_Rec_Type

1820: -- Function Get_Ids
1821:
1822: PROCEDURE Get_Ids
1823: ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
1824: , p_Lot_Serial_val_rec IN OE_Order_PUB.Lot_Serial_Val_Rec_Type
1825: )
1826: IS
1827: BEGIN
1828: