[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE select_row( recinfo IN OUT NOCOPY zx_acct_tx_cls_defs_all%ROWTYPE ) IS
BEGIN
SELECT *
INTO recinfo
FROM zx_acct_tx_cls_defs_all
WHERE ledger_id = recinfo.ledger_id
AND org_id = recinfo.org_id;
'zx_acct_tax_cls_defs_all.select_row');
END select_row;
PROCEDURE select_columns(
x_ledger_id NUMBER,
x_org_id NUMBER,
x_tax_class IN OUT NOCOPY VARCHAr2,
x_tax_classification_code IN OUT NOCOPY VARCHAr2) IS
recinfo zx_acct_tx_cls_defs_all%ROWTYPE;
select_row( recinfo );
'zx_acct_tax_cls_defs_all.select_columns');
END select_columns;
SELECT count(*)
INTO x_total
FROM zx_acct_tx_cls_defs_all
WHERE ledger_id = x_ledger_id
AND org_id = x_org_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_ORG_ID NUMBER,
X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
X_TAX_CLASS VARCHAR2,
X_TAX_CLASSIFICATION_CODE VARCHAR2,
X_ALLOW_TAX_CODE_OVERRIDE_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) IS
CURSOR C IS SELECT ROWID FROM ZX_ACCT_TX_CLS_DEFS_ALL
WHERE LEDGER_ID = X_LEDGER_ID
AND ORG_ID = X_ORG_ID;
INSERT INTO ZX_ACCT_TX_CLS_DEFS_ALL
(ledger_id,
org_id,
account_segment_value,
tax_class,
tax_classification_code,
allow_tax_code_override_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)
VALUES
(X_LEDGER_ID,
X_ORG_ID,
X_ACCOUNT_SEGMENT_VALUE,
X_TAX_CLASS,
X_TAX_CLASSIFICATION_CODE,
X_ALLOW_TAX_CODE_OVERRIDE_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);
END insert_row;
PROCEDURE update_row(
X_LEDGER_ID NUMBER,
X_ORG_ID NUMBER,
X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
X_TAX_CLASS VARCHAR2,
X_TAX_CLASSIFICATION_CODE VARCHAR2,
X_ALLOW_TAX_CODE_OVERRIDE_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_ACCOUNT_SEGMENT_VALUE_ORIG VARCHAR2,
X_TAX_CLASS_ORIG VARCHAR2) IS
BEGIN
UPDATE ZX_ACCT_TX_CLS_DEFS_ALL
SET ledger_id = X_LEDGER_ID,
org_id = X_ORG_ID,
account_segment_value = X_ACCOUNT_SEGMENT_VALUE,
tax_class = X_TAX_CLASS,
tax_classification_code = X_TAX_CLASSIFICATION_CODE,
allow_tax_code_override_flag = X_ALLOW_TAX_CODE_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 org_id = X_ORG_ID
AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE_ORIG
AND tax_class = X_TAX_CLASS_ORIG;
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) IS
CURSOR C IS
SELECT *
FROM ZX_ACCT_TX_CLS_DEFS_ALL
WHERE ledger_id = X_LEDGER_ID
AND org_id = X_ORG_ID
AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE
AND tax_class = X_TAX_CLASS
FOR UPDATE OF tax_classification_code NOWAIT;
FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');