APPS.AK_REGION2_PVT dependencies on AK_REGION_LOV_RELATIONS

Line 107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;

103: l_lov_relation_index NUMBER := 0;
104: l_category_usage_index NUMBER := 0;
105: l_region_rec AK_REGION_PUB.Region_Rec_Type;
106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;
107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_Type;
110: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
111: l_empty_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

Line 108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;

104: l_category_usage_index NUMBER := 0;
105: l_region_rec AK_REGION_PUB.Region_Rec_Type;
106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;
107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_Type;
110: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
111: l_empty_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
112: l_category_usage_tbl AK_REGION_PUB.Category_Usages_Tbl_Type;

Line 4013: from AK_REGION_LOV_RELATIONS

4009: p_base_region_code IN VARCHAR2
4010: ) return boolean is
4011: cursor l_check_lov_relation_csr is
4012: select 1
4013: from AK_REGION_LOV_RELATIONS
4014: where region_application_id = p_region_application_id
4015: and region_code = p_region_code
4016: and attribute_application_id = p_attribute_application_id
4017: and attribute_code = p_attribute_code

Line 4958: insert into AK_REGION_LOV_RELATIONS (

4954: p_create_or_update => 'CREATE') then
4955: null;
4956: end if;
4957:
4958: insert into AK_REGION_LOV_RELATIONS (
4959: REGION_APPLICATION_ID,
4960: REGION_CODE,
4961: ATTRIBUTE_APPLICATION_ID,
4962: ATTRIBUTE_CODE,

Line 5345: from AK_REGION_LOV_RELATIONS

5341: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
5342: ) is
5343: cursor l_get_row_csr is
5344: select *
5345: from AK_REGION_LOV_RELATIONS
5346: where REGION_APPLICATION_ID = p_region_application_id
5347: and REGION_CODE = p_region_code
5348: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
5349: and ATTRIBUTE_CODE = p_attribute_code

Line 5364: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;

5360: l_api_version_number CONSTANT number := 1.0;
5361: l_api_name CONSTANT varchar2(30) := 'Update_Lov_Relation';
5362: l_created_by number;
5363: l_creation_date date;
5364: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
5365: l_required_flag varchar2(1) := 'N';
5366: l_last_update_date date;
5367: l_last_update_login number;
5368: l_last_updated_by number;

Line 5386: --** retrieve ak_region_lov_relations row if it exists **

5382: end if;
5383:
5384: savepoint start_update_lov_relation;
5385:
5386: --** retrieve ak_region_lov_relations row if it exists **
5387: open l_get_row_csr;
5388: fetch l_get_row_csr into l_lov_relation_rec;
5389: if (l_get_row_csr%notfound) then
5390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 5480: update AK_REGION_LOV_RELATIONS set

5476: p_db_last_update_date => l_lov_relation_rec.last_update_date,
5477: p_last_update_login => l_last_update_login,
5478: p_create_or_update => 'UPDATE') then
5479:
5480: update AK_REGION_LOV_RELATIONS set
5481: REQUIRED_FLAG = l_lov_relation_rec.required_flag,
5482: LAST_UPDATE_DATE = l_last_update_date,
5483: LAST_UPDATED_BY = l_last_updated_by,
5484: LAST_UPDATE_LOGIN = l_last_update_login