DBA Data[Home] [Help]

APPS.PSB_PAY_ELEMENT_RATES_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 38: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 45: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

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,

Line 46: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

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,

Line 61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 62: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 74: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 101: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 112: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 137: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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