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 8: FUNCTION get_rate_schedule_id(p_name in CN_RATE_SCHEDULES.NAME%TYPE)

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_MULTI_RATE_SCHEDULES_PUB';
5:
6: -- local util functions
7: -- to get a rate schedule ID from its name
8: FUNCTION get_rate_schedule_id(p_name in CN_RATE_SCHEDULES.NAME%TYPE)
9: RETURN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE IS
10:
11: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
12:

Line 9: RETURN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE IS

5:
6: -- local util functions
7: -- to get a rate schedule ID from its name
8: FUNCTION get_rate_schedule_id(p_name in CN_RATE_SCHEDULES.NAME%TYPE)
9: RETURN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE IS
10:
11: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
12:
13: BEGIN

Line 11: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

7: -- to get a rate schedule ID from its name
8: FUNCTION get_rate_schedule_id(p_name in CN_RATE_SCHEDULES.NAME%TYPE)
9: RETURN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE IS
10:
11: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
12:
13: BEGIN
14: select RATE_SCHEDULE_ID into l_rate_schedule_id
15: from CN_RATE_SCHEDULES

Line 15: from CN_RATE_SCHEDULES

11: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
12:
13: BEGIN
14: select RATE_SCHEDULE_ID into l_rate_schedule_id
15: from CN_RATE_SCHEDULES
16: where name = p_name;
17:
18: RETURN l_rate_schedule_id;
19: EXCEPTION

Line 46: FUNCTION get_rate_sch_dim_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

42: RAISE fnd_api.g_exc_error;
43: END get_rate_dimension_id;
44:
45: -- to get a rate_sch_dim_id from a given rate dimension ID and rate schedule ID
46: FUNCTION get_rate_sch_dim_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
47: p_rate_dimension_id in CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
48: RETURN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE IS
49:
50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

Line 104: FUNCTION get_rate_dim_tier_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

100: RAISE fnd_api.g_exc_error;
101: END get_rate_dim_tier_id;
102:
103: -- to get a rate_dim_tier_id from the rate_schedule and sequence numbers
104: FUNCTION get_rate_dim_tier_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
108:

Line 173: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

169: (p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
174: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
175: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
176: -- Start - MOAC Change
177: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,

Line 174: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
174: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
175: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
176: -- Start - MOAC Change
177: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,
178: -- End - MOAC Change

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

173: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
174: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
175: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
176: -- Start - MOAC Change
177: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE := NULL,
178: -- End - MOAC Change
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 183: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2) IS
182:
183: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
184: l_api_name CONSTANT VARCHAR2(30) := 'Create_Schedule';
185: l_api_version CONSTANT NUMBER := 1.0;
186: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
187: -- Start - MOAC Change

Line 351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,

347: (p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,

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

348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,

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

350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
357: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
358: -- Start - MOAC Change

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

352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
357: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
358: -- Start - MOAC Change
359: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,
360: -- End - MOAC Change

Line 359: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,

355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
357: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
358: -- Start - MOAC Change
359: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,
360: -- End - MOAC Change
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

363: x_msg_data OUT NOCOPY VARCHAR2) IS
364:
365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Schedule';
366: l_api_version CONSTANT NUMBER := 1.0;
367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
368: l_name CN_RATE_SCHEDULES.NAME%TYPE;
369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;

Line 368: l_name CN_RATE_SCHEDULES.NAME%TYPE;

364:
365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Schedule';
366: l_api_version CONSTANT NUMBER := 1.0;
367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
368: l_name CN_RATE_SCHEDULES.NAME%TYPE;
369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
372: -- Start - MOAC Change

Line 369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;

365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Schedule';
366: l_api_version CONSTANT NUMBER := 1.0;
367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
368: l_name CN_RATE_SCHEDULES.NAME%TYPE;
369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
372: -- Start - MOAC Change
373: l_org_id NUMBER;

Line 370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;

