eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AK_CUSTOM_PVT dependencies on AK_REGIONS

Line 62: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

58: ) is
59: cursor l_get_custom_list_csr (application_id number, p_region_code varchar2) is
60: select ac.customization_application_id, ac.customization_code,
61: ac.region_application_id, ac.region_code
62: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
63: where ac.REGION_APPLICATION_ID = application_id
64: and ac.REGION_CODE = p_region_code
65: and ac.region_application_id = ar.region_application_id
66: and ac.region_code = ar.region_code;

Line 70: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

66: and ac.region_code = ar.region_code;
67: cursor l_get_custom_resp_list_csr (application_id number, p_region_code varchar2, levelpk number) 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 = application_id
72: and ac.REGION_CODE = p_region_code
73: and ac.region_application_id = ar.region_application_id
74: and ac.region_code = ar.region_code

Line 79: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

75: and ac.responsibility_id = levelpk;
76: cursor l_get_custom_resp_list2_csr (application_id number, p_region_code 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 = application_id
81: and ac.REGION_CODE = p_region_code
82: and ac.region_application_id = ar.region_application_id
83: and ac.region_code = ar.region_code

Line 88: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

84: and ac.responsibility_id is not null;
85: cursor l_get_custom_org_list_csr (application_id number, p_region_code varchar2, levelpk number) 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 = application_id
90: and ac.REGION_CODE = p_region_code
91: and ac.region_application_id = ar.region_application_id
92: and ac.region_code = ar.region_code

Line 97: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

93: and ac.org_id = levelpk;
94: cursor l_get_custom_org_list2_csr (application_id number, p_region_code 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 = application_id
99: and ac.REGION_CODE = p_region_code
100: and ac.region_application_id = ar.region_application_id
101: and ac.region_code = ar.region_code

Line 106: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

102: and ac.org_id is not null;
103: cursor l_get_custom_site_list_csr (application_id number, p_region_code 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 = application_id
108: and ac.REGION_CODE = p_region_code
109: and ac.region_application_id = ar.region_application_id
110: and ac.region_code = ar.region_code

Line 115: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

111: and ac.site_id = levelpk;
112: cursor l_get_custom_site_list2_csr (application_id number, p_region_code 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 = application_id
117: and ac.REGION_CODE = p_region_code
118: and ac.region_application_id = ar.region_application_id
119: and ac.region_code = ar.region_code

Line 124: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

120: and ac.site_id is not null;
121: cursor l_get_custom_fun_list_csr (application_id number, p_region_code varchar2, levelpk varchar2) is
122: select ac.customization_application_id, ac.customization_code,
123: ac.region_application_id, ac.region_code
124: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
125: where ac.REGION_APPLICATION_ID = application_id
126: and ac.REGION_CODE = p_region_code
127: and ac.region_application_id = ar.region_application_id
128: and ac.region_code = ar.region_code

Line 133: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

129: and ac.function_name = levelpk;
130: cursor l_get_custom_fun_list2_csr (application_id number, p_region_code varchar2) is
131: select ac.customization_application_id, ac.customization_code,
132: ac.region_application_id, ac.region_code
133: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
134: where ac.REGION_APPLICATION_ID = application_id
135: and ac.REGION_CODE = p_region_code
136: and ac.region_application_id = ar.region_application_id
137: and ac.region_code = ar.region_code

Line 142: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

138: and ac.function_name is not null;
139: cursor l_get_custom_local_list_csr (application_id number, p_region_code varchar2, levelpk varchar2) is
140: select ac.customization_application_id, ac.customization_code,
141: ac.region_application_id, ac.region_code
142: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
143: where ac.REGION_APPLICATION_ID = application_id
144: and ac.REGION_CODE = p_region_code
145: and ac.region_application_id = ar.region_application_id
146: and ac.region_code = ar.region_code

Line 151: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

147: and ac.localization_code = levelpk;
148: cursor l_get_custom_local_list2_csr (application_id number, p_region_code varchar2) is
149: select ac.customization_application_id, ac.customization_code,
150: ac.region_application_id, ac.region_code
151: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
152: where ac.REGION_APPLICATION_ID = application_id
153: and ac.REGION_CODE = p_region_code
154: and ac.region_application_id = ar.region_application_id
155: and ac.region_code = ar.region_code

Line 160: from AK_REGIONS

156: and ac.localization_code is not null;
157: cursor l_get_region_list_csr (region_appl_id_param number,
158: region_code_param varchar2) is
159: select region_application_id, region_code
160: from AK_REGIONS
161: where region_application_id = region_appl_id_param
162: and region_code = region_code_param;
163: cursor l_get_region_code_csr (application_id number) is
164: select region_application_id, region_code

Line 165: from AK_REGIONS

161: where region_application_id = region_appl_id_param
162: and region_code = region_code_param;
163: cursor l_get_region_code_csr (application_id number) is
164: select region_application_id, region_code
165: from AK_REGIONS
166: where region_application_id = application_id;
167: cursor l_get_org_id(levelpk varchar2) is
168: select organization_id
169: from MTL_PARAMETERS

Line 656: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar

652: ) is
653: cursor l_get_custom_list_csr (application_id number, application_code varchar2, custom_appl_id number, custom_code varchar2) is
654: select ac.customization_application_id, ac.customization_code,
655: ac.region_application_id, ac.region_code
656: from AK_CUSTOMIZATIONS ac, AK_REGIONS ar
657: where ac.REGION_APPLICATION_ID = application_id
658: and ac.region_code = application_code
659: and ac.customization_application_id = custom_appl_id
660: and ac.customization_code = custom_code