[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE select_row( recinfo IN OUT NOCOPY zx_account_rates%ROWTYPE ) IS
BEGIN
SELECT *
INTO recinfo
FROM zx_account_rates
WHERE ledger_id = recinfo.ledger_id
AND content_owner_id = recinfo.content_owner_id;
'zx_account_rates.select_row');
END select_row;
PROCEDURE select_columns(
x_ledger_id NUMBER,
x_content_owner_id NUMBER,
x_tax_precision IN OUT NOCOPY NUMBER,
x_tax_mau IN OUT NOCOPY NUMBER) IS
recinfo zx_account_rates%ROWTYPE;
select_row( recinfo );
'zx_account_rates.select_columns');
END select_columns;
SELECT count(*)
INTO x_total
FROM zx_account_rates
WHERE ledger_id = x_ledger_id
AND content_owner_id = x_content_owner_id
AND ( x_rowid is null OR rowid <> x_rowid );
'SELECT name ' ||
'FROM hr_operating_units ' ||
'WHERE organization_id = :org_id ',
dbms_sql.v7);
PROCEDURE insert_row(
X_LEDGER_ID NUMBER,
X_CONTENT_OWNER_ID NUMBER,
X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
X_TAX_PRECISION NUMBER,
X_CALCULATION_LEVEL_CODE VARCHAR2,
X_ALLOW_RATE_OVERRIDE_FLAG VARCHAR2,
X_TAX_MAU NUMBER,
X_TAX_CURRENCY_CODE VARCHAR2,
X_TAX_CLASS VARCHAR2,
X_TAX_REGIME_CODE VARCHAR2,
X_TAX VARCHAR2,
X_TAX_STATUS_CODE VARCHAR2,
X_TAX_RATE_CODE VARCHAR2,
X_ROUNDING_RULE_CODE VARCHAR2,
X_AMT_INCL_TAX_FLAG VARCHAR2,
X_RECORD_TYPE_CODE VARCHAR2,
X_CREATION_DATE DATE,
X_CREATED_BY NUMBER,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2,
X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2) IS
CURSOR C IS SELECT ROWID FROM ZX_ACCOUNT_RATES
WHERE LEDGER_ID = X_LEDGER_ID
AND CONTENT_OWNER_ID = X_CONTENT_OWNER_ID
AND (tax_class = X_TAX_CLASS OR
(tax_class IS NULL AND X_TAX_CLASS IS NULL) );
INSERT INTO ZX_ACCOUNT_RATES
(ledger_id,
content_owner_id,
account_segment_value,
tax_precision,
calculation_level_code,
allow_rate_override_flag,
tax_mau,
tax_currency_code,
tax_class,
tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
rounding_rule_code,
amt_incl_tax_flag,
record_type_code,
creation_date,
created_by,
last_updated_by,
last_update_date,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
allow_rounding_override_flag)
VALUES
(X_LEDGER_ID,
X_CONTENT_OWNER_ID,
X_ACCOUNT_SEGMENT_VALUE,
X_TAX_PRECISION,
X_CALCULATION_LEVEL_CODE,
X_ALLOW_RATE_OVERRIDE_FLAG,
X_TAX_MAU,
X_TAX_CURRENCY_CODE,
X_TAX_CLASS,
X_TAX_REGIME_CODE,
X_TAX,
X_TAX_STATUS_CODE,
X_TAX_RATE_CODE,
X_ROUNDING_RULE_CODE,
X_AMT_INCL_TAX_FLAG,
X_RECORD_TYPE_CODE,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ALLOW_ROUNDING_OVERRIDE_FLAG);
END insert_row;
PROCEDURE update_row (
X_RECORD_LEVEL VARCHAR2,
X_LEDGER_ID NUMBER,
X_CONTENT_OWNER_ID NUMBER,
X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
X_TAX_PRECISION NUMBER,
X_CALCULATION_LEVEL_CODE VARCHAR2,
X_ALLOW_RATE_OVERRIDE_FLAG VARCHAR2,
X_TAX_MAU NUMBER,
X_TAX_CURRENCY_CODE VARCHAR2,
X_TAX_CLASS VARCHAR2,
X_TAX_REGIME_CODE VARCHAR2,
X_TAX VARCHAR2,
X_TAX_STATUS_CODE VARCHAR2,
X_TAX_RATE_CODE VARCHAR2,
X_ROUNDING_RULE_CODE VARCHAR2,
X_AMT_INCL_TAX_FLAG VARCHAR2,
X_RECORD_TYPE_CODE VARCHAR2,
X_CREATION_DATE DATE,
X_CREATED_BY NUMBER,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2,
X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2,
X_CONTENT_OWNER_ID_ORIG NUMBER,
X_ACCOUNT_SEGMENT_VALUE_ORIG VARCHAR2,
X_TAX_CLASS_ORIG VARCHAR2) IS
BEGIN
IF x_record_level = 'LEDGER' THEN
/******
BEGIN
UPDATE ZX_ACCOUNT_RATES
SET tax_currency_code = X_TAX_CURRENCY_CODE,
tax_precision = X_TAX_PRECISION,
tax_mau = X_TAX_MAU,
calculation_level_code = X_CALCULATION_LEVEL_CODE,
allow_rounding_override_flag = X_ALLOW_ROUNDING_OVERRIDE_FLAG
WHERE ledger_id = X_LEDGER_ID
--AND content_owner_id = NVL(X_CONTENT_OWNER_ID_ORIG, content_owner_id)
AND account_segment_value IS NULL
AND (tax_class IN ('INPUT', 'OUTPUT')
OR tax_class is null);
UPDATE ZX_ACCOUNT_RATES
SET content_owner_id = X_CONTENT_OWNER_ID,
allow_rate_override_flag = X_ALLOW_RATE_OVERRIDE_FLAG,
-- tax_class = X_TAX_CLASS,
tax_regime_code = X_TAX_REGIME_CODE,
tax = X_TAX,
tax_status_code = X_TAX_STATUS_CODE,
tax_rate_code = X_TAX_RATE_CODE,
rounding_rule_code = X_ROUNDING_RULE_CODE,
amt_incl_tax_flag = X_AMT_INCL_TAX_FLAG,
tax_currency_code = X_TAX_CURRENCY_CODE,
tax_precision = X_TAX_PRECISION,
tax_mau = X_TAX_MAU,
calculation_level_code = X_CALCULATION_LEVEL_CODE,
allow_rounding_override_flag = X_ALLOW_ROUNDING_OVERRIDE_FLAG,
record_type_code = X_RECORD_TYPE_CODE,
creation_date = X_CREATION_DATE,
created_by = X_CREATED_BY,
last_updated_by = X_LAST_UPDATED_BY,
last_update_date = X_LAST_UPDATE_DATE,
last_update_login = X_LAST_UPDATE_LOGIN,
attribute_category = X_ATTRIBUTE_CATEGORY,
attribute1 = X_ATTRIBUTE1,
attribute2 = X_ATTRIBUTE2,
attribute3 = X_ATTRIBUTE3,
attribute4 = X_ATTRIBUTE4,
attribute5 = X_ATTRIBUTE5,
attribute6 = X_ATTRIBUTE6,
attribute7 = X_ATTRIBUTE7,
attribute8 = X_ATTRIBUTE8,
attribute9 = X_ATTRIBUTE9,
attribute10 = X_ATTRIBUTE10,
attribute11 = X_ATTRIBUTE11,
attribute12 = X_ATTRIBUTE12,
attribute13 = X_ATTRIBUTE13,
attribute14 = X_ATTRIBUTE14,
attribute15 = X_ATTRIBUTE15
WHERE ledger_id = X_LEDGER_ID
AND content_owner_id = X_CONTENT_OWNER_ID
AND account_segment_value IS NULL
AND (tax_class = X_TAX_CLASS OR
(tax_class IS NULL AND X_TAX_CLASS IS NULL ));
UPDATE ZX_ACCOUNT_RATES
SET ledger_id = X_LEDGER_ID,
content_owner_id = X_CONTENT_OWNER_ID,
account_segment_value = X_ACCOUNT_SEGMENT_VALUE,
tax_precision = X_TAX_PRECISION,
calculation_level_code = X_CALCULATION_LEVEL_CODE,
allow_rate_override_flag = X_ALLOW_RATE_OVERRIDE_FLAG,
tax_mau = X_TAX_MAU,
tax_currency_code = X_TAX_CURRENCY_CODE,
tax_class = X_TAX_CLASS,
tax_regime_code = X_TAX_REGIME_CODE,
tax = X_TAX,
tax_status_code = X_TAX_STATUS_CODE,
tax_rate_code = X_TAX_RATE_CODE,
rounding_rule_code = X_ROUNDING_RULE_CODE,
amt_incl_tax_flag = X_AMT_INCL_TAX_FLAG,
record_type_code = X_RECORD_TYPE_CODE,
creation_date = X_CREATION_DATE,
created_by = X_CREATED_BY,
last_updated_by = X_LAST_UPDATED_BY,
last_update_date = X_LAST_UPDATE_DATE,
last_update_login = X_LAST_UPDATE_LOGIN,
attribute_category = X_ATTRIBUTE_CATEGORY,
attribute1 = X_ATTRIBUTE1,
attribute2 = X_ATTRIBUTE2,
attribute3 = X_ATTRIBUTE3,
attribute4 = X_ATTRIBUTE4,
attribute5 = X_ATTRIBUTE5,
attribute6 = X_ATTRIBUTE6,
attribute7 = X_ATTRIBUTE7,
attribute8 = X_ATTRIBUTE8,
attribute9 = X_ATTRIBUTE9,
attribute10 = X_ATTRIBUTE10,
attribute11 = X_ATTRIBUTE11,
attribute12 = X_ATTRIBUTE12,
attribute13 = X_ATTRIBUTE13,
attribute14 = X_ATTRIBUTE14,
attribute15 = X_ATTRIBUTE15,
allow_rounding_override_flag = X_ALLOW_ROUNDING_OVERRIDE_FLAG
WHERE ledger_id = X_LEDGER_ID
AND content_owner_id = X_CONTENT_OWNER_ID
AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE
AND (tax_class = X_TAX_CLASS OR
(tax_class IS NULL AND X_TAX_CLASS IS NULL ));
END update_row;
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2,
X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2) IS
CURSOR C1 IS
SELECT *
FROM ZX_ACCOUNT_RATES
WHERE ledger_id = X_LEDGER_ID
AND content_owner_id = X_CONTENT_OWNER_ID
AND account_segment_value is null
AND (tax_class = X_TAX_CLASS OR
(tax_class IS NULL AND X_TAX_CLASS IS NULL ))
FOR UPDATE OF tax_currency_code NOWAIT;
SELECT *
FROM ZX_ACCOUNT_RATES
WHERE ledger_id = X_LEDGER_ID
AND content_owner_id = X_CONTENT_OWNER_ID
AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE
AND (tax_class = X_TAX_CLASS OR
(tax_class IS NULL AND X_TAX_CLASS IS NULL ))
FOR UPDATE OF tax_currency_code NOWAIT;
FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');
FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');