eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_OBJECT2_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38


select *
from   AK_OBJECT_ATTRIBUTE_NAVIGATION
where  DATABASE_OBJECT_NAME = p_database_object_name
and    ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and    ATTRIBUTE_CODE = p_attribute_code;

Line: 233


FND_LOAD_UTIL.OWNER_NAME(l_navigation_rec.last_updated_by) || '"';

Line: 235


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_navigation_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 239


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_navigation_rec.last_update_login),'') || '"';

Line: 325


select *
from   AK_OBJECT_ATTRIBUTES
where  DATABASE_OBJECT_NAME = p_database_object_name;

Line: 330


select *
from   AK_OBJECT_ATTRIBUTES_TL
where  DATABASE_OBJECT_NAME = p_database_object_name
and    ATTRIBUTE_APPLICATION_ID = attribute_appl_id_param
and    ATTRIBUTE_CODE = attribute_code_param
and    LANGUAGE = p_nls_language;

Line: 622


FND_LOAD_UTIL.OWNER_NAME(l_attributes_rec.last_updated_by) || '"';

Line: 624


l_databuffer_tbl(l_index) := '    LAST_UPDATE_DATE = "' ||
to_char(l_attributes_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 628


l_databuffer_tbl(l_index) := '    LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_attributes_rec.last_update_login),'') || '"';

Line: 719


l_databuffer_tbl.delete;

Line: 757


l_databuffer_tbl.delete;

Line: 819


select *
from   AK_FOREIGN_KEYS
where  DATABASE_OBJECT_NAME = p_database_object_name;

Line: 823


select *
from   AK_FOREIGN_KEYS_TL
where  FOREIGN_KEY_NAME = foreign_key_name_param
and    LANGUAGE = p_nls_language;

Line: 828


select *
from   AK_FOREIGN_KEY_COLUMNS
where  FOREIGN_KEY_NAME = foreign_key_name_param;

Line: 1011


FND_LOAD_UTIL.OWNER_NAME(l_foreign_keys_rec.last_updated_by) || '"';

Line: 1013


l_databuffer_tbl(l_index) := '    LAST_UPDATE_DATE = "' ||
to_char(l_foreign_keys_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1017


l_databuffer_tbl(l_index) := '    LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_foreign_keys_rec.last_update_login),'') || '"';

Line: 1213


FND_LOAD_UTIL.OWNER_NAME(l_key_columns_rec.last_updated_by) || '"';

Line: 1215


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_key_columns_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1219


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_key_columns_rec.last_update_login),'') || '"';

Line: 1337


select *
from   AK_UNIQUE_KEYS
where  DATABASE_OBJECT_NAME = p_database_object_name;

Line: 1341


select *
from   AK_UNIQUE_KEY_COLUMNS
where  UNIQUE_KEY_NAME = unique_key_name_param;

Line: 1511


FND_LOAD_UTIL.OWNER_NAME(l_unique_keys_rec.last_updated_by) || '"';

Line: 1513


l_databuffer_tbl(l_index) := '    LAST_UPDATE_DATE = "' ||
to_char(l_unique_keys_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1517


l_databuffer_tbl(l_index) := '    LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_unique_keys_rec.last_update_login),'') || '"';

Line: 1686


FND_LOAD_UTIL.OWNER_NAME(l_key_columns_rec.last_updated_by) || '"';

Line: 1688


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_key_columns_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1692


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_key_columns_rec.last_update_login),'') || '"';

Line: 1778


select *
from AK_OBJECTS
where DATABASE_OBJECT_NAME = p_database_object_name;

Line: 1782


select *
from AK_OBJECTS_TL
where database_object_name = p_database_object_name
and   language = p_nls_language;

Line: 2019


FND_LOAD_UTIL.OWNER_NAME(l_objects_rec.last_updated_by) || '"';

Line: 2021


l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
to_char(l_objects_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 2025


l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_objects_rec.last_update_login),'') || '"';

Line: 2056


