DBA Data[Home] [Help]

PACKAGE: APPS.GLIQAVG_PKG

Source


1 PACKAGE GLIQAVG_PKG AS
2 /* $Header: gliqavgs.pls 120.2 2005/05/05 01:19:01 kvora ship $ */
3 --
4 -- Package
5 --   GLIQAVG_pkg
6 -- Purpose
7 --   To contain database functions needed in Average Balance Inquiry form
8 -- History
9 --   01-10-96   Kevin CHEN	Created
10 
11 --
12 -- PUBLIC VARIABLES
13 --
14 	code_combination_id		NUMBER;
15 	template_id			NUMBER;
16 	factor				NUMBER := 1;
17 
18 --
19 -- PUBLIC PROCEDURES
20 --
21 
22   --
23   -- Procedure
24   -- 	set_ccid
25   -- PURPOSE
26   --	sets the code_combination_id for ar drill down
27   -- History:
28   --	01-10-96 Kevin CHEN Created
29   -- Arguments:
30   --	All the global values of this package
31   -- Notes:
32   --
33     	PROCEDURE set_ccid (X_code_combination_id     	NUMBER);
34 
35   --
36   -- Procedure
37   -- 	set_template_id
38   -- PURPOSE
39   --	sets the template_id for ar drill down
40   -- History:
41   --	01-10-96 Kevin CHEN Created
42   -- Arguments:
43   --	All the global values of this package
44   -- Notes:
45   --
46     	PROCEDURE set_template_id (X_template_id     	NUMBER);
47 
48   --
49   -- Procedure
50   -- 	set_factor
51   -- PURPOSE
52   --	sets the factor for drill down amounts
53   -- History:
54   --	01-12-96 Kevin CHEN Created
55   -- Arguments:
56   --	All the global values of this package
57   -- Notes:
58   --
59     	PROCEDURE set_factor (X_factor     	NUMBER);
60 
61   --
62   -- Procedure
63   --  	get_ccid
64   -- PURPOSE
65   --	gets the package (global) variable, USED in base view's where part
66   -- History:
67   -- 	01-10-96  Kevin CHEN Created
68   -- Notes
69   --
70 	FUNCTION	get_ccid	RETURN NUMBER;
71 	PRAGMA 		RESTRICT_REFERENCES(get_ccid,WNDS,WNPS);
72 
73   --
74   -- Procedure
75   --  	get_template_id
76   -- PURPOSE
77   --	gets the package (global) variable, USED in base view's where part
78   -- History:
79   -- 	01-10-96  Kevin CHEN Created
80   -- Notes
81   --
82 	FUNCTION	get_template_id	RETURN NUMBER;
83 	PRAGMA 		RESTRICT_REFERENCES(get_template_id,WNDS,WNPS);
84 
85   --
86   -- Procedure
87   --  	get_factor
88   -- PURPOSE
89   --	gets the package (global) variable, USED in base view's where part
90   -- History:
91   -- 	01-12-96  Kevin CHEN Created
92   -- Notes
93   --
94 	FUNCTION	get_factor	RETURN NUMBER;
95 	PRAGMA 		RESTRICT_REFERENCES(get_factor,WNDS,WNPS);
96 
97 END GLIQAVG_PKG;