APPS.AK_FLOW2_PVT dependencies on AK_UPLOAD_GRP

Line 3582: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then

3578: if (l_flow_tbl.count > 0) then
3579: for l_index in l_flow_tbl.FIRST .. l_flow_tbl.LAST loop
3580: if (l_flow_tbl.exists(l_index)) then
3581: -- update all records
3582: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
3583: AK_FLOW_PVT.UPDATE_FLOW (
3584: p_validation_level => p_validation_level,
3585: p_api_version_number => 1.0,
3586: p_msg_count => l_msg_count,

Line 3623: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE AND (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then

3619: p_copy_redo_flag => l_copy_redo_flag
3620: );
3621: -- update flow records if primary page has been changed or
3622: -- update non-customized data
3623: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE AND (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then
3624: select af.primary_page_code, af.primary_page_appl_id, af.last_updated_by,
3625: aft.last_updated_by,
3626: af.last_update_date, aft.last_update_date
3627: into l_temp_key_code, l_temp_key_appl_id, l_user_id1, l_user_id2, l_update1, l_update2

Line 3736: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

3732: p_region_code => l_region_tbl(l_index).region_code) then
3733: --
3734: -- Update Page Region only if Update Mode is TRUE
3735: --
3736: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
3737: AK_FLOW_PVT.UPDATE_PAGE_REGION (
3738: p_validation_level => p_validation_level,
3739: p_api_version_number => 1.0,
3740: p_msg_count => l_msg_count,

Line 3785: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

3781: p_loader_timestamp => p_loader_timestamp,
3782: p_pass => p_pass,
3783: p_copy_redo_flag => l_copy_redo_flag
3784: );
3785: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3786: select last_updated_by, last_update_date
3787: into l_user_id1, l_update1
3788: from ak_flow_page_regions
3789: where flow_code = l_region_tbl(l_index).flow_code

Line 4008: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then

4004: if (l_page_tbl.count > 0) then
4005: for l_index in l_page_tbl.FIRST .. l_page_tbl.LAST loop
4006: if (l_page_tbl.exists(l_index)) then
4007: -- update all records
4008: if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
4009: AK_FLOW_PVT.UPDATE_PAGE (
4010: p_validation_level => p_validation_level,
4011: p_api_version_number => 1.0,
4012: p_msg_count => l_msg_count,

Line 4051: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE or (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then

4047: p_loader_timestamp => p_loader_timestamp,
4048: p_pass => p_pass,
4049: p_copy_redo_flag => l_copy_redo_flag
4050: );
4051: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE or (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then
4052: select afp.primary_region_code, afp.primary_region_appl_id, afp.last_updated_by,
4053: afpt.last_updated_by,
4054: afp.last_update_date, afpt.last_update_date
4055: into l_temp_key_code, l_temp_key_appl_id,

Line 4180: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4176: p_to_region_code => l_relation_tbl(l_index).to_region_code) then
4177: --
4178: -- Update Flow Page Region Relation only if G_UPDATE_MODE is TRUE
4179: --
4180: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4181: AK_FLOW_PVT.UPDATE_REGION_RELATION (
4182: p_validation_level => p_validation_level,
4183: p_api_version_number => 1.0,
4184: p_msg_count => l_msg_count,

Line 4227: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

4223: p_loader_timestamp => p_loader_timestamp,
4224: p_pass => p_pass,
4225: p_copy_redo_flag => l_copy_redo_flag
4226: );
4227: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4228: select last_updated_by, last_update_date
4229: into l_user_id1, l_update1
4230: from ak_flow_region_relations
4231: where flow_code = l_relation_tbl(l_index).flow_code

Line 4393: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4389: p_attribute_code => l_item_tbl(l_index).attribute_code) then
4390: --
4391: -- Update Flow Page Region Item only if G_UPDATE_MODE is TRUE
4392: --
4393: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4394: AK_FLOW_PVT.UPDATE_PAGE_REGION_ITEM (
4395: p_validation_level => p_validation_level,
4396: p_api_version_number => 1.0,
4397: p_msg_count => l_msg_count,

Line 4443: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

4439: p_loader_timestamp => p_loader_timestamp,
4440: p_pass => p_pass,
4441: p_copy_redo_flag => l_copy_redo_flag
4442: );
4443: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4444: select last_updated_by, last_update_date
4445: into l_user_id1, l_update1
4446: from ak_flow_page_region_items
4447: where flow_code = l_item_tbl(l_index).flow_code