APPS.AK_REGION_PVT dependencies on AK_REGION_PUB

Line 6386: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type,

6382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6383: p_api_version_number IN NUMBER,
6384: p_return_status OUT NOCOPY VARCHAR2,
6385: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
6386: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type,
6387: p_nls_language IN VARCHAR2,
6388: p_get_object_flag IN VARCHAR2
6389: ) is
6390: cursor l_get_region_list_csr (application_id number) is

Line 6470: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;

6466: l_msg_count NUMBER;
6467: l_msg_data VARCHAR2(2000);
6468: l_object_pk_tbl AK_OBJECT_PUB.Object_PK_Tbl_Type;
6469: l_index NUMBER;
6470: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;
6471: l_return_status varchar2(1);
6472: begin
6473: IF NOT FND_API.Compatible_API_Call (
6474: l_api_version_number, p_api_version_number, l_api_name,

Line 6760: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type

6756: procedure INSERT_REGION_PK_TABLE (
6757: p_return_status OUT NOCOPY VARCHAR2,
6758: p_region_application_id IN NUMBER,
6759: p_region_code IN VARCHAR2,
6760: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type
6761: ) is
6762: l_api_version_number CONSTANT number := 1.0;
6763: l_api_name CONSTANT varchar2(30) := 'Insert_Region_PK_Table';
6764: l_index NUMBER;

Line 8825: p_region_pk_tbl in ak_region_pub.region_pk_tbl_type

8821:
8822: Function REGION_KEY_EXISTS (
8823: p_region_application_id in number,
8824: p_region_code in varchar2,
8825: p_region_pk_tbl in ak_region_pub.region_pk_tbl_type
8826: ) return boolean is
8827:
8828: l_exist boolean := true;
8829:

Line 8851: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type

8847:
8848: Procedure ADD_NESTED_REG_TO_REG_PK (
8849: p_region_application_id IN number,
8850: p_region_code IN varchar2,
8851: p_region_pk_tbl IN OUT NOCOPY AK_REGION_PUB.Region_PK_Tbl_Type
8852: ) IS
8853: cursor l_get_ri_nested_regions_csr (region_appl_id_param number,
8854: region_code_param varchar2) is
8855: select distinct nested_region_application_id, nested_region_code