PACKAGE: APPS.GCS_TEMPLATES_DYNAMIC_PKG

Source

1 PACKAGE GCS_TEMPLATES_DYNAMIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcstempdyns.pls 120.1 2005/10/30 05:19:12 appldev noship $ */
3 --
4 -- Package
5 --   GCS_TEMPLATES_DYNAMIC_PKG
6 -- Purpose
7 --   Package procedures for the Data Preparation Engine Program
8 -- History
9 --   08-Dec-03 Ying Liu    Created
10 --
11 
12   --
13   -- Procedure
14   --   Balance
15   -- Purpose
16   --   Balances the entry in question with the template specified.
17   -- Arguments
18   --   p_entry_header_id	Entry with the information to be balanced.
19   --   p_template_record	Template of the balancing dimension account.
20   --   p_bal_type_code		The balance type of the consolidation.
21   --   p_hierarchy_id		The hierarchy on which the consolidation is
22   --				being run.
23   --   p_entity_id		The entity on which the consolidation is
24   --				being run.
25   --   p_threshold		Threshold under which you should balance. If
26   --				the amount of difference is over the threshold
27   --				then an exception will be raised.
28   -- Example
29   --   GCS_TEMPLATES_PKG.Balance(1, cta_temp)
30   -- Notes
31   --
32   PROCEDURE Balance(
33 	p_entry_id      	NUMBER,
34 	p_template		GCS_TEMPLATES_PKG.TemplateRecord,
35 	p_bal_type_code		VARCHAR2,
36 	p_hierarchy_id		NUMBER,
37 	p_entity_id		NUMBER,
38 	p_threshold		NUMBER	DEFAULT 0,
39         p_threshold_currency_code  VARCHAR2 DEFAULT NULL
40 );
41 
42 
43    -- PROCEDURE
44    --   calculate_re
45    -- Purpose
46    --   Retained Earnings Calculation
47    -- Arguments
48    --   p_entry_id     Entry Identifier
49    --   p_hierarchy_id     Hierarchy Identifier
50    --   p_bal_type_code     Balance Type Code: 'ACTUAL' or 'ADB'
51    --   p_entity_id    Entity Identifer
52    -- Notes
53    --
54       PROCEDURE calculate_re (
55       p_entry_id        NUMBER,
56       p_hierarchy_id    NUMBER,
57       p_bal_type_code   VARCHAR2,
58       p_entity_id       NUMBER,
59       p_data_prep_flag  VARCHAR2 DEFAULT 'N'
60    );
61 
62    PROCEDURE calculate_dp_re (
63       p_entry_id        NUMBER,
64       p_hierarchy_id    NUMBER,
65       p_bal_type_code   VARCHAR2,
66       p_entity_id       NUMBER,
67       p_pre_cal_period_id    NUMBER,
68       p_first_ever_data_prep    VARCHAR2
69    );
70 
71 END GCS_TEMPLATES_DYNAMIC_PKG;