[Home] [Help]
PACKAGE: APPS.XLA_CMP_HASH_PKG
Source
1 PACKAGE xla_cmp_hash_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacphsh.pkh 120.7 2005/06/29 21:50:12 wychan ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_cmp_hash_pkg |
10 | |
11 | DESCRIPTION |
12 | This is a XLA private package, which contains all the logic required |
13 | to generate condition expressions from AMB specifcations |
14 | |
15 | |
16 | HISTORY |
17 | 25-JUL-2002 K.Boussema Created |
18 | 11-FEB-2003 K.Boussema Added Drop package API |
19 | 18-FEB-2003 K.Boussema Added Hash product rule code API |
20 | 18-MAR-2003 K.Boussema Added amb_context_code column |
21 | 21-JAN-2003 K.Boussema Renamed the package generated by the compiler|
22 | from XLA%PAD%PKG to XLA%AAD%PKG |
23 | 24-JUN-2005 K.Boussema Removed the InsertPADHashId() procedure |
24 +===========================================================================*/
25 --
26 /*======================================================================+
27 | Global constant |
28 | |
29 | package name template where, |
30 | |
31 | id1 -> application_id |
32 | id2 -> product rule type code |
33 | id3 -> product rule id |
34 | |
35 +======================================================================*/
36
37 C_PACKAGE_NAME CONSTANT VARCHAR2(30):= 'XLA_$id1$_AAD_$id2$_$id3$_PKG';
38 --
39 --
40 --
41 /*======================================================================+
42 | |
43 | Public Function |
44 | |
45 | BuildPackageName |
46 | |
47 | Build a package name |
48 | |
49 | Parameters |
50 | 1 IN p_application_id NUMBER application id |
51 | 2 IN p_product_rule_code VARCHAR2 product rule |
52 | 3 IN p_product_rule_type_code VARCHAR2 product rule type |
53 | 4 IN p_amb_context_code VARCHAR2 AMB context |
54 +======================================================================*/
55 FUNCTION BuildPackageName (p_application_id IN NUMBER
56 ,p_product_rule_code IN VARCHAR2
57 ,p_product_rule_type_code IN VARCHAR2
58 ,p_amb_context_code IN VARCHAR2
59 )
60 RETURN VARCHAR2
61 ;
62 --
63 --
64
65 --
66 /*======================================================================+
67 | |
68 | Public |
69 | |
70 | DropPadPkg |
71 | |
72 | Drop PAD package for the current application,product rule code, |
73 | , product rule type code |
74 | |
75 | Parameters: |
76 | 1 IN p_application_id NUMBER application id |
77 | 2 IN p_product_rule_code VARCHAR2 product rule |
78 | 3 IN p_product_rule_type_code VARCHAR2 product rule type |
79 | 4 IN p_amb_context_code VARCHAR2 AMB context |
80 +======================================================================*/
81 PROCEDURE DropPadPkg ( p_application_id IN NUMBER
82 ,p_product_rule_code IN VARCHAR2
83 ,p_product_rule_type_code IN VARCHAR2
84 ,p_amb_context_code IN VARCHAR2
85 )
86 ;
87 /*======================================================================+
88 | |
89 | Public Function |
90 | |
91 | DropPadPkg |
92 | |
93 | Drop PAD package for the current application,product rule code, |
94 | , product rule type code |
95 | |
96 | Parameters: |
97 | 1 IN p_application_id NUMBER application id |
98 | 2 IN p_product_rule_code VARCHAR2 product rule |
99 | 3 IN p_product_rule_type_code VARCHAR2 product rule type |
100 | 4 IN p_amb_context_code VARCHAR2 AMB context |
101 +======================================================================*/
102 FUNCTION DropPadPkg ( p_application_id IN NUMBER
103 ,p_product_rule_code IN VARCHAR2
104 ,p_product_rule_type_code IN VARCHAR2
105 ,p_amb_context_code IN VARCHAR2
106 )
107 RETURN BOOLEAN
108 ;
109 --
110 --
111 /*======================================================================+
112 | |
113 | Public Function |
114 | |
115 | GetPADHashId |
116 | |
117 | Determines the product hash id associated to the current product rule |
118 | code, returns a number |
119 | |
120 | Parameters: |
121 | 1 IN p_product_rule_code VARCHAR2 product rule |
122 | 42 IN p_amb_context_code VARCHAR2 AMB context |
123 +======================================================================*/
124 --
125 FUNCTION GetPADHashId (p_product_rule_code IN VARCHAR2
126 ,p_amb_context_code IN VARCHAR2
127 ,p_application_id IN INTEGER
128 ,p_product_rule_type_code IN VARCHAR2)
129 RETURN NUMBER
130 ;
131
132 --
133 END xla_cmp_hash_pkg; -- end of package spec