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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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,
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;