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.

APPS.AK_CUSTOM_PVT dependencies on AK_CUSTOMIZATIONS

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 173: from ak_customizations

169: from MTL_PARAMETERS
170: where organization_code = levelpk;
171: cursor l_get_org_id2 is
172: select 'X'
173: from ak_customizations
174: where org_id is not null
175: and rownum = 1;
176: cursor l_get_resp_id(levelpk varchar2) is
177: select responsibility_id

Line 182: from ak_customizations

178: from FND_RESPONSIBILITY
179: where responsibility_key = levelpk;
180: cursor l_get_resp_id2 is
181: select 'X'
182: from ak_customizations
183: where responsibility_id is not null
184: and rownum = 1;
185: cursor l_get_fun_name(levelpk varchar2) is
186: select function_name

Line 191: from ak_customizations

187: from fnd_form_functions
188: where function_name = levelpk;
189: cursor l_get_fun_name2 is
190: select 'X'
191: from ak_customizations
192: where function_name is not null
193: and rownum = 1;
194: cursor l_get_local_code(levelpk varchar2) is
195: select territory_code

Line 200: from ak_customizations

196: from fnd_territories
197: where territory_code = levelpk;
198: cursor l_get_local_code2 is
199: select 'X'
200: from ak_customizations
201: where localization_code is not null
202: and rownum = 1;
203: l_api_version_number CONSTANT number := 1.0;
204: l_api_name CONSTANT varchar2(30) := 'Download_Custom';

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

Line 763: from AK_CUSTOMIZATIONS

759: p_nls_language IN VARCHAR2
760: ) is
761: cursor l_get_custom_csr is
762: select *
763: from AK_CUSTOMIZATIONS
764: where REGION_APPLICATION_ID = p_region_application_id
765: and REGION_CODE = p_region_code
766: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
767: and CUSTOMIZATION_CODE = p_custom_code;

Line 770: from AK_CUSTOMIZATIONS_TL

766: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
767: and CUSTOMIZATION_CODE = p_custom_code;
768: cursor l_get_custom_tl_csr is
769: select *
770: from AK_CUSTOMIZATIONS_TL
771: where REGION_APPLICATION_ID = p_region_application_id
772: and REGION_CODE = p_region_code
773: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
774: and CUSTOMIZATION_CODE = p_custom_code

Line 779: l_custom_rec AK_CUSTOMIZATIONS%ROWTYPE;

775: and LANGUAGE = p_nls_language;
776: l_api_name CONSTANT varchar2(30) := 'Write_Custom_to_buffer';
777: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
778: l_index NUMBER;
779: l_custom_rec AK_CUSTOMIZATIONS%ROWTYPE;
780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;
781: l_return_status varchar2(1);
782: begin
783: -- Retrieve customization information from the database

Line 780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;

776: l_api_name CONSTANT varchar2(30) := 'Write_Custom_to_buffer';
777: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
778: l_index NUMBER;
779: l_custom_rec AK_CUSTOMIZATIONS%ROWTYPE;
780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;
781: l_return_status varchar2(1);
782: begin
783: -- Retrieve customization information from the database
784:

Line 1970: from AK_CUSTOMIZATIONS

1966: p_pass IN NUMBER := 2
1967: ) return BOOLEAN is
1968: cursor l_check_custom_csr is
1969: select 1
1970: from AK_CUSTOMIZATIONS
1971: where region_application_id = p_region_application_id
1972: and region_code = p_region_code
1973: and customization_application_id = p_custom_application_id
1974: and customization_code = p_custom_code;

Line 2134: from AK_CUSTOMIZATIONS

2130: p_pass IN NUMBER := 2
2131: ) return BOOLEAN is
2132: cursor l_check_custom_csr is
2133: select 1
2134: from AK_CUSTOMIZATIONS
2135: where region_application_id = p_region_application_id
2136: and region_code = p_region_code
2137: and customization_application_id = p_custom_application_id
2138: and customization_code = p_custom_code;

Line 2319: from AK_CUSTOMIZATIONS

2315: p_pass IN NUMBER := 2
2316: ) return BOOLEAN is
2317: cursor l_check_custom_csr is
2318: select 1
2319: from AK_CUSTOMIZATIONS
2320: where region_application_id = p_region_application_id
2321: and region_code = p_region_code
2322: and customization_application_id = p_custom_application_id
2323: and customization_code = p_custom_code;

