APPS.CSC_RESPONSE_CENTER_PKG_V2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 309

 PROCEDURE Update_Address ( p_address_rec           IN               ADDRESS_REC_TYPE,
                            x_msg_count             OUT     NOCOPY   NUMBER,
                            x_msg_data              OUT     NOCOPY   VARCHAR2,
                            x_object_version_number IN OUT  NOCOPY   NUMBER,
                            x_return_status         OUT     NOCOPY   VARCHAR2,
                            x_addr_val_status       OUT     NOCOPY   VARCHAR2,
                            x_addr_warn_msg         OUT     NOCOPY   VARCHAR2)
 IS
    l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line: 404

    HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_TRUE,      -- To initialize the Message List on each call
                                        p_location_rec => l_location_rec,
                                        p_object_version_number => x_object_version_number,
                                        x_return_status => l_return_status,
                                        x_msg_count => l_msg_count,
                                        x_msg_data => l_msg_data,
				        p_do_addr_val      => l_do_addr_val,
                                        x_addr_val_status  => l_addr_val_status,
                                        x_addr_warn_msg => l_addr_warn_msg);

Line: 423

 End Update_Address;