1 PACKAGE igc_cbc_po_grp AS
2 -- $Header: IGCBCPOS.pls 120.6.12010000.2 2008/08/04 14:48:30 sasukuma ship $
3 --
4 --
5 --
6 -- PUBLIC ROUTINES
7 --
8 --
9
10 /*==========================================================================
11 Function Get_Fiscal_Year
12 ===========================================================================*/
13
14 FUNCTION Get_Fiscal_Year( p_date IN DATE
15 ,p_sob_id IN NUMBER)
16 RETURN number;
17
18 /*==========================================================================
19 Procedure IS_CBC_ENABLED
20 ===========================================================================*/
21
22 PROCEDURE is_cbc_enabled( p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
25 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,x_cbc_enabled OUT NOCOPY VARCHAR2);
30
31
32 /*=========================================================================
33 Procedure CBC_HEADER_VALIDATIONS
34 ==========================================================================*/
35
36 PROCEDURE cbc_header_validations ( p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
38 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
39 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 ,p_document_id IN NUMBER
44 ,p_document_type IN VARCHAR2
45 ,p_document_sub_type IN VARCHAR2);
46
47 /*=========================================================================
48 Procedure VALID_CBC_ACCT_DATE
49 ==========================================================================*/
50
51 PROCEDURE valid_cbc_acct_date(p_api_version IN NUMBER
52 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
54 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 ,p_document_id IN NUMBER
59 ,p_document_type IN VARCHAR2
60 ,p_document_sub_type IN VARCHAR2
61 ,p_cbc_acct_date IN DATE);
62
63 /*=========================================================================
64 Procedure GET_CBC_ACCT_UPDATE
65 ==========================================================================*/
66
67 PROCEDURE get_cbc_acct_date(p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
69 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
70 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2
74 ,p_document_id IN NUMBER
75 ,p_document_type IN VARCHAR2
76 ,p_document_sub_type IN VARCHAR2
77 ,p_default IN VARCHAR2
78 ,x_cbc_acct_date OUT NOCOPY DATE );
79
80 /*========================================================================
81 Procedure UPDATE_CBC_ACCT_DATE
82 =========================================================================*/
83
84 PROCEDURE update_cbc_acct_date(p_api_version IN NUMBER
85 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
86 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,p_document_id IN NUMBER
92 ,p_document_type IN VARCHAR2
93 ,p_document_sub_type IN VARCHAR2
94 ,p_cbc_acct_date IN DATE);
95
96 /*========================================================================
97 Procedure GL_DATE_ROLL_FORWARD
98 =========================================================================*/
99
100 PROCEDURE gl_date_roll_forward( p_api_version IN NUMBER
101 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
102 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
103 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
104 ,x_return_status OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 ,p_document_id IN VARCHAR2
108 ,p_document_type IN VARCHAR2
109 ,p_document_sub_type IN VARCHAR2
110 ,p_line_id IN VARCHAR2 := NULL
111 ,p_line_location_id IN VARCHAR2 := NULL
112 ,p_action_date IN DATE
113 ,p_cancel_req IN VARCHAR2 );
114
115
116 -- Package variable to store if CBC is enabled or not.
117 -- This variable is used when the procedures are invoked through forms.
118 g_is_cbc_po_enabled VARCHAR2(1);
119
120 -- FUnction to return the package variable to the forms and librarires
121 FUNCTION cbc_po_enabled_flag
122 RETURN VARCHAR2;
123
124 -- Package variable to store if the User has clicked on 'Cancel'
125 -- on the Dual funds Check form IGCDFCHK
126 g_fundchk_cancel_flag VARCHAR2(1);
127
128 -- Function to set the package variable to the forms and librarires
129 PROCEDURE set_fundchk_cancel_flag (p_value IN VARCHAR2);
130
131 -- Function to get the package variable to the forms and librarires
132 FUNCTION fundchk_cancel_flag
133 RETURN VARCHAR2;
134
135 END igc_cbc_po_grp;
136