751: ,p_TEMPLATE_FLAG => l_template_flag
752: ,p_CP_SERVICE_ID => NULL
753: ,p_CUSTOMER_PRODUCT_ID => NULL
754: ,p_LAST_UPDATE_DATE => sysdate
755: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
756: ,p_CREATION_DATE => sysdate
757: ,p_CREATED_BY => FND_GLOBAL.USER_ID
758: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
759: ,p_START_DATE_ACTIVE => l_start_date_active
753: ,p_CUSTOMER_PRODUCT_ID => NULL
754: ,p_LAST_UPDATE_DATE => sysdate
755: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
756: ,p_CREATION_DATE => sysdate
757: ,p_CREATED_BY => FND_GLOBAL.USER_ID
758: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
759: ,p_START_DATE_ACTIVE => l_start_date_active
760: ,p_END_DATE_ACTIVE => l_end_date_active
761: ,p_ATTRIBUTE1 => l_attribute1
754: ,p_LAST_UPDATE_DATE => sysdate
755: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
756: ,p_CREATION_DATE => sysdate
757: ,p_CREATED_BY => FND_GLOBAL.USER_ID
758: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
759: ,p_START_DATE_ACTIVE => l_start_date_active
760: ,p_END_DATE_ACTIVE => l_end_date_active
761: ,p_ATTRIBUTE1 => l_attribute1
762: ,p_ATTRIBUTE2 => l_attribute2
1249: ,p_GROUP_ID => l_group_id
1250: ,p_INVENTORY_ITEM_ID => l_inventory_item_id
1251: ,p_OBJECT_VERSION_NUMBER => 1
1252: ,p_LAST_UPDATE_DATE => sysdate
1253: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1254: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1255: ,p_CREATION_DATE => sysdate
1256: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1257: ,p_ATTRIBUTE1 => l_attribute1
1250: ,p_INVENTORY_ITEM_ID => l_inventory_item_id
1251: ,p_OBJECT_VERSION_NUMBER => 1
1252: ,p_LAST_UPDATE_DATE => sysdate
1253: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1254: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1255: ,p_CREATION_DATE => sysdate
1256: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1257: ,p_ATTRIBUTE1 => l_attribute1
1258: ,p_ATTRIBUTE2 => l_attribute2
1252: ,p_LAST_UPDATE_DATE => sysdate
1253: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1254: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1255: ,p_CREATION_DATE => sysdate
1256: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1257: ,p_ATTRIBUTE1 => l_attribute1
1258: ,p_ATTRIBUTE2 => l_attribute2
1259: ,p_ATTRIBUTE3 => l_attribute3
1260: ,p_ATTRIBUTE4 => l_attribute4
1956: ,p_END_DATE_ACTIVE => l_end_date_active
1957: ,p_OBJECT_VERSION_NUMBER => 1
1958: ,p_SECURITY_GROUP_ID => l_security_group_id
1959: ,p_LAST_UPDATE_DATE => sysdate
1960: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1961: ,p_CREATION_DATE => sysdate
1962: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1963: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1964: ,p_ATTRIBUTE1 => l_attribute1
1958: ,p_SECURITY_GROUP_ID => l_security_group_id
1959: ,p_LAST_UPDATE_DATE => sysdate
1960: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1961: ,p_CREATION_DATE => sysdate
1962: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1963: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1964: ,p_ATTRIBUTE1 => l_attribute1
1965: ,p_ATTRIBUTE2 => l_attribute2
1966: ,p_ATTRIBUTE3 => l_attribute3
1959: ,p_LAST_UPDATE_DATE => sysdate
1960: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1961: ,p_CREATION_DATE => sysdate
1962: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1963: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1964: ,p_ATTRIBUTE1 => l_attribute1
1965: ,p_ATTRIBUTE2 => l_attribute2
1966: ,p_ATTRIBUTE3 => l_attribute3
1967: ,p_ATTRIBUTE4 => l_attribute4
2371: ,p_START_DATE_ACTIVE => l_start_date_active
2372: ,p_END_DATE_ACTIVE => l_end_date_active
2373: ,p_OBJECT_VERSION_NUMBER => 1
2374: ,p_LAST_UPDATE_DATE => sysdate
2375: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2376: ,p_CREATION_DATE => sysdate
2377: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2378: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2379: ,p_ATTRIBUTE1 => l_attribute1
2373: ,p_OBJECT_VERSION_NUMBER => 1
2374: ,p_LAST_UPDATE_DATE => sysdate
2375: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2376: ,p_CREATION_DATE => sysdate
2377: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2378: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2379: ,p_ATTRIBUTE1 => l_attribute1
2380: ,p_ATTRIBUTE2 => l_attribute2
2381: ,p_ATTRIBUTE3 => l_attribute3
2374: ,p_LAST_UPDATE_DATE => sysdate
2375: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2376: ,p_CREATION_DATE => sysdate
2377: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2378: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2379: ,p_ATTRIBUTE1 => l_attribute1
2380: ,p_ATTRIBUTE2 => l_attribute2
2381: ,p_ATTRIBUTE3 => l_attribute3
2382: ,p_ATTRIBUTE4 => l_attribute4
2803: ,p_ACTIVE_START_DATE => l_active_start_date
2804: ,p_ACTIVE_END_DATE => l_active_end_date
2805: ,p_OBJECT_VERSION_NUMBER => 1
2806: ,p_LAST_UPDATE_DATE => sysdate
2807: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2808: ,p_CREATION_DATE => sysdate
2809: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2810: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2811: ,p_ATTRIBUTE_CATEGORY => l_attribute_category
2805: ,p_OBJECT_VERSION_NUMBER => 1
2806: ,p_LAST_UPDATE_DATE => sysdate
2807: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2808: ,p_CREATION_DATE => sysdate
2809: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2810: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2811: ,p_ATTRIBUTE_CATEGORY => l_attribute_category
2812: ,p_ATTRIBUTE1 => l_attribute1
2813: ,p_ATTRIBUTE2 => l_attribute2
2806: ,p_LAST_UPDATE_DATE => sysdate
2807: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2808: ,p_CREATION_DATE => sysdate
2809: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2810: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
2811: ,p_ATTRIBUTE_CATEGORY => l_attribute_category
2812: ,p_ATTRIBUTE1 => l_attribute1
2813: ,p_ATTRIBUTE2 => l_attribute2
2814: ,p_ATTRIBUTE3 => l_attribute3
3084: ,l_ctr_derived_filters_rec.START_DATE_ACTIVE
3085: ,l_ctr_derived_filters_rec.END_DATE_ACTIVE
3086: ,1
3087: ,sysdate
3088: ,FND_GLOBAL.USER_ID
3089: ,sysdate
3090: ,FND_GLOBAL.USER_ID
3091: ,FND_GLOBAL.USER_ID
3092: ,l_ctr_derived_filters_rec.ATTRIBUTE1
3086: ,1
3087: ,sysdate
3088: ,FND_GLOBAL.USER_ID
3089: ,sysdate
3090: ,FND_GLOBAL.USER_ID
3091: ,FND_GLOBAL.USER_ID
3092: ,l_ctr_derived_filters_rec.ATTRIBUTE1
3093: ,l_ctr_derived_filters_rec.ATTRIBUTE2
3094: ,l_ctr_derived_filters_rec.ATTRIBUTE3
3087: ,sysdate
3088: ,FND_GLOBAL.USER_ID
3089: ,sysdate
3090: ,FND_GLOBAL.USER_ID
3091: ,FND_GLOBAL.USER_ID
3092: ,l_ctr_derived_filters_rec.ATTRIBUTE1
3093: ,l_ctr_derived_filters_rec.ATTRIBUTE2
3094: ,l_ctr_derived_filters_rec.ATTRIBUTE3
3095: ,l_ctr_derived_filters_rec.ATTRIBUTE4
3468: ,p_TEMPLATE_FLAG => p_counter_groups_rec.template_flag
3469: ,p_CP_SERVICE_ID => NULL
3470: ,p_CUSTOMER_PRODUCT_ID => NULL
3471: ,p_LAST_UPDATE_DATE => sysdate
3472: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
3473: ,p_CREATION_DATE => p_counter_groups_rec.creation_date
3474: ,p_CREATED_BY => p_counter_groups_rec.created_by
3475: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
3476: ,p_START_DATE_ACTIVE => p_counter_groups_rec.start_date_active
3471: ,p_LAST_UPDATE_DATE => sysdate
3472: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
3473: ,p_CREATION_DATE => p_counter_groups_rec.creation_date
3474: ,p_CREATED_BY => p_counter_groups_rec.created_by
3475: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
3476: ,p_START_DATE_ACTIVE => p_counter_groups_rec.start_date_active
3477: ,p_END_DATE_ACTIVE => p_counter_groups_rec.end_date_active
3478: ,p_ATTRIBUTE1 => p_counter_groups_rec.attribute1
3479: ,p_ATTRIBUTE2 => p_counter_groups_rec.attribute2
3935: ,p_GROUP_ID => p_ctr_item_associations_rec.group_id
3936: ,p_INVENTORY_ITEM_ID => p_ctr_item_associations_rec.inventory_item_id
3937: ,p_OBJECT_VERSION_NUMBER => p_ctr_item_associations_rec.object_version_number + 1
3938: ,p_LAST_UPDATE_DATE => sysdate
3939: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
3940: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
3941: ,p_CREATION_DATE => p_ctr_item_associations_rec.creation_date
3942: ,p_CREATED_BY => p_ctr_item_associations_rec.created_by
3943: ,p_ATTRIBUTE1 => p_ctr_item_associations_rec.attribute1
3936: ,p_INVENTORY_ITEM_ID => p_ctr_item_associations_rec.inventory_item_id
3937: ,p_OBJECT_VERSION_NUMBER => p_ctr_item_associations_rec.object_version_number + 1
3938: ,p_LAST_UPDATE_DATE => sysdate
3939: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
3940: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
3941: ,p_CREATION_DATE => p_ctr_item_associations_rec.creation_date
3942: ,p_CREATED_BY => p_ctr_item_associations_rec.created_by
3943: ,p_ATTRIBUTE1 => p_ctr_item_associations_rec.attribute1
3944: ,p_ATTRIBUTE2 => p_ctr_item_associations_rec.attribute2
4729: ,p_start_date_active => p_counter_template_rec.start_date_active
4730: ,p_end_date_active => p_counter_template_rec.end_date_active
4731: ,p_object_version_number => p_counter_template_rec.object_version_number
4732: ,p_last_update_date => sysdate
4733: ,p_last_updated_by => FND_GLOBAL.USER_ID
4734: ,p_creation_date => p_counter_template_rec.creation_date
4735: ,p_created_by => p_counter_template_rec.created_by
4736: ,p_last_update_login => FND_GLOBAL.USER_ID
4737: ,p_attribute1 => p_counter_template_rec.attribute1
4732: ,p_last_update_date => sysdate
4733: ,p_last_updated_by => FND_GLOBAL.USER_ID
4734: ,p_creation_date => p_counter_template_rec.creation_date
4735: ,p_created_by => p_counter_template_rec.created_by
4736: ,p_last_update_login => FND_GLOBAL.USER_ID
4737: ,p_attribute1 => p_counter_template_rec.attribute1
4738: ,p_attribute2 => p_counter_template_rec.attribute2
4739: ,p_attribute3 => p_counter_template_rec.attribute3
4740: ,p_attribute4 => p_counter_template_rec.attribute4
5168: ,p_START_DATE_ACTIVE => p_ctr_property_template_rec.start_date_active
5169: ,p_END_DATE_ACTIVE => p_ctr_property_template_rec.end_date_active
5170: ,p_OBJECT_VERSION_NUMBER => p_ctr_property_template_rec.object_version_number + 1
5171: ,p_LAST_UPDATE_DATE => sysdate
5172: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
5173: ,p_CREATION_DATE => p_ctr_property_template_rec.creation_date
5174: ,p_CREATED_BY => p_ctr_property_template_rec.created_by
5175: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
5176: ,p_ATTRIBUTE1 => p_ctr_property_template_rec.attribute1
5171: ,p_LAST_UPDATE_DATE => sysdate
5172: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
5173: ,p_CREATION_DATE => p_ctr_property_template_rec.creation_date
5174: ,p_CREATED_BY => p_ctr_property_template_rec.created_by
5175: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
5176: ,p_ATTRIBUTE1 => p_ctr_property_template_rec.attribute1
5177: ,p_ATTRIBUTE2 => p_ctr_property_template_rec.attribute2
5178: ,p_ATTRIBUTE3 => p_ctr_property_template_rec.attribute3
5179: ,p_ATTRIBUTE4 => p_ctr_property_template_rec.attribute4
5622: ,p_ACTIVE_START_DATE => p_counter_relationships_rec.active_start_date
5623: ,p_ACTIVE_END_DATE => p_counter_relationships_rec.active_end_date
5624: ,p_OBJECT_VERSION_NUMBER => p_counter_relationships_rec.object_version_number + 1
5625: ,p_LAST_UPDATE_DATE => sysdate
5626: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
5627: ,p_CREATION_DATE => p_counter_relationships_rec.creation_date
5628: ,p_CREATED_BY => p_counter_relationships_rec.created_by
5629: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
5630: ,p_ATTRIBUTE_CATEGORY => p_counter_relationships_rec.attribute_category
5625: ,p_LAST_UPDATE_DATE => sysdate
5626: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
5627: ,p_CREATION_DATE => p_counter_relationships_rec.creation_date
5628: ,p_CREATED_BY => p_counter_relationships_rec.created_by
5629: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
5630: ,p_ATTRIBUTE_CATEGORY => p_counter_relationships_rec.attribute_category
5631: ,p_ATTRIBUTE1 => p_counter_relationships_rec.attribute1
5632: ,p_ATTRIBUTE2 => p_counter_relationships_rec.attribute2
5633: ,p_ATTRIBUTE3 => p_counter_relationships_rec.attribute3
5979: ,p_ctr_derived_filters_tbl(tab_row).START_DATE_ACTIVE
5980: ,p_ctr_derived_filters_tbl(tab_row).END_DATE_ACTIVE
5981: ,p_ctr_derived_filters_tbl(tab_row).OBJECT_VERSION_NUMBER +1
5982: ,sysdate
5983: ,FND_GLOBAL.USER_ID
5984: ,p_ctr_derived_filters_tbl(tab_row).CREATION_DATE
5985: ,p_ctr_derived_filters_tbl(tab_row).CREATED_BY
5986: ,FND_GLOBAL.USER_ID
5987: ,p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE1
5982: ,sysdate
5983: ,FND_GLOBAL.USER_ID
5984: ,p_ctr_derived_filters_tbl(tab_row).CREATION_DATE
5985: ,p_ctr_derived_filters_tbl(tab_row).CREATED_BY
5986: ,FND_GLOBAL.USER_ID
5987: ,p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE1
5988: ,p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE2
5989: ,p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE3
5990: ,p_ctr_derived_filters_tbl(tab_row).ATTRIBUTE4
6378: ,p_ESTIMATION_AVG_TYPE => l_estimation_avg_type
6379: ,p_START_DATE_ACTIVE => l_start_date_active
6380: ,p_END_DATE_ACTIVE => l_end_date_active
6381: ,p_LAST_UPDATE_DATE => sysdate
6382: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6383: ,p_CREATION_DATE => sysdate
6384: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
6386: ,p_ATTRIBUTE1 => l_attribute1
6380: ,p_END_DATE_ACTIVE => l_end_date_active
6381: ,p_LAST_UPDATE_DATE => sysdate
6382: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6383: ,p_CREATION_DATE => sysdate
6384: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
6386: ,p_ATTRIBUTE1 => l_attribute1
6387: ,p_ATTRIBUTE2 => l_attribute2
6388: ,p_ATTRIBUTE3 => l_attribute3
6381: ,p_LAST_UPDATE_DATE => sysdate
6382: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6383: ,p_CREATION_DATE => sysdate
6384: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
6386: ,p_ATTRIBUTE1 => l_attribute1
6387: ,p_ATTRIBUTE2 => l_attribute2
6388: ,p_ATTRIBUTE3 => l_attribute3
6389: ,p_ATTRIBUTE4 => l_attribute4
6738: ,p_ESTIMATION_AVG_TYPE => p_ctr_estimation_rec.estimation_avg_type
6739: ,p_START_DATE_ACTIVE => p_ctr_estimation_rec.start_date_active
6740: ,p_END_DATE_ACTIVE => p_ctr_estimation_rec.end_date_active
6741: ,p_LAST_UPDATE_DATE => sysdate
6742: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6743: ,p_CREATION_DATE => p_ctr_estimation_rec.creation_date
6744: ,p_CREATED_BY => p_ctr_estimation_rec.created_by
6745: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
6746: ,p_ATTRIBUTE1 => p_ctr_estimation_rec.attribute1
6741: ,p_LAST_UPDATE_DATE => sysdate
6742: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6743: ,p_CREATION_DATE => p_ctr_estimation_rec.creation_date
6744: ,p_CREATED_BY => p_ctr_estimation_rec.created_by
6745: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
6746: ,p_ATTRIBUTE1 => p_ctr_estimation_rec.attribute1
6747: ,p_ATTRIBUTE2 => p_ctr_estimation_rec.attribute2
6748: ,p_ATTRIBUTE3 => p_ctr_estimation_rec.attribute3
6749: ,p_ATTRIBUTE4 => p_ctr_estimation_rec.attribute4
7212: l_counter_instance_rec.end_date_active := ctr_cur_rec.end_date_active;
7213: l_counter_instance_rec.security_group_id := ctr_cur_rec.security_group_id;
7214: l_counter_instance_rec.object_version_number := 1;
7215: l_counter_instance_rec.last_update_date := sysdate;
7216: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
7217: l_counter_instance_rec.creation_date := sysdate;
7218: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
7219: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
7220: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
7214: l_counter_instance_rec.object_version_number := 1;
7215: l_counter_instance_rec.last_update_date := sysdate;
7216: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
7217: l_counter_instance_rec.creation_date := sysdate;
7218: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
7219: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
7220: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
7221: l_counter_instance_rec.attribute1 := ctr_cur_rec.attribute1;
7222: l_counter_instance_rec.attribute2 := ctr_cur_rec.attribute2;
7215: l_counter_instance_rec.last_update_date := sysdate;
7216: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
7217: l_counter_instance_rec.creation_date := sysdate;
7218: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
7219: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
7220: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
7221: l_counter_instance_rec.attribute1 := ctr_cur_rec.attribute1;
7222: l_counter_instance_rec.attribute2 := ctr_cur_rec.attribute2;
7223: l_counter_instance_rec.attribute3 := ctr_cur_rec.attribute3;
7446: l_ctr_properties_rec.end_date_active := ctr_prop_cur_rec.end_date_active;
7447: l_ctr_properties_rec.security_group_id := ctr_prop_cur_rec.security_group_id;
7448: l_ctr_properties_rec.object_version_number := 1;
7449: l_ctr_properties_rec.last_update_date := sysdate;
7450: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
7451: l_ctr_properties_rec.creation_date := sysdate;
7452: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
7453: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
7454: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
7448: l_ctr_properties_rec.object_version_number := 1;
7449: l_ctr_properties_rec.last_update_date := sysdate;
7450: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
7451: l_ctr_properties_rec.creation_date := sysdate;
7452: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
7453: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
7454: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
7455: l_ctr_properties_rec.attribute1 := ctr_prop_cur_rec.attribute1;
7456: l_ctr_properties_rec.attribute2 := ctr_prop_cur_rec.attribute2;
7449: l_ctr_properties_rec.last_update_date := sysdate;
7450: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
7451: l_ctr_properties_rec.creation_date := sysdate;
7452: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
7453: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
7454: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
7455: l_ctr_properties_rec.attribute1 := ctr_prop_cur_rec.attribute1;
7456: l_ctr_properties_rec.attribute2 := ctr_prop_cur_rec.attribute2;
7457: l_ctr_properties_rec.attribute3 := ctr_prop_cur_rec.attribute3;
7547: l_ctr_derived_filters_tbl.start_date_active := ctr_der_filter_cur_rec.start_date_active;
7548: l_ctr_derived_filters_tbl.end_date_active := ctr_der_filter_cur_rec.end_date_active;
7549: l_ctr_derived_filters_tbl.object_version_number := 1;
7550: l_ctr_derived_filters_tbl.last_update_date := sysdate;
7551: l_ctr_derived_filters_tbl.last_Updated_by := fnd_global.user_id;
7552: l_ctr_derived_filters_tbl.creation_date := sysdate;
7553: l_ctr_derived_filters_tbl.created_by := FND_GLOBAL.user_id;
7554: l_ctr_derived_filters_tbl.last_update_login := FND_GLOBAL.user_id;
7555: */
7549: l_ctr_derived_filters_tbl.object_version_number := 1;
7550: l_ctr_derived_filters_tbl.last_update_date := sysdate;
7551: l_ctr_derived_filters_tbl.last_Updated_by := fnd_global.user_id;
7552: l_ctr_derived_filters_tbl.creation_date := sysdate;
7553: l_ctr_derived_filters_tbl.created_by := FND_GLOBAL.user_id;
7554: l_ctr_derived_filters_tbl.last_update_login := FND_GLOBAL.user_id;
7555: */
7556: CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS
7557: (
7550: l_ctr_derived_filters_tbl.last_update_date := sysdate;
7551: l_ctr_derived_filters_tbl.last_Updated_by := fnd_global.user_id;
7552: l_ctr_derived_filters_tbl.creation_date := sysdate;
7553: l_ctr_derived_filters_tbl.created_by := FND_GLOBAL.user_id;
7554: l_ctr_derived_filters_tbl.last_update_login := FND_GLOBAL.user_id;
7555: */
7556: CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS
7557: (
7558: p_api_version => p_api_version
7687: l_counter_relationships_rec.attribute_category := ctr_formula_bvars_cur_rec.attribute_category;
7688: l_counter_relationships_rec.security_group_id := ctr_formula_bvars_cur_rec.security_group_id;
7689: l_counter_relationships_rec.object_version_number := 1;
7690: l_counter_relationships_rec.last_update_date := sysdate;
7691: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
7692: l_counter_relationships_rec.creation_date := sysdate;
7693: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
7694: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
7695: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
7689: l_counter_relationships_rec.object_version_number := 1;
7690: l_counter_relationships_rec.last_update_date := sysdate;
7691: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
7692: l_counter_relationships_rec.creation_date := sysdate;
7693: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
7694: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
7695: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
7696: l_counter_relationships_rec.relationship_type_code := ctr_formula_bvars_cur_rec.relationship_type_code;
7697: -- l_counter_relationships_rec.source_counter_id := ctr_formula_bvars_cur_rec.source_counter_id;
7690: l_counter_relationships_rec.last_update_date := sysdate;
7691: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
7692: l_counter_relationships_rec.creation_date := sysdate;
7693: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
7694: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
7695: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
7696: l_counter_relationships_rec.relationship_type_code := ctr_formula_bvars_cur_rec.relationship_type_code;
7697: -- l_counter_relationships_rec.source_counter_id := ctr_formula_bvars_cur_rec.source_counter_id;
7698: --l_counter_relationships_rec.object_counter_id := ctr_formula_bvars_cur_rec.object_counter_id;
8232: l_counter_instance_rec.end_date_active := ctr_cur_rec.end_date_active;
8233: l_counter_instance_rec.security_group_id := ctr_cur_rec.security_group_id;
8234: l_counter_instance_rec.object_version_number := 1;
8235: l_counter_instance_rec.last_update_date := sysdate;
8236: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
8237: l_counter_instance_rec.creation_date := sysdate;
8238: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
8239: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
8240: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
8234: l_counter_instance_rec.object_version_number := 1;
8235: l_counter_instance_rec.last_update_date := sysdate;
8236: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
8237: l_counter_instance_rec.creation_date := sysdate;
8238: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
8239: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
8240: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
8241: l_counter_instance_rec.attribute1 := ctr_cur_rec.attribute1;
8242: l_counter_instance_rec.attribute2 := ctr_cur_rec.attribute2;
8235: l_counter_instance_rec.last_update_date := sysdate;
8236: l_counter_instance_rec.last_Updated_by := fnd_global.user_id;
8237: l_counter_instance_rec.creation_date := sysdate;
8238: l_counter_instance_rec.created_by := FND_GLOBAL.user_id;
8239: l_counter_instance_rec.last_update_login := FND_GLOBAL.user_id;
8240: l_counter_instance_rec.attribute_category := ctr_cur_rec.attribute_category;
8241: l_counter_instance_rec.attribute1 := ctr_cur_rec.attribute1;
8242: l_counter_instance_rec.attribute2 := ctr_cur_rec.attribute2;
8243: l_counter_instance_rec.attribute3 := ctr_cur_rec.attribute3;
8369: l_ctr_properties_rec.end_date_active := ctr_prop_cur_rec.end_date_active;
8370: l_ctr_properties_rec.security_group_id := ctr_prop_cur_rec.security_group_id;
8371: l_ctr_properties_rec.object_version_number := 1;
8372: l_ctr_properties_rec.last_update_date := sysdate;
8373: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
8374: l_ctr_properties_rec.creation_date := sysdate;
8375: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
8376: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
8377: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
8371: l_ctr_properties_rec.object_version_number := 1;
8372: l_ctr_properties_rec.last_update_date := sysdate;
8373: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
8374: l_ctr_properties_rec.creation_date := sysdate;
8375: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
8376: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
8377: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
8378: l_ctr_properties_rec.attribute1 := ctr_prop_cur_rec.attribute1;
8379: l_ctr_properties_rec.attribute2 := ctr_prop_cur_rec.attribute2;
8372: l_ctr_properties_rec.last_update_date := sysdate;
8373: l_ctr_properties_rec.last_Updated_by := fnd_global.user_id;
8374: l_ctr_properties_rec.creation_date := sysdate;
8375: l_ctr_properties_rec.created_by := FND_GLOBAL.user_id;
8376: l_ctr_properties_rec.last_update_login := FND_GLOBAL.user_id;
8377: l_ctr_properties_rec.attribute_category := ctr_prop_cur_rec.attribute_category;
8378: l_ctr_properties_rec.attribute1 := ctr_prop_cur_rec.attribute1;
8379: l_ctr_properties_rec.attribute2 := ctr_prop_cur_rec.attribute2;
8380: l_ctr_properties_rec.attribute3 := ctr_prop_cur_rec.attribute3;
8590: l_counter_relationships_rec.attribute_category := ctr_formula_bvars_cur_rec.attribute_category;
8591: l_counter_relationships_rec.security_group_id := ctr_formula_bvars_cur_rec.security_group_id;
8592: l_counter_relationships_rec.object_version_number := 1;
8593: l_counter_relationships_rec.last_update_date := sysdate;
8594: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
8595: l_counter_relationships_rec.creation_date := sysdate;
8596: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
8597: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
8598: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
8592: l_counter_relationships_rec.object_version_number := 1;
8593: l_counter_relationships_rec.last_update_date := sysdate;
8594: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
8595: l_counter_relationships_rec.creation_date := sysdate;
8596: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
8597: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
8598: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
8599: l_counter_relationships_rec.relationship_type_code := ctr_formula_bvars_cur_rec.relationship_type_code;
8600: -- l_counter_relationships_rec.source_counter_id := ctr_formula_bvars_cur_rec.source_counter_id;
8593: l_counter_relationships_rec.last_update_date := sysdate;
8594: l_counter_relationships_rec.last_Updated_by := fnd_global.user_id;
8595: l_counter_relationships_rec.creation_date := sysdate;
8596: l_counter_relationships_rec.created_by := FND_GLOBAL.user_id;
8597: l_counter_relationships_rec.last_update_login := FND_GLOBAL.user_id;
8598: l_counter_relationships_rec.ctr_association_id := ctr_formula_bvars_cur_rec.ctr_association_id;
8599: l_counter_relationships_rec.relationship_type_code := ctr_formula_bvars_cur_rec.relationship_type_code;
8600: -- l_counter_relationships_rec.source_counter_id := ctr_formula_bvars_cur_rec.source_counter_id;
8601: -- l_counter_relationships_rec.object_counter_id := ctr_formula_bvars_cur_rec.object_counter_id;