PACKAGE: APPS.WIP_SERIAL_TEMP_CLEANUP

Source

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;