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.EGO_SEARCH_FWK_PUB dependencies on AK_CUSTOM_REGION_ITEMS

Line 1877: DELETE FROM AK_CUSTOM_REGION_ITEMS

1873: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1874: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1875: AND REGION_CODE = X_REGION_CODE;
1876:
1877: DELETE FROM AK_CUSTOM_REGION_ITEMS
1878: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1879: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1880: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1881: AND REGION_CODE = X_REGION_CODE;

Line 1883: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

1879: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1880: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1881: AND REGION_CODE = X_REGION_CODE;
1882:
1883: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
1884: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1885: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1886: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1887: AND REGION_CODE = X_REGION_CODE;

Line 2024: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2020: IF FND_API.To_Boolean(x_init_msg_list) THEN
2021: FND_MSG_PUB.Initialize;
2022: END IF;
2023:
2024: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2025: X_ROWID => l_rowid,
2026: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2027: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2028: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2045: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2041: );
2042:
2043: IF (X_ORDER_SEQUENCE IS NOT NULL) THEN
2044:
2045: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2046: X_ROWID => l_rowid,
2047: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2048: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2049: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2068: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2064: END IF;
2065:
2066: IF (X_ORDER_DIRECTION IS NOT NULL) THEN
2067:
2068: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2069: X_ROWID => l_rowid,
2070: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2071: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2072: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2090: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2086: END IF;
2087:
2088: IF (X_COLUMN_NAME IS NOT NULL) THEN
2089:
2090: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2091: X_ROWID => l_rowid,
2092: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2093: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2094: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2112: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2108: END IF;
2109:
2110: IF (X_SHOW_TOTAL IS NOT NULL) THEN
2111:
2112: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2113: X_ROWID => l_rowid,
2114: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2115: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2116: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2174: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2170: IF FND_API.To_Boolean(x_init_msg_list) THEN
2171: FND_MSG_PUB.Initialize;
2172: END IF;
2173:
2174: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2175: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2176: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2177: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2178: X_REGION_CODE => X_REGION_CODE,

Line 2193: AK_CUSTOM_REGION_ITEMS

2189:
2190: SELECT
2191: COUNT(*) INTO l_count
2192: FROM
2193: AK_CUSTOM_REGION_ITEMS
2194: WHERE
2195: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2196: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2197: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2206: DELETE FROM AK_CUSTOM_REGION_ITEMS

2202:
2203: IF (X_ORDER_SEQUENCE IS NULL) THEN
2204:
2205: IF (l_count > 0) THEN
2206: DELETE FROM AK_CUSTOM_REGION_ITEMS
2207: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2208: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2209: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2210: AND REGION_CODE = X_REGION_CODE

Line 2220: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2216: ELSE
2217:
2218: IF (l_count > 0) THEN
2219:
2220: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2221: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2222: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2223: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2224: X_REGION_CODE => X_REGION_CODE,

Line 2238: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2234: );
2235:
2236: ELSE
2237:
2238: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2239: X_ROWID => l_rowid,
2240: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2241: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2242: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2265: AK_CUSTOM_REGION_ITEMS

2261:
2262: SELECT
2263: COUNT(*) INTO l_count
2264: FROM
2265: AK_CUSTOM_REGION_ITEMS
2266: WHERE
2267: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2268: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2269: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2278: DELETE FROM AK_CUSTOM_REGION_ITEMS

2274:
2275: IF (X_ORDER_DIRECTION IS NULL) THEN
2276:
2277: IF (l_count > 0) THEN
2278: DELETE FROM AK_CUSTOM_REGION_ITEMS
2279: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2280: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2281: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2282: AND REGION_CODE = X_REGION_CODE

Line 2292: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2288: ELSE
2289:
2290: IF (l_count > 0) THEN
2291:
2292: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2293: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2294: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2295: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2296: X_REGION_CODE => X_REGION_CODE,

