1 PACKAGE igf_db_disb AUTHID CURRENT_USER AS
2 /* $Header: IGFDB01S.pls 115.9 2003/12/04 15:48:12 sjadhav ship $ */
3
4 -----------------------------------------------------------------------------------
5 --
6 -- Created By : mesriniv
7 -- Date Created By : 2000/12/15
8 -- Purpose : To Create the Actual Disbursement
9 -- Records for Awards
10 --
11 -- Known Limitations,Enhancements or Remarks
12 -- Change History :
13 -----------------------------------------------------------------------------------
14 -- sjadhav 3-Dec-2003 FA 131 Build changes, Bug 3252832
15 -- Removed chk_att_result
16 -----------------------------------------------------------------------------------
17 -- Bug No: 2154941
18 -- sjadhav,Jan 07,2002
19 -- 1. Addition of Run For,Student ID , Person Group, Log Detail Parameters
20 --
21 -----------------------------------------------------------------------------------
22
23 -- This is the callable from Concurrent Manager
24
25 PROCEDURE disb_process(errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_award_year IN VARCHAR2,
28 p_run_for IN VARCHAR2,
29 p_per_grp_id IN NUMBER,
30 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
31 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
32 p_log_det IN VARCHAR2 DEFAULT 'N',
33 p_org_id IN NUMBER
34 );
35
36 --
37 -- Parameters
38 --
39 -- p_award_year Award Year
40 -- p_run_for Run For ( P - Person Group, S - Student, F - Fund )
41 -- p_per_grp_id Person Group ID
42 -- p_base_id Base ID
43 -- p_fund_id Fund ID
44 -- p_log_det Log Detail ( Y - Yes , N - No )
45 -- p_org_id Org ID
46
47
48 -- This process is executed via Online Disbursement on Disbursement Detail Screens
49
50 PROCEDURE process_student( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
51 p_result IN OUT NOCOPY VARCHAR2,
52 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE DEFAULT NULL,
53 p_award_id IN igf_aw_award_all.award_id%TYPE DEFAULT NULL,
54 p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL
55 );
56
57
58 -- Process to Cancel Disbursements
59 -- Row ID is from igf_aw_awd_disb_all table
60
61 PROCEDURE revert_disb ( p_row_id IN ROWID,
62 p_flag IN VARCHAR2,
63 p_fund_type IN VARCHAR2);
64
65
66 END igf_db_disb;