[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(X_Rowid IN OUT NOCOPY VARCHAR2,
X_fsc_cls_id NUMBER,
X_fiscal_classification_code VARCHAR2,
X_tax_category_id NUMBER,
X_tax_code VARCHAR2,
X_end_date_active DATE,
X_base_rate NUMBER,
X_start_date_active DATE,
X_org_id NUMBER,
X_enabled_flag VARCHAR2,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_creation_date DATE,
X_created_by NUMBER,
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_calling_sequence VARCHAR2) IS
CURSOR C IS
SELECT rowid
FROM JL_ZZ_AR_TX_FSC_CLS
WHERE fiscal_classification_code = X_fiscal_classification_code
AND tax_category_id = X_tax_category_id
AND end_date_active = X_end_date_active;
current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,
fiscal_classification_code,
tax_category_id,
tax_code,
end_date_active,
base_rate,
start_date_active,
enabled_flag,
org_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES (X_fsc_cls_id,
X_fiscal_classification_code,
X_tax_category_id,
X_tax_code,
X_end_date_active,
X_base_rate,
X_start_date_active,
X_enabled_flag,
X_org_id,
X_last_update_date,
X_last_updated_by,
X_creation_date,
X_created_by,
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;
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_creation_date DATE,
X_created_by NUMBER,
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_calling_sequence VARCHAR2) IS
CURSOR C IS
SELECT FSC_CLS_ID,
FISCAL_CLASSIFICATION_CODE,
TAX_CATEGORY_ID,
TAX_CODE,
END_DATE_ACTIVE,
ENABLED_FLAG,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
BASE_RATE,
START_DATE_ACTIVE,
ORG_ID,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM JL_ZZ_AR_TX_FSC_CLS
WHERE rowid = X_Rowid
FOR UPDATE of fiscal_classification_code,
tax_category_id,
end_date_active,
org_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row
(X_Rowid VARCHAR2,
X_fsc_cls_id NUMBER,
X_fiscal_classification_code VARCHAR2,
X_tax_category_id NUMBER,
X_tax_code VARCHAR2,
X_end_date_active DATE,
X_base_rate NUMBER,
X_start_date_active DATE,
X_org_id NUMBER,
X_enabled_flag VARCHAR2,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_creation_date DATE,
X_created_by NUMBER,
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_calling_sequence VARCHAR2) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
X_calling_sequence;
debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
UPDATE JL_ZZ_AR_TX_FSC_CLS
SET fsc_cls_id = X_fsc_cls_id,
fiscal_classification_code = X_fiscal_classification_code,
tax_category_id = X_tax_category_id,
end_date_active = X_end_date_active,
tax_code = X_tax_code,
base_rate = X_base_rate,
start_date_active = X_start_date_active,
enabled_flag = X_enabled_flag,
last_update_date = X_last_update_date,
last_updated_by = X_last_updated_by,
creation_date = X_creation_date,
created_by = X_created_by,
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 rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row
(X_Rowid VARCHAR2,
X_calling_sequence VARCHAR2) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
X_calling_sequence;
debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
DELETE FROM JL_ZZ_AR_TX_FSC_CLS
WHERE rowid = X_Rowid;
END Delete_Row;
SELECT COUNT(1)
INTO l_dummy
FROM jl_zz_ar_tx_fsc_cls
WHERE fiscal_classification_code = X_fiscal_classification_code
AND tax_category_id = X_tax_category_id
AND end_date_active = X_end_date_active
AND org_id = X_org_id
AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
SELECT COUNT(1)
INTO l_dummy
FROM jl_zz_ar_tx_fsc_cls a
WHERE a.fiscal_classification_code = X_fiscal_classification_code
AND a.tax_category_id = X_tax_category_id
AND ((a.end_date_active <= X_end_date_active AND
a.end_date_active >= X_start_date_active) OR
(a.start_date_active <= X_end_date_active AND
a.start_date_active >= X_start_date_active) OR
(a.start_date_active <= X_start_date_active AND
a.end_date_active >= X_end_date_active))
AND org_id = X_org_id
AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
SELECT COUNT(1)
INTO l_dummy
FROM jl_zz_ar_tx_fsc_cls a
WHERE a.fiscal_classification_code = X_fiscal_classification_code
AND a.tax_category_id = X_tax_category_id
AND trunc(a.end_date_active) = (trunc(X_start_date_active) -1)
AND org_id = X_org_id
AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
SELECT COUNT(1)
INTO l_dummy1
FROM jl_zz_ar_tx_fsc_cls a
WHERE a.fiscal_classification_code = X_fiscal_classification_code
AND a.tax_category_id = X_tax_category_id
AND (trunc(a.start_date_active) = (trunc(X_end_date_active) + 1))
AND org_id = X_org_id
AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
SELECT COUNT(1)
INTO l_dummy2
FROM jl_zz_ar_tx_fsc_cls a
WHERE a.fiscal_classification_code = X_fiscal_classification_code
AND a.tax_category_id = X_tax_category_id
AND org_id = X_org_id
AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
PROCEDURE Update_Category
(X_category_id NUMBER,
X_structure_id NUMBER,
X_disable_date DATE,
X_web_status VARCHAR2,
X_supplier_enabled_flag VARCHAR2,
X_segment1 VARCHAR2,
X_segment2 VARCHAR2,
X_segment3 VARCHAR2,
X_segment4 VARCHAR2,
X_segment5 VARCHAR2,
X_segment6 VARCHAR2,
X_segment7 VARCHAR2,
X_segment8 VARCHAR2,
X_segment9 VARCHAR2,
X_segment10 VARCHAR2,
X_segment11 VARCHAR2,
X_segment12 VARCHAR2,
X_segment13 VARCHAR2,
X_segment14 VARCHAR2,
X_segment15 VARCHAR2,
X_segment16 VARCHAR2,
X_segment17 VARCHAR2,
X_segment18 VARCHAR2,
X_segment19 VARCHAR2,
X_segment20 VARCHAR2,
X_summary_flag VARCHAR2,
X_enabled_flag VARCHAR2,
X_start_date_active DATE,
X_end_date_active DATE,
X_description VARCHAR2,
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_calling_sequence VARCHAR2) IS
l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||
X_calling_sequence;
debug_info := 'calling INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY';
INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY
(
P_API_VERSION => l_api_version,
P_INIT_MSG_LIST => FND_API.G_FALSE,
P_COMMIT => FND_API.G_FALSE,
X_RETURN_STATUS => l_return_status,
X_ERRORCODE => l_errorcode,
X_MSG_COUNT => l_msg_count,
X_MSG_DATA => l_msg_data,
P_CATEGORY_REC => l_category_rec
);
END Update_Category;