82: */
83:
84: PROCEDURE Create_Schedule
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,
83:
84: PROCEDURE Create_Schedule
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,
84: PROCEDURE Create_Schedule
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
125: */
126:
127: PROCEDURE Update_Schedule
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 :=
126:
127: PROCEDURE Update_Schedule
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,
127: PROCEDURE Update_Schedule
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 :=
161: */
162:
163: PROCEDURE Delete_Schedule
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
162:
163: PROCEDURE Delete_Schedule
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
163: PROCEDURE Delete_Schedule
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
197: */
198:
199: PROCEDURE Create_Dimension_Assign
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,
198:
199: PROCEDURE Create_Dimension_Assign
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,
199: PROCEDURE Create_Dimension_Assign
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
237: */
238:
239: PROCEDURE Update_Dimension_Assign
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,
238:
239: PROCEDURE Update_Dimension_Assign
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,
239: PROCEDURE Update_Dimension_Assign
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 :=
273: */
274:
275: PROCEDURE Delete_Dimension_Assign
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,
274:
275: PROCEDURE Delete_Dimension_Assign
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
275: PROCEDURE Delete_Dimension_Assign
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
310:
311:
312: PROCEDURE Update_Rate
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,
311:
312: PROCEDURE Update_Rate
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,
312: PROCEDURE Update_Rate
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,
348: */
349:
350: PROCEDURE Create_Dimension
351: (p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
349:
350: PROCEDURE Create_Dimension
351: (p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
350: PROCEDURE Create_Dimension
351: (p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
358: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
387: */
388:
389: PROCEDURE Update_Dimension
390: (p_api_version IN NUMBER,
391: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
392: p_commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
388:
389: PROCEDURE Update_Dimension
390: (p_api_version IN NUMBER,
391: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
392: p_commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
389: PROCEDURE Update_Dimension
390: (p_api_version IN NUMBER,
391: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
392: p_commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
397: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
426: */
427:
428: PROCEDURE Delete_Dimension
429: (p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
434: -- Start - R12 MOAC Changes
427:
428: PROCEDURE Delete_Dimension
429: (p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
434: -- Start - R12 MOAC Changes
435: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
428: PROCEDURE Delete_Dimension
429: (p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
434: -- Start - R12 MOAC Changes
435: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
436: -- End - R12 MOAC Changes
461: */
462:
463: PROCEDURE Create_Tier
464: (p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
469: p_value1 IN VARCHAR2,
462:
463: PROCEDURE Create_Tier
464: (p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
469: p_value1 IN VARCHAR2,
470: p_value2 IN VARCHAR2,
463: PROCEDURE Create_Tier
464: (p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
469: p_value1 IN VARCHAR2,
470: p_value2 IN VARCHAR2,
471: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
500: */
501:
502: PROCEDURE Update_Tier
503: (p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
508: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
501:
502: PROCEDURE Update_Tier
503: (p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
508: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
509: p_value1 IN VARCHAR2,
502: PROCEDURE Update_Tier
503: (p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
508: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
509: p_value1 IN VARCHAR2,
510: p_value2 IN VARCHAR2,
535: */
536:
537: PROCEDURE Delete_Tier
538: (p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
543: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
536:
537: PROCEDURE Delete_Tier
538: (p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
543: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
544: -- Start - R12 MOAC Changes
537: PROCEDURE Delete_Tier
538: (p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
543: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
544: -- Start - R12 MOAC Changes
545: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new