[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE select_row( recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE ) IS
BEGIN
SELECT *
INTO recinfo
FROM gl_code_combinations
WHERE code_combination_id = recinfo.code_combination_id;
END select_row;
PROCEDURE select_columns(
X_code_combination_id NUMBER,
X_account_type IN OUT NOCOPY VARCHAR2,
X_template_id IN OUT NOCOPY NUMBER ) IS
recinfo gl_code_combinations%ROWTYPE;
select_row(recinfo);
END select_columns;
SELECT 'Duplicate'
FROM gl_code_combinations cc
WHERE cc.code_combination_id = x_ccid
AND ( x_rowid is NULL
OR
cc.rowid <> x_rowid );
SELECT st.ledger_id,
st.template_id
INTO new_ledger_id,
x_template_id
FROM gl_code_combinations cc,
gl_summary_templates st
WHERE cc.code_combination_id = x_ccid
AND st.template_id(+) = cc.template_id;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Code_Combination_Id NUMBER,
X_Alt_Code_Combination_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Chart_Of_Accounts_Id NUMBER,
X_Detail_Posting_F VARCHAR2,
X_Detail_Budgeting_F VARCHAR2,
X_Balanced_budgetF VARCHAR2,
X_Account_Type VARCHAR2,
X_Enabled_Flag VARCHAR2,
X_Summary_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_Segment21 VARCHAR2,
X_Segment22 VARCHAR2,
X_Segment23 VARCHAR2,
X_Segment24 VARCHAR2,
X_Segment25 VARCHAR2,
X_Segment26 VARCHAR2,
X_Segment27 VARCHAR2,
X_Segment28 VARCHAR2,
X_Segment29 VARCHAR2,
X_Segment30 VARCHAR2,
X_Description VARCHAR2,
X_Template_Id NUMBER,
X_Start_Date_Active DATE,
X_End_Date_Active DATE,
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_Context VARCHAR2,
X_Segment_Attribute1 VARCHAR2,
X_Segment_Attribute2 VARCHAR2,
X_Segment_Attribute3 VARCHAR2,
X_Segment_Attribute4 VARCHAR2,
X_Segment_Attribute5 VARCHAR2,
X_Segment_Attribute6 VARCHAR2,
X_Segment_Attribute7 VARCHAR2,
X_Segment_Attribute8 VARCHAR2,
X_Segment_Attribute9 VARCHAR2,
X_Segment_Attribute10 VARCHAR2,
X_Segment_Attribute11 VARCHAR2,
X_Segment_Attribute12 VARCHAR2,
X_Segment_Attribute13 VARCHAR2,
X_Segment_Attribute14 VARCHAR2,
X_Segment_Attribute15 VARCHAR2,
X_Segment_Attribute16 VARCHAR2,
X_Segment_Attribute17 VARCHAR2,
X_Segment_Attribute18 VARCHAR2,
X_Segment_Attribute19 VARCHAR2,
X_Segment_Attribute20 VARCHAR2,
X_Segment_Attribute21 VARCHAR2,
X_Segment_Attribute22 VARCHAR2,
X_Segment_Attribute23 VARCHAR2,
X_Segment_Attribute24 VARCHAR2,
X_Segment_Attribute25 VARCHAR2,
X_Segment_Attribute26 VARCHAR2,
X_Segment_Attribute27 VARCHAR2,
X_Segment_Attribute28 VARCHAR2,
X_Segment_Attribute29 VARCHAR2,
X_Segment_Attribute30 VARCHAR2,
X_Segment_Attribute31 VARCHAR2,
X_Segment_Attribute32 VARCHAR2,
X_Segment_Attribute33 VARCHAR2,
X_Segment_Attribute34 VARCHAR2,
X_Segment_Attribute35 VARCHAR2,
X_Segment_Attribute36 VARCHAR2,
X_Segment_Attribute37 VARCHAR2,
X_Segment_Attribute38 VARCHAR2,
X_Segment_Attribute39 VARCHAR2,
X_Segment_Attribute40 VARCHAR2,
X_Segment_Attribute41 VARCHAR2,
X_Segment_Attribute42 VARCHAR2,
X_Jgzz_Recon_Context VARCHAR2,
X_Jgzz_Recon_Flag VARCHAR2,
X_reference1 VARCHAR2,
X_reference2 VARCHAR2,
X_reference3 VARCHAR2,
X_reference4 VARCHAR2,
X_reference5 VARCHAR2,
X_preserve_flag VARCHAR2,
X_refresh_flag VARCHAR2
) IS
CURSOR C IS SELECT rowid FROM gl_code_combinations
WHERE code_combination_id = X_Code_Combination_Id;
INSERT INTO gl_code_combinations(
code_combination_id,
alternate_code_combination_id,
last_update_date,
last_updated_by,
chart_of_accounts_id,
detail_posting_allowed_flag,
detail_budgeting_allowed_flag,
igi_balanced_budget_flag,
account_type,
enabled_flag,
summary_flag,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30,
description,
template_id,
start_date_active,
end_date_active,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
context,
segment_attribute1,
segment_attribute2,
segment_attribute3,
segment_attribute4,
segment_attribute5,
segment_attribute6,
segment_attribute7,
segment_attribute8,
segment_attribute9,
segment_attribute10,
segment_attribute11,
segment_attribute12,
segment_attribute13,
segment_attribute14,
segment_attribute15,
segment_attribute16,
segment_attribute17,
segment_attribute18,
segment_attribute19,
segment_attribute20,
segment_attribute21,
segment_attribute22,
segment_attribute23,
segment_attribute24,
segment_attribute25,
segment_attribute26,
segment_attribute27,
segment_attribute28,
segment_attribute29,
segment_attribute30,
segment_attribute31,
segment_attribute32,
segment_attribute33,
segment_attribute34,
segment_attribute35,
segment_attribute36,
segment_attribute37,
segment_attribute38,
segment_attribute39,
segment_attribute40,
segment_attribute41,
segment_attribute42,
jgzz_recon_context,
jgzz_recon_flag,
reference1,
reference2,
reference3,
reference4,
reference5,
preserve_flag,
refresh_flag
) VALUES (
X_Code_Combination_Id,
X_Alt_Code_Combination_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Chart_Of_Accounts_Id,
X_Detail_Posting_F,
X_Detail_Budgeting_F,
X_Balanced_budgetF,
X_Account_Type,
X_Enabled_Flag,
X_Summary_Flag,
X_Segment1,
X_Segment2,
X_Segment3,
X_Segment4,
X_Segment5,
X_Segment6,
X_Segment7,
X_Segment8,
X_Segment9,
X_Segment10,
X_Segment11,
X_Segment12,
X_Segment13,
X_Segment14,
X_Segment15,
X_Segment16,
X_Segment17,
X_Segment18,
X_Segment19,
X_Segment20,
X_Segment21,
X_Segment22,
X_Segment23,
X_Segment24,
X_Segment25,
X_Segment26,
X_Segment27,
X_Segment28,
X_Segment29,
X_Segment30,
X_Description,
X_Template_Id,
X_Start_Date_Active,
X_End_Date_Active,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Context,
X_Segment_Attribute1,
X_Segment_Attribute2,
X_Segment_Attribute3,
X_Segment_Attribute4,
X_Segment_Attribute5,
X_Segment_Attribute6,
X_Segment_Attribute7,
X_Segment_Attribute8,
X_Segment_Attribute9,
X_Segment_Attribute10,
X_Segment_Attribute11,
X_Segment_Attribute12,
X_Segment_Attribute13,
X_Segment_Attribute14,
X_Segment_Attribute15,
X_Segment_Attribute16,
X_Segment_Attribute17,
X_Segment_Attribute18,
X_Segment_Attribute19,
X_Segment_Attribute20,
X_Segment_Attribute21,
X_Segment_Attribute22,
X_Segment_Attribute23,
X_Segment_Attribute24,
X_Segment_Attribute25,
X_Segment_Attribute26,
X_Segment_Attribute27,
X_Segment_Attribute28,
X_Segment_Attribute29,
X_Segment_Attribute30,
X_Segment_Attribute31,
X_Segment_Attribute32,
X_Segment_Attribute33,
X_Segment_Attribute34,
X_Segment_Attribute35,
X_Segment_Attribute36,
X_Segment_Attribute37,
X_Segment_Attribute38,
X_Segment_Attribute39,
X_Segment_Attribute40,
X_Segment_Attribute41,
X_Segment_Attribute42,
X_Jgzz_Recon_Context,
X_Jgzz_Recon_Flag,
X_reference1,
X_reference2,
X_reference3,
X_reference4,
X_reference5,
X_preserve_flag,
X_refresh_flag
);
END Insert_Row;
SELECT *
FROM gl_code_combinations
WHERE rowid = X_Rowid
FOR UPDATE of Code_Combination_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Code_Combination_Id NUMBER,
X_Alt_Code_Combination_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Chart_Of_Accounts_Id NUMBER,
X_Detail_Posting_F VARCHAR2,
X_Detail_Budgeting_F VARCHAR2,
X_Balanced_BudgetF VARCHAR2,
X_Account_Type VARCHAR2,
X_Enabled_Flag VARCHAR2,
X_Summary_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_Segment21 VARCHAR2,
X_Segment22 VARCHAR2,
X_Segment23 VARCHAR2,
X_Segment24 VARCHAR2,
X_Segment25 VARCHAR2,
X_Segment26 VARCHAR2,
X_Segment27 VARCHAR2,
X_Segment28 VARCHAR2,
X_Segment29 VARCHAR2,
X_Segment30 VARCHAR2,
X_Description VARCHAR2,
X_Template_Id NUMBER,
X_Start_Date_Active DATE,
X_End_Date_Active DATE,
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_Context VARCHAR2,
X_Segment_Attribute1 VARCHAR2,
X_Segment_Attribute2 VARCHAR2,
X_Segment_Attribute3 VARCHAR2,
X_Segment_Attribute4 VARCHAR2,
X_Segment_Attribute5 VARCHAR2,
X_Segment_Attribute6 VARCHAR2,
X_Segment_Attribute7 VARCHAR2,
X_Segment_Attribute8 VARCHAR2,
X_Segment_Attribute9 VARCHAR2,
X_Segment_Attribute10 VARCHAR2,
X_Segment_Attribute11 VARCHAR2,
X_Segment_Attribute12 VARCHAR2,
X_Segment_Attribute13 VARCHAR2,
X_Segment_Attribute14 VARCHAR2,
X_Segment_Attribute15 VARCHAR2,
X_Segment_Attribute16 VARCHAR2,
X_Segment_Attribute17 VARCHAR2,
X_Segment_Attribute18 VARCHAR2,
X_Segment_Attribute19 VARCHAR2,
X_Segment_Attribute20 VARCHAR2,
X_Segment_Attribute21 VARCHAR2,
X_Segment_Attribute22 VARCHAR2,
X_Segment_Attribute23 VARCHAR2,
X_Segment_Attribute24 VARCHAR2,
X_Segment_Attribute25 VARCHAR2,
X_Segment_Attribute26 VARCHAR2,
X_Segment_Attribute27 VARCHAR2,
X_Segment_Attribute28 VARCHAR2,
X_Segment_Attribute29 VARCHAR2,
X_Segment_Attribute30 VARCHAR2,
X_Segment_Attribute31 VARCHAR2,
X_Segment_Attribute32 VARCHAR2,
X_Segment_Attribute33 VARCHAR2,
X_Segment_Attribute34 VARCHAR2,
X_Segment_Attribute35 VARCHAR2,
X_Segment_Attribute36 VARCHAR2,
X_Segment_Attribute37 VARCHAR2,
X_Segment_Attribute38 VARCHAR2,
X_Segment_Attribute39 VARCHAR2,
X_Segment_Attribute40 VARCHAR2,
X_Segment_Attribute41 VARCHAR2,
X_Segment_Attribute42 VARCHAR2,
X_Jgzz_Recon_Context VARCHAR2,
X_Jgzz_Recon_Flag VARCHAR2,
X_reference1 VARCHAR2,
X_reference2 VARCHAR2,
X_reference3 VARCHAR2,
X_reference4 VARCHAR2,
X_reference5 VARCHAR2,
X_preserve_flag VARCHAR2,
X_refresh_flag VARCHAR2
) IS
old_enabled_flag VARCHAR2(1);
SELECT enabled_flag
INTO old_enabled_flag
FROM gl_code_combinations
WHERE rowid = X_rowid;
SELECT to_char(x_chart_of_accounts_id)||':'||
to_char(sysdate, 'RRDDDSSSSS')||':'||
to_char(x_code_combination_id)
INTO ekey
FROM dual;
UPDATE gl_code_combinations
SET
code_combination_id = X_Code_Combination_Id,
alternate_code_combination_id = X_Alt_Code_Combination_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
chart_of_accounts_id = X_Chart_Of_Accounts_Id,
detail_posting_allowed_flag = X_Detail_Posting_F,
detail_budgeting_allowed_flag = X_Detail_Budgeting_F,
igi_balanced_budget_flag = X_Balanced_BudgetF,
account_type = X_Account_Type,
enabled_flag = X_Enabled_Flag,
summary_flag = X_Summary_Flag,
segment1 = X_Segment1,
segment2 = X_Segment2,
segment3 = X_Segment3,
segment4 = X_Segment4,
segment5 = X_Segment5,
segment6 = X_Segment6,
segment7 = X_Segment7,
segment8 = X_Segment8,
segment9 = X_Segment9,
segment10 = X_Segment10,
segment11 = X_Segment11,
segment12 = X_Segment12,
segment13 = X_Segment13,
segment14 = X_Segment14,
segment15 = X_Segment15,
segment16 = X_Segment16,
segment17 = X_Segment17,
segment18 = X_Segment18,
segment19 = X_Segment19,
segment20 = X_Segment20,
segment21 = X_Segment21,
segment22 = X_Segment22,
segment23 = X_Segment23,
segment24 = X_Segment24,
segment25 = X_Segment25,
segment26 = X_Segment26,
segment27 = X_Segment27,
segment28 = X_Segment28,
segment29 = X_Segment29,
segment30 = X_Segment30,
description = X_Description,
template_id = X_Template_Id,
start_date_active = X_Start_Date_Active,
end_date_active = X_End_Date_Active,
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,
context = X_Context,
segment_attribute1 = X_Segment_Attribute1,
segment_attribute2 = X_Segment_Attribute2,
segment_attribute3 = X_Segment_Attribute3,
segment_attribute4 = X_Segment_Attribute4,
segment_attribute5 = X_Segment_Attribute5,
segment_attribute6 = X_Segment_Attribute6,
segment_attribute7 = X_Segment_Attribute7,
segment_attribute8 = X_Segment_Attribute8,
segment_attribute9 = X_Segment_Attribute9,
segment_attribute10 = X_Segment_Attribute10,
segment_attribute11 = X_Segment_Attribute11,
segment_attribute12 = X_Segment_Attribute12,
segment_attribute13 = X_Segment_Attribute13,
segment_attribute14 = X_Segment_Attribute14,
segment_attribute15 = X_Segment_Attribute15,
segment_attribute16 = X_Segment_Attribute16,
segment_attribute17 = X_Segment_Attribute17,
segment_attribute18 = X_Segment_Attribute18,
segment_attribute19 = X_Segment_Attribute19,
segment_attribute20 = X_Segment_Attribute20,
segment_attribute21 = X_Segment_Attribute21,
segment_attribute22 = X_Segment_Attribute22,
segment_attribute23 = X_Segment_Attribute23,
segment_attribute24 = X_Segment_Attribute24,
segment_attribute25 = X_Segment_Attribute25,
segment_attribute26 = X_Segment_Attribute26,
segment_attribute27 = X_Segment_Attribute27,
segment_attribute28 = X_Segment_Attribute28,
segment_attribute29 = X_Segment_Attribute29,
segment_attribute30 = X_Segment_Attribute30,
segment_attribute31 = X_Segment_Attribute31,
segment_attribute32 = X_Segment_Attribute32,
segment_attribute33 = X_Segment_Attribute33,
segment_attribute34 = X_Segment_Attribute34,
segment_attribute35 = X_Segment_Attribute35,
segment_attribute36 = X_Segment_Attribute36,
segment_attribute37 = X_Segment_Attribute37,
segment_attribute38 = X_Segment_Attribute38,
segment_attribute39 = X_Segment_Attribute39,
segment_attribute40 = X_Segment_Attribute40,
segment_attribute41 = X_Segment_Attribute41,
segment_attribute42 = X_Segment_Attribute42,
jgzz_recon_context = X_Jgzz_Recon_Context,
jgzz_recon_flag = X_Jgzz_Recon_Flag,
reference1 = X_reference1,
reference2 = X_reference2,
reference3 = X_reference3,
reference4 = X_reference4,
reference5 = X_reference5,
preserve_flag = X_preserve_flag,
refresh_flag = X_refresh_flag
WHERE rowid = X_rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM gl_code_combinations
WHERE rowid = X_Rowid;
END Delete_Row;
SELECT 'ccid exists'
FROM DUAL
WHERE EXISTS
(SELECT 'X'
FROM GL_NET_INCOME_ACCOUNTS
WHERE code_combination_id = X_CCID);
SELECT NVL(account_type, 'XXX'), NVL(summary_flag, 'XXX'),
NVL(template_id, -1), NVL(refresh_flag, 'N'),
NVL(preserve_flag, 'N'), enabled_flag
FROM GL_CODE_COMBINATIONS
WHERE code_combination_id = X_CCID;
SELECT to_char(x_coa_id)||':'||
to_char(sysdate, 'RRDDDSSSSS')||':'||
to_char(x_ccid)
INTO ekey
FROM dual;