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: --
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,
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,
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: --
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,
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,
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,
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,
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: --
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,
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,
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: --
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,
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,
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,
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,
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,
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,
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,
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: --