1 PACKAGE GCS_PERIOD_INIT_DYNAMIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcspinds.pls 120.2 2006/09/08 00:29:03 skamdar noship $ */
3 --
4 -- Package
5 -- gcs_period_init_dynamic_pkg
6 -- Purpose
7 -- Package procedures for the Period Initialization Dynamic Program
8 -- History
9 -- 04-MAR-04 T Cheng Created
10 -- Notes
11 -- The package body is created by gcs_period_init_dyn_build_pkg.
12 --
13
14 --
15 -- PUBLIC FUNCTIONS
16 --
17
18 --
19 -- Procedure
20 -- insert_entry_lines
21 -- Purpose
22 -- Create entry lines for the one-item next-period-initialization entry
23 -- and the recurring rules-carry-forward entry if applicable.
24 -- Arguments
25 -- p_run_name Name of the consolidation run
26 -- p_hierarchy_id ID of the hierarchy consolidation is run for
27 -- p_entity_id ID of the entity
28 -- p_currency_code Currency code of the entity
29 -- p_bal_by_org The balance by org flag of the hierarchy
30 -- p_sec_track_col The secondary tracking column of the hierarchy
31 -- p_is_elim_entity If it is an elimination entity (Y/N)
32 -- p_cons_entity_id Id of the consolidation entity
33 -- p_re_template The retained earnings dimension template
34 -- p_cross_year_flag Indicates if it is a cross-year processing
35 -- p_category_code The category code for the entries
36 -- p_init_entry_id Currency entry ID for next-period initialization
37 -- p_init_xlate_entry_id Parent currency entry ID for next-period init.
38 -- p_init_stat_entry_id STAT entry ID for next-period initialization
39 -- p_recur_entry_id Currency entry ID for carry-forward
40 -- p_recur_xlate_entry_id Parent currency entry ID for carry-forward
41 -- p_recur_stat_entry_id STAT entry ID for carry-forward
42 -- Bugfix 5449718: Added parameter for calendar period year
43 -- p_cal_period_year Year for Current Period Being Consolidated
44 -- p_net_to_re_flag Flag Stating If Category Nets to Retained Earnings
45 -- Example
46 -- GCS_PERIOD_INIT_DYNAMIC_PKG.insert_entry_lines
47 -- ('Name', 1, 2, 3, 'USD', 'Y', null, 'N', 10, l_re_template,
48 -- 'N', 'INTERCOMPANY', 7777, 7778, 7779, null, null, null);
49 -- Notes
50 --
51 PROCEDURE insert_entry_lines(
52 p_run_name VARCHAR2,
53 p_hierarchy_id NUMBER,
54 p_entity_id NUMBER,
55 p_currency_code VARCHAR2,
56 p_bal_by_org VARCHAR2,
57 p_sec_track_col VARCHAR2,
58 p_is_elim_entity VARCHAR2,
59 p_cons_entity_id NUMBER,
60 p_re_template GCS_TEMPLATES_PKG.TemplateRecord,
61 p_cross_year_flag VARCHAR2,
62 p_category_code VARCHAR2,
63 p_init_entry_id NUMBER,
64 p_init_xlate_entry_id NUMBER,
65 p_init_stat_entry_id NUMBER,
66 p_recur_entry_id NUMBER,
67 p_recur_xlate_entry_id NUMBER,
68 p_recur_stat_entry_id NUMBER,
69 p_cal_period_year NUMBER,
70 p_net_to_re_flag VARCHAR2);
71
72 END GCS_PERIOD_INIT_DYNAMIC_PKG;