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,
147: x_msg_data OUT NOCOPY VARCHAR2);
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,
147: x_msg_data OUT NOCOPY VARCHAR2);
148: PROCEDURE Update_Rate_Post
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,
155: 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,
155: x_msg_data OUT NOCOPY VARCHAR2);
156: