1 PACKAGE PSB_PAY_ELEMENT_RATES_PVT AS
2 /* $Header: PSBVRTSS.pls 120.2 2005/07/13 11:29:31 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_RATE_ID in NUMBER,
15 P_PAY_ELEMENT_OPTION_ID in NUMBER,
16 P_PAY_ELEMENT_ID in NUMBER,
17 P_EFFECTIVE_START_DATE in DATE,
18 P_EFFECTIVE_END_DATE in DATE,
19 P_WORKSHEET_ID in NUMBER,
20 P_ELEMENT_VALUE_TYPE in VARCHAR2,
21 P_ELEMENT_VALUE in NUMBER,
22 P_PAY_BASIS in VARCHAR2,
23 P_FORMULA_ID in NUMBER,
24 P_MAXIMUM_VALUE in NUMBER,
25 P_MID_VALUE in NUMBER,
26 P_MINIMUM_VALUE in NUMBER,
27 P_CURRENCY_CODE IN VARCHAR2,
28 P_LAST_UPDATE_DATE in DATE,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_LOGIN in NUMBER,
31 P_CREATED_BY in NUMBER,
32 P_CREATION_DATE in DATE
33 );
34
35 PROCEDURE UPDATE_ROW
36 ( p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40 p_return_status OUT NOCOPY VARCHAR2,
41 p_msg_count OUT NOCOPY NUMBER,
42 p_msg_data OUT NOCOPY VARCHAR2,
43 --
44 P_PAY_ELEMENT_RATE_ID in NUMBER,
45 P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
46 P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
47 P_ELEMENT_VALUE_TYPE in VARCHAR2,
48 P_ELEMENT_VALUE in NUMBER,
49 P_PAY_BASIS in VARCHAR2,
50 P_FORMULA_ID in NUMBER,
51 P_MAXIMUM_VALUE in NUMBER,
52 P_MID_VALUE in NUMBER,
53 P_MINIMUM_VALUE in NUMBER,
54 P_LAST_UPDATE_DATE in DATE,
55 P_LAST_UPDATED_BY in NUMBER,
56 P_LAST_UPDATE_LOGIN in NUMBER
57 );
58
59 PROCEDURE DELETE_ROW
60 ( p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_return_status OUT NOCOPY VARCHAR2,
65 p_msg_count OUT NOCOPY NUMBER,
66 p_msg_data OUT NOCOPY VARCHAR2,
67 --
68 P_PAY_ELEMENT_RATE_ID in NUMBER
69 );
70
71 PROCEDURE LOCK_ROW
72 ( p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 p_return_status OUT NOCOPY VARCHAR2,
77 p_msg_count OUT NOCOPY NUMBER,
78 p_msg_data OUT NOCOPY VARCHAR2,
79 --
80 p_row_locked OUT NOCOPY VARCHAR2,
81 --
82 P_PAY_ELEMENT_RATE_ID in NUMBER,
83 P_PAY_ELEMENT_OPTION_ID in NUMBER,
84 P_PAY_ELEMENT_ID in NUMBER,
85 P_EFFECTIVE_START_DATE in DATE,
86 P_EFFECTIVE_END_DATE in DATE,
87 P_WORKSHEET_ID in NUMBER,
88 P_ELEMENT_VALUE_TYPE in VARCHAR2,
89 P_ELEMENT_VALUE in NUMBER,
90 P_PAY_BASIS in VARCHAR2,
91 P_FORMULA_ID in NUMBER,
92 P_MAXIMUM_VALUE in NUMBER,
93 P_MID_VALUE in NUMBER,
94 P_MINIMUM_VALUE in NUMBER,
95 P_CURRENCY_CODE IN VARCHAR2
96 );
97
98 PROCEDURE Delete_Element_Rates
99 ( p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 p_return_status OUT NOCOPY VARCHAR2,
104 p_msg_count OUT NOCOPY NUMBER,
105 p_msg_data OUT NOCOPY VARCHAR2,
106 p_worksheet_id IN NUMBER
107 );
108
109 PROCEDURE Modify_Element_Rates
110 ( p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 p_return_status OUT NOCOPY VARCHAR2,
115 p_msg_count OUT NOCOPY NUMBER,
116 p_msg_data OUT NOCOPY VARCHAR2,
117 p_pay_element_id IN NUMBER,
118 p_pay_element_option_id IN NUMBER,
119 p_effective_start_date IN DATE,
120 p_effective_end_date IN DATE,
121 p_worksheet_id IN NUMBER,
122 p_element_value_type IN VARCHAR2,
123 p_element_value IN NUMBER,
124 p_pay_basis IN VARCHAR2,
125 p_formula_id IN NUMBER,
126 p_maximum_value IN NUMBER,
127 p_mid_value IN NUMBER,
128 p_minimum_value IN NUMBER,
129 p_currency_code IN VARCHAR2
130 );
131
132
133 PROCEDURE Check_Date_Range_Overlap
134 (
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 p_return_status OUT NOCOPY VARCHAR2,
140 p_msg_count OUT NOCOPY NUMBER,
141 p_msg_data OUT NOCOPY VARCHAR2,
142 --
143 p_pay_element_id IN NUMBER,
144 p_pay_element_option_id IN NUMBER,
145 p_overlap_found_flag OUT NOCOPY VARCHAR2
146 );
147
148 END PSB_PAY_ELEMENT_RATES_PVT;