l_databuffer_tbl.delete;

Line: 2200


select database_object_name
from AK_OBJECTS
where APPLICATION_ID = appl_id_parm;

Line: 2204


select REGION_APPLICATION_ID, REGION_CODE
from   AK_REGIONS
where  DATABASE_OBJECT_NAME = database_object_name_param;

Line: 2208


select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_OBJECT_ATTRIBUTES
where  DATABASE_OBJECT_NAME = database_object_name_param;

Line: 2213


select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_REGION_ITEMS
where  REGION_APPLICATION_ID = region_appl_id_param
and    REGION_CODE = region_code_param;

Line: 2218


select uk.DATABASE_OBJECT_NAME
from   AK_UNIQUE_KEYS uk, AK_FOREIGN_KEYS fk
where  uk.UNIQUE_KEY_NAME = fk.UNIQUE_KEY_NAME
and    fk.DATABASE_OBJECT_NAME = database_object_name_param;

Line: 2223


select aa.lov_region_application_id, aa.lov_region_code
from   ak_attributes aa, ak_object_attributes aoa
where  aa.attribute_application_id = aoa.attribute_application_id
and    aa.attribute_code = aoa.attribute_code
and    aoa.database_object_name = database_object_name_param
and    aa.lov_region_code is not null;

Line: 2230


select lov_region_application_id, lov_region_code
from   ak_object_attributes
where  database_object_name = database_object_name_param
and    lov_region_code is not null;

Line: 2236


select lov_region_application_id, lov_region_code
from   AK_REGION_ITEMS
where  REGION_APPLICATION_ID = region_appl_id_param
and    REGION_CODE = region_code_param
and    lov_region_code is not null;

Line: 2243


select database_object_name
from   AK_REGIONS
where  REGION_APPLICATION_ID = region_appl_id_param
and    REGION_CODE = region_code_param;

Line: 2280


FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

Line: 2349


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 2364


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 2376


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 2400


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 2420


AK_ATTRIBUTE_PVT.INSERT_ATTRIBUTE_PK_TABLE (
p_return_status => l_return_status,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_attribute_pk_tbl => l_attribute_pk_tbl);

Line: 2438


AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (
p_return_status => l_return_status,
p_database_object_name => l_database_object_name,
p_object_pk_tbl => l_object_pk_tbl);

Line: 2459


AK_ATTRIBUTE_PVT.INSERT_ATTRIBUTE_PK_TABLE (
p_return_status => l_return_status,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_attribute_pk_tbl => l_attribute_pk_tbl);

Line: 2474


AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (
p_return_status => l_return_status,
p_database_object_name => l_database_object_name,
p_object_pk_tbl => l_object_pk_tbl);

Line: 2645


