APPS.PAY_REPORT_FORMAT_MAPPINGS_PKG dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 25: cursor C is select ROWID from PAY_REPORT_FORMAT_MAPPINGS_F

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,

Line 28: begin insert into PAY_REPORT_FORMAT_MAPPINGS_F (

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,

Line 138: from PAY_REPORT_FORMAT_MAPPINGS_F

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

Line 226: update PAY_REPORT_FORMAT_MAPPINGS_F set

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,

Line 273: delete from PAY_REPORT_FORMAT_MAPPINGS_F

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;

Line 286: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_F B

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