APPS.POR_IFT_ADMIN_PKG dependencies on POR_TEMPLATE_ATTRIBUTES_TL

Line 194: DELETE FROM POR_TEMPLATE_ATTRIBUTES_TL

190: FROM por_templates_v
191: WHERE row_id = p_row_id;
192:
193: l_progress := '002';
194: DELETE FROM POR_TEMPLATE_ATTRIBUTES_TL
195: WHERE ATTRIBUTE_CODE IN
196: (
197: SELECT ATTRIBUTE_CODE
198: FROM POR_TEMPLATE_ATTRIBUTES_B

Line 269: INSERT INTO POR_TEMPLATE_ATTRIBUTES_TL(

265: p_login_id)
266: RETURNING ATTRIBUTE_CODE into l_attribute_code;
267:
268: l_progress := '003';
269: INSERT INTO POR_TEMPLATE_ATTRIBUTES_TL(
270: ATTRIBUTE_CODE,
271: SOURCE_LANG,
272: LANGUAGE,
273: ATTRIBUTE_NAME,

Line 336: from POR_TEMPLATE_ATTRIBUTES_TL

332: ATTRIBUTE_NAME,
333: DESCRIPTION,
334: DEFAULT_VALUE,
335: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
336: from POR_TEMPLATE_ATTRIBUTES_TL
337: where ATTRIBUTE_CODE=p_attribute_code
338: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
339: for update nowait;
340:

Line 462: UPDATE POR_TEMPLATE_ATTRIBUTES_TL

458: LAST_UPDATE_LOGIN = p_login_id
459: WHERE ROWID = p_row_id;
460:
461: l_progress := '003';
462: UPDATE POR_TEMPLATE_ATTRIBUTES_TL
463: SET
464: ATTRIBUTE_NAME = p_attribute_name,
465: DESCRIPTION = p_description,
466: DEFAULT_VALUE = p_default_value,

Line 496: DELETE FROM por_template_attributes_tl

492: DELETE FROM por_template_attributes_b
493: WHERE rowid = p_row_id;
494:
495: l_progress := '003';
496: DELETE FROM por_template_attributes_tl
497: WHERE attribute_code = l_attribute_code_old;
498:
499: EXCEPTION
500: WHEN OTHERS THEN

Line 710: INSERT INTO POR_TEMPLATE_ATTRIBUTES_TL(

706: FROM POR_TEMPLATES_ALL_TL T
707: WHERE T.TEMPLATE_CODE = B.TEMPLATE_CODE
708: AND T.LANGUAGE = L.LANGUAGE_CODE);
709:
710: INSERT INTO POR_TEMPLATE_ATTRIBUTES_TL(
711: ATTRIBUTE_CODE,
712: SOURCE_LANG,
713: LANGUAGE,
714: ATTRIBUTE_NAME,

Line 734: FROM POR_TEMPLATE_ATTRIBUTES_TL B, FND_LANGUAGES L

730: B.CREATION_DATE,
731: B.LAST_UPDATED_BY,
732: B.LAST_UPDATE_DATE,
733: B.LAST_UPDATE_LOGIN
734: FROM POR_TEMPLATE_ATTRIBUTES_TL B, FND_LANGUAGES L
735: WHERE L.INSTALLED_FLAG in ('I', 'B')
736: AND B.LANGUAGE = userenv('LANG')
737: AND NOT EXISTS
738: (SELECT NULL

Line 739: FROM POR_TEMPLATE_ATTRIBUTES_TL T

735: WHERE L.INSTALLED_FLAG in ('I', 'B')
736: AND B.LANGUAGE = userenv('LANG')
737: AND NOT EXISTS
738: (SELECT NULL
739: FROM POR_TEMPLATE_ATTRIBUTES_TL T
740: WHERE T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
741: AND T.LANGUAGE = L.LANGUAGE_CODE);
742:
743: END add_language;