[Home] [Help]
PACKAGE: APPS.IGC_CC_ACCGNWF_PKG
Source
1 PACKAGE IGC_CC_ACCGNWF_PKG AUTHID CURRENT_USER AS
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,
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 ,
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 ,
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
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,
44
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER ,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50 --
51 END IGC_CC_ACCGNWF_PKG;