PACKAGE: APPS.CSTPUTIL

Source

1 PACKAGE CSTPUTIL AS
2 /* $Header: CSTPUTIS.pls 120.1 2006/02/11 16:25:10 rthng noship $ */
3 
4 -- PROCEDURE
5 --  CSTPUGCI		Return Currency Information
6 --
7 -- INPUT PARAMETERS
8 --  I_ORG_ID		Organization id
9 --
10 -- RETURN VALUES
11 --  O_ROUND_UNIT	Rounding Unit - extension of min acct unit, e.g.
12 --			ROUND(number/O_ROUND_UNIT)*O_ROUND_UNIT
13 --  O_PRECISION	Regular precision
14 --  O_EXT_PREC		Extended precision
15 --
16 
17 PROCEDURE CSTPUGCI (
18 	 I_ORG_ID		IN	NUMBER,
19 	 O_ROUND_UNIT		OUT NOCOPY	NUMBER,
20 	 O_PRECISION		OUT NOCOPY	NUMBER,
21 	 O_EXT_PREC		OUT NOCOPY	NUMBER);
22 
23 /*=====================================================================+
24  | PROCEDURE
25  |   DO_SQL
26  |
27  | PURPOSE
28  |   Executes a dynamic SQL statement
29  |
30  | ARGUMENTS
31  |   p_sql_stmt   String holding sql statement.  May be up to 8K long.
32  |
33  | EXCEPTIONS
34  |
35  | NOTES
36  |
37  +=====================================================================*/
38   procedure do_sql(p_sql_stmt in varchar2);
39   Procedure execute_insert_CIT(
40                              p_view_name IN varchar2,
41                              p_cost_org_id IN NUMBER,
42                              p_ct_id       IN NUMBER,
43                              p_item_id     IN NUMBER,
44                              p_app_col_name IN VARCHAR2,
45                              p_flex        IN NUMBER);
46 
47 END CSTPUTIL;