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,
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,
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_ROW_ID in OUT NOCOPY VARCHAR2,
15: P_PAY_ELEMENT_ID in NUMBER,
16: P_BUSINESS_GROUP_ID in NUMBER,
17: P_DATA_EXTRACT_ID in NUMBER,
18: P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
19: P_NAME in VARCHAR2,
20: P_DESCRIPTION in VARCHAR2,
21: P_ELEMENT_VALUE_TYPE in VARCHAR2,
22: P_FORMULA_ID in NUMBER,
54: );
55:
56: PROCEDURE UPDATE_ROW
57: ( p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_return_status OUT NOCOPY VARCHAR2,
62: p_msg_count OUT NOCOPY NUMBER,
55:
56: PROCEDURE UPDATE_ROW
57: ( p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_return_status OUT NOCOPY VARCHAR2,
62: p_msg_count OUT NOCOPY NUMBER,
63: p_msg_data OUT NOCOPY VARCHAR2,
56: PROCEDURE UPDATE_ROW
57: ( p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_return_status OUT NOCOPY VARCHAR2,
62: p_msg_count OUT NOCOPY NUMBER,
63: p_msg_data OUT NOCOPY VARCHAR2,
64: --
65: P_ROW_ID in VARCHAR2,
66: P_PAY_ELEMENT_ID in NUMBER,
67: P_BUSINESS_GROUP_ID in NUMBER,
68: P_DATA_EXTRACT_ID in NUMBER,
69: P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
70: P_NAME in VARCHAR2,
71: P_DESCRIPTION in VARCHAR2,
72: P_ELEMENT_VALUE_TYPE in VARCHAR2,
73: P_FORMULA_ID in NUMBER,
103: );
104:
105: PROCEDURE DELETE_ROW
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
104:
105: PROCEDURE DELETE_ROW
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
112: p_msg_data OUT NOCOPY VARCHAR2,
105: PROCEDURE DELETE_ROW
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
112: p_msg_data OUT NOCOPY VARCHAR2,
113: --
115: );
116:
117: PROCEDURE LOCK_ROW
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
116:
117: PROCEDURE LOCK_ROW
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
124: p_msg_data OUT NOCOPY VARCHAR2,
117: PROCEDURE LOCK_ROW
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
124: p_msg_data OUT NOCOPY VARCHAR2,
125: --
128: P_ROW_ID in VARCHAR2,
129: P_PAY_ELEMENT_ID in NUMBER,
130: P_BUSINESS_GROUP_ID in NUMBER,
131: P_DATA_EXTRACT_ID in NUMBER,
132: P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
133: P_NAME in VARCHAR2,
134: P_DESCRIPTION in VARCHAR2,
135: P_ELEMENT_VALUE_TYPE in VARCHAR2,
136: P_FORMULA_ID in NUMBER,
164:
165: PROCEDURE Check_Unique
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_msg_count OUT NOCOPY NUMBER,
165: PROCEDURE Check_Unique
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_msg_count OUT NOCOPY NUMBER,
173: p_msg_data OUT NOCOPY VARCHAR2,
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_msg_count OUT NOCOPY NUMBER,
173: p_msg_data OUT NOCOPY VARCHAR2,
174: --
180:
181: PROCEDURE Check_References
182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
181: PROCEDURE Check_References
182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,
182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,
190: --
193: );
194:
195: PROCEDURE Copy_Pay_Elements
196: ( p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,
194:
195: PROCEDURE Copy_Pay_Elements
196: ( p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,
202: p_msg_data OUT NOCOPY VARCHAR2,
195: PROCEDURE Copy_Pay_Elements
196: ( p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,
202: p_msg_data OUT NOCOPY VARCHAR2,
203: p_source_pay_element_id IN NUMBER,