21: X_SORT_CODE in VARCHAR2,
22: X_UPDATABLE_FLAG in VARCHAR2,
23: X_DEINITIALIZATION_CODE in VARCHAR2,
24: X_DISPLAY_NAME in VARCHAR2 ) is
25: cursor C is select ROWID from PAY_REPORT_FORMAT_MAPPINGS_F
26: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
27: ;
28: begin insert into PAY_REPORT_FORMAT_MAPPINGS_F (
29: TEMPORARY_ACTION_FLAG,
24: X_DISPLAY_NAME in VARCHAR2 ) is
25: cursor C is select ROWID from PAY_REPORT_FORMAT_MAPPINGS_F
26: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
27: ;
28: begin insert into PAY_REPORT_FORMAT_MAPPINGS_F (
29: TEMPORARY_ACTION_FLAG,
30: REPORT_FORMAT_MAPPING_ID,
31: BUSINESS_GROUP_ID,
32: LEGISLATION_CODE,
134: REPORT_NAME,
135: SORT_CODE,
136: UPDATABLE_FLAG,
137: DEINITIALIZATION_CODE
138: from PAY_REPORT_FORMAT_MAPPINGS_F
139: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
140: for update of REPORT_FORMAT_MAPPING_ID nowait; recinfo c%rowtype;
141:
142: cursor c1 is select DISPLAY_NAME, decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: X_DEINITIALIZATION_CODE in VARCHAR2,
223: X_DISPLAY_NAME in VARCHAR2
224: ) is
225: begin
226: update PAY_REPORT_FORMAT_MAPPINGS_F set
227: TEMPORARY_ACTION_FLAG = X_TEMPORARY_ACTION_FLAG,
228: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
229: LEGISLATION_CODE = X_LEGISLATION_CODE,
230: REPORT_TYPE = X_REPORT_TYPE,
269: if (sql%notfound) then
270: raise no_data_found;
271: end if;
272:
273: delete from PAY_REPORT_FORMAT_MAPPINGS_F
274: where REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID;
275:
276: if (sql%notfound) then
277: raise no_data_found;
282: is
283: begin
284: delete from PAY_REPORT_FORMAT_MAPPINGS_TL T
285: where not exists
286: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_F B
287: where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );
288:
289: update PAY_REPORT_FORMAT_MAPPINGS_TL T set (
290: DISPLAY_NAME