DBA Data[Home] [Help]

APPS.AK_REGION2_PVT dependencies on AK_REGION_ITEMS_TL

Line 2124: from ak_region_items ari, ak_region_items_tl arit

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
2125: where ari.region_code = l_item_tbl(l_index).region_code
2126: and ari.region_application_id = l_item_tbl(l_index).region_application_id
2127: and ari.attribute_code = l_item_tbl(l_index).attribute_code
2128: and ari.attribute_application_id = l_item_tbl(l_index).attribute_application_id

Line 3257: from ak_region_items ari, ak_region_items_tl arit

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
3258: where ari.region_code = G_ITEM_REDO_TBL(l_index).region_code
3259: and ari.region_application_id = G_ITEM_REDO_TBL(l_index).region_application_id
3260: and ari.attribute_code = G_ITEM_REDO_TBL(l_index).attribute_code
3261: and ari.attribute_application_id = G_ITEM_REDO_TBL(l_index).attribute_application_id

Line 3700: from ak_region_items_tl

3696: attribute_code_param IN VARCHAR2,
3697: attribute_application_id_param IN NUMBER,
3698: lang_param IN VARCHAR2) is
3699: select *
3700: from ak_region_items_tl
3701: where region_code = region_code_param
3702: and region_application_id = region_application_id_param
3703: and attribute_code = attribute_code_param
3704: and attribute_application_id = attribute_application_id_param

Line 3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;

3709: l_new_display_sequence NUMBER;
3710: l_return_status VARCHAR2(1);
3711: l_ri_rec ak_region_items%ROWTYPE;
3712: l_orig_ri_rec ak_region_items%ROWTYPE;
3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3714:
3715: begin
3716: l_return_status := FND_API.G_RET_STS_SUCCESS;
3717: open l_ri_csr( p_region_code,