DBA Data[Home] [Help]

APPS.CN_PAY_ELEMENT_INPUTS_PVT dependencies on CN_API

Line 9: := CN_API.G_MISS_CHAR,

5: -- Record type for Pay Element Inputs
6: --
7: TYPE pay_element_input_rec_type IS RECORD
8: ( pay_element_name pay_element_types.element_name%TYPE
9: := CN_API.G_MISS_CHAR,
10: start_date pay_element_types.effective_start_date%TYPE,
11: end_date pay_element_types.effective_end_date%TYPE,
12: table_name cn_objects.name%TYPE
13: := CN_API.G_MISS_CHAR,

Line 13: := CN_API.G_MISS_CHAR,

9: := CN_API.G_MISS_CHAR,
10: start_date pay_element_types.effective_start_date%TYPE,
11: end_date pay_element_types.effective_end_date%TYPE,
12: table_name cn_objects.name%TYPE
13: := CN_API.G_MISS_CHAR,
14: column_name cn_objects.name%TYPE
15: := CN_API.G_MISS_CHAR,
16: pay_input_name pay_input_values.name%TYPE
17: := CN_API.G_MISS_CHAR,

Line 15: := CN_API.G_MISS_CHAR,

11: end_date pay_element_types.effective_end_date%TYPE,
12: table_name cn_objects.name%TYPE
13: := CN_API.G_MISS_CHAR,
14: column_name cn_objects.name%TYPE
15: := CN_API.G_MISS_CHAR,
16: pay_input_name pay_input_values.name%TYPE
17: := CN_API.G_MISS_CHAR,
18: line_number pay_input_values.display_sequence%TYPE,
19: pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,

Line 17: := CN_API.G_MISS_CHAR,

13: := CN_API.G_MISS_CHAR,
14: column_name cn_objects.name%TYPE
15: := CN_API.G_MISS_CHAR,
16: pay_input_name pay_input_values.name%TYPE
17: := CN_API.G_MISS_CHAR,
18: line_number pay_input_values.display_sequence%TYPE,
19: pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
20: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
21: element_input_id cn_pay_element_inputs.element_input_id%TYPE,

Line 26: := CN_API.G_MISS_CHAR,

22: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
23: tab_object_id cn_objects.object_id%TYPE,
24: col_object_id cn_objects.object_id%TYPE,
25: ATTRIBUTE_CATEGORY cn_pay_element_inputs.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE1 cn_pay_element_inputs.attribute1%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE2 cn_pay_element_inputs.attribute2%TYPE
30: := CN_API.G_MISS_CHAR,

Line 28: := CN_API.G_MISS_CHAR,

24: col_object_id cn_objects.object_id%TYPE,
25: ATTRIBUTE_CATEGORY cn_pay_element_inputs.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE1 cn_pay_element_inputs.attribute1%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE2 cn_pay_element_inputs.attribute2%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE
32: := CN_API.G_MISS_CHAR,

Line 30: := CN_API.G_MISS_CHAR,

26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE1 cn_pay_element_inputs.attribute1%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE2 cn_pay_element_inputs.attribute2%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE
34: := CN_API.G_MISS_CHAR,

Line 32: := CN_API.G_MISS_CHAR,

28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE2 cn_pay_element_inputs.attribute2%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE
36: := CN_API.G_MISS_CHAR,

Line 34: := CN_API.G_MISS_CHAR,

30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE
38: := CN_API.G_MISS_CHAR,

Line 36: := CN_API.G_MISS_CHAR,

32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE
40: := CN_API.G_MISS_CHAR,

Line 38: := CN_API.G_MISS_CHAR,

34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE
42: := CN_API.G_MISS_CHAR,

Line 40: := CN_API.G_MISS_CHAR,

36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE
44: := CN_API.G_MISS_CHAR,

Line 42: := CN_API.G_MISS_CHAR,

38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE
46: := CN_API.G_MISS_CHAR,

Line 44: := CN_API.G_MISS_CHAR,

40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE
48: := CN_API.G_MISS_CHAR,

Line 46: := CN_API.G_MISS_CHAR,

42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE
50: := CN_API.G_MISS_CHAR,

Line 48: := CN_API.G_MISS_CHAR,

44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE
52: := CN_API.G_MISS_CHAR,

Line 50: := CN_API.G_MISS_CHAR,

46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE
54: := CN_API.G_MISS_CHAR,

Line 52: := CN_API.G_MISS_CHAR,

48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE
54: := CN_API.G_MISS_CHAR,
55: ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE
56: := CN_API.G_MISS_CHAR

Line 54: := CN_API.G_MISS_CHAR,

50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE
54: := CN_API.G_MISS_CHAR,
55: ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE
56: := CN_API.G_MISS_CHAR
57: );
58:

Line 56: := CN_API.G_MISS_CHAR

52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE
54: := CN_API.G_MISS_CHAR,
55: ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE
56: := CN_API.G_MISS_CHAR
57: );
58:
59: -- Global variable that represent missing values.
60: G_MISS_PAY_ELEMENT_INPUT_REC pay_element_input_rec_type;

Line 101: -- Default = CN_API.G_FALSE

97: -- Desc : Procedure to create a new pay element input
98: -- Parameters :
99: -- IN : p_api_version IN NUMBER Require
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 103: -- Default = CN_API.G_FALSE

