1 PACKAGE IGI_ITR_FUNDS_CONTROL_PKG AS
2 -- $Header: igiitrhs.pls 120.6.12010000.2 2008/08/04 13:03:37 sasukuma ship $
3 Procedure Funds_Check_Reserve(
4 p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
5 p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
6 p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
7 p_reversal_amount IN igi_itr_charge_lines.entered_dr%type,
8 p_called_by IN varchar2, -- fundschecker(F)/approval(A)
9 p_return_message_name IN OUT NOCOPY varchar2,
10 p_calling_sequence IN varchar2);
11
12 Function Encumbrance_Enabled(
13 p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type) Return Boolean;
14
15 Procedure Bc_Packets_Insert(
16 p_packet_id IN gl_bc_packets.packet_id%type,
17 p_set_of_books_id IN gl_bc_packets.ledger_id%type,
18 p_ccid IN gl_bc_packets.code_combination_id%type,
19 p_amount IN gl_bc_packets.entered_dr%type,
20 p_period_year IN gl_bc_packets.period_year%type,
21 p_period_num IN gl_bc_packets.period_num%type,
22 p_quarter_num IN gl_bc_packets.quarter_num%type,
23 p_gl_user IN gl_bc_packets.last_updated_by%type,
24 p_enc_type_id IN gl_bc_packets.encumbrance_type_id%type,
25 p_ref2 IN gl_bc_packets.reference2%type,
26 p_ref4 IN gl_bc_packets.reference4%type,
27 p_ref5 IN gl_bc_packets.reference5%type,
28 p_je_source IN gl_bc_packets.je_source_name%type,
29 p_je_category IN gl_bc_packets.je_category_name%type,
30 p_actual_flag IN gl_bc_packets.actual_flag%type,
31 p_period_name IN gl_bc_packets.period_name%type,
32 p_base_currency_code IN gl_bc_packets.currency_code%type,
33 p_status_code IN gl_bc_packets.status_code%type,
34 p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,
35 p_status_flag IN igi_itr_charge_lines.status_flag%type,
36 p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,
37 p_charge_name IN igi_itr_charge_headers.name%type, --shsaxena for bug 2948237
38 -- p_description IN varchar2,
39 p_calling_sequence IN varchar2);
40
41 Procedure Setup_Gl_Fundschk_Params(
42 p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type,
43 p_mode IN OUT NOCOPY varchar2,
44 p_partial_resv_flag IN OUT NOCOPY varchar2,
45 p_called_by IN varchar2,
46 p_calling_sequence IN varchar2);
47
48 Procedure Fundscheck_Init(
49 p_chart_of_accounts_id IN OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%type,
50 p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
51 p_itr_enc_type_id IN OUT NOCOPY igi_itr_charge_setup.encumbrance_type_id%type,
52 p_gl_user_id IN OUT NOCOPY number,
53 p_calling_sequence IN varchar2);
54
55 Procedure Get_Gl_Fundschk_Packet_Id(
56 p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type);
57
58 END IGI_ITR_FUNDS_CONTROL_PKG;