APPS.FA_INS_MST_POLS_PKG SQL Statements

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

Line: 14

			SELECT 	*
			FROM	fa_ins_mst_pols
			WHERE	rowid = X_Rowid
			FOR UPDATE OF policy_number NOWAIT;

Line: 26

     FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 52

PROCEDURE Update_Row(   X_Rowid                  VARCHAR2,
                        X_Asset_policy_id        NUMBER,
                        X_Policy_number          VARCHAR2,
                        X_Vendor_site_id         NUMBER,
                        X_Vendor_id              NUMBER,
                        X_Calculation_method     VARCHAR2,
                        X_Last_update_date       DATE,
                        X_Last_updated_by        VARCHAR2,
                        X_Last_update_login      VARCHAR2,
                        X_Creation_date          DATE,
                        X_Created_by             VARCHAR2,
			p_log_level_rec     IN   FA_API_TYPES.log_level_rec_type default null) IS

BEGIN

  UPDATE fa_ins_mst_pols
  SET
     asset_policy_id		= X_Asset_policy_id,
     policy_number		= X_Policy_number,
     vendor_site_id		= X_Vendor_site_id,
     vendor_id			= X_Vendor_id,
     calculation_method		= X_Calculation_method,
     last_update_date		= X_Last_update_date,
     last_updated_by		= X_Last_updated_by,
     last_update_login		= X_Last_update_login,
     creation_date		= X_Creation_date,
     created_by			= X_Created_by
  WHERE rowid = X_Rowid;

Line: 87

END Update_Row;

Line: 90

PROCEDURE Delete_Row(	X_asset_policy_id		NUMBER,
                        X_Asset_id			VARCHAR2,
			p_log_level_rec          IN     FA_API_TYPES.log_level_rec_type default null) IS

 CURSOR C IS
       SELECT 1
       FROM   fa_ins_policies
       WHERE  asset_policy_id = X_asset_policy_id
       AND    asset_id <> X_Asset_id;

Line: 107

	DELETE FROM fa_ins_mst_pols
	WHERE asset_policy_id = X_asset_policy_id;

Line: 115

    DELETE FROM fa_ins_lines
    WHERE asset_policy_id = X_asset_policy_id
    AND   asset_id = X_Asset_id;

Line: 122

    DELETE FROM fa_ins_policies
    WHERE asset_policy_id = X_asset_policy_id
    AND   asset_id = X_Asset_id;

Line: 126

    DELETE FROM fa_ins_values
    WHERE asset_policy_id = X_asset_policy_id
    AND   asset_id = X_Asset_id;

Line: 132

END Delete_Row;