1 PACKAGE WIP_SERIAL_TEMP_CLEANUP AUTHID CURRENT_USER AS
2 /* $Header: wipstcls.pls 115.6 2002/12/12 16:02:20 rmahidha ship $ */
3
4 TYPE TRANSACTION_TEMP_ID_T IS TABLE OF
5 MTL_SERIAL_NUMBERS_TEMP.TRANSACTION_TEMP_ID%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 TYPE LAST_UPDATE_DATE_T IS TABLE OF
9 MTL_SERIAL_NUMBERS_TEMP.LAST_UPDATE_DATE%TYPE
10 INDEX BY BINARY_INTEGER;
11
12 TYPE LAST_UPDATED_BY_T IS TABLE OF
13 MTL_SERIAL_NUMBERS_TEMP.LAST_UPDATED_BY%TYPE
14 INDEX BY BINARY_INTEGER;
15
16 TYPE CREATION_DATE_T IS TABLE OF
17 MTL_SERIAL_NUMBERS_TEMP.CREATION_DATE%TYPE
18 INDEX BY BINARY_INTEGER;
19
20 TYPE CREATED_BY_T IS TABLE OF
21 MTL_SERIAL_NUMBERS_TEMP.CREATED_BY%TYPE
22 INDEX BY BINARY_INTEGER;
23
24 TYPE LAST_UPDATE_LOGIN_T IS TABLE OF
25 MTL_SERIAL_NUMBERS_TEMP.LAST_UPDATE_LOGIN%TYPE
26 INDEX BY BINARY_INTEGER;
27
28 TYPE REQUEST_ID_T IS TABLE OF
29 MTL_SERIAL_NUMBERS_TEMP.REQUEST_ID%TYPE
30 INDEX BY BINARY_INTEGER;
31
32 TYPE PROGRAM_APPLICATION_ID_T IS TABLE OF
33 MTL_SERIAL_NUMBERS_TEMP.PROGRAM_APPLICATION_ID%TYPE
34 INDEX BY BINARY_INTEGER;
35
36 TYPE PROGRAM_ID_T IS TABLE OF
37 MTL_SERIAL_NUMBERS_TEMP.PROGRAM_ID%TYPE
38 INDEX BY BINARY_INTEGER;
39
40 TYPE PROGRAM_UPDATE_DATE_T IS TABLE OF
41 MTL_SERIAL_NUMBERS_TEMP.PROGRAM_UPDATE_DATE%TYPE
42 INDEX BY BINARY_INTEGER;
43
44 TYPE VENDOR_SERIAL_NUMBER_T IS TABLE OF
45 MTL_SERIAL_NUMBERS_TEMP.VENDOR_SERIAL_NUMBER%TYPE
46 INDEX BY BINARY_INTEGER;
47
48 TYPE VENDOR_LOT_NUMBER_T IS TABLE OF
49 MTL_SERIAL_NUMBERS_TEMP.VENDOR_LOT_NUMBER%TYPE
50 INDEX BY BINARY_INTEGER;
51
52 TYPE FM_SERIAL_NUMBER_T IS TABLE OF
53 MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE
54 INDEX BY BINARY_INTEGER;
55
56 TYPE TO_SERIAL_NUMBER_T IS TABLE OF
57 MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE
58 INDEX BY BINARY_INTEGER;
59
60 TYPE SERIAL_PREFIX_T IS TABLE OF
61 MTL_SERIAL_NUMBERS_TEMP.SERIAL_PREFIX%TYPE
62 INDEX BY BINARY_INTEGER;
63
64 TYPE ERROR_CODE_T IS TABLE OF
65 MTL_SERIAL_NUMBERS_TEMP.ERROR_CODE%TYPE
66 INDEX BY BINARY_INTEGER;
67
68 TYPE GROUP_HEADER_ID_T IS TABLE OF
69 MTL_SERIAL_NUMBERS_TEMP.GROUP_HEADER_ID%TYPE
70 INDEX BY BINARY_INTEGER;
71
72 TYPE MTL_SERIAL_NUMBERS_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 VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER_T,
85 VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER_T,
86 FM_SERIAL_NUMBER FM_SERIAL_NUMBER_T,
87 TO_SERIAL_NUMBER TO_SERIAL_NUMBER_T,
88 SERIAL_PREFIX SERIAL_PREFIX_T,
89 ERROR_CODE ERROR_CODE_T,
90 GROUP_HEADER_ID GROUP_HEADER_ID_T
91 );
92
93 procedure insert_rows(p_serials in mtl_serial_numbers_temp_rec);
94
95 END WIP_SERIAL_TEMP_CLEANUP;