[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;