DBA Data[Home] [Help]

APPS.WIP_SERIAL_TEMP_CLEANUP dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 5: MTL_SERIAL_NUMBERS_TEMP.TRANSACTION_TEMP_ID%TYPE

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 72: TYPE MTL_SERIAL_NUMBERS_TEMP_REC IS RECORD (

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,

Line 93: procedure insert_rows(p_serials in mtl_serial_numbers_temp_rec);

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;