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.AMS_EVENT_OBJECTS_COPY_PVT dependencies on AMS_CPYUTILITY_PVT

Line 114: l_attributes_table AMS_CpyUtility_PVT.copy_attributes_table_type;

110: SELECT event_header_id
111: FROM ams_event_offers_vl
112: WHERE event_offer_id=l_event_offer_id;
113:
114: l_attributes_table AMS_CpyUtility_PVT.copy_attributes_table_type;
115: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
116:
117: CURSOR new_event_dates (l_new_event_header_id NUMBER) IS
118: SELECT ACTIVE_FROM_DATE, ACTIVE_TO_DATE

Line 115: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;

111: FROM ams_event_offers_vl
112: WHERE event_offer_id=l_event_offer_id;
113:
114: l_attributes_table AMS_CpyUtility_PVT.copy_attributes_table_type;
115: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
116:
117: CURSOR new_event_dates (l_new_event_header_id NUMBER) IS
118: SELECT ACTIVE_FROM_DATE, ACTIVE_TO_DATE
119: FROM ams_event_headers_vl

Line 166: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

162: );
163: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
164: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
165: l_mesg_text := fnd_message.get;
166: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
167: l_event_header_id,
168: l_mesg_text,
169: 'GENERAL'
170: );

Line 219: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

215: p_errnum := 1;
216: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
217: ' , ' || '): ' || l_counter ||
218: ' OF ' || x_msg_count, 1, 4000);
219: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
220: l_event_header_id,
221: p_errmsg,
222: 'ERROR'
223: );

Line 232: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

228: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
229: AMS_Event_Objects_Copy_PVT.get_offer_name (
230: p_src_act_id
231: ), 1, 4000);
232: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
233: l_event_header_id,
234: p_errmsg,
235: 'ERROR'
236: );

Line 365: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

361: p_errnum := 1;
362: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
363: ' , ' || '): ' || l_counter ||
364: ' OF ' || x_msg_count, 1, 4000);
365: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
366: p_src_act_id,
367: p_errmsg,
368: 'ERROR'
369: );

Line 389: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

385: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
386: l_mesg_text := fnd_message.get;
387: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
388: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
389: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
390: p_src_act_id,
391: p_errmsg,
392: 'ERROR'
393: );

Line 523: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

519: );
520: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
521: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
522: l_mesg_text := fnd_message.get;
523: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
524: p_src_act_id,
525: l_mesg_text,
526: 'GENERAL'
527: );

Line 594: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

590: p_errnum := 1;
591: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
592: ' , ' || '): ' || l_counter ||
593: ' OF ' || x_msg_count, 1, 4000);
594: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
595: p_src_act_id,
596: p_errmsg,
597: 'ERROR'
598: );

Line 608: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

604: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
605: AMS_Event_Objects_Copy_PVT.get_agenda_name (
606: agenda_rec.parent_event_header_id
607: ), 1, 4000);
608: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
609: p_src_act_id,
610: p_errmsg,
611: 'ERROR'
612: );

Line 633: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

629: p_errmsg := SUBSTR ( l_mesg_text ||
630: AMS_Event_Objects_Copy_PVT.get_agenda_name (
631: agenda_rec.parent_event_header_id
632: ) || p_errmsg, 1, 4000);
633: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
634: p_src_act_id,
635: p_errmsg,
636: 'ERROR'
637: );

Line 653: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

649: l_mesg_text := fnd_message.get;
650: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
651: ',' || '): ' || p_errcode || SQLERRM,
652: 1, 4000);
653: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
654: p_src_act_id,
655: p_errmsg,
656: 'ERROR'
657: );

Line 672: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

668: x_msg_count OUT NOCOPY NUMBER,
669: x_msg_data OUT NOCOPY VARCHAR2,
670:
671: p_source_object_id IN NUMBER,
672: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
673: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
674:
675: x_new_object_id OUT NOCOPY NUMBER,
676: x_custom_setup_id OUT NOCOPY NUMBER

Line 673: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

