1 PACKAGE PN_PAY_GROUP_RULES_PKG AUTHID CURRENT_USER AS
2 --$Header: PNGRPRLS.pls 115.1 2004/02/12 08:33:09 kkhegde noship $
3
4 -- insert row
5
6 PROCEDURE insert_row(
7 x_GROUPING_RULE_ID IN OUT NOCOPY NUMBER
8 ,x_NAME IN VARCHAR2
9 ,x_DESCRIPTION IN VARCHAR2
10 ,x_LAST_UPDATE_DATE IN DATE
11 ,x_LAST_UPDATED_BY IN NUMBER
12 ,x_CREATION_DATE IN DATE
13 ,x_CREATED_BY IN NUMBER
14 ,x_LAST_UPDATE_LOGIN IN NUMBER
15 ,x_ATTRIBUTE_CATEGORY IN VARCHAR2
16 ,x_ATTRIBUTE1 IN VARCHAR2
17 ,x_ATTRIBUTE2 IN VARCHAR2
18 ,x_ATTRIBUTE3 IN VARCHAR2
19 ,x_ATTRIBUTE4 IN VARCHAR2
20 ,x_ATTRIBUTE5 IN VARCHAR2
21 ,x_ATTRIBUTE6 IN VARCHAR2
22 ,x_ATTRIBUTE7 IN VARCHAR2
23 ,x_ATTRIBUTE8 IN VARCHAR2
24 ,x_ATTRIBUTE9 IN VARCHAR2
25 ,x_ATTRIBUTE10 IN VARCHAR2
26 ,x_ATTRIBUTE11 IN VARCHAR2
27 ,x_ATTRIBUTE12 IN VARCHAR2
28 ,x_ATTRIBUTE13 IN VARCHAR2
29 ,x_ATTRIBUTE14 IN VARCHAR2
30 ,x_ATTRIBUTE15 IN VARCHAR2);
31
32 -- update row
33
34 PROCEDURE update_row(
35 x_GROUPING_RULE_ID IN NUMBER
36 ,x_NAME IN VARCHAR2
37 ,x_DESCRIPTION IN VARCHAR2
38 ,x_LAST_UPDATE_DATE IN DATE
39 ,x_LAST_UPDATED_BY IN NUMBER
40 ,x_LAST_UPDATE_LOGIN IN NUMBER
41 ,x_ATTRIBUTE_CATEGORY IN VARCHAR2
42 ,x_ATTRIBUTE1 IN VARCHAR2
43 ,x_ATTRIBUTE2 IN VARCHAR2
44 ,x_ATTRIBUTE3 IN VARCHAR2
45 ,x_ATTRIBUTE4 IN VARCHAR2
46 ,x_ATTRIBUTE5 IN VARCHAR2
47 ,x_ATTRIBUTE6 IN VARCHAR2
48 ,x_ATTRIBUTE7 IN VARCHAR2
49 ,x_ATTRIBUTE8 IN VARCHAR2
50 ,x_ATTRIBUTE9 IN VARCHAR2
51 ,x_ATTRIBUTE10 IN VARCHAR2
52 ,x_ATTRIBUTE11 IN VARCHAR2
53 ,x_ATTRIBUTE12 IN VARCHAR2
54 ,x_ATTRIBUTE13 IN VARCHAR2
55 ,x_ATTRIBUTE14 IN VARCHAR2
56 ,x_ATTRIBUTE15 IN VARCHAR2);
57
58 -- lock row
59
60 PROCEDURE lock_row(
61 x_GROUPING_RULE_ID IN NUMBER
62 ,x_NAME IN VARCHAR2
63 ,x_DESCRIPTION IN VARCHAR2
64 ,x_ATTRIBUTE_CATEGORY IN VARCHAR2
65 ,x_ATTRIBUTE1 IN VARCHAR2
66 ,x_ATTRIBUTE2 IN VARCHAR2
67 ,x_ATTRIBUTE3 IN VARCHAR2
68 ,x_ATTRIBUTE4 IN VARCHAR2
69 ,x_ATTRIBUTE5 IN VARCHAR2
70 ,x_ATTRIBUTE6 IN VARCHAR2
71 ,x_ATTRIBUTE7 IN VARCHAR2
72 ,x_ATTRIBUTE8 IN VARCHAR2
73 ,x_ATTRIBUTE9 IN VARCHAR2
74 ,x_ATTRIBUTE10 IN VARCHAR2
75 ,x_ATTRIBUTE11 IN VARCHAR2
76 ,x_ATTRIBUTE12 IN VARCHAR2
77 ,x_ATTRIBUTE13 IN VARCHAR2
78 ,x_ATTRIBUTE14 IN VARCHAR2
79 ,x_ATTRIBUTE15 IN VARCHAR2);
80
81 -- delete row
82
83 PROCEDURE delete_row(
84 x_GROUPING_RULE_ID IN NUMBER);
85
86 END PN_PAY_GROUP_RULES_PKG;
[Home] [Help]