1 PACKAGE CSD_AHL_W_CONTRACT_XREF_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtawcs.pls 120.2 2011/07/12 00:12:31 yvchen noship $ */
3 -- Start of Comments
4 -- Package name : CSD_AHL_W_CONTRACT_XREF_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_WARRANTY_CONTRACT_XREF_ID IN OUT NOCOPY NUMBER
12 ,p_OBJECT_VERSION_NUMBER NUMBER
13 ,p_CREATED_BY NUMBER
14 ,p_CREATION_DATE DATE
15 ,p_LAST_UPDATED_BY NUMBER
16 ,p_LAST_UPDATE_DATE DATE
17 ,p_LAST_UPDATE_LOGIN NUMBER
18 ,p_SOURCE_TABLE VARCHAR2
19 ,p_SOURCE_COLUMN VARCHAR2
20 ,p_SOURCE_ID NUMBER
21 ,p_WARRANTY_CONTRACT_ID NUMBER
22 ,p_ATTRIBUTE_CATEGORY VARCHAR2
23 ,p_ATTRIBUTE1 VARCHAR2
24 ,p_ATTRIBUTE2 VARCHAR2
25 ,p_ATTRIBUTE3 VARCHAR2
26 ,p_ATTRIBUTE4 VARCHAR2
27 ,p_ATTRIBUTE5 VARCHAR2
28 ,p_ATTRIBUTE6 VARCHAR2
29 ,p_ATTRIBUTE7 VARCHAR2
30 ,p_ATTRIBUTE8 VARCHAR2
31 ,p_ATTRIBUTE9 VARCHAR2
32 ,p_ATTRIBUTE10 VARCHAR2
33 ,p_ATTRIBUTE11 VARCHAR2
34 ,p_ATTRIBUTE12 VARCHAR2
35 ,p_ATTRIBUTE13 VARCHAR2
36 ,p_ATTRIBUTE14 VARCHAR2
37 ,p_ATTRIBUTE15 VARCHAR2
38 ,p_REPAIR_LINE_ID NUMBER
39 ,p_INSTANCE_ID NUMBER); --yvchen
40
41 /*This Update_Row is not need for R12.2 project.. this procedure was auto generate.
42 It has not fully testing.. This procedure is not use by any of Depot code
43 any dev plan to use it, please test and make sure it is working */
44 PROCEDURE Update_Row(
45 p_WARRANTY_CONTRACT_XREF_ID NUMBER
46 ,p_OBJECT_VERSION_NUMBER NUMBER
47 ,p_CREATED_BY NUMBER
48 ,p_CREATION_DATE DATE
49 ,p_LAST_UPDATED_BY NUMBER
50 ,p_LAST_UPDATE_DATE DATE
51 ,p_LAST_UPDATE_LOGIN NUMBER
52 ,p_SOURCE_TABLE VARCHAR2
53 ,p_SOURCE_COLUMN VARCHAR2
54 ,p_SOURCE_ID NUMBER
55 ,p_WARRANTY_CONTRACT_ID NUMBER
56 ,p_ATTRIBUTE_CATEGORY VARCHAR2
57 ,p_ATTRIBUTE1 VARCHAR2
58 ,p_ATTRIBUTE2 VARCHAR2
59 ,p_ATTRIBUTE3 VARCHAR2
60 ,p_ATTRIBUTE4 VARCHAR2
61 ,p_ATTRIBUTE5 VARCHAR2
62 ,p_ATTRIBUTE6 VARCHAR2
63 ,p_ATTRIBUTE7 VARCHAR2
64 ,p_ATTRIBUTE8 VARCHAR2
65 ,p_ATTRIBUTE9 VARCHAR2
66 ,p_ATTRIBUTE10 VARCHAR2
67 ,p_ATTRIBUTE11 VARCHAR2
68 ,p_ATTRIBUTE12 VARCHAR2
69 ,p_ATTRIBUTE13 VARCHAR2
70 ,p_ATTRIBUTE14 VARCHAR2
71 ,p_ATTRIBUTE15 VARCHAR2
72 ,p_REPAIR_LINE_ID NUMBER
73 ,p_INSTANCE_ID NUMBER); --yvchen
74
75 /*This Lock_Row is not need for R12.2 project.. this procedure was auto generate.
76 It has not fully testing.. This procedure is not use by any of Depot code
77 any dev plan to use it, please test and make sure it is working */
78 PROCEDURE Lock_Row(
79 p_WARRANTY_CONTRACT_XREF_ID NUMBER
80 ,p_OBJECT_VERSION_NUMBER NUMBER
81 ,p_CREATED_BY NUMBER
82 ,p_CREATION_DATE DATE
83 ,p_LAST_UPDATED_BY NUMBER
84 ,p_LAST_UPDATE_DATE DATE
85 ,p_LAST_UPDATE_LOGIN NUMBER
86 ,p_SOURCE_TABLE VARCHAR2
87 ,p_SOURCE_COLUMN VARCHAR2
88 ,p_SOURCE_ID NUMBER
89 ,p_WARRANTY_CONTRACT_ID NUMBER
90 ,p_ATTRIBUTE_CATEGORY VARCHAR2
91 ,p_ATTRIBUTE1 VARCHAR2
92 ,p_ATTRIBUTE2 VARCHAR2
93 ,p_ATTRIBUTE3 VARCHAR2
94 ,p_ATTRIBUTE4 VARCHAR2
95 ,p_ATTRIBUTE5 VARCHAR2
96 ,p_ATTRIBUTE6 VARCHAR2
97 ,p_ATTRIBUTE7 VARCHAR2
98 ,p_ATTRIBUTE8 VARCHAR2
99 ,p_ATTRIBUTE9 VARCHAR2
100 ,p_ATTRIBUTE10 VARCHAR2
101 ,p_ATTRIBUTE11 VARCHAR2
102 ,p_ATTRIBUTE12 VARCHAR2
103 ,p_ATTRIBUTE13 VARCHAR2
104 ,p_ATTRIBUTE14 VARCHAR2
105 ,p_ATTRIBUTE15 VARCHAR2
106 ,p_REPAIR_LINE_ID NUMBER
107 ,p_INSTANCE_ID NUMBER); --yvchen
108
109 /*This Delete_Row is not need for R12.2 project.. this procedure was auto generate.
110 It has not fully testing.. This procedure is not use by any of Depot code
111 any dev plan to use it, please test and make sure it is working */
112 PROCEDURE Delete_Row(
113 p_WARRANTY_CONTRACT_XREF_ID NUMBER);
114 End CSD_AHL_W_CONTRACT_XREF_PKG;