847: ** and populates the CAC_SYNC_CONTACT_TEMPS table
848: **
849: *******************************************************************************/
850: (
851: p_api_version IN NUMBER -- Standard version parameter
852: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
853: , p_principal_id IN NUMBER -- Principal ID
854: , p_person_party_id IN NUMBER -- Person Party ID
855: , p_sync_anchor IN DATE -- Timestamp for sync anchor
848: **
849: *******************************************************************************/
850: (
851: p_api_version IN NUMBER -- Standard version parameter
852: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
853: , p_principal_id IN NUMBER -- Principal ID
854: , p_person_party_id IN NUMBER -- Person Party ID
855: , p_sync_anchor IN DATE -- Timestamp for sync anchor
856: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
852: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
853: , p_principal_id IN NUMBER -- Principal ID
854: , p_person_party_id IN NUMBER -- Person Party ID
855: , p_sync_anchor IN DATE -- Timestamp for sync anchor
856: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
857: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
858: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
859: )
860: IS
853: , p_principal_id IN NUMBER -- Principal ID
854: , p_person_party_id IN NUMBER -- Person Party ID
855: , p_sync_anchor IN DATE -- Timestamp for sync anchor
856: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
857: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
858: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
859: )
860: IS
861: rec_new_contacts c_new_contacts%ROWTYPE;
854: , p_person_party_id IN NUMBER -- Person Party ID
855: , p_sync_anchor IN DATE -- Timestamp for sync anchor
856: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
857: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
858: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
859: )
860: IS
861: rec_new_contacts c_new_contacts%ROWTYPE;
862: rec_updated_contacts c_updated_contacts%ROWTYPE;
1138: ** and populates the CAC_SYNC_CONTACT_TEMPS table
1139: **
1140: *******************************************************************************/
1141: (
1142: p_api_version IN NUMBER -- Standard version parameter
1143: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
1144: , p_person_party_id IN NUMBER -- Person Party ID
1145: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
1146: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
1139: **
1140: *******************************************************************************/
1141: (
1142: p_api_version IN NUMBER -- Standard version parameter
1143: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
1144: , p_person_party_id IN NUMBER -- Person Party ID
1145: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
1146: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
1147: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
1141: (
1142: p_api_version IN NUMBER -- Standard version parameter
1143: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
1144: , p_person_party_id IN NUMBER -- Person Party ID
1145: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
1146: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
1147: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
1148: )
1149: IS
1142: p_api_version IN NUMBER -- Standard version parameter
1143: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
1144: , p_person_party_id IN NUMBER -- Person Party ID
1145: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
1146: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
1147: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
1148: )
1149: IS
1150: rec_all_contacts c_all_contacts%ROWTYPE;
1143: , p_init_msg_list IN VARCHAR2 -- Standard message initialization flag
1144: , p_person_party_id IN NUMBER -- Person Party ID
1145: , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
1146: , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
1147: , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
1148: )
1149: IS
1150: rec_all_contacts c_all_contacts%ROWTYPE;
1151: l_bkm_module VARCHAR2(50);