APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_DQM_SYNC

Line 618: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'U' );

614: where party_id = p_orig_sys_reference_rec.owner_table_id ;
615:
616: IF l_dummy = 'ORGANIZATION'
617: THEN
618: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'U' );
619: ELSIF l_dummy = 'PERSON'
620: THEN
621: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'U' );
622: END IF;

Line 621: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'U' );

617: THEN
618: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'U' );
619: ELSIF l_dummy = 'PERSON'
620: THEN
621: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'U' );
622: END IF;
623: -- END IF;
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN

Line 642: HZ_DQM_SYNC.sync_party_site(p_orig_sys_reference_rec.owner_table_id ,'U') ;

638: BEGIN--bug 6069559
639: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
640:
641: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
642: HZ_DQM_SYNC.sync_party_site(p_orig_sys_reference_rec.owner_table_id ,'U') ;
643: END IF;
644: EXCEPTION
645: WHEN No_Data_Found THEN
646: NULL;

Line 656: HZ_DQM_SYNC.sync_contact(p_orig_sys_reference_rec.owner_table_id,'U') ;

652: BEGIN--bug 6069559
653: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
654:
655: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
656: HZ_DQM_SYNC.sync_contact(p_orig_sys_reference_rec.owner_table_id,'U') ;
657: END IF;
658: EXCEPTION
659: WHEN No_Data_Found THEN
660: NULL;

Line 670: HZ_DQM_SYNC.sync_contact_point(p_orig_sys_reference_rec.owner_table_id,'U') ;

666: BEGIN--bug 6069559
667: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
668:
669: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
670: HZ_DQM_SYNC.sync_contact_point(p_orig_sys_reference_rec.owner_table_id,'U') ;
671: END IF;
672: EXCEPTION
673: WHEN No_Data_Found THEN
674: NULL;

Line 958: HZ_DQM_SYNC.sync_org(l_temp, 'U' );

954: where party_id = l_temp ;
955:
956: IF l_dummy = 'ORGANIZATION'
957: THEN
958: HZ_DQM_SYNC.sync_org(l_temp, 'U' );
959: ELSIF l_dummy = 'PERSON'
960: THEN
961: HZ_DQM_SYNC.sync_person(l_temp, 'U' );
962: END IF;

Line 961: HZ_DQM_SYNC.sync_person(l_temp, 'U' );

957: THEN
958: HZ_DQM_SYNC.sync_org(l_temp, 'U' );
959: ELSIF l_dummy = 'PERSON'
960: THEN
961: HZ_DQM_SYNC.sync_person(l_temp, 'U' );
962: END IF;
963: -- END IF;
964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN

Line 982: HZ_DQM_SYNC.sync_party_site(l_temp ,'U') ;

978: BEGIN--bug 6069559
979: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
980:
981: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
982: HZ_DQM_SYNC.sync_party_site(l_temp ,'U') ;
983: END IF;
984: EXCEPTION
985: WHEN No_Data_Found THEN
986: NULL;

Line 997: HZ_DQM_SYNC.sync_contact(l_temp,'U') ;

993: BEGIN--bug 6069559
994: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
995:
996: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
997: HZ_DQM_SYNC.sync_contact(l_temp,'U') ;
998: END IF;
999: EXCEPTION
1000: WHEN No_Data_Found THEN
1001: NULL;

Line 1013: HZ_DQM_SYNC.sync_contact_point(l_temp,'U') ;

1009: BEGIN--bug 6069559
1010: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1011:
1012: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1013: HZ_DQM_SYNC.sync_contact_point(l_temp,'U') ;
1014: END IF;
1015: EXCEPTION
1016: WHEN No_Data_Found THEN
1017: NULL;