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 5611: from AK_CATEGORY_USAGES

5607: p_category_name IN VARCHAR2
5608: ) return boolean is
5609: cursor l_check_category_usage_csr is
5610: select 1
5611: from AK_CATEGORY_USAGES
5612: where region_application_id = p_region_application_id
5613: and region_code = p_region_code
5614: and attribute_application_id = p_attribute_application_id
5615: and attribute_code = p_attribute_code

Line 5994: insert into AK_CATEGORY_USAGES (

5990: p_create_or_update => 'CREATE') then
5991: null;
5992: end if;
5993:
5994: insert into AK_CATEGORY_USAGES (
5995: REGION_APPLICATION_ID,
5996: REGION_CODE,
5997: ATTRIBUTE_APPLICATION_ID,
5998: ATTRIBUTE_CODE,

Line 6134: from AK_CATEGORY_USAGES

6130: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
6131: ) is
6132: cursor l_get_row_csr is
6133: select *
6134: from AK_CATEGORY_USAGES
6135: where REGION_APPLICATION_ID = p_region_application_id
6136: and REGION_CODE = p_region_code
6137: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
6138: and ATTRIBUTE_CODE = p_attribute_code

Line 6144: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

6140: l_api_version_number CONSTANT number := 1.0;
6141: l_api_name CONSTANT varchar2(30) := 'Update_Category_Usage';
6142: l_created_by number;
6143: l_creation_date date;
6144: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
6145: l_last_update_date date;
6146: l_last_update_login number;
6147: l_last_updated_by number;
6148: l_return_status varchar2(1);

Line 6242: update AK_CATEGORY_USAGES set

6238: p_db_last_update_date => l_category_usage_rec.last_update_date,
6239: p_last_update_login => l_last_update_login,
6240: p_create_or_update => 'UPDATE') then
6241:
6242: update AK_CATEGORY_USAGES set
6243: SHOW_ALL = p_show_all,
6244: APPLICATION_ID = p_application_id,
6245: LAST_UPDATE_DATE = l_last_update_date,
6246: LAST_UPDATED_BY = l_last_updated_by,