424: p_operation,
425: p_staged_flag,
426: p_realtime_sync_flag,
427: p_error_data,
428: hz_utility_pub.created_by,
429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
425: p_staged_flag,
426: p_realtime_sync_flag,
427: p_error_data,
428: hz_utility_pub.created_by,
429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
433: HZ_DQM_SYNC_INTERFACE_S.nextval
426: p_realtime_sync_flag,
427: p_error_data,
428: hz_utility_pub.created_by,
429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
433: HZ_DQM_SYNC_INTERFACE_S.nextval
434: );
427: p_error_data,
428: hz_utility_pub.created_by,
429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
433: HZ_DQM_SYNC_INTERFACE_S.nextval
434: );
435: END insert_dqm_sync_error_rec;
428: hz_utility_pub.created_by,
429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
433: HZ_DQM_SYNC_INTERFACE_S.nextval
434: );
435: END insert_dqm_sync_error_rec;
436:
3323: 'PARTY',
3324: p_operation,
3325: 'N',
3326: 'N',
3327: hz_utility_pub.created_by,
3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3324: p_operation,
3325: 'N',
3326: 'N',
3327: hz_utility_pub.created_by,
3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3325: 'N',
3326: 'N',
3327: hz_utility_pub.created_by,
3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3333: );
3326: 'N',
3327: hz_utility_pub.created_by,
3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3333: );
3334: log ('Done');
3327: hz_utility_pub.created_by,
3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3333: );
3334: log ('Done');
3335: EXCEPTION WHEN OTHERS THEN
3665: 'PARTY_SITES',
3666: p_operation,
3667: 'N',
3668: 'N',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3666: p_operation,
3667: 'N',
3668: 'N',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3667: 'N',
3668: 'N',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3675: );
3668: 'N',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3675: );
3676: log ('Done');
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3675: );
3676: log ('Done');
3677: EXCEPTION WHEN OTHERS THEN
3939: 'CONTACTS',
3940: p_operation,
3941: 'N',
3942: 'N',
3943: hz_utility_pub.created_by,
3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3940: p_operation,
3941: 'N',
3942: 'N',
3943: hz_utility_pub.created_by,
3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3941: 'N',
3942: 'N',
3943: hz_utility_pub.created_by,
3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3949: );
3942: 'N',
3943: hz_utility_pub.created_by,
3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3949: );
3950: log ('Done');
3943: hz_utility_pub.created_by,
3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3949: );
3950: log ('Done');
3951: EXCEPTION WHEN OTHERS THEN
4258: 'CONTACT_POINTS',
4259: p_operation,
4260: 'N',
4261: 'N',
4262: hz_utility_pub.created_by,
4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4259: p_operation,
4260: 'N',
4261: 'N',
4262: hz_utility_pub.created_by,
4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4260: 'N',
4261: 'N',
4262: hz_utility_pub.created_by,
4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4268: );
4261: 'N',
4262: hz_utility_pub.created_by,
4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4268: );
4269: log ('Done');
4262: hz_utility_pub.created_by,
4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4268: );
4269: log ('Done');
4270: EXCEPTION WHEN OTHERS THEN