23: -- CONSTANTS
24: --===================
25:
26: G_OBJECT_TYPE_CUSTOMER CONSTANT VARCHAR2(100) :=
27: FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CUSTOMER');
28:
29: G_OBJECT_TYPE_CSITE CONSTANT VARCHAR2(100) :=
30: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CSITE'),' ');
31:
26: G_OBJECT_TYPE_CUSTOMER CONSTANT VARCHAR2(100) :=
27: FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CUSTOMER');
28:
29: G_OBJECT_TYPE_CSITE CONSTANT VARCHAR2(100) :=
30: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CSITE'),' ');
31:
32: G_OBJECT_TYPE_PRICE_LIST CONSTANT VARCHAR2(100) :=
33: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_PRICELIST'),' ');
34:
29: G_OBJECT_TYPE_CSITE CONSTANT VARCHAR2(100) :=
30: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CSITE'),' ');
31:
32: G_OBJECT_TYPE_PRICE_LIST CONSTANT VARCHAR2(100) :=
33: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_PRICELIST'),' ');
34:
35: G_OBJECT_TYPE_MODIFIER CONSTANT VARCHAR2(100) :=
36: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_MODIFIER'),' ');
37:
32: G_OBJECT_TYPE_PRICE_LIST CONSTANT VARCHAR2(100) :=
33: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_PRICELIST'),' ');
34:
35: G_OBJECT_TYPE_MODIFIER CONSTANT VARCHAR2(100) :=
36: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_MODIFIER'),' ');
37:
38: G_OBJECT_TYPE_SO CONSTANT VARCHAR2(100) :=
39: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_SO'),' ');
40:
35: G_OBJECT_TYPE_MODIFIER CONSTANT VARCHAR2(100) :=
36: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_MODIFIER'),' ');
37:
38: G_OBJECT_TYPE_SO CONSTANT VARCHAR2(100) :=
39: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_SO'),' ');
40:
41: G_OBJECT_TYPE_FORMULA CONSTANT VARCHAR2(100) :=
42: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_FORMULA'),' ');
43:
38: G_OBJECT_TYPE_SO CONSTANT VARCHAR2(100) :=
39: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_SO'),' ');
40:
41: G_OBJECT_TYPE_FORMULA CONSTANT VARCHAR2(100) :=
42: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_FORMULA'),' ');
43:
44: --------------------------
45: ------- Action Codes
46: --------------------------
44: --------------------------
45: ------- Action Codes
46: --------------------------
47: G_ACTION_CONV CONSTANT VARCHAR2(100) :=
48: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_CONV'),' ');
49:
50: G_ACTION_IGNORE CONSTANT VARCHAR2(100) :=
51: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_IGNORE'),' ');
52:
47: G_ACTION_CONV CONSTANT VARCHAR2(100) :=
48: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_CONV'),' ');
49:
50: G_ACTION_IGNORE CONSTANT VARCHAR2(100) :=
51: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_IGNORE'),' ');
52:
53: G_ACTION_COPY CONSTANT VARCHAR2(100) :=
54: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_COPY'),' ');
55:
50: G_ACTION_IGNORE CONSTANT VARCHAR2(100) :=
51: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_IGNORE'),' ');
52:
53: G_ACTION_COPY CONSTANT VARCHAR2(100) :=
54: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_COPY'),' ');
55:
56: G_ACTION_INCOMPLETE CONSTANT VARCHAR2(100) :=
57: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_INCOMP'),' ');
58:
53: G_ACTION_COPY CONSTANT VARCHAR2(100) :=
54: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_COPY'),' ');
55:
56: G_ACTION_INCOMPLETE CONSTANT VARCHAR2(100) :=
57: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_INCOMP'),' ');
58:
59:
60: --------------------------
61: --- Reason codes---------
61: --- Reason codes---------
62: -------------------------
63:
64: G_REASON_EURO CONSTANT VARCHAR2(100) :=
65: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_EURO'),' ');
66:
67: G_REASON_CL_SHORT CONSTANT VARCHAR2(100) :=
68: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CL_SHORT'),' ');
69:
64: G_REASON_EURO CONSTANT VARCHAR2(100) :=
65: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_EURO'),' ');
66:
67: G_REASON_CL_SHORT CONSTANT VARCHAR2(100) :=
68: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CL_SHORT'),' ');
69:
70: G_REASON_PARTIAL CONSTANT VARCHAR2(100) :=
71: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PARTIAL'),' ');
72:
67: G_REASON_CL_SHORT CONSTANT VARCHAR2(100) :=
68: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CL_SHORT'),' ');
69:
70: G_REASON_PARTIAL CONSTANT VARCHAR2(100) :=
71: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PARTIAL'),' ');
72:
73:
74: G_REASON_PROJECT CONSTANT VARCHAR2(100) :=
75: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROJECT'),' ');
71: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PARTIAL'),' ');
72:
73:
74: G_REASON_PROJECT CONSTANT VARCHAR2(100) :=
75: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROJECT'),' ');
76:
77: G_REASON_NOTHING CONSTANT VARCHAR2(100) :=
78: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOTHING'),' ');
79:
74: G_REASON_PROJECT CONSTANT VARCHAR2(100) :=
75: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROJECT'),' ');
76:
77: G_REASON_NOTHING CONSTANT VARCHAR2(100) :=
78: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOTHING'),' ');
79:
80:
81: G_REASON_RATE CONSTANT VARCHAR2(100) :=
82: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RATE'),' ');
78: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOTHING'),' ');
79:
80:
81: G_REASON_RATE CONSTANT VARCHAR2(100) :=
82: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RATE'),' ');
83:
84: G_REASON_RMA CONSTANT VARCHAR2(100) :=
85: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RMA'),' ');
86:
81: G_REASON_RATE CONSTANT VARCHAR2(100) :=
82: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RATE'),' ');
83:
84: G_REASON_RMA CONSTANT VARCHAR2(100) :=
85: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RMA'),' ');
86:
87: G_REASON_USER CONSTANT VARCHAR2(100) :=
88: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_USER'),' ');
89:
84: G_REASON_RMA CONSTANT VARCHAR2(100) :=
85: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RMA'),' ');
86:
87: G_REASON_USER CONSTANT VARCHAR2(100) :=
88: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_USER'),' ');
89:
90: G_REASON_VALIDATION CONSTANT VARCHAR2(100) :=
91: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_VAL'),' ');
92:
87: G_REASON_USER CONSTANT VARCHAR2(100) :=
88: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_USER'),' ');
89:
90: G_REASON_VALIDATION CONSTANT VARCHAR2(100) :=
91: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_VAL'),' ');
92:
93: G_REASON_PROCESS CONSTANT VARCHAR2(100) :=
94: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROCESS'),' ');
95:
90: G_REASON_VALIDATION CONSTANT VARCHAR2(100) :=
91: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_VAL'),' ');
92:
93: G_REASON_PROCESS CONSTANT VARCHAR2(100) :=
94: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROCESS'),' ');
95:
96: G_REASON_CANCEL CONSTANT VARCHAR2(100) :=
97: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CANCEL'),' ');
98:
93: G_REASON_PROCESS CONSTANT VARCHAR2(100) :=
94: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROCESS'),' ');
95:
96: G_REASON_CANCEL CONSTANT VARCHAR2(100) :=
97: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CANCEL'),' ');
98:
99: G_REASON_COPY CONSTANT VARCHAR2(100) :=
100: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_COPY'),' ');
101:
96: G_REASON_CANCEL CONSTANT VARCHAR2(100) :=
97: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CANCEL'),' ');
98:
99: G_REASON_COPY CONSTANT VARCHAR2(100) :=
100: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_COPY'),' ');
101:
102: G_REASON_GET_FAILED CONSTANT VARCHAR2(100) :=
103: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_GET'),' ');
104:
99: G_REASON_COPY CONSTANT VARCHAR2(100) :=
100: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_COPY'),' ');
101:
102: G_REASON_GET_FAILED CONSTANT VARCHAR2(100) :=
103: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_GET'),' ');
104:
105: G_REASON_NOT_ELIGIBLE CONSTANT VARCHAR2(100) :=
106: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOT_ELG'),' ');
107:
102: G_REASON_GET_FAILED CONSTANT VARCHAR2(100) :=
103: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_GET'),' ');
104:
105: G_REASON_NOT_ELIGIBLE CONSTANT VARCHAR2(100) :=
106: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOT_ELG'),' ');
107:
108: G_REASON_QUALIFIER CONSTANT VARCHAR2(100) :=
109: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_QUALIFIER'),' ');
110:
105: G_REASON_NOT_ELIGIBLE CONSTANT VARCHAR2(100) :=
106: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOT_ELG'),' ');
107:
108: G_REASON_QUALIFIER CONSTANT VARCHAR2(100) :=
109: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_QUALIFIER'),' ');
110:
111: G_REASON_FORMULA CONSTANT VARCHAR2(100) :=
112: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_FORMULA'),' ');
113:
108: G_REASON_QUALIFIER CONSTANT VARCHAR2(100) :=
109: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_QUALIFIER'),' ');
110:
111: G_REASON_FORMULA CONSTANT VARCHAR2(100) :=
112: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_FORMULA'),' ');
113:
114: G_REASON_RLTD CONSTANT VARCHAR2(100) :=
115: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RLTD'),' ');
116:
111: G_REASON_FORMULA CONSTANT VARCHAR2(100) :=
112: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_FORMULA'),' ');
113:
114: G_REASON_RLTD CONSTANT VARCHAR2(100) :=
115: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RLTD'),' ');
116:
117: G_REASON_HOLD CONSTANT VARCHAR2(100) :=
118: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_HOLD'),' ');
119:
114: G_REASON_RLTD CONSTANT VARCHAR2(100) :=
115: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RLTD'),' ');
116:
117: G_REASON_HOLD CONSTANT VARCHAR2(100) :=
118: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_HOLD'),' ');
119:
120: G_REASON_PR CONSTANT VARCHAR2(100) :=
121: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PR'),' ');
122:
117: G_REASON_HOLD CONSTANT VARCHAR2(100) :=
118: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_HOLD'),' ');
119:
120: G_REASON_PR CONSTANT VARCHAR2(100) :=
121: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PR'),' ');
122:
123: G_REASON_NSTD CONSTANT VARCHAR2(100) :=
124: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NSTD'),' ');
125:
120: G_REASON_PR CONSTANT VARCHAR2(100) :=
121: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PR'),' ');
122:
123: G_REASON_NSTD CONSTANT VARCHAR2(100) :=
124: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NSTD'),' ');
125:
126: G_REASON_SITE CONSTANT VARCHAR2(100) :=
127: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SITE'),' ');
128:
123: G_REASON_NSTD CONSTANT VARCHAR2(100) :=
124: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NSTD'),' ');
125:
126: G_REASON_SITE CONSTANT VARCHAR2(100) :=
127: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SITE'),' ');
128:
129: G_REASON_SHIP CONSTANT VARCHAR2(100) :=
130: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SHIP'),' ');
131:
126: G_REASON_SITE CONSTANT VARCHAR2(100) :=
127: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SITE'),' ');
128:
129: G_REASON_SHIP CONSTANT VARCHAR2(100) :=
130: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SHIP'),' ');
131:
132: G_REASON_MIXED CONSTANT VARCHAR2(100) :=
133: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_MIXED'),' ');
134:
129: G_REASON_SHIP CONSTANT VARCHAR2(100) :=
130: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SHIP'),' ');
131:
132: G_REASON_MIXED CONSTANT VARCHAR2(100) :=
133: NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_MIXED'),' ');
134:
135:
136: G_RPT_PAGE_COL CONSTANT INTEGER :=130;
137: G_FORMAT_SPACE CONSTANT INTEGER :=2;