1 PACKAGE PSB_PAY_ELEMENT_OPTIONS_PVT AS
2 /* $Header: PSBVOPTS.pls 120.2 2005/07/13 11:27:33 shtripat ship $ */
3
4
5 PROCEDURE INSERT_ROW
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 P_PAY_ELEMENT_OPTION_ID in NUMBER,
15 P_PAY_ELEMENT_ID in NUMBER,
16 P_NAME in VARCHAR2,
17 P_GRADE_STEP in NUMBER,
18 P_SEQUENCE_NUMBER IN NUMBER,
19 P_LAST_UPDATE_DATE in DATE,
20 P_LAST_UPDATED_BY in NUMBER,
21 P_LAST_UPDATE_LOGIN in NUMBER,
22 P_CREATED_BY in NUMBER,
23 P_CREATION_DATE in DATE
24 );
25
26 PROCEDURE UPDATE_ROW
27 ( p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 p_commit IN VARCHAR2 := FND_API.G_FALSE,
30 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_return_status OUT NOCOPY VARCHAR2,
32 p_msg_count OUT NOCOPY NUMBER,
33 p_msg_data OUT NOCOPY VARCHAR2,
34 --
35 P_PAY_ELEMENT_OPTION_ID in NUMBER,
36 P_PAY_ELEMENT_ID in NUMBER,
37 P_NAME in VARCHAR2,
38 P_GRADE_STEP in NUMBER,
39 P_SEQUENCE_NUMBER IN NUMBER,
40 P_LAST_UPDATE_DATE in DATE,
41 P_LAST_UPDATED_BY in NUMBER,
42 P_LAST_UPDATE_LOGIN in NUMBER
43 );
44
45 PROCEDURE DELETE_ROW
46 ( p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50 p_return_status OUT NOCOPY VARCHAR2,
51 p_msg_count OUT NOCOPY NUMBER,
52 p_msg_data OUT NOCOPY VARCHAR2,
53 --
54 P_PAY_ELEMENT_OPTION_ID in NUMBER,
55 P_PAY_ELEMENT_ID in NUMBER
56 );
57
58 PROCEDURE LOCK_ROW
59 ( p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_return_status OUT NOCOPY VARCHAR2,
64 p_msg_count OUT NOCOPY NUMBER,
65 p_msg_data OUT NOCOPY VARCHAR2,
66 --
67 p_row_locked OUT NOCOPY VARCHAR2,
68 --
69 P_PAY_ELEMENT_OPTION_ID in NUMBER,
70 P_PAY_ELEMENT_ID in NUMBER,
71 P_NAME in VARCHAR2,
72 P_GRADE_STEP in NUMBER,
73 P_SEQUENCE_NUMBER IN NUMBER
74 );
75
76 PROCEDURE Check_Unique
77 (
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 p_return_status OUT NOCOPY VARCHAR2,
83 p_msg_count OUT NOCOPY NUMBER,
84 p_msg_data OUT NOCOPY VARCHAR2,
85 --
86 P_PAY_ELEMENT_OPTION_ID in NUMBER,
87 P_PAY_ELEMENT_ID in NUMBER,
88 P_Name IN VARCHAR2,
89 P_GRADE_STEP IN NUMBER,
90 P_Return_Value IN OUT NOCOPY VARCHAR2
91 );
92
93
94 PROCEDURE Check_References
95 (
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98 p_commit IN VARCHAR2 := FND_API.G_FALSE,
99 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100 p_return_status OUT NOCOPY VARCHAR2,
101 p_msg_count OUT NOCOPY NUMBER,
102 p_msg_data OUT NOCOPY VARCHAR2,
103 --
104 P_PAY_ELEMENT_OPTION_ID in NUMBER,
105 P_PAY_ELEMENT_ID in NUMBER,
106 P_Return_Value IN OUT NOCOPY VARCHAR2
107 );
108
109
110 END PSB_PAY_ELEMENT_OPTIONS_PVT;