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_MULTI_RATE_SCHEDULES_VUHK dependencies on CN_MULTI_RATE_SCHEDULES_PUB

Line 15: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

11: -- They can be set using the Update_Tier API.
12: PROCEDURE Create_Schedule_Pre
13: (p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
14: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
15: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
16: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2);

Line 16: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,

12: PROCEDURE Create_Schedule_Pre
13: (p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
14: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
15: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
16: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2);
20: PROCEDURE Create_Schedule_Post

Line 23: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

19: x_msg_data OUT NOCOPY VARCHAR2);
20: PROCEDURE Create_Schedule_Post
21: (p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
22: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
23: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
24: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2);

Line 24: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,

20: PROCEDURE Create_Schedule_Post
21: (p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
22: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
23: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
24: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2);
28:

Line 44: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

40: cn_api.g_miss_char,
41: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
42: cn_api.g_miss_char,
43: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
44: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
45: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2);

Line 45: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,

41: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
42: cn_api.g_miss_char,
43: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
44: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
45: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2);
49: PROCEDURE Update_Schedule_Post

Line 56: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

52: cn_api.g_miss_char,
53: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
54: cn_api.g_miss_char,
55: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
56: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
57: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2);

Line 57: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,

53: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
54: cn_api.g_miss_char,
55: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
56: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
57: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2);
61:

Line 142: p_tier_coordinates_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.tier_coordinates_tbl,

138: -- should correspond to the number of dimensions and the values should be in the
139: -- same order as the dimensions.
140: PROCEDURE Update_Rate_Pre
141: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
142: p_tier_coordinates_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.tier_coordinates_tbl,
143: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
144: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

Line 150: p_tier_coordinates_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.tier_coordinates_tbl,

146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2);
148: PROCEDURE Update_Rate_Post
149: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
150: p_tier_coordinates_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.tier_coordinates_tbl,
151: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
152: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,

Line 165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

161: PROCEDURE Create_Dimension_Pre
162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2);

Line 166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2);
170: PROCEDURE Create_Dimension_Post

Line 174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

170: PROCEDURE Create_Dimension_Post
171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2);

Line 175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2);
179:

Line 192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,

Line 193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2);

Line 206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,

Line 207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2);