1087: NULL,
1088: NULL,
1089: NULL,
1090: NULL,
1091: hz_utility_pub.created_by,
1092: hz_utility_pub.creation_date,
1093: hz_utility_pub.last_update_login,
1094: hz_utility_pub.last_update_date,
1095: hz_utility_pub.user_id
1088: NULL,
1089: NULL,
1090: NULL,
1091: hz_utility_pub.created_by,
1092: hz_utility_pub.creation_date,
1093: hz_utility_pub.last_update_login,
1094: hz_utility_pub.last_update_date,
1095: hz_utility_pub.user_id
1096: );
1089: NULL,
1090: NULL,
1091: hz_utility_pub.created_by,
1092: hz_utility_pub.creation_date,
1093: hz_utility_pub.last_update_login,
1094: hz_utility_pub.last_update_date,
1095: hz_utility_pub.user_id
1096: );
1097: END;
1090: NULL,
1091: hz_utility_pub.created_by,
1092: hz_utility_pub.creation_date,
1093: hz_utility_pub.last_update_login,
1094: hz_utility_pub.last_update_date,
1095: hz_utility_pub.user_id
1096: );
1097: END;
1098:
1091: hz_utility_pub.created_by,
1092: hz_utility_pub.creation_date,
1093: hz_utility_pub.last_update_login,
1094: hz_utility_pub.last_update_date,
1095: hz_utility_pub.user_id
1096: );
1097: END;
1098:
1099: FUNCTION get_size (
4655: l(' p_operation, ');
4656: l(' p_staged_flag, ');
4657: l(' p_realtime_sync_flag, ');
4658: l(' p_error_data, ');
4659: l(' hz_utility_pub.created_by, ');
4660: l(' hz_utility_pub.creation_date, ');
4661: l(' hz_utility_pub.last_update_login, ');
4662: l(' hz_utility_pub.last_update_date, ');
4663: l(' hz_utility_pub.user_id, ');
4656: l(' p_staged_flag, ');
4657: l(' p_realtime_sync_flag, ');
4658: l(' p_error_data, ');
4659: l(' hz_utility_pub.created_by, ');
4660: l(' hz_utility_pub.creation_date, ');
4661: l(' hz_utility_pub.last_update_login, ');
4662: l(' hz_utility_pub.last_update_date, ');
4663: l(' hz_utility_pub.user_id, ');
4664: l(' HZ_DQM_SYNC_INTERFACE_S.nextval ');
4657: l(' p_realtime_sync_flag, ');
4658: l(' p_error_data, ');
4659: l(' hz_utility_pub.created_by, ');
4660: l(' hz_utility_pub.creation_date, ');
4661: l(' hz_utility_pub.last_update_login, ');
4662: l(' hz_utility_pub.last_update_date, ');
4663: l(' hz_utility_pub.user_id, ');
4664: l(' HZ_DQM_SYNC_INTERFACE_S.nextval ');
4665: l(' ); ');
4658: l(' p_error_data, ');
4659: l(' hz_utility_pub.created_by, ');
4660: l(' hz_utility_pub.creation_date, ');
4661: l(' hz_utility_pub.last_update_login, ');
4662: l(' hz_utility_pub.last_update_date, ');
4663: l(' hz_utility_pub.user_id, ');
4664: l(' HZ_DQM_SYNC_INTERFACE_S.nextval ');
4665: l(' ); ');
4666: l(' END insert_dqm_sync_error_rec; ');
4659: l(' hz_utility_pub.created_by, ');
4660: l(' hz_utility_pub.creation_date, ');
4661: l(' hz_utility_pub.last_update_login, ');
4662: l(' hz_utility_pub.last_update_date, ');
4663: l(' hz_utility_pub.user_id, ');
4664: l(' HZ_DQM_SYNC_INTERFACE_S.nextval ');
4665: l(' ); ');
4666: l(' END insert_dqm_sync_error_rec; ');
4667: l('');
5341: l(' ''PARTY'', ');
5342: l(' p_operation, ');
5343: l(' ''N'', ');
5344: l(' ''N'', ');
5345: l(' hz_utility_pub.created_by, ');
5346: l(' hz_utility_pub.creation_date, ');
5347: l(' hz_utility_pub.last_update_login, ');
5348: l(' hz_utility_pub.last_update_date, ');
5349: l(' hz_utility_pub.user_id, ');
5342: l(' p_operation, ');
5343: l(' ''N'', ');
5344: l(' ''N'', ');
5345: l(' hz_utility_pub.created_by, ');
5346: l(' hz_utility_pub.creation_date, ');
5347: l(' hz_utility_pub.last_update_login, ');
5348: l(' hz_utility_pub.last_update_date, ');
5349: l(' hz_utility_pub.user_id, ');
5350: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
5343: l(' ''N'', ');
5344: l(' ''N'', ');
5345: l(' hz_utility_pub.created_by, ');
5346: l(' hz_utility_pub.creation_date, ');
5347: l(' hz_utility_pub.last_update_login, ');
5348: l(' hz_utility_pub.last_update_date, ');
5349: l(' hz_utility_pub.user_id, ');
5350: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
5351: l(' ); ');
5344: l(' ''N'', ');
5345: l(' hz_utility_pub.created_by, ');
5346: l(' hz_utility_pub.creation_date, ');
5347: l(' hz_utility_pub.last_update_login, ');
5348: l(' hz_utility_pub.last_update_date, ');
5349: l(' hz_utility_pub.user_id, ');
5350: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
5351: l(' ); ');
5352: l(' log (''Done''); ');
5345: l(' hz_utility_pub.created_by, ');
5346: l(' hz_utility_pub.creation_date, ');
5347: l(' hz_utility_pub.last_update_login, ');
5348: l(' hz_utility_pub.last_update_date, ');
5349: l(' hz_utility_pub.user_id, ');
5350: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
5351: l(' ); ');
5352: l(' log (''Done''); ');
5353: l(' EXCEPTION WHEN OTHERS THEN ');
6752: l(' ''PARTY_SITES'', ');
6753: l(' p_operation, ');
6754: l(' ''N'', ');
6755: l(' ''N'', ');
6756: l(' hz_utility_pub.created_by, ');
6757: l(' hz_utility_pub.creation_date, ');
6758: l(' hz_utility_pub.last_update_login, ');
6759: l(' hz_utility_pub.last_update_date, ');
6760: l(' hz_utility_pub.user_id, ');
6753: l(' p_operation, ');
6754: l(' ''N'', ');
6755: l(' ''N'', ');
6756: l(' hz_utility_pub.created_by, ');
6757: l(' hz_utility_pub.creation_date, ');
6758: l(' hz_utility_pub.last_update_login, ');
6759: l(' hz_utility_pub.last_update_date, ');
6760: l(' hz_utility_pub.user_id, ');
6761: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
6754: l(' ''N'', ');
6755: l(' ''N'', ');
6756: l(' hz_utility_pub.created_by, ');
6757: l(' hz_utility_pub.creation_date, ');
6758: l(' hz_utility_pub.last_update_login, ');
6759: l(' hz_utility_pub.last_update_date, ');
6760: l(' hz_utility_pub.user_id, ');
6761: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
6762: l(' ); ');
6755: l(' ''N'', ');
6756: l(' hz_utility_pub.created_by, ');
6757: l(' hz_utility_pub.creation_date, ');
6758: l(' hz_utility_pub.last_update_login, ');
6759: l(' hz_utility_pub.last_update_date, ');
6760: l(' hz_utility_pub.user_id, ');
6761: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
6762: l(' ); ');
6763: l(' log (''Done''); ');
6756: l(' hz_utility_pub.created_by, ');
6757: l(' hz_utility_pub.creation_date, ');
6758: l(' hz_utility_pub.last_update_login, ');
6759: l(' hz_utility_pub.last_update_date, ');
6760: l(' hz_utility_pub.user_id, ');
6761: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
6762: l(' ); ');
6763: l(' log (''Done''); ');
6764: l(' EXCEPTION WHEN OTHERS THEN ');
8059: l(' ''CONTACTS'', ');
8060: l(' p_operation, ');
8061: l(' ''N'', ');
8062: l(' ''N'', ');
8063: l(' hz_utility_pub.created_by, ');
8064: l(' hz_utility_pub.creation_date, ');
8065: l(' hz_utility_pub.last_update_login, ');
8066: l(' hz_utility_pub.last_update_date, ');
8067: l(' hz_utility_pub.user_id, ');
8060: l(' p_operation, ');
8061: l(' ''N'', ');
8062: l(' ''N'', ');
8063: l(' hz_utility_pub.created_by, ');
8064: l(' hz_utility_pub.creation_date, ');
8065: l(' hz_utility_pub.last_update_login, ');
8066: l(' hz_utility_pub.last_update_date, ');
8067: l(' hz_utility_pub.user_id, ');
8068: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
8061: l(' ''N'', ');
8062: l(' ''N'', ');
8063: l(' hz_utility_pub.created_by, ');
8064: l(' hz_utility_pub.creation_date, ');
8065: l(' hz_utility_pub.last_update_login, ');
8066: l(' hz_utility_pub.last_update_date, ');
8067: l(' hz_utility_pub.user_id, ');
8068: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
8069: l(' ); ');
8062: l(' ''N'', ');
8063: l(' hz_utility_pub.created_by, ');
8064: l(' hz_utility_pub.creation_date, ');
8065: l(' hz_utility_pub.last_update_login, ');
8066: l(' hz_utility_pub.last_update_date, ');
8067: l(' hz_utility_pub.user_id, ');
8068: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
8069: l(' ); ');
8070: l(' log (''Done''); ');
8063: l(' hz_utility_pub.created_by, ');
8064: l(' hz_utility_pub.creation_date, ');
8065: l(' hz_utility_pub.last_update_login, ');
8066: l(' hz_utility_pub.last_update_date, ');
8067: l(' hz_utility_pub.user_id, ');
8068: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
8069: l(' ); ');
8070: l(' log (''Done''); ');
8071: l(' EXCEPTION WHEN OTHERS THEN ');
9336: l(' ''CONTACT_POINTS'', ');
9337: l(' p_operation, ');
9338: l(' ''N'', ');
9339: l(' ''N'', ');
9340: l(' hz_utility_pub.created_by, ');
9341: l(' hz_utility_pub.creation_date, ');
9342: l(' hz_utility_pub.last_update_login, ');
9343: l(' hz_utility_pub.last_update_date, ');
9344: l(' hz_utility_pub.user_id, ');
9337: l(' p_operation, ');
9338: l(' ''N'', ');
9339: l(' ''N'', ');
9340: l(' hz_utility_pub.created_by, ');
9341: l(' hz_utility_pub.creation_date, ');
9342: l(' hz_utility_pub.last_update_login, ');
9343: l(' hz_utility_pub.last_update_date, ');
9344: l(' hz_utility_pub.user_id, ');
9345: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
9338: l(' ''N'', ');
9339: l(' ''N'', ');
9340: l(' hz_utility_pub.created_by, ');
9341: l(' hz_utility_pub.creation_date, ');
9342: l(' hz_utility_pub.last_update_login, ');
9343: l(' hz_utility_pub.last_update_date, ');
9344: l(' hz_utility_pub.user_id, ');
9345: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
9346: l(' ); ');
9339: l(' ''N'', ');
9340: l(' hz_utility_pub.created_by, ');
9341: l(' hz_utility_pub.creation_date, ');
9342: l(' hz_utility_pub.last_update_login, ');
9343: l(' hz_utility_pub.last_update_date, ');
9344: l(' hz_utility_pub.user_id, ');
9345: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
9346: l(' ); ');
9347: l(' log (''Done''); ');
9340: l(' hz_utility_pub.created_by, ');
9341: l(' hz_utility_pub.creation_date, ');
9342: l(' hz_utility_pub.last_update_login, ');
9343: l(' hz_utility_pub.last_update_date, ');
9344: l(' hz_utility_pub.user_id, ');
9345: l(' HZ_DQM_SH_SYNC_INTERFACE_S.nextval ');
9346: l(' ); ');
9347: l(' log (''Done''); ');
9348: l(' EXCEPTION WHEN OTHERS THEN ');