[Home] [Help]
PACKAGE: APPS.PAY_RATES_PKG
Source
1 PACKAGE PAY_RATES_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyrat01t.pkh 115.3 2002/12/17 13:55:45 dsaxby ship $ */
3
4 PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
5 P_RATE_ID IN OUT NOCOPY NUMBER,
6 P_BUSINESS_GROUP_ID NUMBER,
7 P_PARENT_SPINE_ID NUMBER,
8 P_NAME VARCHAR2,
9 P_RATE_TYPE VARCHAR2,
10 P_RATE_UOM VARCHAR2,
11 P_COMMENTS VARCHAR2,
12 P_REQUEST_ID NUMBER,
13 P_PROGRAM_APPLICATION_ID NUMBER,
14 P_PROGRAM_ID NUMBER,
15 P_PROGRAM_UPDATE_DATE DATE,
16 P_ATTRIBUTE_CATEGORY VARCHAR2,
17 P_ATTRIBUTE1 VARCHAR2,
18 P_ATTRIBUTE2 VARCHAR2,
19 P_ATTRIBUTE3 VARCHAR2,
20 P_ATTRIBUTE4 VARCHAR2,
21 P_ATTRIBUTE5 VARCHAR2,
22 P_ATTRIBUTE6 VARCHAR2,
23 P_ATTRIBUTE7 VARCHAR2,
24 P_ATTRIBUTE8 VARCHAR2,
25 P_ATTRIBUTE9 VARCHAR2,
26 P_ATTRIBUTE10 VARCHAR2,
27 P_ATTRIBUTE11 VARCHAR2,
28 P_ATTRIBUTE12 VARCHAR2,
29 P_ATTRIBUTE13 VARCHAR2,
30 P_ATTRIBUTE14 VARCHAR2,
31 P_ATTRIBUTE15 VARCHAR2,
32 P_ATTRIBUTE16 VARCHAR2,
33 P_ATTRIBUTE17 VARCHAR2,
34 P_ATTRIBUTE18 VARCHAR2,
35 P_ATTRIBUTE19 VARCHAR2,
36 P_ATTRIBUTE20 VARCHAR2,
37 P_RATE_BASIS VARCHAR2);
38 --
39 PROCEDURE UPDATE_ROW(P_ROWID VARCHAR2,
40 P_RATE_ID NUMBER,
41 P_BUSINESS_GROUP_ID NUMBER,
42 P_PARENT_SPINE_ID NUMBER,
43 P_NAME VARCHAR2,
44 P_RATE_TYPE VARCHAR2,
45 P_RATE_UOM VARCHAR2,
46 P_COMMENTS VARCHAR2,
47 P_REQUEST_ID NUMBER,
48 P_PROGRAM_APPLICATION_ID NUMBER,
49 P_PROGRAM_ID NUMBER,
50 P_PROGRAM_UPDATE_DATE DATE,
51 P_ATTRIBUTE_CATEGORY VARCHAR2,
52 P_ATTRIBUTE1 VARCHAR2,
53 P_ATTRIBUTE2 VARCHAR2,
54 P_ATTRIBUTE3 VARCHAR2,
55 P_ATTRIBUTE4 VARCHAR2,
56 P_ATTRIBUTE5 VARCHAR2,
57 P_ATTRIBUTE6 VARCHAR2,
58 P_ATTRIBUTE7 VARCHAR2,
59 P_ATTRIBUTE8 VARCHAR2,
60 P_ATTRIBUTE9 VARCHAR2,
61 P_ATTRIBUTE10 VARCHAR2,
62 P_ATTRIBUTE11 VARCHAR2,
63 P_ATTRIBUTE12 VARCHAR2,
64 P_ATTRIBUTE13 VARCHAR2,
65 P_ATTRIBUTE14 VARCHAR2,
66 P_ATTRIBUTE15 VARCHAR2,
67 P_ATTRIBUTE16 VARCHAR2,
68 P_ATTRIBUTE17 VARCHAR2,
69 P_ATTRIBUTE18 VARCHAR2,
70 P_ATTRIBUTE19 VARCHAR2,
71 P_ATTRIBUTE20 VARCHAR2,
72 P_RATE_BASIS VARCHAR2);
73 --
74 PROCEDURE DELETE_ROW(P_ROWID VARCHAR2,
75 P_RATE_ID NUMBER,
76 P_CHILD VARCHAR2);
77 --
78 PROCEDURE LOCK_ROW(P_ROWID VARCHAR2,
79 P_RATE_ID NUMBER,
80 P_BUSINESS_GROUP_ID NUMBER,
81 P_PARENT_SPINE_ID NUMBER,
82 P_NAME VARCHAR2,
83 P_RATE_TYPE VARCHAR2,
84 P_RATE_UOM VARCHAR2,
85 P_COMMENTS VARCHAR2,
86 P_REQUEST_ID NUMBER,
87 P_PROGRAM_APPLICATION_ID NUMBER,
88 P_PROGRAM_ID NUMBER,
89 P_PROGRAM_UPDATE_DATE DATE,
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_ATTRIBUTE16 VARCHAR2,
107 P_ATTRIBUTE17 VARCHAR2,
108 P_ATTRIBUTE18 VARCHAR2,
109 P_ATTRIBUTE19 VARCHAR2,
110 P_ATTRIBUTE20 VARCHAR2,
111 P_CHILD_EXIST VARCHAR2,
112 P_MODE VARCHAR2,
113 P_RATE_BASIS VARCHAR2);
114
115 END PAY_RATES_PKG;