[Home] [Help]
PACKAGE: APPS.GL_ELIM_GEN_PKG
Source
1 PACKAGE GL_ELIM_GEN_PKG AUTHID CURRENT_USER AS
2 /* $Header: glelgens.pls 120.4 2005/05/05 02:03:48 kvora ship $ */
3 --
4 -- Package
5 -- GL_ELIM_GEN_pkg
6 -- Purpose
7 -- To contain database functions needed in Generate Elimination Sets form
8 -- History
9 --
10
11 --
12 -- PUBLIC VARIABLES
13 --
14 period_start_date DATE;
15 period_end_date DATE;
16
17 --
18 -- Procedure
19 -- set_data
20 -- PURPOSE
21 -- sets ALL the package (global) variables
22 -- History
23 -- 05-NOV-98 Maria Hui Created
24 -- Arguments
25 -- All the global values of this package
26 -- Notes
27 --
28
29 PROCEDURE set_data ( X_period_start DATE,
30 X_period_end DATE);
31
32 --
33 -- Procedure
34 -- get_period_start_date
35 -- PURPOSE
36 -- get the start date of the period
37 -- History
38 -- 05-NOV-98 Maria Hui Created
39 -- Arguments
40 -- None
41 -- Notes
42 --
43
44 FUNCTION get_period_start_date RETURN DATE;
45 PRAGMA RESTRICT_REFERENCES(get_period_start_date,WNDS,WNPS);
46
47
48 --
49 -- Procedure
50 -- get_period_end_date
51 -- PURPOSE
52 -- get the end date of the period
53 -- History
54 -- 05-NOV-98 Maria Hui Created
55 -- Arguments
56 -- None
57 -- Notes
58 --
59
60 FUNCTION get_period_end_date RETURN DATE;
61 PRAGMA RESTRICT_REFERENCES(get_period_end_date,WNDS,WNPS);
62
63
64 --
65 -- Procedure
66 -- insert_elim_history
67 -- PURPOSE
68 -- to create default rows for the generated elimination sets in
69 -- GL_ELIMINATION_HISTORY
70 -- History
71 -- 10-NOV-98 Maria Hui Created
72 -- 05-NOV-02 Jane Huang replaced set_of_books_id with ledger_id
73 -- Arguments
74 -- None
75 -- Notes
76 --
77
78 PROCEDURE insert_elim_history(
79 X_request_id NUMBER,
80 X_elimination_set_id NUMBER,
81 X_ledger_id NUMBER,
82 X_period_name VARCHAR2
83 );
84
85
86 --
87 -- Procedure
88 -- save_to_elim_hist
89 -- PURPOSE
90 -- to commit changes made to GL_ELIMINATION_HISTORY
91 -- History
92 -- 12-NOV-98 Maria Hui Created
93 -- Arguments
94 -- None
95 -- Notes
96 --
97
98 PROCEDURE save_to_elim_hist;
99
100 ----------------------------------------------------------------------------
101 --
102 -- Procedure
103 -- submit_request
104 -- PURPOSE to submit concurrent request
105 -- History:
106 -- 04-03-97 Kevin Chen Created
107 -- Arguments:
108 -- average_translation_flag VARCHAR2(1),
109 -- set_of_books_id NUMBER,
110 -- currency_code VARCHAR2(15),
111 -- period VARCHAR2(15),
112 -- balancing_segment_value VARCHAR2(25),
113 -- source_budget_version_id NUMBER,
114 -- target_budget_version_id NUMBER
115 -- Notes:
116
117 -- FUNCTION submit_request (
118 -- X_average_translation_flag VARCHAR2,
119 -- X_set_of_books_id NUMBER,
120 -- X_currency_code VARCHAR2,
121 -- X_period VARCHAR2,
122 -- X_balance_type VARCHAR2,
123 -- X_balancing_segment_value VARCHAR2,
124 -- X_source_budget_version_id NUMBER,
125 -- X_target_budget_version_id NUMBER) RETURN NUMBER;
126
127 END GL_ELIM_GEN_PKG;