APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_QUOTA_PAY_ELEMENTS

Line 1: PACKAGE CN_QUOTA_PAY_ELEMENTS_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_QUOTA_PAY_ELEMENTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnvqpes.pls 115.4 2002/02/05 00:27:09 pkm ship $ */
3:
4: --
5: -- Record type for quota Pay Element

Line 8: (quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,

4: --
5: -- Record type for quota Pay Element
6: --
7: TYPE quota_pay_element_rec_type IS RECORD
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,

Line 15: status cn_quota_pay_elements.status%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,
19: START_DATE cn_quota_pay_elements.start_date%TYPE

Line 18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%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,
21: END_DATE cn_quota_pay_elements.end_date%TYPE
22: := CN_API.G_MISS_DATE,

Line 19: START_DATE cn_quota_pay_elements.start_date%TYPE

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

Line 21: END_DATE cn_quota_pay_elements.end_date%TYPE

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,
25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE

Line 23: ATTRIBUTE_CATEGORY cn_quota_pay_elements.attribute_category%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,
27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE

Line 25: ATTRIBUTE1 cn_quota_pay_elements.attribute1%TYPE

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,
29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE

Line 27: ATTRIBUTE2 cn_quota_pay_elements.attribute2%TYPE

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,
31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE

Line 29: ATTRIBUTE3 cn_quota_pay_elements.attribute3%TYPE

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,
33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE

Line 31: ATTRIBUTE4 cn_quota_pay_elements.attribute4%TYPE

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,
35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE

Line 33: ATTRIBUTE5 cn_quota_pay_elements.attribute5%TYPE

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,
37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE

Line 35: ATTRIBUTE6 cn_quota_pay_elements.attribute6%TYPE

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,
39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE

Line 37: ATTRIBUTE7 cn_quota_pay_elements.attribute7%TYPE

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,
41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE

Line 39: ATTRIBUTE8 cn_quota_pay_elements.attribute8%TYPE

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,
43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE

Line 41: ATTRIBUTE9 cn_quota_pay_elements.attribute9%TYPE

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,
45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE

Line 43: ATTRIBUTE10 cn_quota_pay_elements.attribute10%TYPE

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,
47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE

Line 45: ATTRIBUTE11 cn_quota_pay_elements.attribute11%TYPE

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,
49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE

Line 47: ATTRIBUTE12 cn_quota_pay_elements.attribute12%TYPE

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,
51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE

Line 49: ATTRIBUTE13 cn_quota_pay_elements.attribute13%TYPE

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,
53: ATTRIBUTE15 cn_quota_pay_elements.attribute15%TYPE

Line 51: ATTRIBUTE14 cn_quota_pay_elements.attribute14%TYPE

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
55: );

Line 53: ATTRIBUTE15 cn_quota_pay_elements.attribute15%TYPE

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:
57: -- Global variable that represent missing values.

Line 71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,

67: G_MISS_QPE_TBL_LIST quota_pay_element_tbl_type;
68:
69: -- user for getting and displaying in the jsp page.
70: TYPE quota_pay_element_out_rec_type IS RECORD
71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,

Line 72: quota_id cn_quota_pay_elements.quota_id%TYPE,

68:
69: -- user for getting and displaying in the jsp page.
70: TYPE quota_pay_element_out_rec_type IS RECORD
71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,

Line 73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,

69: -- user for getting and displaying in the jsp page.
70: TYPE quota_pay_element_out_rec_type IS RECORD
71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,

Line 74: status cn_quota_pay_elements.status%TYPE,

70: TYPE quota_pay_element_out_rec_type IS RECORD
71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,

Line 75: start_date cn_quota_pay_elements.start_date%TYPE,

71: ( quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,
79: pay_start_date cn_quota_pay_elements.start_date%TYPE,

Line 76: end_date cn_quota_pay_elements.end_date%TYPE,

72: quota_id cn_quota_pay_elements.quota_id%TYPE,
73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,
79: pay_start_date cn_quota_pay_elements.start_date%TYPE,
80: pay_end_date cn_quota_pay_elements.end_date%TYPE

Line 79: pay_start_date cn_quota_pay_elements.start_date%TYPE,

75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,
79: pay_start_date cn_quota_pay_elements.start_date%TYPE,
80: pay_end_date cn_quota_pay_elements.end_date%TYPE
81: );
82:
83: TYPE quota_pay_element_out_tbl_type IS TABLE OF

Line 80: pay_end_date cn_quota_pay_elements.end_date%TYPE

76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,
79: pay_start_date cn_quota_pay_elements.start_date%TYPE,
80: pay_end_date cn_quota_pay_elements.end_date%TYPE
81: );
82:
83: TYPE quota_pay_element_out_tbl_type IS TABLE OF
84: quota_pay_element_out_rec_type INDEX BY BINARY_INTEGER;

Line 260: END CN_QUOTA_PAY_ELEMENTS_PVT;

256: x_status OUT VARCHAR2,
257: x_loading_status OUT VARCHAR2
258: );
259:
260: END CN_QUOTA_PAY_ELEMENTS_PVT;