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 1845: DELETE FROM AK_CUSTOM_REGION_ITEMS

1841: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1842: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1843: AND REGION_CODE = X_REGION_CODE;
1844:
1845: DELETE FROM AK_CUSTOM_REGION_ITEMS
1846: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1847: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1848: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1849: AND REGION_CODE = X_REGION_CODE;

Line 1851: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

1847: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1848: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1849: AND REGION_CODE = X_REGION_CODE;
1850:
1851: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
1852: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1853: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1854: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1855: AND REGION_CODE = X_REGION_CODE;

Line 1992: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

1988: IF FND_API.To_Boolean(x_init_msg_list) THEN
1989: FND_MSG_PUB.Initialize;
1990: END IF;
1991:
1992: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
1993: X_ROWID => l_rowid,
1994: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1995: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1996: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2013: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2009: );
2010:
2011: IF (X_ORDER_SEQUENCE IS NOT NULL) THEN
2012:
2013: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2014: X_ROWID => l_rowid,
2015: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2016: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2017: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2036: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2032: END IF;
2033:
2034: IF (X_ORDER_DIRECTION IS NOT NULL) THEN
2035:
2036: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2037: X_ROWID => l_rowid,
2038: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2039: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2040: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2058: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2054: END IF;
2055:
2056: IF (X_COLUMN_NAME IS NOT NULL) THEN
2057:
2058: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2059: X_ROWID => l_rowid,
2060: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2061: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2062: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2080: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2076: END IF;
2077:
2078: IF (X_SHOW_TOTAL IS NOT NULL) THEN
2079:
2080: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2081: X_ROWID => l_rowid,
2082: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2083: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2084: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2142: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2138: IF FND_API.To_Boolean(x_init_msg_list) THEN
2139: FND_MSG_PUB.Initialize;
2140: END IF;
2141:
2142: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2143: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2144: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2145: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2146: X_REGION_CODE => X_REGION_CODE,

Line 2161: AK_CUSTOM_REGION_ITEMS

2157:
2158: SELECT
2159: COUNT(*) INTO l_count
2160: FROM
2161: AK_CUSTOM_REGION_ITEMS
2162: WHERE
2163: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2164: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2165: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2174: DELETE FROM AK_CUSTOM_REGION_ITEMS

2170:
2171: IF (X_ORDER_SEQUENCE IS NULL) THEN
2172:
2173: IF (l_count > 0) THEN
2174: DELETE FROM AK_CUSTOM_REGION_ITEMS
2175: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2176: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2177: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2178: AND REGION_CODE = X_REGION_CODE

Line 2188: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2184: ELSE
2185:
2186: IF (l_count > 0) THEN
2187:
2188: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2189: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2190: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2191: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2192: X_REGION_CODE => X_REGION_CODE,

Line 2206: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2202: );
2203:
2204: ELSE
2205:
2206: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2207: X_ROWID => l_rowid,
2208: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2209: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2210: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2233: AK_CUSTOM_REGION_ITEMS

2229:
2230: SELECT
2231: COUNT(*) INTO l_count
2232: FROM
2233: AK_CUSTOM_REGION_ITEMS
2234: WHERE
2235: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2236: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2237: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2246: DELETE FROM AK_CUSTOM_REGION_ITEMS

2242:
2243: IF (X_ORDER_DIRECTION IS NULL) THEN
2244:
2245: IF (l_count > 0) THEN
2246: DELETE FROM AK_CUSTOM_REGION_ITEMS
2247: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2248: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2249: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2250: AND REGION_CODE = X_REGION_CODE

Line 2260: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2256: ELSE
2257:
2258: IF (l_count > 0) THEN
2259:
2260: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2261: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2262: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2263: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2264: X_REGION_CODE => X_REGION_CODE,

Line 2278: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2274: );
2275:
2276: ELSE
2277:
2278: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2279: X_ROWID => l_rowid,
2280: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2281: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2282: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2304: AK_CUSTOM_REGION_ITEMS

2300:
2301: SELECT
2302: COUNT(*) INTO l_count
2303: FROM
2304: AK_CUSTOM_REGION_ITEMS
2305: WHERE
2306: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2307: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2308: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2317: DELETE FROM AK_CUSTOM_REGION_ITEMS

2313:
2314: IF (X_COLUMN_NAME IS NULL) THEN
2315:
2316: IF (l_count > 0) THEN
2317: DELETE FROM AK_CUSTOM_REGION_ITEMS
2318: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2319: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2320: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2321: AND REGION_CODE = X_REGION_CODE

Line 2331: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2327: ELSE
2328:
2329: IF (l_count > 0) THEN
2330:
2331: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2332: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2333: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2334: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2335: X_REGION_CODE => X_REGION_CODE,

Line 2349: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2345: );
2346:
2347: ELSE
2348:
2349: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2350: X_ROWID => l_rowid,
2351: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2352: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2353: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2375: AK_CUSTOM_REGION_ITEMS

2371:
2372: SELECT
2373: COUNT(*) INTO l_count
2374: FROM
2375: AK_CUSTOM_REGION_ITEMS
2376: WHERE
2377: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2378: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2379: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2388: DELETE FROM AK_CUSTOM_REGION_ITEMS

2384:
2385: IF (X_SHOW_TOTAL IS NULL) THEN
2386:
2387: IF (l_count > 0) THEN
2388: DELETE FROM AK_CUSTOM_REGION_ITEMS
2389: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2390: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2391: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2392: AND REGION_CODE = X_REGION_CODE

Line 2402: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2398: ELSE
2399:
2400: IF (l_count > 0) THEN
2401:
2402: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2403: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2404: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2405: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
2406: X_REGION_CODE => X_REGION_CODE,

Line 2420: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2416: );
2417:
2418: ELSE
2419:
2420: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2421: X_ROWID => l_rowid,
2422: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2423: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2424: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 2472: DELETE FROM AK_CUSTOM_REGION_ITEMS

2468: IF FND_API.To_Boolean(x_init_msg_list) THEN
2469: FND_MSG_PUB.Initialize;
2470: END IF;
2471:
2472: DELETE FROM AK_CUSTOM_REGION_ITEMS
2473: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2474: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2475: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2476: AND REGION_CODE = X_REGION_CODE

Line 2480: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

2476: AND REGION_CODE = X_REGION_CODE
2477: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
2478: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
2479:
2480: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
2481: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2482: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2483: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
2484: AND REGION_CODE = X_REGION_CODE

Line 2944: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

2940: IF FND_API.To_Boolean(x_init_msg_list) THEN
2941: FND_MSG_PUB.Initialize;
2942: END IF;
2943:
2944: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2945: X_ROWID => l_rowid,
2946: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2947: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
2948: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 3000: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

2996: IF FND_API.To_Boolean(x_init_msg_list) THEN
2997: FND_MSG_PUB.Initialize;
2998: END IF;
2999:
3000: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
3001: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
3002: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
3003: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
3004: X_REGION_CODE => X_REGION_CODE,

Line 3044: DELETE FROM AK_CUSTOM_REGION_ITEMS

3040: IF FND_API.To_Boolean(x_init_msg_list) THEN
3041: FND_MSG_PUB.Initialize;
3042: END IF;
3043:
3044: DELETE FROM AK_CUSTOM_REGION_ITEMS
3045: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
3046: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
3047: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
3048: AND REGION_CODE = X_REGION_CODE

Line 3052: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

3048: AND REGION_CODE = X_REGION_CODE
3049: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
3050: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
3051:
3052: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
3053: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
3054: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
3055: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
3056: AND REGION_CODE = X_REGION_CODE