3609: x_msg_count OUT NOCOPY NUMBER,
3610: x_msg_data OUT NOCOPY VARCHAR2,
3611:
3612: p_source_object_id IN NUMBER,
3613: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
3614: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
3615:
3616: x_new_object_id OUT NOCOPY NUMBER,
3617: x_custom_setup_id OUT NOCOPY NUMBER
3610: x_msg_data OUT NOCOPY VARCHAR2,
3611:
3612: p_source_object_id IN NUMBER,
3613: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
3614: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
3615:
3616: x_new_object_id OUT NOCOPY NUMBER,
3617: x_custom_setup_id OUT NOCOPY NUMBER
3618: )
3824: FETCH fetch_sch_details INTO l_reference_rec;
3825: CLOSE fetch_sch_details;
3826:
3827: -- Copy GENERAL info from source schedule
3828: -- IF AMS_CpyUtility_PVT.is_copy_attribute ('DETL', p_attributes_table) = FND_API.G_TRUE THEN
3829: -- OPEN fetch_sch_details(p_source_object_id);
3830: -- FETCH fetch_sch_details INTO l_schedule_rec;
3831: -- CLOSE fetch_sch_details;
3832: -- END IF;
3970: -- copy from the base object
3971: -- -------------------------------------------
3972:
3973:
3974: AMS_CpyUtility_PVT.get_column_value ('StartDate', p_copy_columns_table, l_schedule_rec.start_date_time);
3975: l_schedule_rec.start_date_time := NVL (l_schedule_rec.start_date_time, l_reference_rec.start_date_time);
3976: AMS_CpyUtility_PVT.get_column_value ('EndDate', p_copy_columns_table, l_schedule_rec.end_date_time);
3977: l_schedule_rec.end_date_time := NVL (l_schedule_rec.end_date_time, l_reference_rec.end_date_time);
3978:
3972:
3973:
3974: AMS_CpyUtility_PVT.get_column_value ('StartDate', p_copy_columns_table, l_schedule_rec.start_date_time);
3975: l_schedule_rec.start_date_time := NVL (l_schedule_rec.start_date_time, l_reference_rec.start_date_time);
3976: AMS_CpyUtility_PVT.get_column_value ('EndDate', p_copy_columns_table, l_schedule_rec.end_date_time);
3977: l_schedule_rec.end_date_time := NVL (l_schedule_rec.end_date_time, l_reference_rec.end_date_time);
3978:
3979: -- added by soagrawa on 16-Jun-2001
3980: AMS_CpyUtility_PVT.get_column_value ('copyParSrcCode', p_copy_columns_table, l_schedule_rec.source_code);
3976: AMS_CpyUtility_PVT.get_column_value ('EndDate', p_copy_columns_table, l_schedule_rec.end_date_time);
3977: l_schedule_rec.end_date_time := NVL (l_schedule_rec.end_date_time, l_reference_rec.end_date_time);
3978:
3979: -- added by soagrawa on 16-Jun-2001
3980: AMS_CpyUtility_PVT.get_column_value ('copyParSrcCode', p_copy_columns_table, l_schedule_rec.source_code);
3981: -- next line commented out by soagrawa on 28-mar-2002
3982: --l_schedule_rec.source_code := NVL (l_schedule_rec.source_code, l_reference_rec.source_code);
3983: AMS_CpyUtility_PVT.get_column_value ('copyUseParSrcCode', p_copy_columns_table, l_schedule_rec.use_parent_code_flag);
3984: l_schedule_rec.use_parent_code_flag := NVL (l_schedule_rec.use_parent_code_flag, l_reference_rec.use_parent_code_flag);
3979: -- added by soagrawa on 16-Jun-2001
3980: AMS_CpyUtility_PVT.get_column_value ('copyParSrcCode', p_copy_columns_table, l_schedule_rec.source_code);
3981: -- next line commented out by soagrawa on 28-mar-2002
3982: --l_schedule_rec.source_code := NVL (l_schedule_rec.source_code, l_reference_rec.source_code);
3983: AMS_CpyUtility_PVT.get_column_value ('copyUseParSrcCode', p_copy_columns_table, l_schedule_rec.use_parent_code_flag);
3984: l_schedule_rec.use_parent_code_flag := NVL (l_schedule_rec.use_parent_code_flag, l_reference_rec.use_parent_code_flag);
3985:
3986: --
3987: -- mandatory fields for csch create are
3987: -- mandatory fields for csch create are
3988: -- name, lang, coordinator, currency, st date, time zone
3989: --
3990:
3991: AMS_CpyUtility_PVT.get_column_value ('Language', p_copy_columns_table, l_schedule_rec.language_code);
3992: l_schedule_rec.language_code := NVL (l_schedule_rec.language_code, l_reference_rec.language_code);
3993: AMS_CpyUtility_PVT.get_column_value ('CoordinatorName', p_copy_columns_table, l_coordinator_name);
3994: -- modified by soagrawa for bug# 2380670
3995: -- AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_reference_rec.owner_user_id);
3989: --
3990:
3991: AMS_CpyUtility_PVT.get_column_value ('Language', p_copy_columns_table, l_schedule_rec.language_code);
3992: l_schedule_rec.language_code := NVL (l_schedule_rec.language_code, l_reference_rec.language_code);
3993: AMS_CpyUtility_PVT.get_column_value ('CoordinatorName', p_copy_columns_table, l_coordinator_name);
3994: -- modified by soagrawa for bug# 2380670
3995: -- AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_reference_rec.owner_user_id);
3996: AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_schedule_rec.owner_user_id);
3997: l_schedule_rec.owner_user_id := NVL (l_schedule_rec.owner_user_id, l_reference_rec.owner_user_id);
3991: AMS_CpyUtility_PVT.get_column_value ('Language', p_copy_columns_table, l_schedule_rec.language_code);
3992: l_schedule_rec.language_code := NVL (l_schedule_rec.language_code, l_reference_rec.language_code);
3993: AMS_CpyUtility_PVT.get_column_value ('CoordinatorName', p_copy_columns_table, l_coordinator_name);
3994: -- modified by soagrawa for bug# 2380670
3995: -- AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_reference_rec.owner_user_id);
3996: AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_schedule_rec.owner_user_id);
3997: l_schedule_rec.owner_user_id := NVL (l_schedule_rec.owner_user_id, l_reference_rec.owner_user_id);
3998:
3999: AMS_CpyUtility_PVT.get_column_value ('Currency', p_copy_columns_table, l_schedule_rec.transaction_currency_code);
3992: l_schedule_rec.language_code := NVL (l_schedule_rec.language_code, l_reference_rec.language_code);
3993: AMS_CpyUtility_PVT.get_column_value ('CoordinatorName', p_copy_columns_table, l_coordinator_name);
3994: -- modified by soagrawa for bug# 2380670
3995: -- AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_reference_rec.owner_user_id);
3996: AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_schedule_rec.owner_user_id);
3997: l_schedule_rec.owner_user_id := NVL (l_schedule_rec.owner_user_id, l_reference_rec.owner_user_id);
3998:
3999: AMS_CpyUtility_PVT.get_column_value ('Currency', p_copy_columns_table, l_schedule_rec.transaction_currency_code);
4000: l_schedule_rec.transaction_currency_code := NVL (l_schedule_rec.transaction_currency_code, l_reference_rec.transaction_currency_code);
3995: -- AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_reference_rec.owner_user_id);
3996: AMS_CpyUtility_PVT.get_column_value ('CoordinatorId', p_copy_columns_table, l_schedule_rec.owner_user_id);
3997: l_schedule_rec.owner_user_id := NVL (l_schedule_rec.owner_user_id, l_reference_rec.owner_user_id);
3998:
3999: AMS_CpyUtility_PVT.get_column_value ('Currency', p_copy_columns_table, l_schedule_rec.transaction_currency_code);
4000: l_schedule_rec.transaction_currency_code := NVL (l_schedule_rec.transaction_currency_code, l_reference_rec.transaction_currency_code);
4001:
4002: --dbiswas added the following columns that can be edited on the UI.
4003:
4000: l_schedule_rec.transaction_currency_code := NVL (l_schedule_rec.transaction_currency_code, l_reference_rec.transaction_currency_code);
4001:
4002: --dbiswas added the following columns that can be edited on the UI.
4003:
4004: AMS_CpyUtility_PVT.get_column_value ('MarketingMediumId', p_copy_columns_table, l_schedule_rec.marketing_medium_id);
4005: l_schedule_rec.marketing_medium_id := NVL (l_schedule_rec.marketing_medium_id, l_reference_rec.marketing_medium_id);
4006:
4007: AMS_CpyUtility_PVT.get_column_value ('Purpose', p_copy_columns_table, l_schedule_rec.purpose);
4008:
4003:
4004: AMS_CpyUtility_PVT.get_column_value ('MarketingMediumId', p_copy_columns_table, l_schedule_rec.marketing_medium_id);
4005: l_schedule_rec.marketing_medium_id := NVL (l_schedule_rec.marketing_medium_id, l_reference_rec.marketing_medium_id);
4006:
4007: AMS_CpyUtility_PVT.get_column_value ('Purpose', p_copy_columns_table, l_schedule_rec.purpose);
4008:
4009: AMS_CpyUtility_PVT.get_column_value ('SourceCode', p_copy_columns_table, l_schedule_rec.source_code);
4010:
4011: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_schedule_rec.description);
4005: l_schedule_rec.marketing_medium_id := NVL (l_schedule_rec.marketing_medium_id, l_reference_rec.marketing_medium_id);
4006:
4007: AMS_CpyUtility_PVT.get_column_value ('Purpose', p_copy_columns_table, l_schedule_rec.purpose);
4008:
4009: AMS_CpyUtility_PVT.get_column_value ('SourceCode', p_copy_columns_table, l_schedule_rec.source_code);
4010:
4011: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_schedule_rec.description);
4012:
4013:
4007: AMS_CpyUtility_PVT.get_column_value ('Purpose', p_copy_columns_table, l_schedule_rec.purpose);
4008:
4009: AMS_CpyUtility_PVT.get_column_value ('SourceCode', p_copy_columns_table, l_schedule_rec.source_code);
4010:
4011: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_schedule_rec.description);
4012:
4013:
4014: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_schedule_rec.attribute_category);
4015:
4010:
4011: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_schedule_rec.description);
4012:
4013:
4014: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_schedule_rec.attribute_category);
4015:
4016: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_schedule_rec.attribute1);
4017:
4018: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_schedule_rec.attribute2);
4012:
4013:
4014: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_schedule_rec.attribute_category);
4015:
4016: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_schedule_rec.attribute1);
4017:
4018: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_schedule_rec.attribute2);
4019:
4020: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_schedule_rec.attribute3);
4014: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_schedule_rec.attribute_category);
4015:
4016: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_schedule_rec.attribute1);
4017:
4018: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_schedule_rec.attribute2);
4019:
4020: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_schedule_rec.attribute3);
4021:
4022: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_schedule_rec.attribute4);
4016: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_schedule_rec.attribute1);
4017:
4018: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_schedule_rec.attribute2);
4019:
4020: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_schedule_rec.attribute3);
4021:
4022: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_schedule_rec.attribute4);
4023:
4024: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_schedule_rec.attribute5);
4018: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_schedule_rec.attribute2);
4019:
4020: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_schedule_rec.attribute3);
4021:
4022: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_schedule_rec.attribute4);
4023:
4024: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_schedule_rec.attribute5);
4025:
4026: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_schedule_rec.attribute6);
4020: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_schedule_rec.attribute3);
4021:
4022: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_schedule_rec.attribute4);
4023:
4024: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_schedule_rec.attribute5);
4025:
4026: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_schedule_rec.attribute6);
4027:
4028: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_schedule_rec.attribute7);
4022: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_schedule_rec.attribute4);
4023:
4024: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_schedule_rec.attribute5);
4025:
4026: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_schedule_rec.attribute6);
4027:
4028: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_schedule_rec.attribute7);
4029:
4030: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_schedule_rec.attribute8);
4024: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_schedule_rec.attribute5);
4025:
4026: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_schedule_rec.attribute6);
4027:
4028: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_schedule_rec.attribute7);
4029:
4030: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_schedule_rec.attribute8);
4031:
4032: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_schedule_rec.attribute9);
4026: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_schedule_rec.attribute6);
4027:
4028: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_schedule_rec.attribute7);
4029:
4030: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_schedule_rec.attribute8);
4031:
4032: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_schedule_rec.attribute9);
4033:
4034: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_schedule_rec.attribute10);
4028: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_schedule_rec.attribute7);
4029:
4030: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_schedule_rec.attribute8);
4031:
4032: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_schedule_rec.attribute9);
4033:
4034: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_schedule_rec.attribute10);
4035:
4036: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_schedule_rec.attribute11);
4030: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_schedule_rec.attribute8);
4031:
4032: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_schedule_rec.attribute9);
4033:
4034: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_schedule_rec.attribute10);
4035:
4036: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_schedule_rec.attribute11);
4037:
4038: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_schedule_rec.attribute12);
4032: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_schedule_rec.attribute9);
4033:
4034: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_schedule_rec.attribute10);
4035:
4036: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_schedule_rec.attribute11);
4037:
4038: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_schedule_rec.attribute12);
4039:
4040: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_schedule_rec.attribute13);
4034: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_schedule_rec.attribute10);
4035:
4036: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_schedule_rec.attribute11);
4037:
4038: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_schedule_rec.attribute12);
4039:
4040: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_schedule_rec.attribute13);
4041:
4042: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_schedule_rec.attribute14);
4036: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_schedule_rec.attribute11);
4037:
4038: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_schedule_rec.attribute12);
4039:
4040: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_schedule_rec.attribute13);
4041:
4042: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_schedule_rec.attribute14);
4043:
4044: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_schedule_rec.attribute15);
4038: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_schedule_rec.attribute12);
4039:
4040: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_schedule_rec.attribute13);
4041:
4042: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_schedule_rec.attribute14);
4043:
4044: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_schedule_rec.attribute15);
4045:
4046:
4040: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_schedule_rec.attribute13);
4041:
4042: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_schedule_rec.attribute14);
4043:
4044: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_schedule_rec.attribute15);
4045:
4046:
4047: AMS_CpyUtility_PVT.get_column_value ('activityAttributeCategory', p_copy_columns_table, l_schedule_rec.activity_attribute_category);
4048:
4043:
4044: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_schedule_rec.attribute15);
4045:
4046:
4047: AMS_CpyUtility_PVT.get_column_value ('activityAttributeCategory', p_copy_columns_table, l_schedule_rec.activity_attribute_category);
4048:
4049: AMS_CpyUtility_PVT.get_column_value ('activityAttribute1', p_copy_columns_table, l_schedule_rec.activity_attribute1);
4050:
4051: AMS_CpyUtility_PVT.get_column_value ('activityAttribute2', p_copy_columns_table, l_schedule_rec.activity_attribute2);
4045:
4046:
4047: AMS_CpyUtility_PVT.get_column_value ('activityAttributeCategory', p_copy_columns_table, l_schedule_rec.activity_attribute_category);
4048:
4049: AMS_CpyUtility_PVT.get_column_value ('activityAttribute1', p_copy_columns_table, l_schedule_rec.activity_attribute1);
4050:
4051: AMS_CpyUtility_PVT.get_column_value ('activityAttribute2', p_copy_columns_table, l_schedule_rec.activity_attribute2);
4052:
4053: AMS_CpyUtility_PVT.get_column_value ('activityAttribute3', p_copy_columns_table, l_schedule_rec.activity_attribute3);
4047: AMS_CpyUtility_PVT.get_column_value ('activityAttributeCategory', p_copy_columns_table, l_schedule_rec.activity_attribute_category);
4048:
4049: AMS_CpyUtility_PVT.get_column_value ('activityAttribute1', p_copy_columns_table, l_schedule_rec.activity_attribute1);
4050:
4051: AMS_CpyUtility_PVT.get_column_value ('activityAttribute2', p_copy_columns_table, l_schedule_rec.activity_attribute2);
4052:
4053: AMS_CpyUtility_PVT.get_column_value ('activityAttribute3', p_copy_columns_table, l_schedule_rec.activity_attribute3);
4054:
4055: AMS_CpyUtility_PVT.get_column_value ('activityAttribute4', p_copy_columns_table, l_schedule_rec.activity_attribute4);
4049: AMS_CpyUtility_PVT.get_column_value ('activityAttribute1', p_copy_columns_table, l_schedule_rec.activity_attribute1);
4050:
4051: AMS_CpyUtility_PVT.get_column_value ('activityAttribute2', p_copy_columns_table, l_schedule_rec.activity_attribute2);
4052:
4053: AMS_CpyUtility_PVT.get_column_value ('activityAttribute3', p_copy_columns_table, l_schedule_rec.activity_attribute3);
4054:
4055: AMS_CpyUtility_PVT.get_column_value ('activityAttribute4', p_copy_columns_table, l_schedule_rec.activity_attribute4);
4056:
4057: AMS_CpyUtility_PVT.get_column_value ('activityAttribute5', p_copy_columns_table, l_schedule_rec.activity_attribute5);
4051: AMS_CpyUtility_PVT.get_column_value ('activityAttribute2', p_copy_columns_table, l_schedule_rec.activity_attribute2);
4052:
4053: AMS_CpyUtility_PVT.get_column_value ('activityAttribute3', p_copy_columns_table, l_schedule_rec.activity_attribute3);
4054:
4055: AMS_CpyUtility_PVT.get_column_value ('activityAttribute4', p_copy_columns_table, l_schedule_rec.activity_attribute4);
4056:
4057: AMS_CpyUtility_PVT.get_column_value ('activityAttribute5', p_copy_columns_table, l_schedule_rec.activity_attribute5);
4058:
4059: AMS_CpyUtility_PVT.get_column_value ('activityAttribute6', p_copy_columns_table, l_schedule_rec.activity_attribute6);
4053: AMS_CpyUtility_PVT.get_column_value ('activityAttribute3', p_copy_columns_table, l_schedule_rec.activity_attribute3);
4054:
4055: AMS_CpyUtility_PVT.get_column_value ('activityAttribute4', p_copy_columns_table, l_schedule_rec.activity_attribute4);
4056:
4057: AMS_CpyUtility_PVT.get_column_value ('activityAttribute5', p_copy_columns_table, l_schedule_rec.activity_attribute5);
4058:
4059: AMS_CpyUtility_PVT.get_column_value ('activityAttribute6', p_copy_columns_table, l_schedule_rec.activity_attribute6);
4060:
4061: AMS_CpyUtility_PVT.get_column_value ('activityAttribute7', p_copy_columns_table, l_schedule_rec.activity_attribute7);
4055: AMS_CpyUtility_PVT.get_column_value ('activityAttribute4', p_copy_columns_table, l_schedule_rec.activity_attribute4);
4056:
4057: AMS_CpyUtility_PVT.get_column_value ('activityAttribute5', p_copy_columns_table, l_schedule_rec.activity_attribute5);
4058:
4059: AMS_CpyUtility_PVT.get_column_value ('activityAttribute6', p_copy_columns_table, l_schedule_rec.activity_attribute6);
4060:
4061: AMS_CpyUtility_PVT.get_column_value ('activityAttribute7', p_copy_columns_table, l_schedule_rec.activity_attribute7);
4062:
4063: AMS_CpyUtility_PVT.get_column_value ('activityAttribute8', p_copy_columns_table, l_schedule_rec.activity_attribute8);
4057: AMS_CpyUtility_PVT.get_column_value ('activityAttribute5', p_copy_columns_table, l_schedule_rec.activity_attribute5);
4058:
4059: AMS_CpyUtility_PVT.get_column_value ('activityAttribute6', p_copy_columns_table, l_schedule_rec.activity_attribute6);
4060:
4061: AMS_CpyUtility_PVT.get_column_value ('activityAttribute7', p_copy_columns_table, l_schedule_rec.activity_attribute7);
4062:
4063: AMS_CpyUtility_PVT.get_column_value ('activityAttribute8', p_copy_columns_table, l_schedule_rec.activity_attribute8);
4064:
4065: AMS_CpyUtility_PVT.get_column_value ('activityAttribute9', p_copy_columns_table, l_schedule_rec.activity_attribute9);
4059: AMS_CpyUtility_PVT.get_column_value ('activityAttribute6', p_copy_columns_table, l_schedule_rec.activity_attribute6);
4060:
4061: AMS_CpyUtility_PVT.get_column_value ('activityAttribute7', p_copy_columns_table, l_schedule_rec.activity_attribute7);
4062:
4063: AMS_CpyUtility_PVT.get_column_value ('activityAttribute8', p_copy_columns_table, l_schedule_rec.activity_attribute8);
4064:
4065: AMS_CpyUtility_PVT.get_column_value ('activityAttribute9', p_copy_columns_table, l_schedule_rec.activity_attribute9);
4066:
4067: AMS_CpyUtility_PVT.get_column_value ('activityAttribute10', p_copy_columns_table, l_schedule_rec.activity_attribute10);
4061: AMS_CpyUtility_PVT.get_column_value ('activityAttribute7', p_copy_columns_table, l_schedule_rec.activity_attribute7);
4062:
4063: AMS_CpyUtility_PVT.get_column_value ('activityAttribute8', p_copy_columns_table, l_schedule_rec.activity_attribute8);
4064:
4065: AMS_CpyUtility_PVT.get_column_value ('activityAttribute9', p_copy_columns_table, l_schedule_rec.activity_attribute9);
4066:
4067: AMS_CpyUtility_PVT.get_column_value ('activityAttribute10', p_copy_columns_table, l_schedule_rec.activity_attribute10);
4068:
4069: AMS_CpyUtility_PVT.get_column_value ('activityAttribute11', p_copy_columns_table, l_schedule_rec.activity_attribute11);
4063: AMS_CpyUtility_PVT.get_column_value ('activityAttribute8', p_copy_columns_table, l_schedule_rec.activity_attribute8);
4064:
4065: AMS_CpyUtility_PVT.get_column_value ('activityAttribute9', p_copy_columns_table, l_schedule_rec.activity_attribute9);
4066:
4067: AMS_CpyUtility_PVT.get_column_value ('activityAttribute10', p_copy_columns_table, l_schedule_rec.activity_attribute10);
4068:
4069: AMS_CpyUtility_PVT.get_column_value ('activityAttribute11', p_copy_columns_table, l_schedule_rec.activity_attribute11);
4070:
4071: AMS_CpyUtility_PVT.get_column_value ('activityAttribute12', p_copy_columns_table, l_schedule_rec.activity_attribute12);
4065: AMS_CpyUtility_PVT.get_column_value ('activityAttribute9', p_copy_columns_table, l_schedule_rec.activity_attribute9);
4066:
4067: AMS_CpyUtility_PVT.get_column_value ('activityAttribute10', p_copy_columns_table, l_schedule_rec.activity_attribute10);
4068:
4069: AMS_CpyUtility_PVT.get_column_value ('activityAttribute11', p_copy_columns_table, l_schedule_rec.activity_attribute11);
4070:
4071: AMS_CpyUtility_PVT.get_column_value ('activityAttribute12', p_copy_columns_table, l_schedule_rec.activity_attribute12);
4072:
4073: AMS_CpyUtility_PVT.get_column_value ('activityAttribute13', p_copy_columns_table, l_schedule_rec.activity_attribute13);
4067: AMS_CpyUtility_PVT.get_column_value ('activityAttribute10', p_copy_columns_table, l_schedule_rec.activity_attribute10);
4068:
4069: AMS_CpyUtility_PVT.get_column_value ('activityAttribute11', p_copy_columns_table, l_schedule_rec.activity_attribute11);
4070:
4071: AMS_CpyUtility_PVT.get_column_value ('activityAttribute12', p_copy_columns_table, l_schedule_rec.activity_attribute12);
4072:
4073: AMS_CpyUtility_PVT.get_column_value ('activityAttribute13', p_copy_columns_table, l_schedule_rec.activity_attribute13);
4074:
4075: AMS_CpyUtility_PVT.get_column_value ('activityAttribute14', p_copy_columns_table, l_schedule_rec.activity_attribute14);
4069: AMS_CpyUtility_PVT.get_column_value ('activityAttribute11', p_copy_columns_table, l_schedule_rec.activity_attribute11);
4070:
4071: AMS_CpyUtility_PVT.get_column_value ('activityAttribute12', p_copy_columns_table, l_schedule_rec.activity_attribute12);
4072:
4073: AMS_CpyUtility_PVT.get_column_value ('activityAttribute13', p_copy_columns_table, l_schedule_rec.activity_attribute13);
4074:
4075: AMS_CpyUtility_PVT.get_column_value ('activityAttribute14', p_copy_columns_table, l_schedule_rec.activity_attribute14);
4076:
4077: AMS_CpyUtility_PVT.get_column_value ('activityAttribute15', p_copy_columns_table, l_schedule_rec.activity_attribute15);
4071: AMS_CpyUtility_PVT.get_column_value ('activityAttribute12', p_copy_columns_table, l_schedule_rec.activity_attribute12);
4072:
4073: AMS_CpyUtility_PVT.get_column_value ('activityAttribute13', p_copy_columns_table, l_schedule_rec.activity_attribute13);
4074:
4075: AMS_CpyUtility_PVT.get_column_value ('activityAttribute14', p_copy_columns_table, l_schedule_rec.activity_attribute14);
4076:
4077: AMS_CpyUtility_PVT.get_column_value ('activityAttribute15', p_copy_columns_table, l_schedule_rec.activity_attribute15);
4078:
4079: -- end updates by dbiswas for columns that can be edited from the UI
4073: AMS_CpyUtility_PVT.get_column_value ('activityAttribute13', p_copy_columns_table, l_schedule_rec.activity_attribute13);
4074:
4075: AMS_CpyUtility_PVT.get_column_value ('activityAttribute14', p_copy_columns_table, l_schedule_rec.activity_attribute14);
4076:
4077: AMS_CpyUtility_PVT.get_column_value ('activityAttribute15', p_copy_columns_table, l_schedule_rec.activity_attribute15);
4078:
4079: -- end updates by dbiswas for columns that can be edited from the UI
4080: -- -------------------------------------------
4081: -- if field is not passed in from copy_columns_table
4081: -- if field is not passed in from copy_columns_table
4082: -- copy from the base object
4083: -- -------------------------------------------
4084:
4085: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_schedule_rec.schedule_name);
4086:
4087: AMS_CpyUtility_PVT.get_column_value ('CampaignName', p_copy_columns_table, l_campaign_name);
4088: OPEN get_camp_id;
4089: FETCH get_camp_id INTO l_schedule_rec.campaign_id;
4083: -- -------------------------------------------
4084:
4085: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_schedule_rec.schedule_name);
4086:
4087: AMS_CpyUtility_PVT.get_column_value ('CampaignName', p_copy_columns_table, l_campaign_name);
4088: OPEN get_camp_id;
4089: FETCH get_camp_id INTO l_schedule_rec.campaign_id;
4090: CLOSE get_camp_id;
4091:
4089: FETCH get_camp_id INTO l_schedule_rec.campaign_id;
4090: CLOSE get_camp_id;
4091:
4092: -- next line removed by soagrawa on 07-mar-2002 to fix bug# 2229618
4093: -- AMS_CpyUtility_PVT.get_column_value ('CampaignSource', p_copy_columns_table, l_schedule_rec.source_code);
4094:
4095: /*AMS_CpyUtility_PVT.get_column_value ('CountryName', p_copy_columns_table, l_country_name);
4096: OPEN get_country_id;
4097: FETCH get_camp_id INTO l_schedule_rec.campaign_id;
4091:
4092: -- next line removed by soagrawa on 07-mar-2002 to fix bug# 2229618
4093: -- AMS_CpyUtility_PVT.get_column_value ('CampaignSource', p_copy_columns_table, l_schedule_rec.source_code);
4094:
4095: /*AMS_CpyUtility_PVT.get_column_value ('CountryName', p_copy_columns_table, l_country_name);
4096: OPEN get_country_id;
4097: FETCH get_camp_id INTO l_schedule_rec.campaign_id;
4098: CLOSE get_camp_id;
4099: */
4111: -- end of Fix for bug 2989203
4112:
4113:
4114:
4115: -- AMS_CpyUtility_PVT.get_column_value ('', p_copy_columns_table, l_schedule_rec.);
4116:
4117: AMS_UTILITY_PVT.debug_message('before copying event '||l_schedule_rec.activity_type_code);
4118: AMS_UTILITY_PVT.debug_message('before copying event '||l_reference_rec.related_event_id);
4119:
4320: -- Registration REGS // Leave for later
4321: -- Task TASK
4322:
4323:
4324: IF AMS_CpyUtility_PVT.is_copy_attribute ('AGEN', p_attributes_table) = FND_API.G_TRUE
4325: THEN l_attr_list.p_AGEN := 'Y';
4326: END IF;
4327:
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4324: IF AMS_CpyUtility_PVT.is_copy_attribute ('AGEN', p_attributes_table) = FND_API.G_TRUE
4325: THEN l_attr_list.p_AGEN := 'Y';
4326: END IF;
4327:
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4329: THEN l_attr_list.p_ATCH := 'Y';
4330: END IF;
4331:
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4329: THEN l_attr_list.p_ATCH := 'Y';
4330: END IF;
4331:
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4333: THEN l_attr_list.p_CATG := 'Y';
4334: END IF;
4335:
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4333: THEN l_attr_list.p_CATG := 'Y';
4334: END IF;
4335:
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4337: THEN l_attr_list.p_CELL := 'Y';
4338: END IF;
4339:
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4337: THEN l_attr_list.p_CELL := 'Y';
4338: END IF;
4339:
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4341: THEN l_attr_list.p_DELV := 'Y';
4342: END IF;
4343:
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4341: THEN l_attr_list.p_DELV := 'Y';
4342: END IF;
4343:
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4345: THEN l_attr_list.p_MESG := 'Y';
4346: END IF;
4347:
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4345: THEN l_attr_list.p_MESG := 'Y';
4346: END IF;
4347:
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4349: THEN l_attr_list.p_PROD := 'Y';
4350: END IF;
4351:
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4349: THEN l_attr_list.p_PROD := 'Y';
4350: END IF;
4351:
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4353: THEN l_attr_list.p_PTNR := 'Y';
4354: END IF;
4355:
4356: IF AMS_CpyUtility_PVT.is_copy_attribute ('REGS', p_attributes_table) = FND_API.G_TRUE
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4353: THEN l_attr_list.p_PTNR := 'Y';
4354: END IF;
4355:
4356: IF AMS_CpyUtility_PVT.is_copy_attribute ('REGS', p_attributes_table) = FND_API.G_TRUE
4357: THEN l_attr_list.p_REGS := 'Y';
4358: END IF;
4359:
4360: -- added by soagrawa on 25-jan-2002 bug# 2175580
4357: THEN l_attr_list.p_REGS := 'Y';
4358: END IF;
4359:
4360: -- added by soagrawa on 25-jan-2002 bug# 2175580
4361: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE
4362: THEN l_attr_list.p_CONTENT := 'Y';
4363: END IF;
4364:
4365: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE schedules only.
4362: THEN l_attr_list.p_CONTENT := 'Y';
4363: END IF;
4364:
4365: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE schedules only.
4366: IF AMS_CpyUtility_PVT.is_copy_attribute ('TGRP', p_attributes_table) = FND_API.G_TRUE
4367: THEN l_attr_list.p_TGRP := 'Y';
4368: END IF;
4369:
4370: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE and CLASSIC schedules
4369:
4370: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE and CLASSIC schedules
4371: -- For Classic schedules, copy of COLT will always to true - to be in sync with 11.5.9 cover letter copy
4372: IF l_schedule_rec.usage = 'LITE' then
4373: IF AMS_CpyUtility_PVT.is_copy_attribute ('COLT', p_attributes_table) = FND_API.G_TRUE
4374: THEN
4375: l_attr_list.p_COLT := 'Y';
4376: -- Debug Message
4377: IF (AMS_DEBUG_HIGH_ON) THEN
4390: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is PHAT thus setting copy COLT to true' );
4391: END IF;
4392: END IF;
4393:
4394: IF AMS_CpyUtility_PVT.is_copy_attribute ('COLT', p_attributes_table) = FND_API.G_TRUE
4395: THEN l_attr_list.p_COLT := 'Y';
4396: END IF;
4397:
4398: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for LITE schedules.'OFFERING' does not exist for Classic schedules
4395: THEN l_attr_list.p_COLT := 'Y';
4396: END IF;
4397:
4398: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for LITE schedules.'OFFERING' does not exist for Classic schedules
4399: IF AMS_CpyUtility_PVT.is_copy_attribute ('OFFERING', p_attributes_table) = FND_API.G_TRUE
4400: THEN l_attr_list.p_PROD := 'Y';
4401: END IF;
4402:
4403: -- added by spragupa on 23-nov-2007 for ER 6467510 - For extending COPY functionality for TASKS
4400: THEN l_attr_list.p_PROD := 'Y';
4401: END IF;
4402:
4403: -- added by spragupa on 23-nov-2007 for ER 6467510 - For extending COPY functionality for TASKS
4404: IF AMS_CpyUtility_PVT.is_copy_attribute ('TASK', p_attributes_table) = FND_API.G_TRUE
4405: THEN l_attr_list.p_TASK := 'Y';
4406: END IF;
4407:
4408: Ams_CopyActivities_PVT.copy_schedule_attributes (