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 1249: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1245: ,X_CLASSIFICATION_1
1246: ,X_CLASSIFICATION_2
1247: ,X_CLASSIFICATION_3) = FALSE) THEN
1248:
1249: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1250: X_ROWID => l_rowid,
1251: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1252: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1253: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1266: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1262: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1263: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1264: );
1265:
1266: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1267: X_ROWID => l_rowid,
1268: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1269: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1270: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1304: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1300: );
1301:
1302: END IF;
1303:
1304: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1305: X_ROWID => l_rowid,
1306: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1307: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1308: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1321: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1317: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1318: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1319: );
1320:
1321: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1322: X_ROWID => l_rowid,
1323: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1324: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1325: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1338: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1334: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1335: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1336: );
1337:
1338: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1339: X_ROWID => l_rowid,
1340: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1341: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1342: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1355: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

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

Line 1372: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

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

Line 1391: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1387: );
1388:
1389: IF (X_IMPORT_FLAG IS NOT NULL) THEN
1390:
1391: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1392: X_ROWID => l_rowid,
1393: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1394: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1395: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1408: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1404: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1405: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1406: );
1407:
1408: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1409: X_ROWID => l_rowid,
1410: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1411: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1412: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1510: AK_CUSTOM_REGIONS_TL name_query ,

1506:
1507: CURSOR get_data_level IS
1508: select data_level_query.property_varchar2_value data_level
1509: from
1510: AK_CUSTOM_REGIONS_TL name_query ,
1511: AK_CUSTOM_REGIONS data_level_query
1512: where name_query.property_name = 'RESULT_NAME'
1513: and name_query.language = USERENV('LANG')
1514: and data_level_query.property_name (+) = 'DATA_LEVEL'

Line 1511: AK_CUSTOM_REGIONS data_level_query

1507: CURSOR get_data_level IS
1508: select data_level_query.property_varchar2_value data_level
1509: from
1510: AK_CUSTOM_REGIONS_TL name_query ,
1511: AK_CUSTOM_REGIONS data_level_query
1512: where name_query.property_name = 'RESULT_NAME'
1513: and name_query.language = USERENV('LANG')
1514: and data_level_query.property_name (+) = 'DATA_LEVEL'
1515: and name_query.customization_application_id = data_level_query.customization_application_id(+)

Line 1541: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1537: ,X_CLASSIFICATION_1
1538: ,X_CLASSIFICATION_2
1539: ,X_CLASSIFICATION_3) = FALSE) THEN
1540:
1541: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1542: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1543: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1544: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1545: X_REGION_CODE => X_REGION_CODE,

Line 1555: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1551: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1552: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1553: );
1554:
1555: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1556: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1557: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1558: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1559: X_REGION_CODE => X_REGION_CODE,

Line 1595: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1591:
1592: END IF;
1593:
1594:
1595: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1596: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1597: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1598: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1599: X_REGION_CODE => X_REGION_CODE,

Line 1609: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1605: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1606: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1607: );
1608:
1609: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1610: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1611: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1612: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1613: X_REGION_CODE => X_REGION_CODE,

Line 1623: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1619: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1620: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1621: );
1622:
1623: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1624: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1625: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1626: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1627: X_REGION_CODE => X_REGION_CODE,

Line 1637: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1633: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1634: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1635: );
1636:
1637: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1638: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1639: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1640: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1641: X_REGION_CODE => X_REGION_CODE,

Line 1651: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1647: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1648: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1649: );
1650:
1651: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1652: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1653: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1654: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1655: X_REGION_CODE => X_REGION_CODE,

Line 1666: FROM AK_CUSTOM_REGIONS

1662: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
1663: );
1664:
1665: SELECT COUNT(*) INTO l_count
1666: FROM AK_CUSTOM_REGIONS
1667: WHERE
1668: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1669: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1670: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1677: DELETE FROM AK_CUSTOM_REGIONS

1673:
1674: IF (l_count > 0) THEN
1675:
1676: IF (X_IMPORT_FLAG IS NULL) THEN
1677: DELETE FROM AK_CUSTOM_REGIONS
1678: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1679: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1680: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1681: AND REGION_CODE = X_REGION_CODE

Line 1684: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1680: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1681: AND REGION_CODE = X_REGION_CODE
1682: AND PROPERTY_NAME = 'IMPORT_FLAG';
1683: ELSE
1684: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1685: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1686: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1687: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1688: X_REGION_CODE => X_REGION_CODE,

Line 1703: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1699: ELSE
1700:
1701: IF (X_IMPORT_FLAG IS NOT NULL) THEN
1702:
1703: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1704: X_ROWID => l_rowid,
1705: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1706: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1707: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1730: FROM AK_CUSTOM_REGIONS

1726:
1727: IF (X_DATA_LEVEL IS NOT NULL) THEN
1728:
1729: SELECT COUNT(*) INTO l_count
1730: FROM AK_CUSTOM_REGIONS
1731: WHERE
1732: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1733: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1734: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1739: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1735: AND REGION_CODE = X_REGION_CODE
1736: AND PROPERTY_NAME = 'DATA_LEVEL';
1737:
1738: IF (l_count > 0) THEN
1739: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1740: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1741: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1742: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
1743: X_REGION_CODE => X_REGION_CODE,

Line 1755: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(

1751: );
1752:
1753: ELSE
1754:
1755: AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
1756: X_ROWID => l_rowid,
1757: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
1758: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
1759: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 1827: DELETE FROM AK_CUSTOM_REGIONS

1823: );
1824:
1825: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
1826:
1827: DELETE FROM AK_CUSTOM_REGIONS
1828: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1829: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1830: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1831: AND REGION_CODE = X_REGION_CODE;

Line 1833: DELETE FROM AK_CUSTOM_REGIONS_TL

1829: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1830: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1831: AND REGION_CODE = X_REGION_CODE;
1832:
1833: DELETE FROM AK_CUSTOM_REGIONS_TL
1834: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1835: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1836: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1837: AND REGION_CODE = X_REGION_CODE;

Line 1887: FROM ak_custom_regions_tl

1883: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1884:
1885: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
1886: SELECT last_updated_by, last_update_date
1887: FROM ak_custom_regions_tl
1888: WHERE customization_application_id = p_customization_application_id
1889: AND customization_code = p_customization_code
1890: AND region_application_id = p_region_application_id
1891: AND region_code = p_region_code

Line 1910: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1906: ,l_last_updated_by
1907: ,l_last_update_date
1908: ,NULL)) THEN
1909:
1910: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1911: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
1912: X_CUSTOMIZATION_CODE => p_customization_code,
1913: X_REGION_APPLICATION_ID => p_region_application_id,
1914: X_REGION_CODE => p_region_code,

Line 1935: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(

1931: ,p_last_update_date
1932: ,l_last_updated_by
1933: ,l_last_update_date
1934: ,NULL)) THEN
1935: AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
1936: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
1937: X_CUSTOMIZATION_CODE => p_customization_code,
1938: X_REGION_APPLICATION_ID => p_region_application_id,
1939: X_REGION_CODE => p_region_code,