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_PAY_ELEMENT_INPUTS_PVT dependencies on CN_PAY_ELEMENT_INPUTS

Line 1: PACKAGE CN_PAY_ELEMENT_INPUTS_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_PAY_ELEMENT_INPUTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnvqpis.pls 115.4 2002/02/05 00:27:12 pkm ship $ */
3:
4: --
5: -- Record type for Pay Element Inputs

Line 19: pay_element_input_id cn_pay_element_inputs.pay_element_input_id%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,
22: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
23: tab_object_id cn_objects.object_id%TYPE,

Line 20: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,

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

Line 21: element_input_id cn_pay_element_inputs.element_input_id%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,
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

Line 22: element_type_id cn_pay_element_inputs.element_type_id%TYPE,

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

Line 25: ATTRIBUTE_CATEGORY cn_pay_element_inputs.attribute_category%TYPE

21: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
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

Line 27: ATTRIBUTE1 cn_pay_element_inputs.attribute1%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,
31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE

Line 29: ATTRIBUTE2 cn_pay_element_inputs.attribute2%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,
33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE

Line 31: ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE

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,
35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE

Line 33: ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE

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,
37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE

Line 35: ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE

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,
39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE

Line 37: ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE

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,
41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE

Line 39: ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE

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,
43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE

Line 41: ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE

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,
45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE

Line 43: ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE

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,
47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE

Line 45: ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE

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,
49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE

Line 47: ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE

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,
51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE

Line 49: ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE

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,
53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE

Line 51: ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE

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,
55: ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE

Line 53: ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE

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

Line 55: ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE

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

Line 73: ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,

69: G_MISS_QPI_TBL_LIST pay_element_input_tbl_type;
70:
71: -- user for getting and displaying in the jsp page.
72: TYPE pay_element_input_out_rec_type IS RECORD
73: ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
74: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,

Line 74: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,

70:
71: -- user for getting and displaying in the jsp page.
72: TYPE pay_element_input_out_rec_type IS RECORD
73: ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
74: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,
78: column_name cn_objects.name%TYPE,

Line 75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,

71: -- user for getting and displaying in the jsp page.
72: TYPE pay_element_input_out_rec_type IS RECORD
73: ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
74: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,
78: column_name cn_objects.name%TYPE,
79: start_date cn_pay_element_inputs.start_date%TYPE,

Line 76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,

72: TYPE pay_element_input_out_rec_type IS RECORD
73: ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
74: quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,
78: column_name cn_objects.name%TYPE,
79: start_date cn_pay_element_inputs.start_date%TYPE,
80: end_date cn_pay_element_inputs.end_date%TYPE,

Line 79: start_date cn_pay_element_inputs.start_date%TYPE,

75: element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,
78: column_name cn_objects.name%TYPE,
79: start_date cn_pay_element_inputs.start_date%TYPE,
80: end_date cn_pay_element_inputs.end_date%TYPE,
81: pay_element_name pay_element_types.element_name%TYPE,
82: pay_input_name pay_input_values.name%TYPE,
83: line_number cn_pay_element_inputs.line_number%TYPE,

Line 80: end_date cn_pay_element_inputs.end_date%TYPE,

76: element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77: table_name cn_objects.name%TYPE,
78: column_name cn_objects.name%TYPE,
79: start_date cn_pay_element_inputs.start_date%TYPE,
80: end_date cn_pay_element_inputs.end_date%TYPE,
81: pay_element_name pay_element_types.element_name%TYPE,
82: pay_input_name pay_input_values.name%TYPE,
83: line_number cn_pay_element_inputs.line_number%TYPE,
84: tab_object_id cn_objects.object_id%TYPE,

Line 83: line_number cn_pay_element_inputs.line_number%TYPE,

79: start_date cn_pay_element_inputs.start_date%TYPE,
80: end_date cn_pay_element_inputs.end_date%TYPE,
81: pay_element_name pay_element_types.element_name%TYPE,
82: pay_input_name pay_input_values.name%TYPE,
83: line_number cn_pay_element_inputs.line_number%TYPE,
84: tab_object_id cn_objects.object_id%TYPE,
85: col_object_id cn_objects.object_id%TYPE
86: );
87:

Line 251: p_element_type_id IN cn_pay_element_inputs.element_type_id%TYPE,

247: p_validation_level IN NUMBER,
248: x_return_status OUT VARCHAR2,
249: x_msg_count OUT NUMBER,
250: x_msg_data OUT VARCHAR2,
251: p_element_type_id IN cn_pay_element_inputs.element_type_id%TYPE,
252: p_start_record IN NUMBER,
253: p_increment_count IN NUMBER,
254: p_order_by IN VARCHAR2,
255: x_pay_element_input_tbl OUT pay_element_input_out_tbl_type,

Line 261: END CN_PAY_ELEMENT_INPUTS_PVT;

257: x_status OUT VARCHAR2,
258: x_loading_status OUT VARCHAR2
259: );
260:
261: END CN_PAY_ELEMENT_INPUTS_PVT;