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 3996: from AK_REGION_LOV_RELATIONS

3992: p_base_region_code IN VARCHAR2
3993: ) return boolean is
3994: cursor l_check_lov_relation_csr is
3995: select 1
3996: from AK_REGION_LOV_RELATIONS
3997: where region_application_id = p_region_application_id
3998: and region_code = p_region_code
3999: and attribute_application_id = p_attribute_application_id
4000: and attribute_code = p_attribute_code

Line 4938: insert into AK_REGION_LOV_RELATIONS (

4934: p_create_or_update => 'CREATE') then
4935: null;
4936: end if;
4937:
4938: insert into AK_REGION_LOV_RELATIONS (
4939: REGION_APPLICATION_ID,
4940: REGION_CODE,
4941: ATTRIBUTE_APPLICATION_ID,
4942: ATTRIBUTE_CODE,

Line 5323: from AK_REGION_LOV_RELATIONS

5319: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
5320: ) is
5321: cursor l_get_row_csr is
5322: select *
5323: from AK_REGION_LOV_RELATIONS
5324: where REGION_APPLICATION_ID = p_region_application_id
5325: and REGION_CODE = p_region_code
5326: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
5327: and ATTRIBUTE_CODE = p_attribute_code

Line 5342: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;

5338: l_api_version_number CONSTANT number := 1.0;
5339: l_api_name CONSTANT varchar2(30) := 'Update_Lov_Relation';
5340: l_created_by number;
5341: l_creation_date date;
5342: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
5343: l_required_flag varchar2(1) := 'N';
5344: l_last_update_date date;
5345: l_last_update_login number;
5346: l_last_updated_by number;

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

5360: end if;
5361:
5362: savepoint start_update_lov_relation;
5363:
5364: --** retrieve ak_region_lov_relations row if it exists **
5365: open l_get_row_csr;
5366: fetch l_get_row_csr into l_lov_relation_rec;
5367: if (l_get_row_csr%notfound) then
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 5455: update AK_REGION_LOV_RELATIONS set

5451: p_db_last_update_date => l_lov_relation_rec.last_update_date,
5452: p_last_update_login => l_last_update_login,
5453: p_create_or_update => 'UPDATE') then
5454:
5455: update AK_REGION_LOV_RELATIONS set
5456: REQUIRED_FLAG = l_lov_relation_rec.required_flag,
5457: LAST_UPDATE_DATE = l_last_update_date,
5458: LAST_UPDATED_BY = l_last_updated_by,
5459: LAST_UPDATE_LOGIN = l_last_update_login