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_REGIONS

Line 36: AK_CUSTOM_REGIONS_TL name_query ,

32:
33: CURSOR fetch_custmztn_code IS
34: select name_query.customization_code customization_code
35: from
36: AK_CUSTOM_REGIONS_TL name_query ,
37: AK_CUSTOM_REGIONS level_id_query ,
38: AK_CUSTOM_REGIONS user_id_query ,
39: EGO_CUSTOMIZATION_EXT ect ,
40: AK_CUSTOM_REGIONS data_level_query

Line 37: AK_CUSTOM_REGIONS level_id_query ,

33: CURSOR fetch_custmztn_code IS
34: select name_query.customization_code customization_code
35: from
36: AK_CUSTOM_REGIONS_TL name_query ,
37: AK_CUSTOM_REGIONS level_id_query ,
38: AK_CUSTOM_REGIONS user_id_query ,
39: EGO_CUSTOMIZATION_EXT ect ,
40: AK_CUSTOM_REGIONS data_level_query
41: where name_query.property_name = 'RESULT_NAME'

Line 38: AK_CUSTOM_REGIONS user_id_query ,

34: select name_query.customization_code customization_code
35: from
36: AK_CUSTOM_REGIONS_TL name_query ,
37: AK_CUSTOM_REGIONS level_id_query ,
38: AK_CUSTOM_REGIONS user_id_query ,
39: EGO_CUSTOMIZATION_EXT ect ,
40: AK_CUSTOM_REGIONS data_level_query
41: where name_query.property_name = 'RESULT_NAME'
42: and name_query.language = USERENV('LANG')

Line 40: AK_CUSTOM_REGIONS data_level_query

36: AK_CUSTOM_REGIONS_TL name_query ,
37: AK_CUSTOM_REGIONS level_id_query ,
38: AK_CUSTOM_REGIONS user_id_query ,
39: EGO_CUSTOMIZATION_EXT ect ,
40: AK_CUSTOM_REGIONS data_level_query
41: where name_query.property_name = 'RESULT_NAME'
42: and name_query.language = USERENV('LANG')
43: and name_query.customization_application_id = level_id_query.customization_application_id
44: and name_query.customization_code = level_id_query.customization_code

Line 83: UPDATE AK_CUSTOM_REGIONS

79: FETCH fetch_custmztn_code BULK COLLECT INTO l_custmztn_code_tbl;
80: CLOSE fetch_custmztn_code;
81:
82: FORALL i IN 1..l_custmztn_code_tbl.COUNT
83: UPDATE AK_CUSTOM_REGIONS
84: SET
85: PROPERTY_VARCHAR2_VALUE = 'N'
86: WHERE
87: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID

Line 94: UPDATE AK_CUSTOM_REGIONS_TL

90: AND PROPERTY_NAME = 'DEFAULT_RESULT_FLAG'
91: AND CUSTOMIZATION_CODE = l_custmztn_code_tbl(i);
92:
93: FORALL i IN 1..l_custmztn_code_tbl.COUNT
94: UPDATE AK_CUSTOM_REGIONS_TL
95: SET
96: PROPERTY_VARCHAR2_VALUE = 'N'
97: WHERE
98: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID

Line 125: from AK_CUSTOM_REGIONS_TL name_query

121: l_name VARCHAR2(2000);
122:
123: CURSOR get_name IS
124: select name_query.property_varchar2_value name
125: from AK_CUSTOM_REGIONS_TL name_query
126: where name_query.property_name = 'RESULT_NAME'
127: and name_query.language = USERENV('LANG')
128: and name_query.customization_application_id = x_customization_application_id
129: and name_query.customization_code = x_customization_code

Line 299: AK_CUSTOM_REGIONS_TL name_query ,

295: -- get count with customization code (wcc) , with level id (wlv)
296: CURSOR get_cnt_wccwlv IS
297: select count(*) count
298: from
299: AK_CUSTOM_REGIONS_TL name_query ,
300: AK_CUSTOM_REGIONS level_id_query ,
301: AK_CUSTOM_REGIONS user_id_query ,
302: EGO_CUSTOMIZATION_EXT ect
303: where name_query.property_name = 'RESULT_NAME'

Line 300: AK_CUSTOM_REGIONS level_id_query ,

296: CURSOR get_cnt_wccwlv IS
297: select count(*) count
298: from
299: AK_CUSTOM_REGIONS_TL name_query ,
300: AK_CUSTOM_REGIONS level_id_query ,
301: AK_CUSTOM_REGIONS user_id_query ,
302: EGO_CUSTOMIZATION_EXT ect
303: where name_query.property_name = 'RESULT_NAME'
304: and name_query.language = USERENV('LANG')

Line 301: AK_CUSTOM_REGIONS user_id_query ,

297: select count(*) count
298: from
299: AK_CUSTOM_REGIONS_TL name_query ,
300: AK_CUSTOM_REGIONS level_id_query ,
301: AK_CUSTOM_REGIONS user_id_query ,
302: EGO_CUSTOMIZATION_EXT ect
303: where name_query.property_name = 'RESULT_NAME'
304: and name_query.language = USERENV('LANG')
305: and name_query.customization_application_id = level_id_query.customization_application_id

Line 336: AK_CUSTOM_REGIONS_TL name_query ,

332: -- get count with customization code (wcc) , without level id (wolv)
333: CURSOR get_cnt_wccwolv IS
334: select count(*) count
335: from
336: AK_CUSTOM_REGIONS_TL name_query ,
337: AK_CUSTOM_REGIONS level_id_query ,
338: AK_CUSTOM_REGIONS user_id_query ,
339: EGO_CUSTOMIZATION_EXT ect
340: where name_query.property_name = 'RESULT_NAME'

Line 337: AK_CUSTOM_REGIONS level_id_query ,

333: CURSOR get_cnt_wccwolv IS
334: select count(*) count
335: from
336: AK_CUSTOM_REGIONS_TL name_query ,
337: AK_CUSTOM_REGIONS level_id_query ,
338: AK_CUSTOM_REGIONS user_id_query ,
339: EGO_CUSTOMIZATION_EXT ect
340: where name_query.property_name = 'RESULT_NAME'
341: and name_query.language = USERENV('LANG')

Line 338: AK_CUSTOM_REGIONS user_id_query ,

334: select count(*) count
335: from
336: AK_CUSTOM_REGIONS_TL name_query ,
337: AK_CUSTOM_REGIONS level_id_query ,
338: AK_CUSTOM_REGIONS user_id_query ,
339: EGO_CUSTOMIZATION_EXT ect
340: where name_query.property_name = 'RESULT_NAME'
341: and name_query.language = USERENV('LANG')
342: and name_query.customization_application_id = level_id_query.customization_application_id

Line 369: AK_CUSTOM_REGIONS_TL name_query ,

365: -- get count without customization code (wocc) , with level id (wlv)
366: CURSOR get_cnt_woccwlv IS
367: select count(*) count
368: from
369: AK_CUSTOM_REGIONS_TL name_query ,
370: AK_CUSTOM_REGIONS level_id_query ,
371: AK_CUSTOM_REGIONS user_id_query ,
372: EGO_CUSTOMIZATION_EXT ect
373: where name_query.property_name = 'RESULT_NAME'

Line 370: AK_CUSTOM_REGIONS level_id_query ,

366: CURSOR get_cnt_woccwlv IS
367: select count(*) count
368: from
369: AK_CUSTOM_REGIONS_TL name_query ,
370: AK_CUSTOM_REGIONS level_id_query ,
371: AK_CUSTOM_REGIONS user_id_query ,
372: EGO_CUSTOMIZATION_EXT ect
373: where name_query.property_name = 'RESULT_NAME'
374: and name_query.language = USERENV('LANG')

Line 371: AK_CUSTOM_REGIONS user_id_query ,

367: select count(*) count
368: from
369: AK_CUSTOM_REGIONS_TL name_query ,
370: AK_CUSTOM_REGIONS level_id_query ,
371: AK_CUSTOM_REGIONS user_id_query ,
372: EGO_CUSTOMIZATION_EXT ect
373: where name_query.property_name = 'RESULT_NAME'
374: and name_query.language = USERENV('LANG')
375: and name_query.customization_application_id = level_id_query.customization_application_id

Line 405: AK_CUSTOM_REGIONS_TL name_query ,

401: -- get count without customization code (wocc) , without level id (wolv)
402: CURSOR get_cnt_woccwolv IS
403: select count(*) count
404: from
405: AK_CUSTOM_REGIONS_TL name_query ,
406: AK_CUSTOM_REGIONS level_id_query ,
407: AK_CUSTOM_REGIONS user_id_query ,
408: EGO_CUSTOMIZATION_EXT ect
409: where name_query.property_name = 'RESULT_NAME'

Line 406: AK_CUSTOM_REGIONS level_id_query ,

402: CURSOR get_cnt_woccwolv IS
403: select count(*) count
404: from
405: AK_CUSTOM_REGIONS_TL name_query ,
406: AK_CUSTOM_REGIONS level_id_query ,
407: AK_CUSTOM_REGIONS user_id_query ,
408: EGO_CUSTOMIZATION_EXT ect
409: where name_query.property_name = 'RESULT_NAME'
410: and name_query.language = USERENV('LANG')

Line 407: AK_CUSTOM_REGIONS user_id_query ,

403: select count(*) count
404: from
405: AK_CUSTOM_REGIONS_TL name_query ,
406: AK_CUSTOM_REGIONS level_id_query ,
407: AK_CUSTOM_REGIONS user_id_query ,
408: EGO_CUSTOMIZATION_EXT ect
409: where name_query.property_name = 'RESULT_NAME'
410: and name_query.language = USERENV('LANG')
411: and name_query.customization_application_id = level_id_query.customization_application_id

Line 1281: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1277: ,X_CLASSIFICATION_1
1278: ,X_CLASSIFICATION_2
1279: ,X_CLASSIFICATION_3) = FALSE) THEN
1280:
1281: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1282: X_ROWID => l_rowid,
1283: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1284: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1285: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1298: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1294: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1295: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1296: );
1297:
1298: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1299: X_ROWID => l_rowid,
1300: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1301: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1302: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1336: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1332: );
1333:
1334: END IF;
1335:
1336: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1337: X_ROWID => l_rowid,
1338: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1339: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1340: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1353: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1349: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1350: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1351: );
1352:
1353: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1354: X_ROWID => l_rowid,
1355: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1356: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1357: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1370: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1366: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1367: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1368: );
1369:
1370: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1371: X_ROWID => l_rowid,
1372: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1373: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1374: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1387: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1383: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1384: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1385: );
1386:
1387: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1388: X_ROWID => l_rowid,
1389: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1390: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1391: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1404: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1400: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1401: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1402: );
1403:
1404: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1405: X_ROWID => l_rowid,
1406: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1407: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1408: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1423: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1419: );
1420:
1421: IF (X_IMPORT_FLAG IS NOT NULL) THEN
1422:
1423: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1424: X_ROWID => l_rowid,
1425: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1426: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1427: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1440: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1436: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1437: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1438: );
1439:
1440: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1441: X_ROWID => l_rowid,
1442: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1443: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1444: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1542: AK_CUSTOM_REGIONS_TL name_query ,

1538:
1539: CURSOR get_data_level IS
1540: select data_level_query.property_varchar2_value data_level
1541: from
1542: AK_CUSTOM_REGIONS_TL name_query ,
1543: AK_CUSTOM_REGIONS data_level_query
1544: where name_query.property_name = 'RESULT_NAME'
1545: and name_query.language = USERENV('LANG')
1546: and data_level_query.property_name (+) = 'DATA_LEVEL'

Line 1543: AK_CUSTOM_REGIONS data_level_query

1539: CURSOR get_data_level IS
1540: select data_level_query.property_varchar2_value data_level
1541: from
1542: AK_CUSTOM_REGIONS_TL name_query ,
1543: AK_CUSTOM_REGIONS data_level_query
1544: where name_query.property_name = 'RESULT_NAME'
1545: and name_query.language = USERENV('LANG')
1546: and data_level_query.property_name (+) = 'DATA_LEVEL'
1547: and name_query.customization_application_id = data_level_query.customization_application_id(+)

Line 1573: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1569: ,X_CLASSIFICATION_1
1570: ,X_CLASSIFICATION_2
1571: ,X_CLASSIFICATION_3) = FALSE) THEN
1572:
1573: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1574: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1575: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1576: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1577: X_REGION_CODE => X_REGION_CODE,

Line 1587: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1583: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1584: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1585: );
1586:
1587: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1588: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1589: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1590: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1591: X_REGION_CODE => X_REGION_CODE,

