APPS.PAY_REPORT_FORMAT_MAPPINGS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_REPORT_FORMAT_MAPPING_ID in NUMBER,
X_TEMPORARY_ACTION_FLAG in VARCHAR2,
X_BUSINESS_GROUP_ID in NUMBER,
X_LEGISLATION_CODE in VARCHAR2,
X_REPORT_TYPE in VARCHAR2,
X_REPORT_QUALIFIER in VARCHAR2,
X_REPORT_FORMAT in VARCHAR2,
X_EFFECTIVE_START_DATE in DATE,
X_EFFECTIVE_END_DATE in DATE,
X_RANGE_CODE in VARCHAR2,
X_ASSIGNMENT_ACTION_CODE in VARCHAR2,
X_INITIALIZATION_CODE in VARCHAR2,
X_ARCHIVE_CODE in VARCHAR2,
X_MAGNETIC_CODE in VARCHAR2,
X_REPORT_CATEGORY in VARCHAR2,
X_REPORT_NAME in VARCHAR2,
X_SORT_CODE in VARCHAR2,
X_UPDATABLE_FLAG in VARCHAR2,
X_DEINITIALIZATION_CODE in VARCHAR2,
X_DISPLAY_NAME in VARCHAR2 ) is
cursor C is select ROWID from PAY_REPORT_FORMAT_MAPPINGS_F
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
;

Line: 28

begin insert into PAY_REPORT_FORMAT_MAPPINGS_F (
TEMPORARY_ACTION_FLAG,
REPORT_FORMAT_MAPPING_ID,
BUSINESS_GROUP_ID,
LEGISLATION_CODE,
REPORT_TYPE,
REPORT_QUALIFIER,
REPORT_FORMAT,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_CATEGORY,
REPORT_NAME,
SORT_CODE,
UPDATABLE_FLAG,
DEINITIALIZATION_CODE
) values (
X_TEMPORARY_ACTION_FLAG,
X_REPORT_FORMAT_MAPPING_ID,
X_BUSINESS_GROUP_ID,
X_LEGISLATION_CODE,
X_REPORT_TYPE,
X_REPORT_QUALIFIER,
X_REPORT_FORMAT,
X_EFFECTIVE_START_DATE,
X_EFFECTIVE_END_DATE,
X_RANGE_CODE,
X_ASSIGNMENT_ACTION_CODE,
X_INITIALIZATION_CODE,
X_ARCHIVE_CODE,
X_MAGNETIC_CODE,
X_REPORT_CATEGORY,
X_REPORT_NAME,
X_SORT_CODE,
X_UPDATABLE_FLAG,
X_DEINITIALIZATION_CODE
);

Line: 70

insert into PAY_REPORT_FORMAT_MAPPINGS_TL (
REPORT_FORMAT_MAPPING_ID,
DISPLAY_NAME,
LANGUAGE,
SOURCE_LANG
) select
X_REPORT_FORMAT_MAPPING_ID,
X_DISPLAY_NAME,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T
where T.REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 95

end INSERT_ROW;

Line: 119

cursor c is select
TEMPORARY_ACTION_FLAG,
BUSINESS_GROUP_ID,
LEGISLATION_CODE,
REPORT_TYPE,
REPORT_QUALIFIER,
REPORT_FORMAT,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_CATEGORY,
REPORT_NAME,
SORT_CODE,
UPDATABLE_FLAG,
DEINITIALIZATION_CODE
from PAY_REPORT_FORMAT_MAPPINGS_F
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
for update of REPORT_FORMAT_MAPPING_ID nowait; recinfo c%rowtype;

Line: 142

cursor c1 is select DISPLAY_NAME, decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from PAY_REPORT_FORMAT_MAPPINGS_TL
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of REPORT_FORMAT_MAPPING_ID nowait;

Line: 150

fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 203

