1 PACKAGE igs_fi_prc_acct_pkg AS
2 /* $Header: IGSFI60S.pls 120.2 2005/07/27 08:50:40 appldev ship $ */
3
4 /*******************************************************************************
5 Created by : rbezawad
6 Date created : 19-Jul-2001
7 Purpose : This procedure generates debit and credit account pairs for
8 Charge and Credit Transactions.
9
10 Known limitations/enhancements/remarks:
11
12 Change History: (who, when, what: NO CREATION RECORDS HERE!)
13 Who When What
14 gurprsin 27-Jul-2005 Bug# 3392095 Tuition Waiver build, Added Waiver_Name in build_accounts procedure.
15 bannamal 03-JUN-2005 Bug#3442712 Unit Level Fee Assessment Build
16 Added new parameters unit_type_id, unit_class,
17 unit_mode, unit_level in procedure build_accounts.
18 vchappid 19-May-2003 Build Bug# 2831572, Financial Accounting Enhancements
19 Added Attendance Type, Attendance Mode and Residency Status parameters
20 agairola 17-May-2002 For bug fix 2323555, modified the Build Account
21 procedure - made the account codes as IN OUT NOCOPY
22
23 *******************************************************************************/
24 PROCEDURE build_accounts(
25 p_fee_type IN VARCHAR2,
26 p_fee_cal_type IN VARCHAR2,
27 p_fee_ci_sequence_number IN NUMBER,
28 p_course_cd IN VARCHAR2,
29 p_course_version_number IN NUMBER,
30 p_org_unit_cd IN VARCHAR2,
31 p_org_start_dt IN DATE,
32 p_unit_cd IN VARCHAR2,
33 p_unit_version_number IN NUMBER,
34 p_uoo_id IN NUMBER,
35 p_location_cd IN VARCHAR2,
36 p_transaction_type IN VARCHAR2,
37 p_credit_type_id IN NUMBER,
38 p_source_transaction_id IN NUMBER,
39 x_dr_gl_ccid IN OUT NOCOPY NUMBER,
40 x_cr_gl_ccid IN OUT NOCOPY NUMBER,
41 x_dr_account_cd IN OUT NOCOPY VARCHAR2,
42 x_cr_account_cd IN OUT NOCOPY VARCHAR2,
43 x_err_type OUT NOCOPY NUMBER,
44 x_err_string OUT NOCOPY VARCHAR2,
45 x_ret_status OUT NOCOPY BOOLEAN,
46 p_v_attendance_type IN VARCHAR2 DEFAULT NULL,
47 p_v_attendance_mode IN VARCHAR2 DEFAULT NULL,
48 p_v_residency_status_cd IN VARCHAR2 DEFAULT NULL,
49 p_n_unit_type_id IN NUMBER DEFAULT NULL,
50 p_v_unit_class IN VARCHAR2 DEFAULT NULL,
51 p_v_unit_mode IN VARCHAR2 DEFAULT NULL,
52 p_v_unit_level IN VARCHAR2 DEFAULT NULL,
53 p_v_waiver_name IN VARCHAR2 DEFAULT NULL
54 );
55
56 END igs_fi_prc_acct_pkg;