PACKAGE: APPS.GCS_TEMPLATES_PKG

Source

1 PACKAGE GCS_TEMPLATES_PKG AS
2 /* $Header: gcstemps.pls 120.1 2005/10/30 05:19:10 appldev noship $ */
3 
4 
5 --
6 -- Exceptions
7 --
8   -- This generic exception will be raised by the procedure if the balancing
9   -- fails. A message will already have been written.
10   GCS_TMP_BALANCING_FAILED	EXCEPTION;
11 
12 --
13 -- Types
14 --
15   TYPE TemplateRecord IS RECORD (
16     financial_elem_id	NUMBER,
17     product_id		NUMBER,
18     natural_account_id	NUMBER,
19     channel_id		NUMBER,
20     line_item_id	NUMBER,
21     project_id		NUMBER,
22     customer_id		NUMBER,
23     task_id		NUMBER,
24     user_dim1_id	NUMBER,
25     user_dim2_id	NUMBER,
26     user_dim3_id	NUMBER,
27     user_dim4_id	NUMBER,
28     user_dim5_id	NUMBER,
29     user_dim6_id	NUMBER,
30     user_dim7_id	NUMBER,
31     user_dim8_id	NUMBER,
32     user_dim9_id	NUMBER,
33     user_dim10_id	NUMBER
34 );
35 
36 --
37 -- Package
38 --   gcs_templates_pkg
39 -- Purpose
40 --   Package procedures for template-based calculations
41 -- History
42 --   22-DEC-03	M Ward		Created
43 --
44 
45    PROCEDURE create_dynamic_pkg (
46       x_errbuf   IN              VARCHAR2,
47       x_retcode  IN              VARCHAR2
48    );
49 
50   --
51   -- Procedure
52   --   get_dimension_template
53   -- Purpose
54   --   Get the specified template of a hierarchy.
55   -- Arguments
56   --   p_hierarchy_id		ID of the hierarchy
57   --   p_template_code		'RE' (Retained Earnings) or 'SUSPENSE'
58   --   p_balance_type_code	Balance type of the consolidation
59   --   p_template_record        Record to hold the template retrieved
60   -- Example
61   --   GCS_TEMPLATES_PKG.get_dimension_template(1000, 'RE', 'ADB', l_template);
62   -- Notes
63   --
64   PROCEDURE get_dimension_template(
65 	p_hierarchy_id		NUMBER,
66 	p_template_code		VARCHAR2,
67 	p_balance_type_code	VARCHAR2,
68 	p_template_record	OUT NOCOPY TemplateRecord);
69 END GCS_TEMPLATES_PKG;