Line 1627: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1623:
1624: END IF;
1625:
1626:
1627: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1628: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1629: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1630: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1631: X_REGION_CODE => X_REGION_CODE,

Line 1641: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1637: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1638: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1639: );
1640:
1641: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1642: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1643: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1644: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1645: X_REGION_CODE => X_REGION_CODE,

Line 1655: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1651: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1652: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1653: );
1654:
1655: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1656: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1657: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1658: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1659: X_REGION_CODE => X_REGION_CODE,

Line 1669: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1665: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1666: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1667: );
1668:
1669: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1670: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1671: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1672: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1673: X_REGION_CODE => X_REGION_CODE,

Line 1683: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1679: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1680: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1681: );
1682:
1683: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1684: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1685: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1686: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1687: X_REGION_CODE => X_REGION_CODE,

Line 1698: FROM AK_CUSTOM_REGIONS

1694: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1695: );
1696:
1697: SELECT COUNT(*) INTO l_count
1698: FROM AK_CUSTOM_REGIONS
1699: WHERE
1700: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1701: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1702: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1709: DELETE FROM AK_CUSTOM_REGIONS

1705:
1706: IF (l_count > 0) THEN
1707:
1708: IF (X_IMPORT_FLAG IS NULL) THEN
1709: DELETE FROM AK_CUSTOM_REGIONS
1710: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1711: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1712: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1713: AND REGION_CODE = X_REGION_CODE

Line 1716: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1712: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1713: AND REGION_CODE = X_REGION_CODE
1714: AND PROPERTY_NAME = 'IMPORT_FLAG';
1715: ELSE
1716: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1717: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1718: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1719: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1720: X_REGION_CODE => X_REGION_CODE,

Line 1735: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1731: ELSE
1732:
1733: IF (X_IMPORT_FLAG IS NOT NULL) THEN
1734:
1735: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1736: X_ROWID => l_rowid,
1737: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1738: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1739: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1762: FROM AK_CUSTOM_REGIONS

1758:
1759: IF (X_DATA_LEVEL IS NOT NULL) THEN
1760:
1761: SELECT COUNT(*) INTO l_count
1762: FROM AK_CUSTOM_REGIONS
1763: WHERE
1764: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1765: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1766: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1771: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1767: AND REGION_CODE = X_REGION_CODE
1768: AND PROPERTY_NAME = 'DATA_LEVEL';
1769:
1770: IF (l_count > 0) THEN
1771: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1772: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1773: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1774: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1775: X_REGION_CODE => X_REGION_CODE,

Line 1787: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1783: );
1784:
1785: ELSE
1786:
1787: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1788: X_ROWID => l_rowid,
1789: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1790: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1791: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1859: DELETE FROM AK_CUSTOM_REGIONS

1855: );
1856:
1857: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
1858:
1859: DELETE FROM AK_CUSTOM_REGIONS
1860: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1861: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1862: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1863: AND REGION_CODE = X_REGION_CODE;

Line 1865: DELETE FROM AK_CUSTOM_REGIONS_TL

1861: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1862: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1863: AND REGION_CODE = X_REGION_CODE;
1864:
1865: DELETE FROM AK_CUSTOM_REGIONS_TL
1866: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1867: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1868: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1869: AND REGION_CODE = X_REGION_CODE;

Line 1919: FROM ak_custom_regions_tl

1915: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1916:
1917: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
1918: SELECT last_updated_by, last_update_date
1919: FROM ak_custom_regions_tl
1920: WHERE customization_application_id = p_customization_application_id
1921: AND customization_code = p_customization_code
1922: AND region_application_id = p_region_application_id
1923: AND region_code = p_region_code

Line 1942: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1938: ,l_last_updated_by
1939: ,l_last_update_date
1940: ,NULL)) THEN
1941:
1942: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1943: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
1944: X_CUSTOMIZATION_CODE => p_customization_code,
1945: X_REGION_APPLICATION_ID => p_region_application_id,
1946: X_REGION_CODE => p_region_code,

Line 1967: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1963: ,p_last_update_date
1964: ,l_last_updated_by
1965: ,l_last_update_date
1966: ,NULL)) THEN
1967: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1968: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
1969: X_CUSTOMIZATION_CODE => p_customization_code,
1970: X_REGION_APPLICATION_ID => p_region_application_id,
1971: X_REGION_CODE => p_region_code,