[Home] [Help]
562: call_sync_index_serial ;
563: END IF;
564: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN
565: insert_interface_rec(p_party_id,null,null,null,'PARTY',p_create_upd);
566: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
567: -- if shadow staging conc prog completed successfully.
568: IF (is_shadow_staging_complete) THEN
569: insert_sh_interface_rec(p_party_id,null,null,null,'PARTY',p_create_upd);
570: END IF;
606: call_sync_index_serial ;
607: END IF;
608: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN
609: insert_interface_rec(p_party_id,null,null,null,'PARTY',p_create_upd);
610: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
611: -- if shadow staging conc prog completed successfully.
612: IF (is_shadow_staging_complete) THEN
613: insert_sh_interface_rec(p_party_id,null,null,null,'PARTY',p_create_upd);
614: END IF;
617: LOOP
618: FETCH c_contact INTO l_org_contact_id;
619: EXIT WHEN c_contact%NOTFOUND;
620: insert_interface_rec(p_party_id,l_org_contact_id,null,null,'CONTACTS','U');
621: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
622: -- if shadow staging conc prog completed successfully.
623: IF (is_shadow_staging_complete) THEN
624: insert_sh_interface_rec(p_party_id,l_org_contact_id,null,null,'CONTACTS','U');
625: END IF;
684: l_party_id1:=l_party_id;
685: l_org_contact_id:=NULL;
686: END IF;
687: insert_interface_rec(l_party_id1,p_party_site_id,null,l_org_contact_id,'PARTY_SITES',p_create_upd);
688: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
689: -- if shadow staging conc prog completed successfully.
690: IF (is_shadow_staging_complete) THEN
691: insert_sh_interface_rec(l_party_id1,p_party_site_id,null,l_org_contact_id,'PARTY_SITES',p_create_upd);
692: END IF;
730: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
731: AND (r.status is null OR r.status = 'A' or r.status = 'I') ;
732:
733: insert_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_create_upd);
734: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
735: -- if shadow staging conc prog completed successfully.
736: IF (is_shadow_staging_complete) THEN
737: insert_sh_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_create_upd);
738: END IF;
829: END IF;
830: END IF;
831:
832: insert_interface_rec(l_party_id,p_contact_point_id,l_party_site_id, l_org_contact_id, 'CONTACT_POINTS',p_create_upd);
833: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
834: -- if shadow staging conc prog completed successfully.
835: IF (is_shadow_staging_complete) THEN
836: insert_sh_interface_rec(l_party_id,p_contact_point_id,l_party_site_id, l_org_contact_id, 'CONTACT_POINTS',p_create_upd);
837: END IF;
1025: HZ_DQM_SYNC_INTERFACE_S.nextval
1026: );
1027: END insert_error_rec;
1028:
1029: -- REPURI. Bug 4884742. Added this procedure to insert data into hz_dqm_sh_sync_interface table.
1030: -- This is the interface table for Shadow Sync.
1031:
1032: PROCEDURE insert_sh_interface_rec (
1033: p_party_id IN NUMBER,
1050: -- REPURI. Bug 4968126.
1051: -- Using the Merge instead of Insert statement
1052: -- so that duplicate records dont get inserted.
1053:
1054: MERGE INTO hz_dqm_sh_sync_interface S
1055: USING (
1056: SELECT
1057: p_entity AS entity
1058: ,p_party_id AS party_id
1095: hz_utility_pub.creation_date,
1096: hz_utility_pub.last_update_login,
1097: hz_utility_pub.last_update_date,
1098: hz_utility_pub.user_id,
1099: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
1100: );
1101:
1102: END insert_sh_interface_rec;
1103: