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 3139: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

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

Line 3255: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

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

Line 4684: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

4680:
4681: -- Create record if no validation error was found
4682:
4683: -- Set WHO columns
4684: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
4685: AK_ON_OBJECTS_PVT.SET_WHO (
4686: p_return_status => l_return_status,
4687: p_loader_timestamp => p_loader_timestamp,
4688: p_created_by => l_created_by,

Line 4694: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

4690: p_last_updated_by => l_last_updated_by,
4691: p_last_update_date => l_last_update_date,
4692: p_last_update_login => l_last_update_login);
4693:
4694: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
4695: l_created_by := p_created_by;
4696: l_last_updated_by := p_last_updated_by;
4697: l_last_update_login := p_last_update_login;
4698: end if;

Line 5194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

5190:
5191: --** - next, load non-null, non-key columns **
5192:
5193: -- Set WHO columns
5194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
5195: AK_ON_OBJECTS_PVT.SET_WHO (
5196: p_return_status => l_return_status,
5197: p_loader_timestamp => p_loader_timestamp,
5198: p_created_by => l_created_by,

Line 5204: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

5200: p_last_updated_by => l_last_updated_by,
5201: p_last_update_date => l_last_update_date,
5202: p_last_update_login => l_last_update_login);
5203:
5204: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
5205: l_created_by := p_created_by;
5206: l_last_updated_by := p_last_updated_by;
5207: l_last_update_login := p_last_update_login;
5208: end if;