[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;
741: AND DIRECTIONAL_FLAG= 'F';
742: END IF;
743:
744: insert_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_create_upd);
745: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
746: -- if shadow staging conc prog completed successfully.
747: IF (is_shadow_staging_complete) THEN
748: insert_sh_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_create_upd);
749: END IF;
840: END IF;
841: END IF;
842:
843: insert_interface_rec(l_party_id,p_contact_point_id,l_party_site_id, l_org_contact_id, 'CONTACT_POINTS',p_create_upd);
844: -- REPURI. Bug 4884742. Added this to insert data into hz_dqm_sh_sync_interface table
845: -- if shadow staging conc prog completed successfully.
846: IF (is_shadow_staging_complete) THEN
847: insert_sh_interface_rec(l_party_id,p_contact_point_id,l_party_site_id, l_org_contact_id, 'CONTACT_POINTS',p_create_upd);
848: END IF;
1036: HZ_DQM_SYNC_INTERFACE_S.nextval
1037: );
1038: END insert_error_rec;
1039:
1040: -- REPURI. Bug 4884742. Added this procedure to insert data into hz_dqm_sh_sync_interface table.
1041: -- This is the interface table for Shadow Sync.
1042:
1043: PROCEDURE insert_sh_interface_rec (
1044: p_party_id IN NUMBER,
1061: -- REPURI. Bug 4968126.
1062: -- Using the Merge instead of Insert statement
1063: -- so that duplicate records dont get inserted.
1064:
1065: MERGE INTO hz_dqm_sh_sync_interface S
1066: USING (
1067: SELECT
1068: p_entity AS entity
1069: ,p_party_id AS party_id
1106: hz_utility_pub.creation_date,
1107: hz_utility_pub.last_update_login,
1108: hz_utility_pub.last_update_date,
1109: hz_utility_pub.user_id,
1110: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
1111: );
1112:
1113: END insert_sh_interface_rec;
1114: