PACKAGE: APPS.IGI_BUD

Source

1 PACKAGE IGI_BUD AUTHID CURRENT_USER AS
2 -- $Header: igibudas.pls 120.2.12000000.2 2007/08/01 08:40:56 pshivara ship $
3 /* ================================================================== */
4 FUNCTION is_number(P_CHAR VARCHAR2) RETURN NUMBER;
5 PRAGMA RESTRICT_REFERENCES(is_number,WNDS,WNPS);
6 /* ================================================================== */
7 FUNCTION bud_period_amount
8 		( p_annual_amount	NUMBER
9 		, p_period_number	NUMBER
10 		, p_start_period	NUMBER
11 		, p_profile_code	VARCHAR2
12 		, p_set_of_books_id	NUMBER
13 		, p_max_period_number   NUMBER
14 		)
15 RETURN NUMBER;
16 /* ================================================================== */
17 FUNCTION bud_profile_valid
18 		( p_set_of_books_id	NUMBER
19 		, p_profile_code	VARCHAR2
20 		)
21 RETURN boolean;
22 /* ================================================================== */
23 PROCEDURE bud_profile_insert
24 		( p_sob_id		NUMBER
25 		, p_batch_id		NUMBER
26 		, p_header_id		NUMBER
27 		, p_line_number		NUMBER
28 		, p_cc_id		NUMBER
29 		, p_profile_code	VARCHAR2
30 		, p_start_period	VARCHAR2
31 		, p_entered_dr		NUMBER
32 		, p_entered_cr		NUMBER
33 		, p_description		VARCHAR2
34 		, p_reason_code		VARCHAR2
35 		, p_recurring		VARCHAR2
36 		, p_effect		VARCHAR2
37 		, p_next_year_budget	NUMBER
38 		);
39 /* ================================================================== */
40 FUNCTION flexsql_select
41 		( p_appl_short_name		VARCHAR2
42 		, p_id_flex_code		VARCHAR2
43 		, p_id_flex_num			NUMBER
44 		, p_table_alias			VARCHAR2
45 		)
46 RETURN VARCHAR2;
47 /* ================================================================== */
48 FUNCTION flexsql_concat
49 		( p_appl_short_name		VARCHAR2
50 		, p_id_flex_code		VARCHAR2
51 		, p_id_flex_num			NUMBER
52 		, p_table_alias			VARCHAR2
53 		)
54 RETURN VARCHAR2;
55 /* ================================================================== */
56 FUNCTION flexsql_range
57 		( p_appl_short_name		VARCHAR2
58 		, p_id_flex_code		VARCHAR2
59 		, p_id_flex_num			NUMBER
60 		, p_single_table_alias		VARCHAR2
61 		, p_range_table_alias		VARCHAR2
62 		, p_not_between			VARCHAR2
63 		)
64 RETURN VARCHAR2;
65 /* ================================================================== */
66 PROCEDURE bud_profile_default
67 		( p_code_combination_id		NUMBER
68 		, p_set_of_books_id		NUMBER
69 		, p_new_profile_code		VARCHAR2
70 		);
71 /* ================================================================== */
72 PROCEDURE bud_next_year_budget
73 		( p_je_header_id		NUMBER
74 	  	, p_set_of_books_id		NUMBER
75 	  	, p_budget_version_id		NUMBER
76 	  	, p_currency_code		VARCHAR2
77 	  	, p_period_name			VARCHAR2
78 		);
79 /* ================================================================== */
80 END;	-- End of package header create