1 PACKAGE ARP_IER_PKG AUTHID CURRENT_USER as
2 /* $Header: ARXIIERS.pls 115.2 2003/08/17 02:20:21 ykonishi ship $ */
3
4
5 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
6 p_Item_Exception_Rate_Id IN OUT NOCOPY NUMBER,
7 p_Creation_Date DATE,
8 p_Created_By NUMBER,
9 p_Last_Update_Login NUMBER,
10 p_Last_Updated_By NUMBER,
11 p_Last_Update_Date DATE,
12 p_Item_Id NUMBER,
13 p_Rate_Context VARCHAR2,
14 p_Location1_Rate NUMBER,
15 p_Location2_Rate NUMBER,
16 p_Location3_Rate NUMBER,
17 p_Location4_Rate NUMBER,
18 p_Location5_Rate NUMBER,
19 p_Location6_Rate NUMBER,
20 p_Location7_Rate NUMBER,
21 p_Location8_Rate NUMBER,
22 p_Location9_Rate NUMBER,
23 p_Location10_Rate NUMBER,
24 p_Start_Date DATE,
25 p_End_Date DATE,
26 p_Attribute_Category VARCHAR2,
27 p_Attribute1 VARCHAR2,
28 p_Attribute2 VARCHAR2,
29 p_Attribute3 VARCHAR2,
30 p_Attribute4 VARCHAR2,
31 p_Attribute5 VARCHAR2,
32 p_Attribute6 VARCHAR2,
33 p_Attribute7 VARCHAR2,
34 p_Attribute8 VARCHAR2,
35 p_Attribute9 VARCHAR2,
36 p_Attribute10 VARCHAR2,
37 p_Attribute11 VARCHAR2,
38 p_Attribute12 VARCHAR2,
39 p_Attribute13 VARCHAR2,
40 p_Attribute14 VARCHAR2,
41 p_Attribute15 VARCHAR2,
42 p_Reason_Code VARCHAR2,
43 p_Location_Context VARCHAR2,
44 p_Location_Id_Segment_1 NUMBER,
45 p_Location_Id_Segment_2 NUMBER,
46 p_Location_Id_Segment_3 NUMBER,
47 p_Location_Id_Segment_4 NUMBER,
48 p_Location_Id_Segment_5 NUMBER,
49 p_Location_Id_Segment_6 NUMBER,
50 p_Location_Id_Segment_7 NUMBER,
51 p_Location_Id_Segment_8 NUMBER,
52 p_Location_Id_Segment_9 NUMBER,
53 p_Location_Id_Segment_10 NUMBER,
54 p_org_id NUMBER DEFAULT -1 -- Bug 3098063
55 );
56
57 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
58 p_Item_Exception_Rate_Id NUMBER,
59 p_Item_Id NUMBER,
60 p_Rate_Context VARCHAR2,
61 p_Location1_Rate NUMBER,
62 p_Location2_Rate NUMBER,
63 p_Location3_Rate NUMBER,
64 p_Location4_Rate NUMBER,
65 p_Location5_Rate NUMBER,
66 p_Location6_Rate NUMBER,
67 p_Location7_Rate NUMBER,
68 p_Location8_Rate NUMBER,
69 p_Location9_Rate NUMBER,
70 p_Location10_Rate NUMBER,
71 p_Start_Date DATE,
72 p_End_Date DATE,
73 p_Attribute_Category VARCHAR2,
74 p_Attribute1 VARCHAR2,
75 p_Attribute2 VARCHAR2,
76 p_Attribute3 VARCHAR2,
77 p_Attribute4 VARCHAR2,
78 p_Attribute5 VARCHAR2,
79 p_Attribute6 VARCHAR2,
80 p_Attribute7 VARCHAR2,
81 p_Attribute8 VARCHAR2,
82 p_Attribute9 VARCHAR2,
83 p_Attribute10 VARCHAR2,
84 p_Attribute11 VARCHAR2,
85 p_Attribute12 VARCHAR2,
86 p_Attribute13 VARCHAR2,
87 p_Attribute14 VARCHAR2,
88 p_Attribute15 VARCHAR2,
89 p_Reason_Code VARCHAR2,
90 p_Location_Context VARCHAR2,
91 p_Location_Id_Segment_1 NUMBER,
92 p_Location_Id_Segment_2 NUMBER,
93 p_Location_Id_Segment_3 NUMBER,
94 p_Location_Id_Segment_4 NUMBER,
95 p_Location_Id_Segment_5 NUMBER,
96 p_Location_Id_Segment_6 NUMBER,
97 p_Location_Id_Segment_7 NUMBER,
98 p_Location_Id_Segment_8 NUMBER,
99 p_Location_Id_Segment_9 NUMBER,
100 p_Location_Id_Segment_10 NUMBER
101 );
102
103
104
105 PROCEDURE Update_Row(p_Rowid VARCHAR2,
106 p_Item_Exception_Rate_Id NUMBER,
107 p_Last_Update_Login NUMBER,
108 p_Last_Updated_By NUMBER,
109 p_Last_Update_Date DATE,
110 p_Item_Id NUMBER,
111 p_Rate_Context VARCHAR2,
112 p_Location1_Rate NUMBER,
113 p_Location2_Rate NUMBER,
114 p_Location3_Rate NUMBER,
115 p_Location4_Rate NUMBER,
116 p_Location5_Rate NUMBER,
117 p_Location6_Rate NUMBER,
118 p_Location7_Rate NUMBER,
119 p_Location8_Rate NUMBER,
120 p_Location9_Rate NUMBER,
121 p_Location10_Rate NUMBER,
122 p_Start_Date DATE,
123 p_End_Date DATE,
124 p_Attribute_Category VARCHAR2,
125 p_Attribute1 VARCHAR2,
126 p_Attribute2 VARCHAR2,
127 p_Attribute3 VARCHAR2,
128 p_Attribute4 VARCHAR2,
129 p_Attribute5 VARCHAR2,
130 p_Attribute6 VARCHAR2,
131 p_Attribute7 VARCHAR2,
132 p_Attribute8 VARCHAR2,
133 p_Attribute9 VARCHAR2,
134 p_Attribute10 VARCHAR2,
135 p_Attribute11 VARCHAR2,
136 p_Attribute12 VARCHAR2,
137 p_Attribute13 VARCHAR2,
138 p_Attribute14 VARCHAR2,
139 p_Attribute15 VARCHAR2,
140 p_Reason_Code VARCHAR2,
141 p_Location_Context VARCHAR2,
142 p_Location_Id_Segment_1 NUMBER,
143 p_Location_Id_Segment_2 NUMBER,
144 p_Location_Id_Segment_3 NUMBER,
145 p_Location_Id_Segment_4 NUMBER,
146 p_Location_Id_Segment_5 NUMBER,
147 p_Location_Id_Segment_6 NUMBER,
148 p_Location_Id_Segment_7 NUMBER,
149 p_Location_Id_Segment_8 NUMBER,
150 p_Location_Id_Segment_9 NUMBER,
151 p_Location_Id_Segment_10 NUMBER,
152 p_org_id NUMBER DEFAULT -1 -- Bug 3098063
153 );
154 PROCEDURE Delete_Row(p_Rowid VARCHAR2);
155
156 END ARP_IER_PKG;
|
|
|