AK_OBJECT3_PVT.UPDATE_OBJECT (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_database_object_name =>
G_OBJECT_REDO_TBL(l_index).database_object_name,
p_name => G_OBJECT_REDO_TBL(l_index).name,
p_description => G_OBJECT_REDO_TBL(l_index).description,
p_application_id => G_OBJECT_REDO_TBL(l_index).application_id,
p_primary_key_name => G_OBJECT_REDO_TBL(l_index).primary_key_name,
p_defaulting_api_pkg => G_OBJECT_REDO_TBL(l_index).defaulting_api_pkg,
p_defaulting_api_proc => G_OBJECT_REDO_TBL(l_index).defaulting_api_proc,
p_validation_api_pkg => G_OBJECT_REDO_TBL(l_index).validation_api_pkg,
p_validation_api_proc => G_OBJECT_REDO_TBL(l_index).validation_api_proc,
p_attribute_category => G_OBJECT_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_OBJECT_REDO_TBL(l_index).attribute1,
p_attribute2 => G_OBJECT_REDO_TBL(l_index).attribute2,
p_attribute3 => G_OBJECT_REDO_TBL(l_index).attribute3,
p_attribute4 => G_OBJECT_REDO_TBL(l_index).attribute4,
p_attribute5 => G_OBJECT_REDO_TBL(l_index).attribute5,
p_attribute6 => G_OBJECT_REDO_TBL(l_index).attribute6,
p_attribute7 => G_OBJECT_REDO_TBL(l_index).attribute7,
p_attribute8 => G_OBJECT_REDO_TBL(l_index).attribute8,
p_attribute9 => G_OBJECT_REDO_TBL(l_index).attribute9,
p_attribute10 => G_OBJECT_REDO_TBL(l_index).attribute10,
p_attribute11 => G_OBJECT_REDO_TBL(l_index).attribute11,
p_attribute12 => G_OBJECT_REDO_TBL(l_index).attribute12,
p_attribute13 => G_OBJECT_REDO_TBL(l_index).attribute13,
p_attribute14 => G_OBJECT_REDO_TBL(l_index).attribute14,
p_attribute15 => G_OBJECT_REDO_TBL(l_index).attribute15,
p_created_by => G_OBJECT_REDO_TBL(l_index).created_by,
p_creation_date => G_OBJECT_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_OBJECT_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_OBJECT_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_OBJECT_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 2721


p_last_updated_by => G_OBJECT_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_OBJECT_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_OBJECT_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 2755


AK_OBJECT3_PVT.UPDATE_ATTRIBUTE (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_database_object_name =>
G_OBJECT_ATTR_REDO_TBL(l_index).database_object_name,
p_attribute_application_id =>
G_OBJECT_ATTR_REDO_TBL(l_index).attribute_appl_id,
p_attribute_code => G_OBJECT_ATTR_REDO_TBL(l_index).attribute_code,
p_column_name => G_OBJECT_ATTR_REDO_TBL(l_index).column_name,
p_attribute_label_length =>
G_OBJECT_ATTR_REDO_TBL(l_index).attribute_label_length,
p_display_value_length =>
G_OBJECT_ATTR_REDO_TBL(l_index).display_value_length,
p_bold => G_OBJECT_ATTR_REDO_TBL(l_index).bold,
p_italic => G_OBJECT_ATTR_REDO_TBL(l_index).italic,
p_vertical_alignment =>
G_OBJECT_ATTR_REDO_TBL(l_index).vertical_alignment,
p_horizontal_alignment =>
G_OBJECT_ATTR_REDO_TBL(l_index).horizontal_alignment,
p_data_source_type => G_OBJECT_ATTR_REDO_TBL(l_index).data_source_type,
p_data_storage_type => G_OBJECT_ATTR_REDO_TBL(l_index).data_storage_type,
p_table_name => G_OBJECT_ATTR_REDO_TBL(l_index).table_name,
p_base_table_column_name =>
G_OBJECT_ATTR_REDO_TBL(l_index).base_table_column_name,
p_required_flag => G_OBJECT_ATTR_REDO_TBL(l_index).required_flag,
p_default_value_varchar2 =>
G_OBJECT_ATTR_REDO_TBL(l_index).default_value_varchar2,
p_default_value_number =>
G_OBJECT_ATTR_REDO_TBL(l_index).default_value_number,
p_default_value_date =>
G_OBJECT_ATTR_REDO_TBL(l_index).default_value_date,
p_lov_region_application_id =>
G_OBJECT_ATTR_REDO_TBL(l_index).lov_region_application_id,
p_lov_region_code => G_OBJECT_ATTR_REDO_TBL(l_index).lov_region_code,
p_lov_foreign_key_name =>
G_OBJECT_ATTR_REDO_TBL(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
G_OBJECT_ATTR_REDO_TBL(l_index).lov_attribute_application_id,
p_lov_attribute_code =>
G_OBJECT_ATTR_REDO_TBL(l_index).lov_attribute_code,
p_defaulting_api_pkg =>
G_OBJECT_ATTR_REDO_TBL(l_index).defaulting_api_pkg,
p_defaulting_api_proc =>
G_OBJECT_ATTR_REDO_TBL(l_index).defaulting_api_proc,
p_validation_api_pkg =>G_OBJECT_ATTR_REDO_TBL(l_index).validation_api_pkg,
p_validation_api_proc =>
G_OBJECT_ATTR_REDO_TBL(l_index).validation_api_proc,
p_attribute_category => G_OBJECT_ATTR_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute1,
p_attribute2 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute2,
p_attribute3 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute3,
p_attribute4 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute4,
p_attribute5 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute5,
p_attribute6 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute6,
p_attribute7 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute7,
p_attribute8 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute8,
p_attribute9 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute9,
p_attribute10 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute10,
p_attribute11 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute11,
p_attribute12 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute12,
p_attribute13 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute13,
p_attribute14 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute14,
p_attribute15 => G_OBJECT_ATTR_REDO_TBL(l_index).attribute15,
p_attribute_label_long =>
G_OBJECT_ATTR_REDO_TBL(l_index).attribute_label_long,
p_attribute_label_short =>
G_OBJECT_ATTR_REDO_TBL(l_index).attribute_label_short,
p_created_by => G_OBJECT_ATTR_REDO_TBL(l_index).created_by,
p_creation_date => G_OBJECT_ATTR_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_OBJECT_ATTR_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_OBJECT_ATTR_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_OBJECT_ATTR_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 2937


AK_OBJECT3_PVT.UPDATE_ATTRIBUTE_NAVIGATION (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_database_object_name =>
G_ATTR_NAV_REDO_TBL(l_index).database_object_name,
p_attribute_application_id =>
G_ATTR_NAV_REDO_TBL(l_index).attribute_appl_id,
p_attribute_code => G_ATTR_NAV_REDO_TBL(l_index).attribute_code,
p_value_varchar2 => G_ATTR_NAV_REDO_TBL(l_index).value_varchar2,
p_value_date => G_ATTR_NAV_REDO_TBL(l_index).value_date,
p_value_number => G_ATTR_NAV_REDO_TBL(l_index).value_number,
p_to_region_appl_id => G_ATTR_NAV_REDO_TBL(l_index).to_region_appl_id,
p_to_region_code => G_ATTR_NAV_REDO_TBL(l_index).to_region_code,
p_attribute_category => G_ATTR_NAV_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_ATTR_NAV_REDO_TBL(l_index).attribute1,
p_attribute2 => G_ATTR_NAV_REDO_TBL(l_index).attribute2,
p_attribute3 => G_ATTR_NAV_REDO_TBL(l_index).attribute3,
p_attribute4 => G_ATTR_NAV_REDO_TBL(l_index).attribute4,
p_attribute5 => G_ATTR_NAV_REDO_TBL(l_index).attribute5,
p_attribute6 => G_ATTR_NAV_REDO_TBL(l_index).attribute6,
p_attribute7 => G_ATTR_NAV_REDO_TBL(l_index).attribute7,
p_attribute8 => G_ATTR_NAV_REDO_TBL(l_index).attribute8,
p_attribute9 => G_ATTR_NAV_REDO_TBL(l_index).attribute9,
p_attribute10 => G_ATTR_NAV_REDO_TBL(l_index).attribute10,
p_attribute11 => G_ATTR_NAV_REDO_TBL(l_index).attribute11,
p_attribute12 => G_ATTR_NAV_REDO_TBL(l_index).attribute12,
p_attribute13 => G_ATTR_NAV_REDO_TBL(l_index).attribute13,
p_attribute14 => G_ATTR_NAV_REDO_TBL(l_index).attribute14,
p_attribute15 => G_ATTR_NAV_REDO_TBL(l_index).attribute15,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3036


AK_KEY_PVT.UPDATE_UNIQUE_KEY (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_unique_key_name =>
G_UNIQUE_KEY_REDO_TBL(l_index).unique_key_name,
p_database_object_name =>
G_UNIQUE_KEY_REDO_TBL(l_index).database_object_name,
p_application_id => G_UNIQUE_KEY_REDO_TBL(l_index).application_id,
p_attribute_category => G_UNIQUE_KEY_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute1,
p_attribute2 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute2,
p_attribute3 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute3,
p_attribute4 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute4,
p_attribute5 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute5,
p_attribute6 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute6,
p_attribute7 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute7,
p_attribute8 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute8,
p_attribute9 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute9,
p_attribute10 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute10,
p_attribute11 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute11,
p_attribute12 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute12,
p_attribute13 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute13,
p_attribute14 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute14,
p_attribute15 => G_UNIQUE_KEY_REDO_TBL(l_index).attribute15,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3127


AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_unique_key_name =>
G_UNIQUE_KEY_COL_REDO_TBL(l_index).unique_key_name,
p_attribute_application_id =>
G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_application_id,
p_attribute_code =>
G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_code,
p_unique_key_sequence =>
G_UNIQUE_KEY_COL_REDO_TBL(l_index).unique_key_sequence,
p_attribute_category => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute1,
p_attribute2 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute2,
p_attribute3 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute3,
p_attribute4 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute4,
p_attribute5 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute5,
p_attribute6 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute6,
p_attribute7 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute7,
p_attribute8 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute8,
p_attribute9 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute9,
p_attribute10 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute10,
p_attribute11 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute11,
p_attribute12 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute12,
p_attribute13 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute13,
p_attribute14 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute14,
p_attribute15 => G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute15,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3220


AK_KEY_PVT.UPDATE_FOREIGN_KEY (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name =>
G_FOREIGN_KEY_REDO_TBL(l_index).foreign_key_name,
p_database_object_name =>
G_FOREIGN_KEY_REDO_TBL(l_index).database_object_name,
p_unique_key_name =>
G_FOREIGN_KEY_REDO_TBL(l_index).unique_key_name,
p_application_id => G_FOREIGN_KEY_REDO_TBL(l_index).application_id,
p_attribute_category => G_FOREIGN_KEY_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute1,
p_attribute2 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute2,
p_attribute3 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute3,
p_attribute4 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute4,
p_attribute5 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute5,
p_attribute6 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute6,
p_attribute7 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute7,
p_attribute8 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute8,
p_attribute9 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute9,
p_attribute10 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute10,
p_attribute11 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute11,
p_attribute12 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute12,
p_attribute13 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute13,
p_attribute14 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute14,
p_attribute15 => G_FOREIGN_KEY_REDO_TBL(l_index).attribute15,
p_from_to_name => G_FOREIGN_KEY_REDO_TBL(l_index).from_to_name,
p_from_to_description =>
G_FOREIGN_KEY_REDO_TBL(l_index).from_to_description,
p_to_from_name => G_FOREIGN_KEY_REDO_TBL(l_index).to_from_name,
p_to_from_description =>
G_FOREIGN_KEY_REDO_TBL(l_index).to_from_description,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3327


AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name =>
G_FOREIGN_KEY_COL_REDO_TBL(l_index).foreign_key_name,
p_attribute_application_id =>
G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_application_id,
p_attribute_code =>
G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_code,
p_foreign_key_sequence =>
G_FOREIGN_KEY_COL_REDO_TBL(l_index).foreign_key_sequence,
p_attribute_category => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute1,
p_attribute2 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute2,
p_attribute3 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute3,
p_attribute4 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute4,
p_attribute5 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute5,
p_attribute6 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute6,
p_attribute7 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute7,
p_attribute8 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute8,
p_attribute9 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute9,
p_attribute10 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute10,
p_attribute11 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute11,
p_attribute12 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute12,
p_attribute13 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute13,
p_attribute14 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute14,
p_attribute15 => G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute15,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);