APPS.AK_REGION_PVT dependencies on AK_REGION_PUB

Line 6397: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type,

6393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6394: p_api_version_number IN NUMBER,
6395: p_return_status OUT NOCOPY VARCHAR2,
6396: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
6397: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type,
6398: p_nls_language IN VARCHAR2,
6399: p_get_object_flag IN VARCHAR2
6400: ) is
6401: cursor l_get_region_list_csr (application_id number) is

Line 6481: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;

6477: l_msg_count NUMBER;
6478: l_msg_data VARCHAR2(2000);
6479: l_object_pk_tbl AK_OBJECT_PUB.Object_PK_Tbl_Type;
6480: l_index NUMBER;
6481: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;
6482: l_return_status varchar2(1);
6483: begin
6484: IF NOT FND_API.Compatible_API_Call (
6485: l_api_version_number, p_api_version_number, l_api_name,

Line 6771: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type

6767: procedure INSERT_REGION_PK_TABLE (
6768: p_return_status OUT NOCOPY VARCHAR2,
6769: p_region_application_id IN NUMBER,
6770: p_region_code IN VARCHAR2,
6771: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type
6772: ) is
6773: l_api_version_number CONSTANT number := 1.0;
6774: l_api_name CONSTANT varchar2(30) := 'Insert_Region_PK_Table';
6775: l_index NUMBER;

Line 8848: p_region_pk_tbl in ak_region_pub.region_pk_tbl_type

8844:
8845: Function REGION_KEY_EXISTS (
8846: p_region_application_id in number,
8847: p_region_code in varchar2,
8848: p_region_pk_tbl in ak_region_pub.region_pk_tbl_type
8849: ) return boolean is
8850:
8851: l_exist boolean := true;
8852:

Line 8874: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type

8870:
8871: Procedure ADD_NESTED_REG_TO_REG_PK (
8872: p_region_application_id IN number,
8873: p_region_code IN varchar2,
8874: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type
8875: ) IS
8876: cursor l_get_ri_nested_regions_csr (region_appl_id_param number,
8877: region_code_param varchar2) is
8878: select distinct nested_region_application_id, nested_region_code