APPS.AK_REGION2_PVT dependencies on AK_CATEGORY_USAGES

Line 110: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

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;
113: l_return_status varchar2(1);
114: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

Line 111: l_empty_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

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;
113: l_return_status varchar2(1);
114: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
115: l_state NUMBER;

Line 5583: from AK_CATEGORY_USAGES

5579: p_category_name IN VARCHAR2
5580: ) return boolean is
5581: cursor l_check_category_usage_csr is
5582: select 1
5583: from AK_CATEGORY_USAGES
5584: where region_application_id = p_region_application_id
5585: and region_code = p_region_code
5586: and attribute_application_id = p_attribute_application_id
5587: and attribute_code = p_attribute_code

Line 5963: insert into AK_CATEGORY_USAGES (

5959: p_create_or_update => 'CREATE') then
5960: null;
5961: end if;
5962:
5963: insert into AK_CATEGORY_USAGES (
5964: REGION_APPLICATION_ID,
5965: REGION_CODE,
5966: ATTRIBUTE_APPLICATION_ID,
5967: ATTRIBUTE_CODE,

Line 6101: from AK_CATEGORY_USAGES

6097: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
6098: ) is
6099: cursor l_get_row_csr is
6100: select *
6101: from AK_CATEGORY_USAGES
6102: where REGION_APPLICATION_ID = p_region_application_id
6103: and REGION_CODE = p_region_code
6104: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
6105: and ATTRIBUTE_CODE = p_attribute_code

Line 6111: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

6107: l_api_version_number CONSTANT number := 1.0;
6108: l_api_name CONSTANT varchar2(30) := 'Update_Category_Usage';
6109: l_created_by number;
6110: l_creation_date date;
6111: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
6112: l_last_update_date date;
6113: l_last_update_login number;
6114: l_last_updated_by number;
6115: l_return_status varchar2(1);

Line 6206: update AK_CATEGORY_USAGES set

6202: p_db_last_update_date => l_category_usage_rec.last_update_date,
6203: p_last_update_login => l_last_update_login,
6204: p_create_or_update => 'UPDATE') then
6205:
6206: update AK_CATEGORY_USAGES set
6207: SHOW_ALL = p_show_all,
6208: APPLICATION_ID = p_application_id,
6209: LAST_UPDATE_DATE = l_last_update_date,
6210: LAST_UPDATED_BY = l_last_updated_by,