APPS.EAM_GENEALOGY_IMPORT_PUB SQL Statements

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

Line: 48

    SELECT  *
    FROM    MTL_OBJECT_GENEALOGY_INTERFACE mogi
    WHERE   mogi.group_id = p_interface_group_id
    AND     mogi.process_status = 'R';

Line: 114

            select msi.eam_item_type into l_dummy
            from mtl_serial_numbers msn, mtl_system_items msi
            where msn.serial_number = genealogy_rec.serial_number
            and msi.organization_id = genealogy_rec.organization_id
            and msi.inventory_item_id = genealogy_rec.inventory_item_id
            and msn.inventory_item_id = msi.inventory_item_id
	    and msi.organization_id = msn.current_organization_id;

Line: 147

	                INV_GENEALOGY_PUB.insert_genealogy(
                                            p_api_version => l_api_version
                                        ,   p_commit => fnd_api.g_true
                                        ,   p_object_type =>  genealogy_rec.object_type
                                        ,   p_parent_object_type => genealogy_rec.parent_object_type
                                        ,   p_object_id => genealogy_rec.object_id
                                        ,   p_object_number => genealogy_rec.serial_number
                                        ,   p_inventory_item_id => genealogy_rec.inventory_item_id
                                        ,   p_org_id => genealogy_rec.organization_id
                                        ,   p_parent_object_id => genealogy_rec.parent_object_id
                                        ,   p_parent_object_number => genealogy_rec.parent_serial_number
                                        ,   p_parent_inventory_item_id => genealogy_rec.parent_inventory_item_id
                                        ,   p_parent_org_id => genealogy_rec.parent_organization_id
                                        ,   p_genealogy_origin => genealogy_rec.genealogy_origin
                                        ,   p_genealogy_type => genealogy_rec.genealogy_type
                                        ,   p_start_date_active => genealogy_rec.start_date_active
                                        ,   p_end_date_active => genealogy_rec.end_date_active
                                        ,   p_origin_txn_id => genealogy_rec.origin_txn_id
                                        ,   p_update_txn_id => genealogy_rec.update_txn_id
                                        ,   x_return_status => l_return_status
                                        ,   x_msg_count => l_msg_count
                                        ,   x_msg_data => l_msg_data);

Line: 184

                                        ,   p_update_txn_id => genealogy_rec.update_txn_id
					,   p_from_eam => fnd_api.g_true
                                        ,   x_return_status => l_return_status
                                        ,   x_msg_count => l_msg_count
                                        ,   x_msg_data => l_msg_data);

Line: 209

	        INV_GENEALOGY_PUB.update_genealogy(
                                            p_api_version => l_api_version
                                        ,   p_commit => fnd_api.g_true
                                        ,   p_object_type =>  genealogy_rec.object_type
                                        ,   p_object_id => genealogy_rec.object_id
                                        ,   p_object_number => genealogy_rec.serial_number
                                        ,   p_inventory_item_id => genealogy_rec.inventory_item_id
                                        ,   p_org_id => genealogy_rec.organization_id
                                        ,   p_genealogy_origin => genealogy_rec.genealogy_origin
                                        ,   p_genealogy_type => genealogy_rec.genealogy_type
                                        ,   p_end_date_active => genealogy_rec.end_date_active
                                        ,   p_update_txn_id => genealogy_rec.update_txn_id
                                        ,   x_return_status => l_return_status
                                        ,   x_msg_count => l_msg_count
                                        ,   x_msg_data => l_msg_data);

Line: 229

                  UPDATE MTL_OBJECT_GENEALOGY_INTERFACE mogi
                  SET mogi.process_status = 'E',
                  mogi.error_message = l_msg_data
                  WHERE mogi.group_id = p_interface_group_id and mogi.interface_header_id = genealogy_rec.interface_header_id;

Line: 235

                UPDATE MTL_OBJECT_GENEALOGY_INTERFACE mogi
                SET mogi.process_status = 'S'
                WHERE mogi.group_id = p_interface_group_id and mogi.interface_header_id = genealogy_rec.interface_header_id;

Line: 251

                UPDATE MTL_OBJECT_GENEALOGY_INTERFACE mogi
                SET mogi.process_status = 'E',
                mogi.error_message = l_msg_data
                WHERE mogi.group_id = p_interface_group_id and mogi.interface_header_id = genealogy_rec.interface_header_id;

Line: 266

                UPDATE MTL_OBJECT_GENEALOGY_INTERFACE mogi
                SET mogi.process_status = 'E',
                mogi.error_message = l_msg_data
                WHERE mogi.group_id = p_interface_group_id and mogi.interface_header_id = genealogy_rec.interface_header_id;

Line: 278

        DELETE FROM MTL_OBJECT_GENEALOGY_INTERFACE mogi
        WHERE mogi.process_status = 'S' and
              mogi.group_id = p_interface_group_id;

Line: 311

        UPDATE MTL_OBJECT_GENEALOGY_INTERFACE mogi
        SET mogi.process_status = 'E',
        mogi.error_message = l_msg_data,
        mogi.error_code = 9999
        WHERE mogi.group_id = p_interface_group_id;