[Home] [Help]
PACKAGE: APPS.CSD_MRO_SERIAL_NUMBERS_PKG
Source
1 PACKAGE CSD_MRO_SERIAL_NUMBERS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtsrls.pls 115.4 2002/11/08 20:21:28 swai noship $ */
3
4 PROCEDURE Insert_Row(
5 px_MRO_SERIAL_NUMBER_ID IN OUT NOCOPY NUMBER
6 ,p_REPAIR_GROUP_ID NUMBER
7 ,p_SERIAL_NUMBER VARCHAR2
8 ,p_VALIDATE_LEVEL VARCHAR2
9 ,p_CREATED_BY NUMBER
10 ,p_CREATION_DATE DATE
11 ,p_LAST_UPDATED_BY NUMBER
12 ,p_LAST_UPDATE_DATE DATE
13 ,p_LAST_UPDATE_LOGIN NUMBER
14 ,p_CONTEXT VARCHAR2
15 ,p_ATTRIBUTE1 VARCHAR2
16 ,p_ATTRIBUTE2 VARCHAR2
17 ,p_ATTRIBUTE3 VARCHAR2
18 ,p_ATTRIBUTE4 VARCHAR2
19 ,p_ATTRIBUTE5 VARCHAR2
20 ,p_ATTRIBUTE6 VARCHAR2
21 ,p_ATTRIBUTE7 VARCHAR2
22 ,p_ATTRIBUTE8 VARCHAR2
23 ,p_ATTRIBUTE9 VARCHAR2
24 ,p_ATTRIBUTE10 VARCHAR2
25 ,p_ATTRIBUTE11 VARCHAR2
26 ,p_ATTRIBUTE12 VARCHAR2
27 ,p_ATTRIBUTE13 VARCHAR2
28 ,p_ATTRIBUTE14 VARCHAR2
29 ,p_ATTRIBUTE15 VARCHAR2
30 ,p_OBJECT_VERSION_NUMBER NUMBER
31 ,p_CUSTOMER_PRODUCT_ID NUMBER
32 ,p_REFERENCE_NUMBER VARCHAR2);
33
34 PROCEDURE Update_Row(
35 p_MRO_SERIAL_NUMBER_ID NUMBER
36 ,p_REPAIR_GROUP_ID NUMBER
37 ,p_SERIAL_NUMBER VARCHAR2
38 ,p_VALIDATE_LEVEL VARCHAR2
39 ,p_CREATED_BY NUMBER
40 ,p_CREATION_DATE DATE
41 ,p_LAST_UPDATED_BY NUMBER
42 ,p_LAST_UPDATE_DATE DATE
43 ,p_LAST_UPDATE_LOGIN NUMBER
44 ,p_CONTEXT VARCHAR2
45 ,p_ATTRIBUTE1 VARCHAR2
46 ,p_ATTRIBUTE2 VARCHAR2
47 ,p_ATTRIBUTE3 VARCHAR2
48 ,p_ATTRIBUTE4 VARCHAR2
49 ,p_ATTRIBUTE5 VARCHAR2
50 ,p_ATTRIBUTE6 VARCHAR2
51 ,p_ATTRIBUTE7 VARCHAR2
52 ,p_ATTRIBUTE8 VARCHAR2
53 ,p_ATTRIBUTE9 VARCHAR2
54 ,p_ATTRIBUTE10 VARCHAR2
55 ,p_ATTRIBUTE11 VARCHAR2
56 ,p_ATTRIBUTE12 VARCHAR2
57 ,p_ATTRIBUTE13 VARCHAR2
58 ,p_ATTRIBUTE14 VARCHAR2
59 ,p_ATTRIBUTE15 VARCHAR2
60 ,p_OBJECT_VERSION_NUMBER NUMBER
61 ,p_CUSTOMER_PRODUCT_ID NUMBER
62 ,p_REFERENCE_NUMBER VARCHAR2);
63
64 PROCEDURE Lock_Row(
65 p_MRO_SERIAL_NUMBER_ID NUMBER
66 ,p_OBJECT_VERSION_NUMBER NUMBER);
67
68 PROCEDURE Delete_Row(
69 p_MRO_SERIAL_NUMBER_ID NUMBER);
70 End CSD_MRO_SERIAL_NUMBERS_PKG;