[Home] [Help]
PACKAGE: APPS.AHL_PRD_DISP_MTL_TXN_PVT
Source
1 PACKAGE AHL_PRD_DISP_MTL_TXN_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDMTS.pls 120.1 2005/06/10 13:53:36 appldev $ */
3
4
5 ---------------------------------
6 -- Define Record Type for Node --
7 ---------------------------------
8 TYPE Disp_Mtl_Txn_Rec_Type IS RECORD (
9 DISP_MTL_TXN_ID NUMBER,
10 OBJECT_VERSION_NUMBER NUMBER,
11 LAST_UPDATE_DATE DATE,
12 LAST_UPDATED_BY NUMBER(15) ,
13 CREATION_DATE DATE ,
14 CREATED_BY NUMBER(15) ,
15 LAST_UPDATE_LOGIN NUMBER(15),
16 DISPOSITION_ID NUMBER ,
17 WO_MTL_TXN_ID NUMBER,
18 QUANTITY NUMBER ,
19 UOM VARCHAR2(3) ,
20 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
21 ATTRIBUTE1 VARCHAR2(150) ,
22 ATTRIBUTE2 VARCHAR2(150) ,
23 ATTRIBUTE3 VARCHAR2(150) ,
24 ATTRIBUTE4 VARCHAR2(150) ,
25 ATTRIBUTE5 VARCHAR2(150) ,
26 ATTRIBUTE6 VARCHAR2(150) ,
27 ATTRIBUTE7 VARCHAR2(150) ,
28 ATTRIBUTE8 VARCHAR2(150) ,
29 ATTRIBUTE9 VARCHAR2(150) ,
30 ATTRIBUTE10 VARCHAR2(150) ,
31 ATTRIBUTE11 VARCHAR2(150) ,
32 ATTRIBUTE12 VARCHAR2(150) ,
33 ATTRIBUTE13 VARCHAR2(150) ,
34 ATTRIBUTE14 VARCHAR2(150) ,
35 ATTRIBUTE15 VARCHAR2(150)
36 );
37
38 TYPE disp_mtxn_assoc_rec_type IS RECORD (
39 DISPOSITION_ID NUMBER,
40 INVENTORY_ITEM_ID NUMBER,
41 ITEM_ORG_ID NUMBER,
42 ITEM_NUMBER VARCHAR(40),
43 ITEM_GROUP_ID NUMBER,
44 ITEM_GROUP_NAME VARCHAR(80),
45 SERIAL_NUMBER VARCHAR2(30),
46 LOT_NUMBER MTL_LOT_NUMBERS.LOT_NUMBER%TYPE,
47 IMMEDIATE_DISPOSITION_CODE VARCHAR2(30),
48 IMMEDIATE_TYPE VARCHAR(150),
49 SECONDARY_DISPOSITION_CODE VARCHAR2(30),
50 SECONDARY_TYPE VARCHAR(150),
51 STATUS_CODE VARCHAR2(30),
52 STATUS VARCHAR(80),
53 QUANTITY NUMBER,
54 UOM VARCHAR2(3),
55 ASSOC_QTY NUMBER,
56 ASSOC_UOM VARCHAR2(3),
57 UNTXNED_QTY NUMBER,
58 UNTXNED_UOM VARCHAR2(3)
59 );
60 TYPE Disp_Mtl_Txn_Tbl_Type IS TABLE OF Disp_Mtl_Txn_Rec_Type INDEX BY BINARY_INTEGER;
61
62 TYPE Disp_Mtxn_Assoc_Tbl_Type IS TABLE OF Disp_Mtxn_assoc_Rec_Type
63 INDEX BY BINARY_INTEGER;
64 ------------------------
65 -- Declare Procedures --
66 ------------------------
67 -- Start of Comments --
68 -- Procedure name : Process_Disp_Mtl_Txn
69 -- Type : Private
70 -- Function : Creates and updates the disposition material transactions.
71 -- Pre-reqs :
72 -- Parameters :
73 --
74 -- Process_Disp_Mtl_Txn Parameters:
75 -- p_x_disp_mtl_txn_tbl IN OUT NOCOPY the material transaction +
76 -- disposition records.
77 --
78 -- End of Comments.
79
80 PROCEDURE Process_Disp_Mtl_Txn (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_module IN VARCHAR2 := 'JSP',
89 p_x_disp_mtl_txn_tbl IN OUT NOCOPY AHL_PRD_DISP_MTL_TXN_PVT.Disp_Mtl_Txn_Tbl_Type);
90
91
92 ------------------------
93 -- Start of Comments --
94 -- Procedure name : Get_Disp_For_Mtl_Txn
95 -- Type : Private
96 -- Function : Fetch the matching dispositions for given material txn
97 -- Pre-reqs :
98 -- Parameters : p_wo_mtl_txn_id: The material transaction id
99 -- x_disp_list_tbl: returning list of dispositions
100 --
101 --
102 -- End of Comments.
103 PROCEDURE Get_Disp_For_Mtl_Txn (
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_wo_mtl_txn_id IN NUMBER,
112 x_disp_list_tbl OUT NOCOPY disp_mtxn_assoc_tbl_type);
113
114 ----------------------
115 -- Function name : Calculate_Txned_Qty
116 -- Type : Private
117 -- Function : Calculates the mtl transactions qtys txned for a disposition.
118 -- Pre-reqs :
119 -- Parameters :
120 --
121 -- Calculate_Txned_Qty parameters:
122 -- p_disposition_id is the disposition_id
123 -- Returns: qty of the mtl transaction that's assoc to disp. can be
124 -- >0 or =0
125 --
126 -- End of Comments.
127
128 FUNCTION Calculate_Txned_Qty(
129 p_disposition_id IN NUMBER)
130 RETURN NUMBER;
131 --Qty txned
132
133 End AHL_PRD_DISP_MTL_TXN_PVT;
134