Line 2705: insert into AK_CUSTOMIZATIONS (

2701:
2702: select userenv('LANG') into l_lang
2703: from dual;
2704:
2705: insert into AK_CUSTOMIZATIONS (
2706: CUSTOMIZATION_APPLICATION_ID,
2707: CUSTOMIZATION_CODE,
2708: REGION_APPLICATION_ID,
2709: REGION_CODE,

Line 2769: insert into AK_CUSTOMIZATIONS_TL (

2765: --dbms_output.put_line(l_api_name || 'Error - row already exists');
2766: raise FND_API.G_EXC_ERROR;
2767: end if;
2768:
2769: insert into AK_CUSTOMIZATIONS_TL (
2770: CUSTOMIZATION_APPLICATION_ID,
2771: CUSTOMIZATION_CODE,
2772: REGION_APPLICATION_ID,
2773: REGION_CODE,

Line 2801: from AK_CUSTOMIZATIONS_TL T

2797: from FND_LANGUAGES L
2798: where L.INSTALLED_FLAG in ('I', 'B')
2799: and not exists
2800: (select NULL
2801: from AK_CUSTOMIZATIONS_TL T
2802: where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
2803: and T.CUSTOMIZATION_CODE = p_custom_code
2804: and T.REGION_APPLICATION_ID = p_region_appl_id
2805: and T.REGION_CODE = p_region_code

Line 3871: from AK_CUSTOMIZATIONS

3867: p_region_code IN VARCHAR2
3868: ) return BOOLEAN is
3869: cursor l_check_csr is
3870: select 1
3871: from AK_CUSTOMIZATIONS
3872: where region_application_id = p_region_application_id
3873: and region_code = p_region_code
3874: and customization_application_id = p_custom_appl_id
3875: and customization_code = p_custom_code;

Line 4208: from AK_CUSTOMIZATIONS

4204: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
4205: ) is
4206: cursor l_get_row_csr is
4207: select *
4208: from AK_CUSTOMIZATIONS
4209: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4210: and CUSTOMIZATION_CODE = p_custom_code
4211: and REGION_APPLICATION_ID = p_region_application_id
4212: and REGION_CODE = p_region_code

Line 4216: from AK_CUSTOMIZATIONS_TL

4212: and REGION_CODE = p_region_code
4213: for update of VERTICALIZATION_ID;
4214: cursor l_get_tl_row_csr (lang_parm varchar2) is
4215: select *
4216: from AK_CUSTOMIZATIONS_TL
4217: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4218: and CUSTOMIZATION_CODE = p_custom_code
4219: and REGION_APPLICATION_ID = p_region_application_id
4220: and REGION_CODE = p_region_code

Line 4227: l_custom_rec ak_customizations%ROWTYPE;

4223: l_api_version_number CONSTANT number := 1.0;
4224: l_api_name CONSTANT varchar2(30) := 'Update_Custom';
4225: l_created_by number;
4226: l_creation_date date;
4227: l_custom_rec ak_customizations%ROWTYPE;
4228: l_custom_tl_rec ak_customizations_tl%ROWTYPE;
4229: l_error boolean;
4230: l_lang varchar2(30);
4231: l_last_update_date date;

Line 4228: l_custom_tl_rec ak_customizations_tl%ROWTYPE;

4224: l_api_name CONSTANT varchar2(30) := 'Update_Custom';
4225: l_created_by number;
4226: l_creation_date date;
4227: l_custom_rec ak_customizations%ROWTYPE;
4228: l_custom_tl_rec ak_customizations_tl%ROWTYPE;
4229: l_error boolean;
4230: l_lang varchar2(30);
4231: l_last_update_date date;
4232: l_last_update_login number;

Line 4256: -- retrieve ak_customizations row if it exists

4252:
4253: select userenv('LANG') into l_lang
4254: from dual;
4255:
4256: --** retrieve ak_customizations row if it exists **
4257: open l_get_row_csr;
4258: fetch l_get_row_csr into l_custom_rec;
4259: if (l_get_row_csr%notfound) then
4260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 4270: -- retrieve ak_customizations_tl row if it exists

4266: raise FND_API.G_EXC_ERROR;
4267: end if;
4268: close l_get_row_csr;
4269:
4270: --** retrieve ak_customizations_tl row if it exists **
4271: open l_get_tl_row_csr(l_lang);
4272: fetch l_get_tl_row_csr into l_custom_tl_rec;
4273: if (l_get_tl_row_csr%notfound) then
4274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 4439: update AK_CUSTOMIZATIONS set

4435: and REGION_CODE = p_region_code
4436: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4437: and CUSTOMIZATION_CODE = p_custom_code;
4438:
4439: update AK_CUSTOMIZATIONS set
4440: VERTICALIZATION_ID = l_custom_rec.verticalization_id,
4441: LOCALIZATION_CODE = l_custom_rec.localization_code,
4442: ORG_ID = l_custom_rec.org_id,
4443: SITE_ID = l_custom_rec.site_id,

Line 4479: update AK_CUSTOMIZATIONS_TL set

4475: and REGION_CODE = p_region_code
4476: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4477: and CUSTOMIZATION_CODE = p_custom_code;
4478:
4479: update AK_CUSTOMIZATIONS_TL set
4480: NAME = l_custom_tl_rec.name,
4481: DESCRIPTION = l_custom_tl_rec.description,
4482: LAST_UPDATED_BY = l_last_updated_by,
4483: LAST_UPDATE_DATE = l_last_update_date,