669: x_msg_data OUT NOCOPY VARCHAR2,
670:
671: p_source_object_id IN NUMBER,
672: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
673: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
674:
675: x_new_object_id OUT NOCOPY NUMBER,
676: x_custom_setup_id OUT NOCOPY NUMBER
677: )

Line 796: AMS_CpyUtility_PVT.get_column_value('startDate', p_copy_columns_table, l_event_header_rec.active_from_date);

792: -- Mandatory fields for EVEH are EventName,EventHeaderId,Start Date and End Date
793: -- for ams_event_headers_all_b table :
794: -- ------------------------------
795:
796: AMS_CpyUtility_PVT.get_column_value('startDate', p_copy_columns_table, l_event_header_rec.active_from_date);
797: l_event_header_rec.active_from_date:= NVL(l_event_header_rec.active_from_date , l_reference_rec.active_from_date);
798: AMS_CpyUtility_PVT.get_column_value('endDate', p_copy_columns_table, l_event_header_rec.active_to_date);
799: l_event_header_rec.active_to_date:= NVL( l_event_header_rec.active_to_date, l_reference_rec.active_to_date);
800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);

Line 798: AMS_CpyUtility_PVT.get_column_value('endDate', p_copy_columns_table, l_event_header_rec.active_to_date);

794: -- ------------------------------
795:
796: AMS_CpyUtility_PVT.get_column_value('startDate', p_copy_columns_table, l_event_header_rec.active_from_date);
797: l_event_header_rec.active_from_date:= NVL(l_event_header_rec.active_from_date , l_reference_rec.active_from_date);
798: AMS_CpyUtility_PVT.get_column_value('endDate', p_copy_columns_table, l_event_header_rec.active_to_date);
799: l_event_header_rec.active_to_date:= NVL( l_event_header_rec.active_to_date, l_reference_rec.active_to_date);
800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);
801: l_event_header_rec.event_header_name:= NVL( l_event_header_rec.event_header_name, l_reference_rec.event_header_name);
802: AMS_CpyUtility_PVT.get_column_value('ownerId', p_copy_columns_table,l_event_header_rec.owner_user_id);

Line 800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);

796: AMS_CpyUtility_PVT.get_column_value('startDate', p_copy_columns_table, l_event_header_rec.active_from_date);
797: l_event_header_rec.active_from_date:= NVL(l_event_header_rec.active_from_date , l_reference_rec.active_from_date);
798: AMS_CpyUtility_PVT.get_column_value('endDate', p_copy_columns_table, l_event_header_rec.active_to_date);
799: l_event_header_rec.active_to_date:= NVL( l_event_header_rec.active_to_date, l_reference_rec.active_to_date);
800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);
801: l_event_header_rec.event_header_name:= NVL( l_event_header_rec.event_header_name, l_reference_rec.event_header_name);
802: AMS_CpyUtility_PVT.get_column_value('ownerId', p_copy_columns_table,l_event_header_rec.owner_user_id);
803: l_event_header_rec.owner_user_id:= NVL(l_event_header_rec.owner_user_id, l_reference_rec.owner_user_id);
804: AMS_CpyUtility_PVT.get_column_value('newSrcCode', p_copy_columns_table, l_event_header_rec.source_code);

Line 802: AMS_CpyUtility_PVT.get_column_value('ownerId', p_copy_columns_table,l_event_header_rec.owner_user_id);

798: AMS_CpyUtility_PVT.get_column_value('endDate', p_copy_columns_table, l_event_header_rec.active_to_date);
799: l_event_header_rec.active_to_date:= NVL( l_event_header_rec.active_to_date, l_reference_rec.active_to_date);
800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);
801: l_event_header_rec.event_header_name:= NVL( l_event_header_rec.event_header_name, l_reference_rec.event_header_name);
802: AMS_CpyUtility_PVT.get_column_value('ownerId', p_copy_columns_table,l_event_header_rec.owner_user_id);
803: l_event_header_rec.owner_user_id:= NVL(l_event_header_rec.owner_user_id, l_reference_rec.owner_user_id);
804: AMS_CpyUtility_PVT.get_column_value('newSrcCode', p_copy_columns_table, l_event_header_rec.source_code);
805: l_event_header_rec.source_code:= NVL(l_event_header_rec.source_code, NULL);
806: IF (AMS_DEBUG_HIGH_ON) THEN

