PACKAGE: APPS.WIP_LOT_TEMP_CLEANUP

Source

1 PACKAGE WIP_LOT_TEMP_CLEANUP AUTHID CURRENT_USER AS
2 /* $Header: wipltcls.pls 115.6 2002/11/28 13:20:01 rmahidha ship $ */
3 
4   TYPE TRANSACTION_TEMP_ID_T IS TABLE OF
5   MTL_TRANSACTION_LOTS_TEMP.TRANSACTION_TEMP_ID%TYPE
6   INDEX BY BINARY_INTEGER;
7 
8   TYPE LAST_UPDATE_DATE_T IS TABLE OF
9   MTL_TRANSACTION_LOTS_TEMP.LAST_UPDATE_DATE%TYPE
10   INDEX BY BINARY_INTEGER;
11 
12   TYPE LAST_UPDATED_BY_T IS TABLE OF
13   MTL_TRANSACTION_LOTS_TEMP.LAST_UPDATED_BY%TYPE
14   INDEX BY BINARY_INTEGER;
15 
16   TYPE CREATION_DATE_T IS TABLE OF
17   MTL_TRANSACTION_LOTS_TEMP.CREATION_DATE%TYPE
18   INDEX BY BINARY_INTEGER;
19 
20   TYPE CREATED_BY_T IS TABLE OF
21   MTL_TRANSACTION_LOTS_TEMP.CREATED_BY%TYPE
22   INDEX BY BINARY_INTEGER;
23 
24   TYPE LAST_UPDATE_LOGIN_T IS TABLE OF
25   MTL_TRANSACTION_LOTS_TEMP.LAST_UPDATE_LOGIN%TYPE
26   INDEX BY BINARY_INTEGER;
27 
28   TYPE REQUEST_ID_T IS TABLE OF
29   MTL_TRANSACTION_LOTS_TEMP.REQUEST_ID%TYPE
30   INDEX BY BINARY_INTEGER;
31 
32   TYPE PROGRAM_APPLICATION_ID_T IS TABLE OF
33   MTL_TRANSACTION_LOTS_TEMP.PROGRAM_APPLICATION_ID%TYPE
34   INDEX BY BINARY_INTEGER;
35 
36   TYPE PROGRAM_ID_T IS TABLE OF
37   MTL_TRANSACTION_LOTS_TEMP.PROGRAM_ID%TYPE
38   INDEX BY BINARY_INTEGER;
39 
40   TYPE PROGRAM_UPDATE_DATE_T IS TABLE OF
41   MTL_TRANSACTION_LOTS_TEMP.PROGRAM_UPDATE_DATE%TYPE
42   INDEX BY BINARY_INTEGER;
43 
44   TYPE TRANSACTION_QUANTITY_T IS TABLE OF
45   MTL_TRANSACTION_LOTS_TEMP.TRANSACTION_QUANTITY%TYPE
46   INDEX BY BINARY_INTEGER;
47 
48   TYPE PRIMARY_QUANTITY_T IS TABLE OF
49   MTL_TRANSACTION_LOTS_TEMP.PRIMARY_QUANTITY%TYPE
50   INDEX BY BINARY_INTEGER;
51 
52   TYPE LOT_NUMBER_T IS TABLE OF
53   MTL_TRANSACTION_LOTS_TEMP.LOT_NUMBER%TYPE
54   INDEX BY BINARY_INTEGER;
55 
56   TYPE LOT_EXPIRATION_DATE_T IS TABLE OF
57   MTL_TRANSACTION_LOTS_TEMP.LOT_EXPIRATION_DATE%TYPE
58   INDEX BY BINARY_INTEGER;
59 
60   TYPE ERROR_CODE_T IS TABLE OF
61   MTL_TRANSACTION_LOTS_TEMP.ERROR_CODE%TYPE
62   INDEX BY BINARY_INTEGER;
63 
64   TYPE SERIAL_TRANSACTION_TEMP_ID_T IS TABLE OF
65   MTL_TRANSACTION_LOTS_TEMP.SERIAL_TRANSACTION_TEMP_ID%TYPE
66   INDEX BY BINARY_INTEGER;
67 
68   TYPE GROUP_HEADER_ID_T IS TABLE OF
69   MTL_TRANSACTION_LOTS_TEMP.GROUP_HEADER_ID%TYPE
70   INDEX BY BINARY_INTEGER;
71 
72   TYPE MTL_TRANSACTION_LOTS_TEMP_REC IS RECORD (
73     NUMRECS NUMBER,
74     TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID_T,
75     LAST_UPDATE_DATE LAST_UPDATE_DATE_T,
76     LAST_UPDATED_BY LAST_UPDATED_BY_T,
77     CREATION_DATE CREATION_DATE_T,
78     CREATED_BY CREATED_BY_T,
79     LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_T,
80     REQUEST_ID REQUEST_ID_T,
81     PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID_T,
82     PROGRAM_ID PROGRAM_ID_T,
83     PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE_T,
84     TRANSACTION_QUANTITY TRANSACTION_QUANTITY_T,
85     PRIMARY_QUANTITY PRIMARY_QUANTITY_T,
86     LOT_NUMBER LOT_NUMBER_T,
87     LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE_T,
88     ERROR_CODE ERROR_CODE_T,
89     SERIAL_TRANSACTION_TEMP_ID SERIAL_TRANSACTION_TEMP_ID_T,
90     GROUP_HEADER_ID GROUP_HEADER_ID_T
91   );
92 
93   procedure insert_rows(p_lots in mtl_transaction_lots_temp_rec);
94 
95 END WIP_LOT_TEMP_CLEANUP;