130: X_LAST_UPDATED_BY,
131: X_LAST_UPDATE_LOGIN
132: );
133:
134: insert into PAY_CUSTOM_RESTRICTIONS_TL (
135: CUSTOMIZED_RESTRICTION_ID,
136: QUERY_FORM_TITLE,
137: STANDARD_FORM_TITLE,
138: CREATED_BY,
156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from PAY_CUSTOM_RESTRICTIONS_TL T
161: where T.CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
162: and T.LANGUAGE = L.LANGUAGE_CODE);
163:
164: open c;
207: cursor c1 is select
208: QUERY_FORM_TITLE,
209: STANDARD_FORM_TITLE,
210: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
211: from PAY_CUSTOM_RESTRICTIONS_TL
212: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
213: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
214: for update of CUSTOMIZED_RESTRICTION_ID nowait;
215: begin
289: if (sql%notfound) then
290: raise no_data_found;
291: end if;
292:
293: update PAY_CUSTOM_RESTRICTIONS_TL set
294: QUERY_FORM_TITLE = X_QUERY_FORM_TITLE,
295: STANDARD_FORM_TITLE = X_STANDARD_FORM_TITLE,
296: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
297: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
301: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
302:
303: if (sql%notfound) then
304:
305: insert into PAY_CUSTOM_RESTRICTIONS_TL (
306: CUSTOMIZED_RESTRICTION_ID,
307: QUERY_FORM_TITLE,
308: STANDARD_FORM_TITLE,
309: CREATED_BY,
327: from FND_LANGUAGES L
328: where L.INSTALLED_FLAG in ('I', 'B')
329: and not exists
330: (select NULL
331: from PAY_CUSTOM_RESTRICTIONS_TL T
332: where T.CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
333: and T.LANGUAGE = L.LANGUAGE_CODE);
334:
335: end if;
338: procedure DELETE_ROW (
339: X_CUSTOMIZED_RESTRICTION_ID in NUMBER
340: ) is
341: begin
342: delete from PAY_CUSTOM_RESTRICTIONS_TL
343: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID;
344:
345: if (sql%notfound) then
346: raise no_data_found;
499: OPEN C1;
500: FETCH C1 INTO l_cust_rest_id ;
501: IF C1%FOUND THEN
502:
503: UPDATE PAY_CUSTOM_RESTRICTIONS_TL
504: SET
505: QUERY_FORM_TITLE = X_QUERY_FORM_TITLE ,
506: STANDARD_FORM_TITLE = X_STANDARD_FORM_TITLE ,
507: LAST_UPDATE_DATE = sysdate ,
519:
520: procedure ADD_LANGUAGE
521: is
522: begin
523: delete from PAY_CUSTOM_RESTRICTIONS_TL T
524: where not exists
525: (select NULL
526: from PAY_CUSTOMIZED_RESTRICTIONS B
527: where B.CUSTOMIZED_RESTRICTION_ID = T.CUSTOMIZED_RESTRICTION_ID
526: from PAY_CUSTOMIZED_RESTRICTIONS B
527: where B.CUSTOMIZED_RESTRICTION_ID = T.CUSTOMIZED_RESTRICTION_ID
528: );
529:
530: update PAY_CUSTOM_RESTRICTIONS_TL T set (
531: QUERY_FORM_TITLE,
532: STANDARD_FORM_TITLE
533: ) = (select
534: B.QUERY_FORM_TITLE,
532: STANDARD_FORM_TITLE
533: ) = (select
534: B.QUERY_FORM_TITLE,
535: B.STANDARD_FORM_TITLE
536: from PAY_CUSTOM_RESTRICTIONS_TL B
537: where B.CUSTOMIZED_RESTRICTION_ID = T.CUSTOMIZED_RESTRICTION_ID
538: and B.LANGUAGE = T.SOURCE_LANG)
539: where (
540: T.CUSTOMIZED_RESTRICTION_ID,
541: T.LANGUAGE
542: ) in (select
543: SUBT.CUSTOMIZED_RESTRICTION_ID,
544: SUBT.LANGUAGE
545: from PAY_CUSTOM_RESTRICTIONS_TL SUBB, PAY_CUSTOM_RESTRICTIONS_TL SUBT
546: where SUBB.CUSTOMIZED_RESTRICTION_ID = SUBT.CUSTOMIZED_RESTRICTION_ID
547: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
548: and (SUBB.QUERY_FORM_TITLE <> SUBT.QUERY_FORM_TITLE
549: or SUBB.STANDARD_FORM_TITLE <> SUBT.STANDARD_FORM_TITLE
548: and (SUBB.QUERY_FORM_TITLE <> SUBT.QUERY_FORM_TITLE
549: or SUBB.STANDARD_FORM_TITLE <> SUBT.STANDARD_FORM_TITLE
550: ));
551:
552: insert into PAY_CUSTOM_RESTRICTIONS_TL (
553: CUSTOMIZED_RESTRICTION_ID,
554: QUERY_FORM_TITLE,
555: STANDARD_FORM_TITLE,
556: CREATED_BY,
570: B.LAST_UPDATE_DATE,
571: B.LAST_UPDATE_LOGIN,
572: L.LANGUAGE_CODE,
573: B.SOURCE_LANG
574: from PAY_CUSTOM_RESTRICTIONS_TL B, FND_LANGUAGES L
575: where L.INSTALLED_FLAG in ('I', 'B')
576: and B.LANGUAGE = userenv('LANG')
577: and not exists
578: (select NULL
575: where L.INSTALLED_FLAG in ('I', 'B')
576: and B.LANGUAGE = userenv('LANG')
577: and not exists
578: (select NULL
579: from PAY_CUSTOM_RESTRICTIONS_TL T
580: where T.CUSTOMIZED_RESTRICTION_ID = B.CUSTOMIZED_RESTRICTION_ID
581: and T.LANGUAGE = L.LANGUAGE_CODE);
582: end ADD_LANGUAGE;
583: