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_UPLOAD_GRP

Line 1684: if (AK_UPLOAD_GRP.G_EXTRACT_OBJ = 'REGION') then

1680: p_region_code => l_region_tbl(l_index).region_code) then
1681: /* REMOVE DELETE FUNCTIONALITY DURING UPLOAD
1682: --Delete all region items under this region only when the
1683: --jlt file was extracted in the REGION mode
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 (

Line 1707: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

1703: */
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,

Line 1782: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

1778: p_loader_timestamp => p_loader_timestamp,
1779: p_pass => p_pass,
1780: p_copy_redo_flag => l_copy_redo_flag
1781: );
1782: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
1783: -- do not update customized data
1784: select ar.last_updated_by, art.last_updated_by,
1785: ar.last_update_date, art.last_update_date
1786: into l_user_id1, l_user_id2, l_update1, l_update2

Line 2003: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

1999: p_attribute_code => l_item_tbl(l_index).attribute_code) then
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,

Line 2120: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

2116: p_pass => p_pass,
2117: p_copy_redo_flag => l_copy_redo_flag
2118: );
2119: -- update non-customized data only
2120: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
2121: select ari.last_updated_by, arit.last_updated_by,
2122: ari.last_update_date, arit.last_update_date
2123: into l_user_id1, l_user_id2, l_update1, l_update2
2124: from ak_region_items ari, ak_region_items_tl arit

Line 2445: if (AK_UPLOAD_GRP.G_UPDATE_MODE or AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

2441: -- Update Region lov relations if G_UPDATE_MODE is TRUE
2442: -- Also update Region Lov relations if G_NO_CUSTOM_UPDATE since there's
2443: -- no customized data in this table, do not update if G_NO_UPDATE_MODE
2444: --
2445: if (AK_UPLOAD_GRP.G_UPDATE_MODE or AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2446: AK_REGION2_PVT.UPDATE_LOV_RELATION (
2447: p_validation_level => p_validation_level,
2448: p_api_version_number => 1.0,
2449: p_msg_count => l_msg_count,

Line 2657: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

2653: p_graph_number => l_graph_tbl(l_index).graph_number) then
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,

Line 2682: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

2678: p_pass => p_pass,
2679: p_copy_redo_flag => l_copy_redo_flag
2680: );
2681: -- update non-customized data only
2682: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
2683: select arg.last_updated_by, argt.last_updated_by into l_user_id1, l_user_id2
2684: from ak_region_graphs arg, ak_region_graphs_tl argt
2685: where arg.region_code = l_graph_tbl(l_index).region_code
2686: and arg.region_application_id = l_graph_tbl(l_index).region_application_id

Line 2779: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

2775: p_attribute_code => l_graph_column_tbl(l_index).attribute_code) = false) then */
2776: /* --
2777: -- Update Region graph columns if G_UPDATE_MODE is TRUE
2778: --
2779: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
2780: AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (
2781: p_validation_level => p_validation_level,
2782: p_api_version_number => 1.0,
2783: p_msg_count => l_msg_count,

Line 2801: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

2797: p_pass => p_pass,
2798: p_copy_redo_flag => l_copy_redo_flag
2799: );
2800: -- update non-customized data only
2801: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
2802: select last_updated_by into l_user_id1
2803: from ak_region_graph_columns
2804: where region_code = l_graph_column_tbl(l_index).region_code
2805: and region_application_id = l_graph_column_tbl(l_index).region_application_id

Line 3137: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

3133: p_attribute_code => G_ITEM_REDO_TBL(l_index).attribute_code) then
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,

Line 3253: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

3249: p_loader_timestamp => p_loader_timestamp,
3250: p_pass => p_pass,
3251: p_copy_redo_flag => l_copy_redo_flag
3252: );
3253: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3254: select ari.last_updated_by, arit.last_updated_by,
3255: ari.last_update_date, arit.last_update_date
3256: into l_user_id1, l_user_id2, l_update1, l_update2
3257: from ak_region_items ari, ak_region_items_tl arit

Line 4667: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

4663:
4664: -- Create record if no validation error was found
4665:
4666: -- Set WHO columns
4667: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
4668: AK_ON_OBJECTS_PVT.SET_WHO (
4669: p_return_status => l_return_status,
4670: p_loader_timestamp => p_loader_timestamp,
4671: p_created_by => l_created_by,

Line 4677: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

4673: p_last_updated_by => l_last_updated_by,
4674: p_last_update_date => l_last_update_date,
4675: p_last_update_login => l_last_update_login);
4676:
4677: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
4678: l_created_by := p_created_by;
4679: l_last_updated_by := p_last_updated_by;
4680: l_last_update_login := p_last_update_login;
4681: end if;

Line 5172: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

5168:
5169: --** - next, load non-null, non-key columns **
5170:
5171: -- Set WHO columns
5172: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
5173: AK_ON_OBJECTS_PVT.SET_WHO (
5174: p_return_status => l_return_status,
5175: p_loader_timestamp => p_loader_timestamp,
5176: p_created_by => l_created_by,

Line 5182: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

5178: p_last_updated_by => l_last_updated_by,
5179: p_last_update_date => l_last_update_date,
5180: p_last_update_login => l_last_update_login);
5181:
5182: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
5183: l_created_by := p_created_by;
5184: l_last_updated_by := p_last_updated_by;
5185: l_last_update_login := p_last_update_login;
5186: end if;