DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_DQM_SYNC

Line 628: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'C' );

624: --Bug13117445
625: IF l_dummy = 'ORGANIZATION'
626: THEN
627: IF p_orig_sys_reference_rec.dqm_sync_mode = 'C' THEN
628: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'C' );
629: ELSE
630: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'U' );
631: END IF;
632: ELSIF l_dummy = 'PERSON'

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

626: THEN
627: IF p_orig_sys_reference_rec.dqm_sync_mode = 'C' THEN
628: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'C' );
629: ELSE
630: HZ_DQM_SYNC.sync_org(p_orig_sys_reference_rec.owner_table_id, 'U' );
631: END IF;
632: ELSIF l_dummy = 'PERSON'
633: THEN
634: IF p_orig_sys_reference_rec.dqm_sync_mode = 'C' THEN

Line 635: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'C' );

631: END IF;
632: ELSIF l_dummy = 'PERSON'
633: THEN
634: IF p_orig_sys_reference_rec.dqm_sync_mode = 'C' THEN
635: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'C' );
636: ELSE
637: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'U' );
638: END IF;
639: END IF;

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

633: THEN
634: IF p_orig_sys_reference_rec.dqm_sync_mode = 'C' THEN
635: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'C' );
636: ELSE
637: HZ_DQM_SYNC.sync_person(p_orig_sys_reference_rec.owner_table_id, 'U' );
638: END IF;
639: END IF;
640: -- END IF;
641: EXCEPTION

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

655: BEGIN--bug 6069559
656: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
657:
658: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
659: HZ_DQM_SYNC.sync_party_site(p_orig_sys_reference_rec.owner_table_id ,'U') ;
660: END IF;
661: EXCEPTION
662: WHEN No_Data_Found THEN
663: NULL;

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

669: BEGIN--bug 6069559
670: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
671:
672: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
673: HZ_DQM_SYNC.sync_contact(p_orig_sys_reference_rec.owner_table_id,'U') ;
674: END IF;
675: EXCEPTION
676: WHEN No_Data_Found THEN
677: NULL;

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

683: BEGIN--bug 6069559
684: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
685:
686: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
687: HZ_DQM_SYNC.sync_contact_point(p_orig_sys_reference_rec.owner_table_id,'U') ;
688: END IF;
689: EXCEPTION
690: WHEN No_Data_Found THEN
691: NULL;

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

983: where party_id = l_temp ;
984:
985: IF l_dummy = 'ORGANIZATION'
986: THEN
987: HZ_DQM_SYNC.sync_org(l_temp, 'U' );
988: ELSIF l_dummy = 'PERSON'
989: THEN
990: HZ_DQM_SYNC.sync_person(l_temp, 'U' );
991: END IF;

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

986: THEN
987: HZ_DQM_SYNC.sync_org(l_temp, 'U' );
988: ELSIF l_dummy = 'PERSON'
989: THEN
990: HZ_DQM_SYNC.sync_person(l_temp, 'U' );
991: END IF;
992: -- END IF;
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN

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

1007: BEGIN--bug 6069559
1008: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
1009:
1010: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1011: HZ_DQM_SYNC.sync_party_site(l_temp ,'U') ;
1012: END IF;
1013: EXCEPTION
1014: WHEN No_Data_Found THEN
1015: NULL;

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

1022: BEGIN--bug 6069559
1023: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
1024:
1025: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1026: HZ_DQM_SYNC.sync_contact(l_temp,'U') ;
1027: END IF;
1028: EXCEPTION
1029: WHEN No_Data_Found THEN
1030: NULL;

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

1038: BEGIN--bug 6069559
1039: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1040:
1041: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1042: HZ_DQM_SYNC.sync_contact_point(l_temp,'U') ;
1043: END IF;
1044: EXCEPTION
1045: WHEN No_Data_Found THEN
1046: NULL;