procedure UPDATE_ROW (
X_REPORT_FORMAT_MAPPING_ID in NUMBER,
X_TEMPORARY_ACTION_FLAG in VARCHAR2,
X_BUSINESS_GROUP_ID in NUMBER,
X_LEGISLATION_CODE in VARCHAR2,
X_REPORT_TYPE in VARCHAR2,
X_REPORT_QUALIFIER in VARCHAR2,
X_REPORT_FORMAT in VARCHAR2,
X_EFFECTIVE_START_DATE in DATE,
X_EFFECTIVE_END_DATE in DATE,
X_RANGE_CODE in VARCHAR2,
X_ASSIGNMENT_ACTION_CODE in VARCHAR2,
X_INITIALIZATION_CODE in VARCHAR2,
X_ARCHIVE_CODE in VARCHAR2,
X_MAGNETIC_CODE in VARCHAR2,
X_REPORT_CATEGORY in VARCHAR2,
X_REPORT_NAME in VARCHAR2,
X_SORT_CODE in VARCHAR2,
X_UPDATABLE_FLAG in VARCHAR2,
X_DEINITIALIZATION_CODE in VARCHAR2,
X_DISPLAY_NAME in VARCHAR2
) is
begin
update PAY_REPORT_FORMAT_MAPPINGS_F set
TEMPORARY_ACTION_FLAG = X_TEMPORARY_ACTION_FLAG,
BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
LEGISLATION_CODE = X_LEGISLATION_CODE,
REPORT_TYPE = X_REPORT_TYPE,
REPORT_QUALIFIER = X_REPORT_QUALIFIER,
REPORT_FORMAT = X_REPORT_FORMAT,
EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
RANGE_CODE = X_RANGE_CODE,
ASSIGNMENT_ACTION_CODE = X_ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE = X_INITIALIZATION_CODE,
ARCHIVE_CODE = X_ARCHIVE_CODE,
MAGNETIC_CODE = X_MAGNETIC_CODE,
REPORT_CATEGORY = X_REPORT_CATEGORY,
REPORT_NAME = X_REPORT_NAME,
SORT_CODE = X_SORT_CODE,
UPDATABLE_FLAG = X_UPDATABLE_FLAG,
DEINITIALIZATION_CODE = X_DEINITIALIZATION_CODE
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID;

Line: 251

update PAY_REPORT_FORMAT_MAPPINGS_TL set
DISPLAY_NAME = X_DISPLAY_NAME,
SOURCE_LANG = userenv('LANG')
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 260

end UPDATE_ROW;

Line: 262

procedure DELETE_ROW (
X_REPORT_FORMAT_MAPPING_ID in NUMBER
) is
begin
delete from PAY_REPORT_FORMAT_MAPPINGS_TL
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID;

Line: 273

delete from PAY_REPORT_FORMAT_MAPPINGS_F
where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID;

Line: 279

end DELETE_ROW;

Line: 284

delete from PAY_REPORT_FORMAT_MAPPINGS_TL T
where not exists
   (select NULL from PAY_REPORT_FORMAT_MAPPINGS_F B
    where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );

Line: 289

update PAY_REPORT_FORMAT_MAPPINGS_TL T set (
DISPLAY_NAME
) = (select B.DISPLAY_NAME from PAY_REPORT_FORMAT_MAPPINGS_TL B
     where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID
     and B.LANGUAGE = T.SOURCE_LANG)
where (
T.REPORT_FORMAT_MAPPING_ID,
T.LANGUAGE
) in (select
SUBT.REPORT_FORMAT_MAPPING_ID, SUBT.LANGUAGE
from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB, PAY_REPORT_FORMAT_MAPPINGS_TL SUBT
where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME ));

Line: 304

insert into PAY_REPORT_FORMAT_MAPPINGS_TL (
REPORT_FORMAT_MAPPING_ID,
DISPLAY_NAME,
LANGUAGE,
SOURCE_LANG
) select /*+ ORDERED */
B.REPORT_FORMAT_MAPPING_ID,
B.DISPLAY_NAME,
L.LANGUAGE_CODE, B.SOURCE_LANG from PAY_REPORT_FORMAT_MAPPINGS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
    (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T
     where T.REPORT_FORMAT_MAPPING_ID = B.REPORT_FORMAT_MAPPING_ID
     and T.LANGUAGE = L.LANGUAGE_CODE);