PACKAGE: APPS.GL_CONS_WRK_PKG

Source

1 PACKAGE GL_CONS_WRK_PKG AS
2 /* $Header: glcowrks.pls 120.5 2005/05/05 02:02:57 kvora ship $ */
3 --
4 -- Package
5 --   GL_CONS_WRK_pkg
6 -- Purpose
7 --   To contain database functions needed in Consolidation Workbench form
8 -- History
9 --   04-03-97   Kevin Chen	Created
10 
11 --
12 -- PUBLIC VARIABLES
13 --
14 	period			VARCHAR2(15);
15 	access_set_id		NUMBER;
16 
17   --
18   -- Procedure
19   -- set_data
20   --  PURPOSE sets ALL the package (global) variables
21   -- History: 04-03-97 Kevin Chen Created
22   --          07-18-02 Michael Ward changed sob_id to ledger_id
23   --          01-09-03 Michael Ward changed ledger_id to access_set_id
24   -- Arguments: All the global values of this package
25   -- Notes:
26 
27     PROCEDURE set_data (X_period     	VARCHAR2,
28 			X_access_set_id	NUMBER);
29 
30   --
31   -- Procedure
32   -- get_period
33   --  PURPOSE get period name
34   -- History: 04-03-97 Kevin Chen Created
35   -- Arguments: None
36   -- Notes:
37 
38     FUNCTION get_period RETURN VARCHAR2;
39     PRAGMA 		RESTRICT_REFERENCES(get_period,WNDS,WNPS);
40 
41   --
42   -- Procedure
43   -- get_access_set_id
44   --  PURPOSE get access set id
45   -- History: 04-03-97 Kevin Chen Created
46   --          07-18-02 Michael Ward Changed sob_id to ledger_id
47   --          01-09-03 Michael Ward Changed ledger_id to access_set_id
48   -- Arguments: None
49   -- Notes:
50 
51     FUNCTION get_access_set_id RETURN NUMBER;
52     PRAGMA 		RESTRICT_REFERENCES(get_access_set_id,WNDS,WNPS);
53 
54   --
55   -- Procedure
56   -- submit_request
57   --  PURPOSE to submit concurrent request
58   -- History: 04-03-97 Kevin Chen Created
59   --          07-18-02 Michael Ward Changed sob_id to ledger_id
60   --          05-07-03 Michael Ward Added parameters
61   -- Arguments:
62   --	average_translation_flag VARCHAR2(1),
63   --	ledger_id		 NUMBER,
64   --	currency_code		 VARCHAR2(15),
65   -- 	period			 VARCHAR2(15),
66   --	balancing_segment_value	 VARCHAR2(25),
67   --	source_budget_version_id NUMBER,
68   --	target_budget_version_id NUMBER,
69   --	access_set_id		 NUMBER,
70   --    chart_of_accounts_id	 NUMBER,
71   --	avg_rate_type		 VARCHAR2(30),
72   --    eop_rate_type		 VARCHAR2(30),
73   --	ledger_short_name	 VARCHAR2(20)
74   -- Notes:
75 
76     FUNCTION submit_request (
77 	X_average_translation_flag 	VARCHAR2,
78 	X_ledger_id			NUMBER,
79 	X_currency_code		 	VARCHAR2,
80 	X_period			VARCHAR2,
81 	X_balance_type			VARCHAR2,
82 	X_balancing_segment_value	VARCHAR2,
83 	X_source_budget_version_id 	NUMBER,
84 	X_target_budget_version_id 	NUMBER,
85 	X_access_set_id			NUMBER,
86 	X_chart_of_accounts_id		NUMBER,
87 	X_avg_rate_type			VARCHAR2,
88 	X_eop_rate_type			VARCHAR2,
89 	X_ledger_short_name		VARCHAR2) RETURN NUMBER;
90 
91   --
92   -- Function
93   -- get_translation_status
94   --  PURPOSE to get translation status of a consolidation
95   -- History: 06-06-97 Kevin Chen Created
96   --          07-18-02 Michael Ward Changed sob_id to ledger_id
97   -- Arguments:
98   --	ledger_id		 NUMBER,
99   --    period_name   		 VARCHAR2(15),
100   --	currency_code		 VARCHAR2(15),
101   -- 	actual_flag		 VARCHAR2(1)
102   -- Notes:
103    FUNCTION get_translation_status (
104 	X_ledger_id		 NUMBER,
105         X_period_name   		 VARCHAR2,
106   	X_currency_code		 VARCHAR2,
107    	X_actual_flag		 VARCHAR2) RETURN VARCHAR2;
108 
109 END GL_CONS_WRK_PKG;