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_PUB dependencies on CN_RATE_SCHEDULES

Line 30: (rate_schedule_name CN_RATE_SCHEDULES.NAME%TYPE,

26: -- This is the record type for rate dimension assignments. Each contains
27: -- a rate schedule name and rate dimension name (they have to be unique),
28: -- a sequence number, and the object version number (for locking)
29: TYPE dim_assign_rec_type IS RECORD
30: (rate_schedule_name CN_RATE_SCHEDULES.NAME%TYPE,
31: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
32: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
33: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);
34:

Line 89: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

85: (p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
90: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
91: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
92: -- Start - MOAC Change
93: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,

Line 90: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
90: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
91: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
92: -- Start - MOAC Change
93: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,
94: -- End - MOAC Change

Line 93: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,

89: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
90: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
91: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
92: -- Start - MOAC Change
93: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,
94: -- End - MOAC Change
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2);

Line 132: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,

128: (p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
133: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
134: cn_api.g_miss_char,
135: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
136: cn_api.g_miss_char,

Line 133: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=

129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
133: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
134: cn_api.g_miss_char,
135: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
136: cn_api.g_miss_char,
137: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,

Line 135: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=

131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
133: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
134: cn_api.g_miss_char,
135: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
136: cn_api.g_miss_char,
137: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
138: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
139: -- Start - MOAC Change

Line 137: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,

133: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
134: cn_api.g_miss_char,
135: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
136: cn_api.g_miss_char,
137: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
138: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
139: -- Start - MOAC Change
140: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,
141: -- End - MOAC Change

Line 140: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,

136: cn_api.g_miss_char,
137: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
138: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
139: -- Start - MOAC Change
140: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,
141: -- End - MOAC Change
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2);

Line 168: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

164: (p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
169: -- Start - R12 MOAC Changes
170: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
171: -- End - R12 MOAC Changes
172: x_return_status OUT NOCOPY VARCHAR2,

Line 170: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
169: -- Start - R12 MOAC Changes
170: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
171: -- End - R12 MOAC Changes
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2);

Line 204: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

200: (p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
205: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
206: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
207: -- Start - MOAC Change
208: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

Line 244: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

240: (p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
245: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
246: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
247: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
248: cn_api.g_miss_num,

Line 280: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
281: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
282: -- Start - R12 MOAC Changes
283: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
284: -- End - R12 MOAC Changes

Line 317: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

313: (p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
318: p_tier_coordinates_tbl IN tier_coordinates_tbl,
319: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
320: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
321: -- Start - MOAC Change