2: /* $Header: IGCCAGNS.pls 120.3.12000000.2 2007/10/18 15:48:09 vumaasha ship $ */
3:
4: PROCEDURE Generate_Account
5: (
6: p_project_id IN igc_cc_acct_lines.project_id%TYPE ,
7: p_task_id IN igc_cc_acct_lines.task_id%TYPE ,
8: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE ,
9: p_expenditure_organization_id IN igc_cc_acct_lines.expenditure_org_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
3:
4: PROCEDURE Generate_Account
5: (
6: p_project_id IN igc_cc_acct_lines.project_id%TYPE ,
7: p_task_id IN igc_cc_acct_lines.task_id%TYPE ,
8: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE ,
9: p_expenditure_organization_id IN igc_cc_acct_lines.expenditure_org_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
11: p_vendor_id IN NUMBER,
4: PROCEDURE Generate_Account
5: (
6: p_project_id IN igc_cc_acct_lines.project_id%TYPE ,
7: p_task_id IN igc_cc_acct_lines.task_id%TYPE ,
8: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE ,
9: p_expenditure_organization_id IN igc_cc_acct_lines.expenditure_org_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
11: p_vendor_id IN NUMBER,
12: p_chart_of_accounts_id IN NUMBER,
5: (
6: p_project_id IN igc_cc_acct_lines.project_id%TYPE ,
7: p_task_id IN igc_cc_acct_lines.task_id%TYPE ,
8: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE ,
9: p_expenditure_organization_id IN igc_cc_acct_lines.expenditure_org_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
11: p_vendor_id IN NUMBER,
12: p_chart_of_accounts_id IN NUMBER,
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
6: p_project_id IN igc_cc_acct_lines.project_id%TYPE ,
7: p_task_id IN igc_cc_acct_lines.task_id%TYPE ,
8: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE ,
9: p_expenditure_organization_id IN igc_cc_acct_lines.expenditure_org_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
11: p_vendor_id IN NUMBER,
12: p_chart_of_accounts_id IN NUMBER,
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
10: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,
11: p_vendor_id IN NUMBER,
12: p_chart_of_accounts_id IN NUMBER,
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
11: p_vendor_id IN NUMBER,
12: p_chart_of_accounts_id IN NUMBER,
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
12: p_chart_of_accounts_id IN NUMBER,
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
13: p_gen_budget_account IN VARCHAR2, /* 'Y' or 'N' */
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
14: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
15: p_cc_header_id IN igc_cc_acct_lines.cc_header_id%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
16: p_cc_charge_ccid IN igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
17: p_cc_budget_ccid IN igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
18: p_cc_acct_desc IN igc_cc_acct_lines.cc_acct_desc%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
19: p_cc_acct_taxable_flag IN igc_cc_acct_lines.cc_acct_taxable_flag%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
20: p_tax_name IN igc_cc_acct_lines.tax_classif_code%TYPE , /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
21: p_context IN igc_cc_acct_lines.context%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
22: p_attribute1 IN igc_cc_acct_lines.attribute1%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
23: p_attribute2 IN igc_cc_acct_lines.attribute2%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
24: p_attribute3 IN igc_cc_acct_lines.attribute3%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
25: p_attribute4 IN igc_cc_acct_lines.attribute4%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
26: p_attribute5 IN igc_cc_acct_lines.attribute5%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
27: p_attribute6 IN igc_cc_acct_lines.attribute6%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
28: p_attribute7 IN igc_cc_acct_lines.attribute7%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
29: p_attribute8 IN igc_cc_acct_lines.attribute8%TYPE ,
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
30: p_attribute9 IN igc_cc_acct_lines.attribute9%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
38: x_out_charge_ccid OUT NOCOPY igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
31: p_attribute10 IN igc_cc_acct_lines.attribute10%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
38: x_out_charge_ccid OUT NOCOPY igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
39: x_out_budget_ccid OUT NOCOPY igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
32: p_attribute11 IN igc_cc_acct_lines.attribute11%TYPE ,
33: p_attribute12 IN igc_cc_acct_lines.attribute12%TYPE ,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
38: x_out_charge_ccid OUT NOCOPY igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
39: x_out_budget_ccid OUT NOCOPY igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
40: x_out_charge_account_flex OUT NOCOPY VARCHAR2,
34: p_attribute13 IN igc_cc_acct_lines.attribute13%TYPE ,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
38: x_out_charge_ccid OUT NOCOPY igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
39: x_out_budget_ccid OUT NOCOPY igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
40: x_out_charge_account_flex OUT NOCOPY VARCHAR2,
41: x_out_budget_account_flex OUT NOCOPY VARCHAR2,
42: x_out_charge_account_desc OUT NOCOPY VARCHAR2,
35: p_attribute14 IN igc_cc_acct_lines.attribute14%TYPE ,
36: p_attribute15 IN igc_cc_acct_lines.attribute15%TYPE ,
37:
38: x_out_charge_ccid OUT NOCOPY igc_cc_acct_lines.cc_charge_code_combination_id%TYPE ,
39: x_out_budget_ccid OUT NOCOPY igc_cc_acct_lines.cc_budget_code_combination_id%TYPE ,
40: x_out_charge_account_flex OUT NOCOPY VARCHAR2,
41: x_out_budget_account_flex OUT NOCOPY VARCHAR2,
42: x_out_charge_account_desc OUT NOCOPY VARCHAR2,
43: x_out_budget_account_desc OUT NOCOPY VARCHAR2,