PACKAGE: APPS.IGC_CBC_INQUIRY_PKG

Source

1 PACKAGE IGC_CBC_INQUIRY_PKG AUTHID CURRENT_USER 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;