865: l_bkm_category VARCHAR2(30);
866: l_bkm_preference_code VARCHAR2(30);
867: l_count NUMBER;
868: BEGIN
869: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
870: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
871: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
872:
873: SAVEPOINT prepare_fastsync_sp;
866: l_bkm_preference_code VARCHAR2(30);
867: l_count NUMBER;
868: BEGIN
869: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
870: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
871: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
872:
873: SAVEPOINT prepare_fastsync_sp;
874:
867: l_count NUMBER;
868: BEGIN
869: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
870: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
871: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
872:
873: SAVEPOINT prepare_fastsync_sp;
874:
875: cac_sync_contact_util_pvt.log(p_message=>'Entering PREPARE_FASTSYNC...',
1152: l_bkm_category VARCHAR2(30);
1153: l_bkm_preference_code VARCHAR2(30);
1154: l_count NUMBER;
1155: BEGIN
1156: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
1157: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
1158: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
1159:
1160: SAVEPOINT prepare_slowsync_sp;
1153: l_bkm_preference_code VARCHAR2(30);
1154: l_count NUMBER;
1155: BEGIN
1156: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
1157: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
1158: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
1159:
1160: SAVEPOINT prepare_slowsync_sp;
1161:
1154: l_count NUMBER;
1155: BEGIN
1156: l_bkm_module := fnd_profile.value('CAC_SYNC_CONT_BKM_MODULE');
1157: l_bkm_category := fnd_profile.value('CAC_SYNC_CONT_BKM_CATEGORY');
1158: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
1159:
1160: SAVEPOINT prepare_slowsync_sp;
1161:
1162: cac_sync_contact_util_pvt.log(p_message => 'Entering PREPARE_SLOWSYNC...: ',