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_REGION2_PVT dependencies on AK_REGION_PVT

Line 1675: if AK_REGION_PVT.REGION_EXISTS (

1671: --
1672: if (l_region_tbl.count > 0) then
1673: for l_index in l_region_tbl.FIRST .. l_region_tbl.LAST loop
1674: if (l_region_tbl.exists(l_index)) then
1675: if AK_REGION_PVT.REGION_EXISTS (
1676: p_api_version_number => 1.0,
1677: p_return_status => l_return_status,
1678: p_region_application_id =>
1679: l_region_tbl(l_index).region_application_id,

Line 1688: AK_REGION_PVT.DELETE_ITEM (

1684: if (AK_UPLOAD_GRP.G_EXTRACT_OBJ = 'REGION') then
1685: for l_item_rec in l_get_region_item_csr(
1686: l_region_tbl(l_index).region_application_id,
1687: l_region_tbl(l_index).region_code) LOOP
1688: AK_REGION_PVT.DELETE_ITEM (
1689: p_validation_level => p_validation_level,
1690: p_api_version_number => 1.0,
1691: p_msg_count => l_msg_count,
1692: p_msg_data => l_msg_data,

Line 1708: AK_REGION_PVT.UPDATE_REGION (

1704: --
1705: -- Update Regions only if G_UPDATE_MODE is TRUE
1706: --
1707: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
1708: AK_REGION_PVT.UPDATE_REGION (
1709: p_validation_level => p_validation_level,
1710: p_api_version_number => 1.0,
1711: p_msg_count => l_msg_count,
1712: p_msg_data => l_msg_data,

Line 1817: AK_REGION_PVT.UPDATE_REGION (

1813: p_db_last_update_date => l_update2,
1814: p_last_update_login => l_region_tbl(l_index).last_update_login,
1815: p_create_or_update => 'UPDATE')) then
1816:
1817: AK_REGION_PVT.UPDATE_REGION (
1818: p_validation_level => p_validation_level,
1819: p_api_version_number => 1.0,
1820: p_msg_count => l_msg_count,
1821: p_msg_data => l_msg_data,

Line 1894: AK_REGION_PVT.CREATE_REGION (

1890: );
1891: end if; -- /* if ( l_user_id1 = 1 and l_user_id2 = 1 ) */
1892: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1893: else
1894: AK_REGION_PVT.CREATE_REGION (
1895: p_validation_level => p_validation_level,
1896: p_api_version_number => 1.0,
1897: p_msg_count => l_msg_count,
1898: p_msg_data => l_msg_data,

Line 1992: if AK_REGION_PVT.ITEM_EXISTS (

1988: --
1989: if (l_item_tbl.count > 0) then
1990: for l_index in l_item_tbl.FIRST .. l_item_tbl.LAST loop
1991: if (l_item_tbl.exists(l_index)) then
1992: if AK_REGION_PVT.ITEM_EXISTS (
1993: p_api_version_number => 1.0,
1994: p_return_status => l_return_status,
1995: p_region_application_id =>l_item_tbl(l_index).region_application_id,
1996: p_region_code => l_item_tbl(l_index).region_code,

Line 2004: AK_REGION_PVT.UPDATE_ITEM (

2000: --
2001: -- Update Region Items only if G_UPDATE_MODE is TRUE
2002: --
2003: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
2004: AK_REGION_PVT.UPDATE_ITEM (
2005: p_validation_level => p_validation_level,
2006: p_api_version_number => 1.0,
2007: p_msg_count => l_msg_count,
2008: p_msg_data => l_msg_data,

Line 2158: AK_REGION_PVT.UPDATE_ITEM (

2154: p_db_last_update_date => l_update2,
2155: p_last_update_login => l_item_tbl(l_index).last_update_login,
2156: p_create_or_update => 'UPDATE')) then
2157:
2158: AK_REGION_PVT.UPDATE_ITEM (
2159: p_validation_level => p_validation_level,
2160: p_api_version_number => 1.0,
2161: p_msg_count => l_msg_count,
2162: p_msg_data => l_msg_data,

Line 2276: AK_REGION_PVT.CREATE_ITEM (

2272: );
2273: end if; /* if l_user_id1 = 1 and l_user_id2 = 1 */
2274: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
2275: else
2276: AK_REGION_PVT.CREATE_ITEM (
2277: p_validation_level => p_validation_level,
2278: p_api_version_number => 1.0,
2279: p_msg_count => l_msg_count,
2280: p_msg_data => l_msg_data,

Line 2648: if AK_REGION_PVT.GRAPH_EXISTS (

2644: --
2645: if (l_graph_tbl.count > 0) then
2646: for l_index in l_graph_tbl.FIRST .. l_graph_tbl.LAST loop
2647: if (l_graph_tbl.exists(l_index)) then
2648: if AK_REGION_PVT.GRAPH_EXISTS (
2649: p_api_version_number => 1.0,
2650: p_return_status => l_return_status,
2651: p_region_application_id => l_graph_tbl(l_index).region_application_id,
2652: p_region_code => l_graph_tbl(l_index).region_code,

Line 2658: AK_REGION_PVT.UPDATE_GRAPH (

2654: --
2655: -- Update Region Graphs only if G_UPDATE_MODE is TRUE
2656: --
2657: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
2658: AK_REGION_PVT.UPDATE_GRAPH (
2659: p_validation_level => p_validation_level,
2660: p_api_version_number => 1.0,
2661: p_msg_count => l_msg_count,
2662: p_msg_data => l_msg_data,

Line 2694: AK_REGION_PVT.UPDATE_GRAPH (

2690: and arg.graph_number = argt.graph_number
2691: and argt.language = userenv('LANG');
2692: if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
2693: ( l_user_id2 = 1 or l_user_id2 = 2 )) then
2694: AK_REGION_PVT.UPDATE_GRAPH (
2695: p_validation_level => p_validation_level,
2696: p_api_version_number => 1.0,
2697: p_msg_count => l_msg_count,
2698: p_msg_data => l_msg_data,

Line 2720: AK_REGION_PVT.CREATE_GRAPH (

2716: );
2717: end if; -- if l_user_id1 = 1 and l_user_id2 = 1
2718: end if; -- if G_UPDATE_MODE G_NO_CUSTOM_UPDATE
2719: else
2720: AK_REGION_PVT.CREATE_GRAPH (
2721: p_validation_level => p_validation_level,
2722: p_api_version_number => 1.0,
2723: p_msg_count => l_msg_count,
2724: p_msg_data => l_msg_data,

Line 2954: if AK_REGION_PVT.REGION_EXISTS (

2950: --
2951: if (G_REGION_REDO_INDEX > 0) then
2952: for l_index in G_REGION_REDO_TBL.FIRST .. G_REGION_REDO_TBL.LAST loop
2953: if (G_REGION_REDO_TBL.exists(l_index)) then
2954: if AK_REGION_PVT.REGION_EXISTS (
2955: p_api_version_number => 1.0,
2956: p_return_status => l_return_status,
2957: p_region_application_id =>
2958: G_REGION_REDO_TBL(l_index).region_application_id,

Line 2960: AK_REGION_PVT.UPDATE_REGION (

2956: p_return_status => l_return_status,
2957: p_region_application_id =>
2958: G_REGION_REDO_TBL(l_index).region_application_id,
2959: p_region_code => G_REGION_REDO_TBL(l_index).region_code) then
2960: AK_REGION_PVT.UPDATE_REGION (
2961: p_validation_level => p_validation_level,
2962: p_api_version_number => 1.0,
2963: p_msg_count => l_msg_count,
2964: p_msg_data => l_msg_data,

Line 3035: AK_REGION_PVT.CREATE_REGION (

3031: p_pass => p_pass,
3032: p_copy_redo_flag => l_copy_redo_flag
3033: );
3034: else
3035: AK_REGION_PVT.CREATE_REGION (
3036: p_validation_level => p_validation_level,
3037: p_api_version_number => 1.0,
3038: p_msg_count => l_msg_count,
3039: p_msg_data => l_msg_data,

Line 3126: if AK_REGION_PVT.ITEM_EXISTS (

3122: --
3123: if (G_ITEM_REDO_INDEX > 0) then
3124: for l_index in G_ITEM_REDO_TBL.FIRST .. G_ITEM_REDO_TBL.LAST loop
3125: if (G_ITEM_REDO_TBL.exists(l_index)) then
3126: if AK_REGION_PVT.ITEM_EXISTS (
3127: p_api_version_number => 1.0,
3128: p_return_status => l_return_status,
3129: p_region_application_id =>G_ITEM_REDO_TBL(l_index).region_application_id,
3130: p_region_code => G_ITEM_REDO_TBL(l_index).region_code,

Line 3138: AK_REGION_PVT.UPDATE_ITEM (

3134: --
3135: -- Update Region Items only if G_UPDATE_MODE is TRUE
3136: --
3137: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
3138: AK_REGION_PVT.UPDATE_ITEM (
3139: p_validation_level => p_validation_level,
3140: p_api_version_number => 1.0,
3141: p_msg_count => l_msg_count,
3142: p_msg_data => l_msg_data,

Line 3291: AK_REGION_PVT.UPDATE_ITEM (

3287: p_db_last_update_date => l_update2,
3288: p_last_update_login => G_ITEM_REDO_TBL(l_index).last_update_login,
3289: p_create_or_update => 'UPDATE')) then
3290:
3291: AK_REGION_PVT.UPDATE_ITEM (
3292: p_validation_level => p_validation_level,
3293: p_api_version_number => 1.0,
3294: p_msg_count => l_msg_count,
3295: p_msg_data => l_msg_data,

Line 3409: AK_REGION_PVT.CREATE_ITEM (

3405: );
3406: end if; -- /* if l_user_id1 = 1 and l_user_id2 = 1 */
3407: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE*/
3408: else
3409: AK_REGION_PVT.CREATE_ITEM (
3410: p_validation_level => p_validation_level,
3411: p_api_version_number => 1.0,
3412: p_msg_count => l_msg_count,
3413: p_msg_data => l_msg_data,

Line 3757: AK_REGION_PVT.UPDATE_ITEM (

3753: fetch l_ri_csr into l_ri_rec;
3754: end loop;
3755:
3756: --** ASSUMPTION: You have found a unique sequence number for this region.
3757: AK_REGION_PVT.UPDATE_ITEM (
3758: p_validation_level => p_validation_level,
3759: p_api_version_number => 1.0,
3760: p_msg_count => p_msg_count,
3761: p_msg_data => p_msg_data,