APPS.PER_DK_POSTALCODE_UPLOAD SQL Statements

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

Line: 231

    update_flag VARCHAR2(2);

Line: 238

	update_flag :='N';

Line: 243

	   select SECURITY_GROUP_ID into l_security_group_id from per_business_groups where business_group_id = g_bg_id;

Line: 271

			    select 'Y' INTO update_flag
		            from fnd_lookup_values
			    where lookup_type=l_lookup_type
			    and lookup_code=l_lookup_code and
			    security_group_id = l_security_group_id and
			    view_application_id = l_view_application_id and
				language = userenv('LANG');

Line: 284

		            IF  update_flag='Y' then
				update_row(l_lookup_code,l_meaning,l_description);

Line: 287

				insert_row(l_lookup_code,l_meaning,l_description);

Line: 301

PROCEDURE insert_row
         ( p_lookup_code	IN fnd_lookup_values.lookup_code%type,
	   p_meaning		IN fnd_lookup_values.meaning%type,
	   p_description	IN fnd_lookup_values.description%type)

IS

l_lookup_type            CONSTANT VARCHAR2(50):='DK_POSTCODE_TOWN';

Line: 314

    FND_LOOKUP_VALUES_PKG.INSERT_ROW(
    X_ROWID => l_rowid,
    X_LOOKUP_TYPE => l_lookup_type,
    X_SECURITY_GROUP_ID => l_security_group_id,
    X_VIEW_APPLICATION_ID => 3,
    X_LOOKUP_CODE => p_lookup_code,
    X_TAG => NULL,
    X_ATTRIBUTE_CATEGORY => null,
    X_ATTRIBUTE1 => null,
    X_ATTRIBUTE2 => null,
    X_ATTRIBUTE3 => null,
    X_ATTRIBUTE4 => null,
    X_ENABLED_FLAG => 'Y',
    X_START_DATE_ACTIVE => null,
    X_END_DATE_ACTIVE => null,
    X_TERRITORY_CODE => 'DK',
    X_ATTRIBUTE5 => null,
    X_ATTRIBUTE6 => null,
    X_ATTRIBUTE7 => null,
    X_ATTRIBUTE8 => null,
    X_ATTRIBUTE9 => null,
    X_ATTRIBUTE10 => null,
    X_ATTRIBUTE11 => null,
    X_ATTRIBUTE12 => null,
    X_ATTRIBUTE13 => null,
    X_ATTRIBUTE14 => null,
    X_ATTRIBUTE15 => null,
    X_MEANING => p_meaning,
    X_DESCRIPTION => p_description,
    X_CREATION_DATE => SYSDATE,
    X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
    X_LAST_UPDATE_DATE => SYSDATE,
    X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
    X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));

Line: 349

    hr_utility.set_location (   ' insert row ', 30);

Line: 351

end insert_row;

Line: 355

PROCEDURE update_row
	  ( p_lookup_code	IN fnd_lookup_values.lookup_code%type,
	   p_meaning		IN fnd_lookup_values.meaning%type,
	   p_description	IN fnd_lookup_values.description%type)

IS

l_lookup_type            CONSTANT VARCHAR2(50):='DK_POSTCODE_TOWN';

Line: 366

    FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
    X_LOOKUP_TYPE =>  l_lookup_type,
    X_SECURITY_GROUP_ID => l_security_group_id,
    X_VIEW_APPLICATION_ID => 3,
    X_LOOKUP_CODE => l_lookup_code,
    X_TAG => NULL,
    X_ATTRIBUTE_CATEGORY => NULL,
    X_ATTRIBUTE1 => NULL,
    X_ATTRIBUTE2 => NULL,
    X_ATTRIBUTE3 => NULL,
    X_ATTRIBUTE4 => NULL,
    X_ENABLED_FLAG => 'Y',
    X_START_DATE_ACTIVE => null,
    X_END_DATE_ACTIVE => NULL,
    X_TERRITORY_CODE => 'DK',
    X_ATTRIBUTE5 => NULL,
    X_ATTRIBUTE6 => NULL,
    X_ATTRIBUTE7 => NULL,
    X_ATTRIBUTE8 => NULL,
    X_ATTRIBUTE9 => NULL,
    X_ATTRIBUTE10 => NULL,
    X_ATTRIBUTE11 => NULL,
    X_ATTRIBUTE12 => NULL,
    X_ATTRIBUTE13 => NULL,
    X_ATTRIBUTE14 => NULL,
    X_ATTRIBUTE15 => NULL,
    X_MEANING => p_meaning,
    X_DESCRIPTION => p_description,
    X_LAST_UPDATE_DATE => SYSDATE,
    X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
    X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));

Line: 398

        hr_utility.set_location (   ' update row ', 30);

Line: 399

end update_row;