DBA Data[Home] [Help]

APPS.AK_OBJECT_ATTRIBUTES_PKG dependencies on AK_REGION_ITEMS

Line 730: from ak_region_items

726:
727: /* cursor definition */
728: cursor c1 is
729: select 1
730: from ak_region_items
731: where region_application_id = X_REGION_APPLICATION_ID
732: and region_code = X_REGION_CODE
733: and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID
734: and attribute_code = X_ATTRIBUTE_CODE;

Line 737: from ak_region_items

733: and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID
734: and attribute_code = X_ATTRIBUTE_CODE;
735: cursor c2 is
736: select max(display_sequence)
737: from ak_region_items
738: where region_application_id = X_REGION_APPLICATION_ID
739: and region_code = X_REGION_CODE;
740: begin
741: /* no need to insert record if one already exists */

Line 758: ak_region_items_pkg.insert_row(

754: max_sequence := nvl(dummy,0) + 1;
755:
756: /* call package procedure to insert new record */
757:
758: ak_region_items_pkg.insert_row(
759: x_rowid => row_id,
760: x_region_application_id => x_region_application_id,
761: x_region_code => x_region_code,
762: x_attribute_application_id => x_attribute_application_id,