99: -- IN : p_api_version IN NUMBER Require
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL
106: -- p_pay_element_input_rec IN pay_element_input_rec_type
107: -- Required input :

Line 105: -- Default = CN_API.G_VALID_LEVEL_FULL

101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL
106: -- p_pay_element_input_rec IN pay_element_input_rec_type
107: -- Required input :
108: -- OUT : x_return_status OUT VARCHAR2(1)
109: -- x_msg_count OUT NUMBER

Line 124: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

120: --============================================================================
121: PROCEDURE Create_pay_element_input
122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
125: p_commit IN VARCHAR2 := CN_API.G_FALSE,
126: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT VARCHAR2,
128: x_msg_count OUT NUMBER,

Line 125: p_commit IN VARCHAR2 := CN_API.G_FALSE,

121: PROCEDURE Create_pay_element_input
122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
125: p_commit IN VARCHAR2 := CN_API.G_FALSE,
126: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT VARCHAR2,
128: x_msg_count OUT NUMBER,
129: x_msg_data OUT VARCHAR2,

Line 126: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
125: p_commit IN VARCHAR2 := CN_API.G_FALSE,
126: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT VARCHAR2,
128: x_msg_count OUT NUMBER,
129: x_msg_data OUT VARCHAR2,
130: p_pay_element_input_rec IN pay_element_input_rec_type

Line 145: -- Default = CN_API.G_FALSE

141: -- Desc : Procedure to update pay element input
142: -- Parameters :
143: -- IN : p_api_version IN NUMBER Require
144: -- p_init_msg_list IN VARCHAR2 Optional
145: -- Default = CN_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = CN_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 147: -- Default = CN_API.G_FALSE

143: -- IN : p_api_version IN NUMBER Require
144: -- p_init_msg_list IN VARCHAR2 Optional
145: -- Default = CN_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = CN_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = CN_API.G_VALID_LEVEL_FULL
150: -- p_pay_element_input_rec IN pay_element_input_rec_type
151: -- Required input :

Line 149: -- Default = CN_API.G_VALID_LEVEL_FULL

145: -- Default = CN_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = CN_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = CN_API.G_VALID_LEVEL_FULL
150: -- p_pay_element_input_rec IN pay_element_input_rec_type
151: -- Required input :
152: -- OUT : x_return_status OUT VARCHAR2(1)
153: -- x_msg_count OUT NUMBER

Line 165: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

161: --============================================================================
162: PROCEDURE Update_pay_element_input
163: (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
166: p_commit IN VARCHAR2 := CN_API.G_FALSE,
167: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT VARCHAR2,
169: x_msg_count OUT NUMBER,

Line 166: p_commit IN VARCHAR2 := CN_API.G_FALSE,

162: PROCEDURE Update_pay_element_input
163: (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
166: p_commit IN VARCHAR2 := CN_API.G_FALSE,
167: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT VARCHAR2,
169: x_msg_count OUT NUMBER,
170: x_msg_data OUT VARCHAR2,

Line 167: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

163: (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
166: p_commit IN VARCHAR2 := CN_API.G_FALSE,
167: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT VARCHAR2,
169: x_msg_count OUT NUMBER,
170: x_msg_data OUT VARCHAR2,
171: po_pay_element_input_rec IN pay_element_input_rec_type

Line 185: -- Default = CN_API.G_FALSE

181: -- Pre-reqs : None.
182: -- Parameters :
183: -- IN : p_api_version IN NUMBER Require
184: -- p_init_msg_list IN VARCHAR2 Optional
185: -- Default = CN_API.G_FALSE
186: -- p_commit IN VARCHAR2 Optional
187: -- Default = CN_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional
189: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 187: -- Default = CN_API.G_FALSE

183: -- IN : p_api_version IN NUMBER Require
184: -- p_init_msg_list IN VARCHAR2 Optional
185: -- Default = CN_API.G_FALSE
186: -- p_commit IN VARCHAR2 Optional
187: -- Default = CN_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional
189: -- Default = CN_API.G_VALID_LEVEL_FULL
190: -- Required input :
191: -- pay_element_input_id

Line 189: -- Default = CN_API.G_VALID_LEVEL_FULL

185: -- Default = CN_API.G_FALSE
186: -- p_commit IN VARCHAR2 Optional
187: -- Default = CN_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional
189: -- Default = CN_API.G_VALID_LEVEL_FULL
190: -- Required input :
191: -- pay_element_input_id
192: -- OUT : x_return_status OUT VARCHAR2(1)
193: -- x_msg_count OUT NUMBER

Line 206: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

202: --============================================================================
203: PROCEDURE Delete_pay_element_input
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
207: p_commit IN VARCHAR2 := CN_API.G_FALSE,
208: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,

Line 207: p_commit IN VARCHAR2 := CN_API.G_FALSE,

203: PROCEDURE Delete_pay_element_input
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
207: p_commit IN VARCHAR2 := CN_API.G_FALSE,
208: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,
211: x_msg_data OUT VARCHAR2,

Line 208: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
207: p_commit IN VARCHAR2 := CN_API.G_FALSE,
208: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,
211: x_msg_data OUT VARCHAR2,
212: p_pay_element_input_id IN NUMBER,