Line 804: AMS_CpyUtility_PVT.get_column_value('newSrcCode', p_copy_columns_table, l_event_header_rec.source_code);

800: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_event_header_rec.event_header_name);
801: l_event_header_rec.event_header_name:= NVL( l_event_header_rec.event_header_name, l_reference_rec.event_header_name);
802: AMS_CpyUtility_PVT.get_column_value('ownerId', p_copy_columns_table,l_event_header_rec.owner_user_id);
803: l_event_header_rec.owner_user_id:= NVL(l_event_header_rec.owner_user_id, l_reference_rec.owner_user_id);
804: AMS_CpyUtility_PVT.get_column_value('newSrcCode', p_copy_columns_table, l_event_header_rec.source_code);
805: l_event_header_rec.source_code:= NVL(l_event_header_rec.source_code, NULL);
806: IF (AMS_DEBUG_HIGH_ON) THEN
807:
808: AMS_UTILITY_PVT.debug_message('the l_event_header_rec.source_code: '||l_event_header_rec.source_code);

Line 810: AMS_CpyUtility_PVT.get_column_value('countryId', p_copy_columns_table, l_event_header_rec.country_code);

806: IF (AMS_DEBUG_HIGH_ON) THEN
807:
808: AMS_UTILITY_PVT.debug_message('the l_event_header_rec.source_code: '||l_event_header_rec.source_code);
809: END IF;
810: AMS_CpyUtility_PVT.get_column_value('countryId', p_copy_columns_table, l_event_header_rec.country_code);
811: l_event_header_rec.country_code:= NVL( l_event_header_rec.country_code, l_reference_rec.country_code);
812: AMS_CpyUtility_PVT.get_column_value('programId', p_copy_columns_table, l_event_header_rec.program_id);
813: -- batoleti commneted the below stmt. Refer bug# 5388748 for more details on this.
814: --l_event_header_rec.program_id:= NVL(l_event_header_rec.program_id, l_reference_rec.program_id);

Line 812: AMS_CpyUtility_PVT.get_column_value('programId', p_copy_columns_table, l_event_header_rec.program_id);

808: AMS_UTILITY_PVT.debug_message('the l_event_header_rec.source_code: '||l_event_header_rec.source_code);
809: END IF;
810: AMS_CpyUtility_PVT.get_column_value('countryId', p_copy_columns_table, l_event_header_rec.country_code);
811: l_event_header_rec.country_code:= NVL( l_event_header_rec.country_code, l_reference_rec.country_code);
812: AMS_CpyUtility_PVT.get_column_value('programId', p_copy_columns_table, l_event_header_rec.program_id);
813: -- batoleti commneted the below stmt. Refer bug# 5388748 for more details on this.
814: --l_event_header_rec.program_id:= NVL(l_event_header_rec.program_id, l_reference_rec.program_id);
815: --
816: -- mandatory fields for eveh create are

Line 820: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_event_header_rec.main_language_code );

816: -- mandatory fields for eveh create are
817: -- name, lang, coordinator, currency, startDate,endDate
818: --
819:
820: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_event_header_rec.main_language_code );
821: l_event_header_rec.main_language_code := NVL (l_event_header_rec.main_language_code, l_reference_rec.main_language_code );
822:
823: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_event_header_rec.currency_code_tc);
824: l_event_header_rec.currency_code_tc:= NVL (l_event_header_rec.currency_code_tc, l_reference_rec.currency_code_tc);

Line 823: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_event_header_rec.currency_code_tc);

819:
820: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_event_header_rec.main_language_code );
821: l_event_header_rec.main_language_code := NVL (l_event_header_rec.main_language_code, l_reference_rec.main_language_code );
822:
823: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_event_header_rec.currency_code_tc);
824: l_event_header_rec.currency_code_tc:= NVL (l_event_header_rec.currency_code_tc, l_reference_rec.currency_code_tc);
825:
826: -- Fields not to be copied
827:

Line 891: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN

887: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_header_id||'\n');
888: END IF;
889:
890: END IF;
891: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN
892: copy_event_header_agenda (
893: p_src_act_type => G_OBJECT_TYPE_MODEL,
894: p_new_act_type => G_OBJECT_TYPE_MODEL,
895: p_src_act_id => l_event_header_id,

Line 908: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN

904: END IF;
905:
906: -- copy resources
907: /* Commented by mukemar on may14 2002 we are not supporting the resource copy
908: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN
909: AMS_CopyElements_PVT.copy_act_resources (
910: p_src_act_type => G_OBJECT_TYPE_MODEL,
911: p_new_act_type => G_OBJECT_TYPE_MODEL,
912: p_src_act_id => l_event_header_id,

Line 923: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: */
923: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
924: AMS_CopyElements_PVT.copy_act_prod (
925: p_src_act_type => G_OBJECT_TYPE_MODEL,
926: p_new_act_type => G_OBJECT_TYPE_MODEL,
927: p_src_act_id => l_event_header_id,

Line 937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN

933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: END IF;
937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN
938: AMS_CopyElements_PVT.copy_act_geo_areas (
939: p_src_act_type => G_OBJECT_TYPE_MODEL,
940: p_new_act_type => G_OBJECT_TYPE_MODEL,
941: p_src_act_id => l_event_header_id,

Line 951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN

947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN
952: AMS_CopyElements_PVT.copy_act_market_segments (
953: p_src_act_type => G_OBJECT_TYPE_MODEL,
954: p_new_act_type => G_OBJECT_TYPE_MODEL,
955: p_src_act_id => l_event_header_id,

Line 967: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN

963: END IF;
964: END IF;
965:
966: -- copy categories
967: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN
968: AMS_CopyElements_PVT.copy_act_categories (
969: p_src_act_type => G_OBJECT_TYPE_MODEL,
970: p_new_act_type => G_OBJECT_TYPE_MODEL,
971: p_src_act_id => l_event_header_id,

Line 981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN

977: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: END IF;
981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN
982: AMS_CopyElements_PVT.copy_act_attachments (
983: p_src_act_type => G_OBJECT_TYPE_MODEL,
984: p_new_act_type => G_OBJECT_TYPE_MODEL,
985: p_src_act_id => l_event_header_id,

Line 996: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994: END IF;
995:
996: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN
997: AMS_CopyElements_PVT.copy_act_messages(
998: p_src_act_type => G_OBJECT_TYPE_MODEL,
999: p_new_act_type => G_OBJECT_TYPE_MODEL,
1000: p_src_act_id => l_event_header_id,

Line 1011: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN

1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF;
1010:
1011: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN
1012: --Added for the bug fix : 5213670
1013: g_commit:='F';
1014: copy_act_delivery_method(
1015: p_src_act_type => G_OBJECT_TYPE_MODEL,

Line 1030: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_EVEO, p_attributes_table) = FND_API.G_TRUE THEN

1026: END IF;
1027: END IF;
1028:
1029:
1030: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_EVEO, p_attributes_table) = FND_API.G_TRUE THEN
1031:
1032: -- Get the Schedule Ids as comma separated variables.
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034:

Line 1038: AMS_CpyUtility_PVT.get_column_value ('eventScheduleIdRec', p_copy_columns_table, x_event_schedule_ids);

1034:
1035: AMS_UTILITY_PVT.debug_message('Getting scheduleid values');
1036: END IF;
1037:
1038: AMS_CpyUtility_PVT.get_column_value ('eventScheduleIdRec', p_copy_columns_table, x_event_schedule_ids);
1039: l_event_schedule_ids := NVL (x_event_schedule_ids, '');
1040:
1041: FOR i IN 1..p_copy_columns_table.COUNT LOOP
1042: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_name); END IF;