1 PACKAGE cn_global_var AS
2 -- $Header: cnsygin1s.pls 120.1 2005/07/06 18:47:42 appldev ship $
3 --
4 -- Package Name
5 -- cn
6 -- Purpose
7 -- This package is used to initialize global variables for the 'current'
8 -- commissions instance
9 --
10 -- History
11 -- 16-JUN-94 P Cook Created
12 -- 08-MAY-95 P Cook Added srp_batch_size
13 -- 19-SEP-95 P Cook Added currency code
14 -- 05-MAR-02 S Venkat Replace global variable g_srp_batch_size with function g_srp_batch_size
15 -- 30-May-02 S Venkat Bring g_salesrep_batch_size/package name change(cn_global_var) in sync
16
17 -- Define global variables
18 g_curr_period_name VARCHAR2(30) ;
19 g_repository_id NUMBER ;
20 g_rev_class_hierarchy_id NUMBER ;
21 g_srp_rollup_hierarchy_id NUMBER ;
22 g_curr_period_id NUMBER ;
23 g_curr_period_start_date DATE ;
24 g_curr_period_end_date DATE ;
25 g_system_batch_size NUMBER ;
26 g_transfer_batch_size NUMBER ;
27 g_srp_rollup_flag VARCHAR2(1) ;
28 g_curr_prd_rev_class_hier_id NUMBER ;
29 g_curr_prd_srp_rollup_hier_id NUMBER ;
30 -- g_srp_batch_size NUMBER ;
31 g_cls_package_size NUMBER ;
32 -- g_salesrep_batch_size NUMBER ;
33 g_system_start_period_id NUMBER ;
34 g_system_start_date DATE ;
35 g_set_of_books_id NUMBER ;
36 gl_currency_code VARCHAR2(15) ;
37 g_precision NUMBER;
38 g_ext_precision NUMBER;
39 g_min_acct_unit NUMBER;
40
41 --
42 -- Global record type
43 --
44 TYPE attribute_rec_type IS RECORD
45 (attribute_category VARCHAR2(30) := NULL,
46 attribute1 VARCHAR2(150) := NULL,
47 attribute2 VARCHAR2(150) := NULL,
48 attribute3 VARCHAR2(150) := NULL,
49 attribute4 VARCHAR2(150) := NULL,
50 attribute5 VARCHAR2(150) := NULL,
51 attribute6 VARCHAR2(150) := NULL,
52 attribute7 VARCHAR2(150) := NULL,
53 attribute8 VARCHAR2(150) := NULL,
54 attribute9 VARCHAR2(150) := NULL,
55 attribute10 VARCHAR2(150) := NULL,
56 attribute11 VARCHAR2(150) := NULL,
57 attribute12 VARCHAR2(150) := NULL,
58 attribute13 VARCHAR2(150) := NULL,
59 attribute14 VARCHAR2(150) := NULL,
60 attribute15 VARCHAR2(150) := NULL
61 );
62
63 G_MISS_ATTRIBUTE_REC attribute_rec_type;
64
65 --
66 -- Procedure Name
67 -- instance_info
68 -- Purpose
69 -- Retrieve global variables and pass them thru parameters
70 -- Used when accessing globals from sqlforms.
71 --
72 -- Notes
73 --
74 -- History
75 -- 16-JUN-94 P Cook Created
76 --
77 /*
78 PROCEDURE instance_info(x_repository_id OUT NOCOPY NUMBER ,
79 x_rev_class_hierarchy_id OUT NOCOPY NUMBER ,
80 x_srp_rollup_hierarchy_id OUT NOCOPY NUMBER ,
81 x_curr_period_id OUT NOCOPY NUMBER ,
82 x_curr_period_name IN OUT NOCOPY VARCHAR2 ,
83 x_curr_period_start_date OUT NOCOPY DATE ,
84 x_curr_period_end_date OUT NOCOPY DATE ,
85 x_system_batch_size OUT NOCOPY NUMBER ,
86 x_transfer_batch_size OUT NOCOPY NUMBER ,
87 x_srp_rollup_flag IN OUT NOCOPY VARCHAR2 ,
88 x_curr_prd_rev_class_hier_id OUT NOCOPY NUMBER ,
89 x_curr_prd_srp_rollup_hier_id OUT NOCOPY NUMBER ,
90 x_srp_batch_size OUT NOCOPY NUMBER ,
91 x_cls_package_size OUT NOCOPY NUMBER ,
92 x_system_start_period_id OUT NOCOPY NUMBER ,
93 x_system_start_date OUT NOCOPY DATE ,
94 x_currency_code OUT NOCOPY VARCHAR2 );
95
96 */
97
98 FUNCTION get_currency_code(p_org_id IN NUMBER) RETURN VARCHAR2;
99
100 --new method included by Sundar Venkat on 05 March 2002
101 --this function replaces the existing global variable g_srp_batch_size
102 --this is used in posting_details
103 FUNCTION get_srp_batch_size(p_org_id IN NUMBER) RETURN NUMBER;
104 FUNCTION get_salesrep_batch_size(p_org_id IN NUMBER) RETURN NUMBER;
105
106 PROCEDURE initialize_instance_info(p_org_id IN NUMBER);
107
108
109 END cn_global_var;