PACKAGE: APPS.INV_VALIDATE_TROLIN

Source

1 PACKAGE INV_Validate_Trolin AS
2 /* $Header: INVLTRLS.pls 120.1 2005/12/13 05:00:47 jrayarot noship $ */
3 
4 
5 SUBTYPE item IS mtl_system_items%ROWTYPE;
6 SUBTYPE sub  IS mtl_secondary_inventories%ROWTYPE;
7 SUBTYPE locator IS mtl_item_locations%ROWTYPE;
8 SUBTYPE lot IS mtl_lot_numbers%ROWTYPE;
9 SUBTYPE serial IS mtl_serial_numbers%ROWTYPE;
10 SUBTYPE transaction IS mtl_transaction_types%ROWTYPE;
11 
12 T CONSTANT NUMBER := 1;
13 F CONSTANT NUMBER := 0;
14 
15 g_item ITEM;
16 g_from_sub  SUB;
17 g_from_locator LOCATOR;
18 g_to_sub SUB;
19 g_to_locator LOCATOR;
20 g_lot LOT;
21 g_serial SERIAL;
22 g_transaction_l transaction;
23 
24 
25 --Line level validations
26 
27 FUNCTION Line(p_line_id IN NUMBER)RETURN NUMBER;
28 
29 FUNCTION Line_Number(p_line_number IN NUMBER,
30 		     p_header_id IN NUMBER,
31 		     p_org IN inv_validate_trohdr.ORG)RETURN NUMBER;
32 
33 FUNCTION Line_Status(p_line_status IN NUMBER)RETURN NUMBER;
34 
35 FUNCTION Quantity_Delivered(p_quantity_delivered IN NUMBER)RETURN NUMBER;
36 
37 FUNCTION Quantity_Detailed(p_quantity_detailed IN NUMBER)RETURN NUMBER;
38 
39 --INVCONV
40 FUNCTION Secondary_Quantity_Delivered(p_secondary_quantity_delivered IN NUMBER)RETURN NUMBER;
41 
42 FUNCTION Secondary_Quantity_Detailed(p_secondary_quantity_detailed IN NUMBER)RETURN NUMBER;
43 
44 --INVCONV
45 
46 --  Procedure Entity
47 
48 PROCEDURE Entity
49 (   x_return_status                 OUT NOCOPY VARCHAR2
50 ,   p_trolin_rec                    IN  INV_Move_Order_PUB.Trolin_Rec_Type
51 ,   p_old_trolin_rec                IN  INV_Move_Order_PUB.Trolin_Rec_Type := INV_Move_Order_PUB.G_MISS_TROLIN_REC
52 ,   p_move_order_type		    IN  NUMBER DEFAULT INV_GLOBALS.G_MOVE_ORDER_REQUISITION
53 );
54 
55 
56 --  Procedure Attributes
57 
58 PROCEDURE Attributes
59 (   x_return_status                 OUT NOCOPY VARCHAR2
60 ,   p_trolin_rec                    IN OUT NOCOPY INV_Move_Order_PUB.Trolin_Rec_Type
61 ,   p_trolin_val_rec                IN  INV_Move_Order_PUB.Trolin_Val_Rec_Type
62 ,   p_old_trolin_rec                IN  INV_Move_Order_PUB.Trolin_Rec_Type :=
63                                         INV_Move_Order_PUB.G_MISS_TROLIN_REC
64 );
65 
66 
67 --  Procedure Entity_Delete
68 
69 PROCEDURE Entity_Delete
70 (   x_return_status                 OUT NOCOPY VARCHAR2
71 ,   p_trolin_rec                    IN  INV_Move_Order_PUB.Trolin_Rec_Type
72 );
73 
74 -- Bug # 1911054
75 -- Procedure Init : used to initialized the global variable created in this package
76 PROCEDURE Init;
77 
78 END INV_Validate_Trolin;