[Home] [Help]
PACKAGE: APPS.XDP_PARAM_CACHE
Source
1 PACKAGE XDP_PARAM_CACHE AUTHID CURRENT_USER AS
2 /* $Header: XDPPACHS.pls 120.1 2005/06/16 02:15:53 appldev $ */
3
4 g_FAParam varchar2(10) := 'FA';
5 g_WIParam varchar2(10) := 'WI';
6
7 pv_workitem_instance_id number := null;
8 pv_workitem_id number := null;
9
10 pv_fa_instance_id number := null;
11 pv_fa_id number := null;
12
13 TYPE XDP_PARAM IS RECORD
14 (
15 parameter_name VARCHAR2(40),
16 parameter_value VARCHAR2(4000),
17 parameter_ref_value VARCHAR2(4000) DEFAULT NULL,
18 log_flag varchar2(1),
19 evaluation_mode varchar2(80),
20 evaluation_proc varchar2(80),
21 default_value varchar2(4000)
22 );
23
24 TYPE XDP_PARAM_LIST IS TABLE OF XDP_PARAM
25 INDEX BY BINARY_INTEGER;
26
27 cursor c_GetWiParams is
28 SELECT
29 parameter_name,
30 log_in_audit_trail_flag,
31 validation_procedure,
32 evaluation_mode,
33 evaluation_procedure,
34 default_value
35 FROM
36 xdp_wi_parameters
37 WHERE
38 workitem_id = pv_workitem_id;
39
40 cursor c_GetWiParamConfig (p_param_name varchar2) is
41 SELECT
42 log_in_audit_trail_flag,
43 validation_procedure,
44 evaluation_mode,
45 evaluation_procedure,
46 default_value
47 FROM
48 xdp_wi_parameters
49 WHERE
50 workitem_id = pv_workitem_id AND
51 parameter_name = p_param_name;
52
53 cursor c_GetWiConfig (p_wi_instance_id number) is
54 SELECT
55 wim.wi_type_code,
56 wim.fa_exec_map_proc,
57 wim.workitem_name,
58 wim.workitem_id,
59 wim.user_wf_item_type,
60 wim.user_wf_item_key_prefix,
61 wim.user_wf_process_name,
62 wim.wf_exec_proc
63 FROM
64 xdp_workitems wim,
65 xdp_fulfill_worklist fwt
66 WHERE
67 wim.workitem_id = fwt.workitem_id AND
68 fwt.workitem_instance_id = p_wi_instance_id;
69
70 pv_workitem_name varchar2(80) := null;
71 pv_workitem_type varchar2(80) := null;
72
73 pv_wi_eval_proc_name varchar2(80) := null;
74
75 pv_wi_item_type varchar2(8) := null;
76 pv_wi_process_name varchar2(80) := null;
77 pv_wi_key_prefix varchar2(80) := null;
78
79 pv_wi_param_list XDP_PARAM_LIST;
80
81 pv_fa_name varchar2(80) := null;
82 pv_fe_routing_proc varchar2(80) := null;
83
84 pv_fa_param_list XDP_PARAM_LIST;
85
86 cursor c_GetFaConfig (p_fa_instance_id number) is
87 SELECT
88 xfa.fulfillment_action_id,
89 xfa.fulfillment_action,
90 xfa.fe_routing_proc
91 FROM
92 xdp_fulfill_actions xfa,
93 xdp_fa_runtime_list frl
94 WHERE
95 xfa.fulfillment_action_id = frl.fulfillment_action_id AND
96 frl.fa_instance_id = p_fa_instance_id;
97
98 cursor c_GetFAParams is
99 SELECT
100 parameter_name,
101 log_in_audit_trail_flag,
102 evaluation_procedure,
103 default_value
104 FROM
105 xdp_fa_parameters
106 WHERE
107 fulfillment_action_id = pv_fa_id;
108
109 cursor c_GetFAParamConfig (p_param_name varchar2) is
110 SELECT
111 log_in_audit_trail_flag,
112 evaluation_procedure,
113 default_value
114 FROM
115 xdp_fa_parameters
116 WHERE
117 fulfillment_action_id = pv_fa_id AND
118 parameter_name = p_param_name;
119
120
121 -- Public Routines
122
123 Procedure clear_cache;
124 Procedure init_cache(p_wi_instance_id number,
125 p_load_param_config in boolean default TRUE);
126
127 Procedure init_cache(p_wi_instance_id number,
128 p_wi_param_list in varchar2,
129 p_load_param_config in boolean default TRUE);
130
131 Procedure init_cache(p_wi_instance_id number,
132 p_fa_instance_id number,
133 p_load_param_config in boolean default TRUE);
134
135 Procedure Add_wi_param_to_cache(
136 p_param_name in varchar2,
137 p_param_value in varchar2,
138 p_param_ref_value in varchar2 default null,
139 p_log_flag in varchar2 default null,
140 p_evaluation_mode in varchar2 default null,
141 p_evaluation_proc in varchar2 default null,
142 p_default_value in varchar2 default null,
143 p_update_db in varchar2 default 'Y');
144
145 Procedure Get_WI_param_from_cache(p_param_name in varchar2,
146 p_exists_in_cache OUT NOCOPY varchar2,
147 p_param_value OUT NOCOPY varchar2,
148 p_param_ref_value OUT NOCOPY varchar2,
149 p_log_flag OUT NOCOPY varchar2,
150 p_evaluation_mode OUT NOCOPY varchar2,
151 p_evaluation_proc OUT NOCOPY varchar2,
152 p_default_value OUT NOCOPY varchar2);
153
154 Procedure Get_FA_param_from_cache(p_param_name in varchar2,
155 p_exists_in_cache OUT NOCOPY varchar2,
156 p_param_value OUT NOCOPY varchar2,
157 p_log_flag OUT NOCOPY varchar2,
158 p_evaluation_proc OUT NOCOPY varchar2,
159 p_default_value OUT NOCOPY varchar2);
160
161 Procedure remove_from_cache(p_param_type in varchar2,
162 p_param_name in varchar2);
163
164 end XDP_PARAM_CACHE;