Line 2310: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2306: );
2307:
2308: ELSE
2309:
2310: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2311: X_ROWID => l_rowid,
2312: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2313: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2314: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2336: AK_CUSTOM_REGION_ITEMS

2332:
2333: SELECT
2334: COUNT(*) INTO l_count
2335: FROM
2336: AK_CUSTOM_REGION_ITEMS
2337: WHERE
2338: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2339: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2340: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2349: DELETE FROM AK_CUSTOM_REGION_ITEMS

2345:
2346: IF (X_COLUMN_NAME IS NULL) THEN
2347:
2348: IF (l_count > 0) THEN
2349: DELETE FROM AK_CUSTOM_REGION_ITEMS
2350: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2351: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2352: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2353: AND REGION_CODE = X_REGION_CODE

Line 2363: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2359: ELSE
2360:
2361: IF (l_count > 0) THEN
2362:
2363: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2364: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2365: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2366: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2367: X_REGION_CODE => X_REGION_CODE,

Line 2381: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2377: );
2378:
2379: ELSE
2380:
2381: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2382: X_ROWID => l_rowid,
2383: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2384: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2385: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2407: AK_CUSTOM_REGION_ITEMS

2403:
2404: SELECT
2405: COUNT(*) INTO l_count
2406: FROM
2407: AK_CUSTOM_REGION_ITEMS
2408: WHERE
2409: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2410: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2411: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2420: DELETE FROM AK_CUSTOM_REGION_ITEMS

2416:
2417: IF (X_SHOW_TOTAL IS NULL) THEN
2418:
2419: IF (l_count > 0) THEN
2420: DELETE FROM AK_CUSTOM_REGION_ITEMS
2421: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2422: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2423: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2424: AND REGION_CODE = X_REGION_CODE

Line 2434: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2430: ELSE
2431:
2432: IF (l_count > 0) THEN
2433:
2434: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2435: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2436: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2437: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2438: X_REGION_CODE => X_REGION_CODE,

Line 2452: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2448: );
2449:
2450: ELSE
2451:
2452: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2453: X_ROWID => l_rowid,
2454: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2455: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2456: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2504: DELETE FROM AK_CUSTOM_REGION_ITEMS

2500: IF FND_API.To_Boolean(x_init_msg_list) THEN
2501: FND_MSG_PUB.Initialize;
2502: END IF;
2503:
2504: DELETE FROM AK_CUSTOM_REGION_ITEMS
2505: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2506: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2507: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2508: AND REGION_CODE = X_REGION_CODE

Line 2512: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

2508: AND REGION_CODE = X_REGION_CODE
2509: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
2510: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
2511:
2512: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
2513: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2514: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2515: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2516: AND REGION_CODE = X_REGION_CODE

Line 2976: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2972: IF FND_API.To_Boolean(x_init_msg_list) THEN
2973: FND_MSG_PUB.Initialize;
2974: END IF;
2975:
2976: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2977: X_ROWID => l_rowid,
2978: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2979: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2980: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 3032: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

3028: IF FND_API.To_Boolean(x_init_msg_list) THEN
3029: FND_MSG_PUB.Initialize;
3030: END IF;
3031:
3032: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
3033: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
3034: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
3035: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
3036: X_REGION_CODE => X_REGION_CODE,

Line 3076: DELETE FROM AK_CUSTOM_REGION_ITEMS

3072: IF FND_API.To_Boolean(x_init_msg_list) THEN
3073: FND_MSG_PUB.Initialize;
3074: END IF;
3075:
3076: DELETE FROM AK_CUSTOM_REGION_ITEMS
3077: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
3078: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
3079: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
3080: AND REGION_CODE = X_REGION_CODE

Line 3084: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

3080: AND REGION_CODE = X_REGION_CODE
3081: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
3082: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
3083:
3084: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
3085: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
3086: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
3087: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
3088: AND REGION_CODE = X_REGION_CODE