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 3259: from ak_region_items ari, ak_region_items_tl arit

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

Line 3717: from ak_region_items_tl

3713: attribute_code_param IN VARCHAR2,
3714: attribute_application_id_param IN NUMBER,
3715: lang_param IN VARCHAR2) is
3716: select *
3717: from ak_region_items_tl
3718: where region_code = region_code_param
3719: and region_application_id = region_application_id_param
3720: and attribute_code = attribute_code_param
3721: and attribute_application_id = attribute_application_id_param

Line 3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;

3726: l_new_display_sequence NUMBER;
3727: l_return_status VARCHAR2(1);
3728: l_ri_rec ak_region_items%ROWTYPE;
3729: l_orig_ri_rec ak_region_items%ROWTYPE;
3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3731:
3732: begin
3733: l_return_status := FND_API.G_RET_STS_SUCCESS;
3734: open l_ri_csr( p_region_code,