[Home] [Help]
PACKAGE: APPS.IGC_CBC_INQUIRY_PKG
Source
1 PACKAGE IGC_CBC_INQUIRY_PKG AS
2 /* $Header: IGCINQRS.pls 120.2.12000000.1 2007/08/20 12:15:26 mbremkum ship $ */
3
4 PROCEDURE Initialize
5 (
6 p_amount_type IN VARCHAR2,
7 p_period_cutoff IN gl_periods.period_name%TYPE,
8 p_set_of_books_id IN gl_period_statuses.set_of_books_id%TYPE,
9 p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
10 );
11
12 FUNCTION Check_Amount_Type
13 (p_period_name IN gl_periods.period_name%TYPE,
14 p_period_year IN gl_periods.period_year%TYPE,
15 p_quarter_num IN gl_periods.quarter_num%TYPE,
16 p_period_num IN gl_periods.period_num%TYPE,
17 p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,
18 p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
19 ) RETURN VARCHAR2 ;
20
21 PRAGMA RESTRICT_REFERENCES(Check_Amount_Type,RNDS,WNDS,WNPS);
22
23 FUNCTION Get_Amount_Type RETURN VARCHAR2;
24
25 PRAGMA RESTRICT_REFERENCES(Get_Amount_Type,RNDS,WNDS,WNPS);
26
27
28 FUNCTION Get_Period_Name RETURN VARCHAR2;
29
30 PRAGMA RESTRICT_REFERENCES(Get_Period_Name,RNDS,WNDS,WNPS);
31
32 FUNCTION Get_FC_Balances(
33 p_mode IN VARCHAR2,
34 p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35 p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36 p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37 p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38 p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39 p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40 p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41 p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42 p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43 p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
44 )
45 RETURN NUMBER;
46 PRAGMA RESTRICT_REFERENCES(Get_FC_Balances,WNDS,WNPS,RNPS);
47
48
49 END IGC_CBC_INQUIRY_PKG;