eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_API

Line 12: := CN_API.G_MISS_DATE,

8: (quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
9: quota_name cn_quotas.name%TYPE,
10: pay_element_name pay_element_types.element_name%TYPE,
11: pay_start_date pay_element_types.effective_start_date%TYPE
12: := CN_API.G_MISS_DATE,
13: pay_end_date pay_element_types.effective_end_date%TYPE
14: := CN_API.G_MISS_DATE,
15: status cn_quota_pay_elements.status%TYPE
16: := CN_API.G_MISS_CHAR,

Line 14: := CN_API.G_MISS_DATE,

10: pay_element_name pay_element_types.element_name%TYPE,
11: pay_start_date pay_element_types.effective_start_date%TYPE
12: := CN_API.G_MISS_DATE,
13: pay_end_date pay_element_types.effective_end_date%TYPE
14: := CN_API.G_MISS_DATE,
15: status cn_quota_pay_elements.status%TYPE
16: := CN_API.G_MISS_CHAR,
17: quota_id cn_quotas.quota_id%TYPE,
18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,

Line 16: := CN_API.G_MISS_CHAR,

12: := CN_API.G_MISS_DATE,
13: pay_end_date pay_element_types.effective_end_date%TYPE
14: := CN_API.G_MISS_DATE,
15: status cn_quota_pay_elements.status%TYPE
16: := CN_API.G_MISS_CHAR,
17: quota_id cn_quotas.quota_id%TYPE,
18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
19: START_DATE cn_quota_pay_elements.start_date%TYPE
20: := CN_API.G_MISS_DATE,

Line 20: := CN_API.G_MISS_DATE,

16: := CN_API.G_MISS_CHAR,
17: quota_id cn_quotas.quota_id%TYPE,
18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
19: START_DATE cn_quota_pay_elements.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_quota_pay_elements.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: ATTRIBUTE_CATEGORY cn_quota_pay_elements.attribute_category%TYPE
24: := CN_API.G_MISS_CHAR,

Line 22: := CN_API.G_MISS_DATE,

18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
19: START_DATE cn_quota_pay_elements.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_quota_pay_elements.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: ATTRIBUTE_CATEGORY cn_quota_pay_elements.attribute_category%TYPE
24: := CN_API.G_MISS_CHAR,
25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE
26: := CN_API.G_MISS_CHAR,

Line 24: := CN_API.G_MISS_CHAR,

20: := CN_API.G_MISS_DATE,
21: END_DATE cn_quota_pay_elements.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: ATTRIBUTE_CATEGORY cn_quota_pay_elements.attribute_category%TYPE
24: := CN_API.G_MISS_CHAR,
25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE
26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE
28: := CN_API.G_MISS_CHAR,

Line 26: := CN_API.G_MISS_CHAR,

22: := CN_API.G_MISS_DATE,
23: ATTRIBUTE_CATEGORY cn_quota_pay_elements.attribute_category%TYPE
24: := CN_API.G_MISS_CHAR,
25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE
26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE
30: := CN_API.G_MISS_CHAR,

Line 28: := CN_API.G_MISS_CHAR,

24: := CN_API.G_MISS_CHAR,
25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE
26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE
32: := CN_API.G_MISS_CHAR,

Line 30: := CN_API.G_MISS_CHAR,

26: := CN_API.G_MISS_CHAR,
27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE
28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE
34: := CN_API.G_MISS_CHAR,

Line 32: := CN_API.G_MISS_CHAR,

28: := CN_API.G_MISS_CHAR,
29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE
30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE
36: := CN_API.G_MISS_CHAR,

Line 34: := CN_API.G_MISS_CHAR,

30: := CN_API.G_MISS_CHAR,
31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE
32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE
38: := CN_API.G_MISS_CHAR,

Line 36: := CN_API.G_MISS_CHAR,

32: := CN_API.G_MISS_CHAR,
33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE
34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE
40: := CN_API.G_MISS_CHAR,

Line 38: := CN_API.G_MISS_CHAR,

34: := CN_API.G_MISS_CHAR,
35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE
36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE
42: := CN_API.G_MISS_CHAR,

Line 40: := CN_API.G_MISS_CHAR,

36: := CN_API.G_MISS_CHAR,
37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE
38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE
44: := CN_API.G_MISS_CHAR,

Line 42: := CN_API.G_MISS_CHAR,

38: := CN_API.G_MISS_CHAR,
39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE
40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE
46: := CN_API.G_MISS_CHAR,

Line 44: := CN_API.G_MISS_CHAR,

40: := CN_API.G_MISS_CHAR,
41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE
42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE
48: := CN_API.G_MISS_CHAR,

Line 46: := CN_API.G_MISS_CHAR,

42: := CN_API.G_MISS_CHAR,
43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE
44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE
50: := CN_API.G_MISS_CHAR,

Line 48: := CN_API.G_MISS_CHAR,

44: := CN_API.G_MISS_CHAR,
45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE
46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE
52: := CN_API.G_MISS_CHAR,

Line 50: := CN_API.G_MISS_CHAR,

46: := CN_API.G_MISS_CHAR,
47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE
48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE15 cn_quota_pay_elements.attribute15%TYPE
54: := CN_API.G_MISS_CHAR

Line 52: := CN_API.G_MISS_CHAR,

48: := CN_API.G_MISS_CHAR,
49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE
50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE15 cn_quota_pay_elements.attribute15%TYPE
54: := CN_API.G_MISS_CHAR
55: );
56:

Line 54: := CN_API.G_MISS_CHAR

50: := CN_API.G_MISS_CHAR,
51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE
52: := CN_API.G_MISS_CHAR,
53: ATTRIBUTE15 cn_quota_pay_elements.attribute15%TYPE
54: := CN_API.G_MISS_CHAR
55: );
56:
57: -- Global variable that represent missing values.
58: G_MISS_QUOTA_PAY_ELEMENT_REC quota_pay_element_rec_type;

Line 96: -- Default = CN_API.G_FALSE

92: -- Desc : Procedure to create a new quota pay element mapping
93: -- Parameters :
94: -- IN : p_api_version IN NUMBER Require
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = CN_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = CN_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 98: -- Default = CN_API.G_FALSE

94: -- IN : p_api_version IN NUMBER Require
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = CN_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = CN_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = CN_API.G_VALID_LEVEL_FULL
101: -- p_quota_pay_elements_rec IN quota_pay_elements_rec_type
102: -- Required input :

Line 100: -- Default = CN_API.G_VALID_LEVEL_FULL

96: -- Default = CN_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = CN_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = CN_API.G_VALID_LEVEL_FULL
101: -- p_quota_pay_elements_rec IN quota_pay_elements_rec_type
102: -- Required input :
103: -- quota_id quota id
104: -- pay_element_input_id

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

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

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

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

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

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

Line 143: -- Default = CN_API.G_FALSE

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

Line 145: -- Default = CN_API.G_FALSE

141: -- IN : p_api_version IN NUMBER Require
142: -- p_init_msg_list IN VARCHAR2 Optional
143: -- Default = CN_API.G_FALSE
144: -- p_commit IN VARCHAR2 Optional
145: -- Default = CN_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional
147: -- Default = CN_API.G_VALID_LEVEL_FULL
148: -- p_quota_pay_element_rec IN quota_pay_element_rec_type
149: -- Required input :

Line 147: -- Default = CN_API.G_VALID_LEVEL_FULL

143: -- Default = CN_API.G_FALSE
144: -- p_commit IN VARCHAR2 Optional
145: -- Default = CN_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional
147: -- Default = CN_API.G_VALID_LEVEL_FULL
148: -- p_quota_pay_element_rec IN quota_pay_element_rec_type
149: -- Required input :
150: -- OUT : x_return_status OUT VARCHAR2(1)
151: -- x_msg_count OUT NUMBER

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

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

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

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

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

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

Line 183: -- Default = CN_API.G_FALSE

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

Line 185: -- Default = CN_API.G_FALSE

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

Line 187: -- Default = CN_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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