[Home] [Help]
22: and session_id = session_id_param;
23: cursor l_get_custom_list_csr(appl_id_param number, custom_code_param varchar2) is
24: select ac.customization_application_id, ac.customization_code,
25: ac.region_application_id, ac.region_code
26: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
27: where ac.region_application_id = appl_id_param
28: and ac.region_code like custom_code_param
29: and ac.region_application_id = ar.region_application_id
30: and ac.region_code = ar.region_code;
30: and ac.region_code = ar.region_code;
31: cursor l_get_custom_resp_list_csr(appl_id_param number, custom_code_param varchar2, levelpk number) is
32: select ac.customization_application_id, ac.customization_code,
33: ac.region_application_id, ac.region_code
34: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
35: where ac.region_application_id = appl_id_param
36: and ac.region_code like custom_code_param
37: and ac.region_application_id = ar.region_application_id
38: and ac.region_code = ar.region_code
39: and ac.responsibility_id = levelpk;
40: cursor l_get_custom_resp_list2_csr(appl_id_param number, custom_code_param varchar2) is
41: select ac.customization_application_id, ac.customization_code,
42: ac.region_application_id, ac.region_code
43: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
44: where ac.region_application_id = appl_id_param
45: and ac.region_code like custom_code_param
46: and ac.region_application_id = ar.region_application_id
47: and ac.region_code = ar.region_code
48: and ac.responsibility_id is not null;
49: cursor l_get_custom_org_list_csr(appl_id_param number, custom_code_param varchar2, levelpk number) is
50: select ac.customization_application_id, ac.customization_code,
51: ac.region_application_id, ac.region_code
52: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
53: where ac.region_application_id = appl_id_param
54: and ac.region_code like custom_code_param
55: and ac.region_application_id = ar.region_application_id
56: and ac.region_code = ar.region_code
57: and ac.org_id = levelpk;
58: cursor l_get_custom_org_list2_csr(appl_id_param number, custom_code_param varchar2) is
59: select ac.customization_application_id, ac.customization_code,
60: ac.region_application_id, ac.region_code
61: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
62: where ac.region_application_id = appl_id_param
63: and ac.region_code like custom_code_param
64: and ac.region_application_id = ar.region_application_id
65: and ac.region_code = ar.region_code
66: and ac.org_id is not null;
67: cursor l_get_custom_fun_list_csr(appl_id_param number, custom_code_param varchar2, levelpk varchar2) is
68: select ac.customization_application_id, ac.customization_code,
69: ac.region_application_id, ac.region_code
70: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
71: where ac.region_application_id = appl_id_param
72: and ac.region_code like custom_code_param
73: and ac.region_application_id = ar.region_application_id
74: and ac.region_code = ar.region_code
75: and ac.function_name = levelpk;
76: cursor l_get_custom_fun_list2_csr(appl_id_param number, custom_code_param varchar2) is
77: select ac.customization_application_id, ac.customization_code,
78: ac.region_application_id, ac.region_code
79: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
80: where ac.region_application_id = appl_id_param
81: and ac.region_code like custom_code_param
82: and ac.region_application_id = ar.region_application_id
83: and ac.region_code = ar.region_code
84: and ac.function_name is not null;
85: cursor l_get_custom_local_list_csr(appl_id_param number, custom_code_param varchar2, levelpk varchar2) is
86: select ac.customization_application_id, ac.customization_code,
87: ac.region_application_id, ac.region_code
88: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
89: where ac.region_application_id = appl_id_param
90: and ac.region_code like custom_code_param
91: and ac.region_application_id = ar.region_application_id
92: and ac.region_code = ar.region_code
93: and ac.localization_code = levelpk;
94: cursor l_get_custom_local_list2_csr(appl_id_param number, custom_code_param varchar2) is
95: select ac.customization_application_id, ac.customization_code,
96: ac.region_application_id, ac.region_code
97: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
98: where ac.region_application_id = appl_id_param
99: and ac.region_code like custom_code_param
100: and ac.region_application_id = ar.region_application_id
101: and ac.region_code = ar.region_code
102: and ac.localization_code is not null;
103: cursor l_get_custom_site_list_csr(appl_id_param number, custom_code_param varchar2, levelpk number) is
104: select ac.customization_application_id, ac.customization_code,
105: ac.region_application_id, ac.region_code
106: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
107: where ac.region_application_id = appl_id_param
108: and ac.region_code like custom_code_param
109: and ac.region_application_id = ar.region_application_id
110: and ac.region_code = ar.region_code
111: and ac.site_id = levelpk;
112: cursor l_get_custom_site_list2_csr(appl_id_param number, custom_code_param varchar2) is
113: select ac.customization_application_id, ac.customization_code,
114: ac.region_application_id, ac.region_code
115: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
116: where ac.region_application_id = appl_id_param
117: and ac.region_code like custom_code_param
118: and ac.region_application_id = ar.region_application_id
119: and ac.region_code = ar.region_code
130: select instr(objectpk,'%')
131: from dual;
132: cursor l_get_like_region_csr (appl_id_param number, region_code_param varchar2) is
133: select region_application_id, region_code
134: from ak_regions
135: where region_application_id = appl_id_param
136: and region_code like region_code_param;
137: cursor l_get_like_flow_csr (appl_id_param number, flow_code_param varchar2) is
138: select flow_application_id, flow_code