366: l_api_version CONSTANT NUMBER := 1.0;
367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
368: l_name CN_RATE_SCHEDULES.NAME%TYPE;
369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
372: -- Start - MOAC Change
373: l_org_id NUMBER;
374: -- End - MOAC Change

Line 400: FROM cn_rate_schedules

396: l_rate_schedule_id := get_rate_schedule_id(p_original_name);
397:
398: -- Start - MOAC Change
399: SELECT org_id INTO l_org_id
400: FROM cn_rate_schedules
401: WHERE rate_schedule_id = l_rate_schedule_id;
402:
403: IF (l_org_id <> p_org_id)
404: THEN

Line 424: from cn_rate_schedules

420: -- End - MOAC Change
421:
422: -- handle G_MISSES (validation for this select already performed)
423: select commission_unit_code into l_original_comm_unit_code
424: from cn_rate_schedules
425: where rate_schedule_id = l_rate_schedule_id;
426:
427: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
428: decode(p_commission_unit_code, cn_api.g_miss_char,

Line 565: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

561: (p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
563: p_commit IN VARCHAR2 := FND_API.G_FALSE,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
565: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
566: -- Start - R12 MOAC Changes
567: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
568: -- End - R12 MOAC Changes
569: x_return_status OUT NOCOPY VARCHAR2,

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

563: p_commit IN VARCHAR2 := FND_API.G_FALSE,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
565: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
566: -- Start - R12 MOAC Changes
567: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
568: -- End - R12 MOAC Changes
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,
571: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 573: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := 0;

569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,
571: x_msg_data OUT NOCOPY VARCHAR2) IS
572:
573: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := 0;
574: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Schedule';
575: l_api_version CONSTANT NUMBER := 1.0;
576: BEGIN
577: -- Standard Start of API savepoint

Line 706: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

702: (p_api_version IN NUMBER,
703: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
704: p_commit IN VARCHAR2 := FND_API.G_FALSE,
705: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
706: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
707: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
708: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
709: -- Start - MOAC Change
710: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

Line 718: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

714: x_msg_data OUT NOCOPY VARCHAR2) IS
715:
716: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension_Assign';
717: l_api_version CONSTANT NUMBER := 1.0;
718: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
719: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
720: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
721: -- Start - MOAC Change
722: l_org_id NUMBER;

Line 880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

876: (p_api_version IN NUMBER,
877: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
878: p_commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,

Line 895: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

891: x_msg_data OUT NOCOPY VARCHAR2) IS
892:
893: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension_Assign';
894: l_api_version CONSTANT NUMBER := 1.0;
895: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
896: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
897: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
898: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
899: -- Start - MOAC Change

Line 1091: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

1087: (p_api_version IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1089: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1092: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1093: -- Start - R12 MOAC Changes
1094: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
1095: -- End - R12 MOAC Changes

Line 1102: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

1098: x_msg_data OUT NOCOPY VARCHAR2) IS
1099:
1100: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dimension_Assign';
1101: l_api_version CONSTANT NUMBER := 1.0;
1102: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1103: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
1105: BEGIN
1106: -- Standard Start of API savepoint

Line 1241: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,

1237: (p_api_version IN NUMBER,
1238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1241: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1242: p_tier_coordinates_tbl IN tier_coordinates_tbl,
1243: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1244: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
1245: -- Start - MOAC Change

Line 1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

1250: x_msg_data OUT NOCOPY VARCHAR2) IS
1251:
1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rate';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1255: l_rate_tier_id CN_RATE_TIERS.RATE_TIER_ID%TYPE;
1256: l_rate_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
1257: l_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE;
1258: l_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE;

Line 1289: FROM cn_rate_schedules

1285: l_rate_schedule_id := get_rate_schedule_id(p_rate_schedule_name);
1286:
1287: -- Start - MOAC Change
1288: SELECT org_id INTO l_org_id
1289: FROM cn_rate_schedules
1290: WHERE rate_schedule_id = l_rate_schedule_id;
1291:
1292: IF (l_org_id <> p_org_id)
1293: THEN