APPS.AK_OBJECT3_PVT dependencies on AK_OBJECT_ATTRIBUTE_NAVIGATION

Line 1003: from AK_OBJECT_ATTRIBUTE_NAVIGATION

999: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1000: ) is
1001: cursor l_get_row_1_csr is
1002: select *
1003: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1004: where DATABASE_OBJECT_NAME = p_database_object_name
1005: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1006: and ATTRIBUTE_CODE = p_attribute_code
1007: and VALUE_VARCHAR2 = p_value_varchar2

Line 1013: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1009: and VALUE_NUMBER is null
1010: for update of to_region_appl_id;
1011: cursor l_get_row_2_csr is
1012: select *
1013: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1014: where DATABASE_OBJECT_NAME = p_database_object_name
1015: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1016: and ATTRIBUTE_CODE = p_attribute_code
1017: and VALUE_VARCHAR2 is null

Line 1023: from AK_OBJECT_ATTRIBUTE_NAVIGATION

1019: and VALUE_NUMBER is null
1020: for update of to_region_appl_id;
1021: cursor l_get_row_3_csr is
1022: select *
1023: from AK_OBJECT_ATTRIBUTE_NAVIGATION
1024: where DATABASE_OBJECT_NAME = p_database_object_name
1025: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1026: and ATTRIBUTE_CODE = p_attribute_code
1027: and VALUE_VARCHAR2 is null

Line 1037: l_navigation_rec ak_object_attribute_navigation%ROWTYPE;

1033: l_count number;
1034: l_created_by number;
1035: l_creation_date date;
1036: l_error boolean;
1037: l_navigation_rec ak_object_attribute_navigation%ROWTYPE;
1038: l_last_update_date date;
1039: l_last_update_login number;
1040: l_last_updated_by number;
1041: l_return_status varchar2(1);

Line 1079: --** retrieve ak_object_attribute_navigation row if it exists **

1075: -- dbms_output.put_line('One and only one value field must be non-null');
1076: raise FND_API.G_EXC_ERROR;
1077: end if;
1078:
1079: --** retrieve ak_object_attribute_navigation row if it exists **
1080: if (p_value_varchar2 is not null) then
1081: open l_get_row_1_csr;
1082: fetch l_get_row_1_csr into l_navigation_rec;
1083: if (l_get_row_1_csr%notfound) then

Line 1251: update AK_OBJECT_ATTRIBUTE_NAVIGATION set

1247: p_last_update_login => l_last_update_login,
1248: p_create_or_update => 'UPDATE') then
1249:
1250: if (p_value_varchar2 is not null) then
1251: update AK_OBJECT_ATTRIBUTE_NAVIGATION set
1252: TO_REGION_APPL_ID = l_navigation_rec.to_region_appl_id,
1253: TO_REGION_CODE = l_navigation_rec.to_region_code,
1254: ATTRIBUTE_CATEGORY = l_navigation_rec.attribute_category,
1255: ATTRIBUTE1 = l_navigation_rec.attribute1,

Line 1280: update AK_OBJECT_ATTRIBUTE_NAVIGATION set

1276: and value_varchar2 = p_value_varchar2
1277: and value_date is null
1278: and value_number is null;
1279: elsif (p_value_date is not null) then
1280: update AK_OBJECT_ATTRIBUTE_NAVIGATION set
1281: TO_REGION_APPL_ID = l_navigation_rec.to_region_appl_id,
1282: TO_REGION_CODE = l_navigation_rec.to_region_code,
1283: LAST_UPDATE_DATE = l_last_update_date,
1284: LAST_UPDATED_BY = l_last_updated_by,

Line 1293: update AK_OBJECT_ATTRIBUTE_NAVIGATION set

1289: and value_varchar2 is null
1290: and value_date = p_value_date
1291: and value_number is null;
1292: elsif (p_value_number is not null) then
1293: update AK_OBJECT_ATTRIBUTE_NAVIGATION set
1294: TO_REGION_APPL_ID = l_navigation_rec.to_region_appl_id,
1295: TO_REGION_CODE = l_navigation_rec.to_region_code,
1296: LAST_UPDATE_DATE = l_last_update_date,
1297: LAST_UPDATED_BY = l_last_updated_by,

Line 4354: from ak_object_attribute_navigation aoan

4350: );
4351: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4352: select aoan.last_updated_by, aoan.last_update_date
4353: into l_user_id1, l_update1
4354: from ak_object_attribute_navigation aoan
4355: where aoan.database_object_name = l_navigation_tbl(l_index).database_object_name
4356: and aoan.attribute_code = l_navigation_tbl(l_index).attribute_code
4357: and aoan.attribute_application_id = l_navigation_tbl(l_index).attribute_appl_id
4358: and aoan.value_varchar2 = l_navigation_tbl(l_index).value_varchar2