APPS.POR_IFT_ADMIN_PKG dependencies on POR_TEMPLATES_ALL_TL

Line 39: INSERT INTO POR_TEMPLATES_ALL_TL(

35: RETURNING TEMPLATE_CODE INTO l_template_code;
36:
37:
38: l_progress := '003';
39: INSERT INTO POR_TEMPLATES_ALL_TL(
40: TEMPLATE_CODE,
41: SOURCE_LANG,
42: LANGUAGE,
43: TEMPLATE_NAME,

Line 92: from POR_TEMPLATES_ALL_TL

88: CURSOR c_tl_rec(p_template_code VARCHAR2) IS
89: SELECT
90: TEMPLATE_NAME,
91: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
92: from POR_TEMPLATES_ALL_TL
93: where TEMPLATE_CODE=p_template_code
94: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
95: for update nowait;
96: l_rec c_rec%ROWTYPE;

Line 165: UPDATE POR_TEMPLATES_ALL_TL

161: LAST_UPDATE_LOGIN = p_login_id
162: WHERE ROWID = p_row_id;
163:
164: l_progress := '002';
165: UPDATE POR_TEMPLATES_ALL_TL
166: SET
167: TEMPLATE_NAME = p_name,
168: LAST_UPDATED_BY = p_user_id,
169: LAST_UPDATE_DATE = sysdate,

Line 211: DELETE FROM POR_TEMPLATES_ALL_TL

207: DELETE FROM POR_TEMPLATES_ALL_B
208: WHERE TEMPLATE_CODE = l_template_code;
209:
210: l_progress := '005';
211: DELETE FROM POR_TEMPLATES_ALL_TL
212: WHERE TEMPLATE_CODE = l_template_code;
213:
214: l_progress := '006';
215: DELETE FROM POR_TEMPLATE_ASSOC

Line 681: INSERT INTO POR_TEMPLATES_ALL_TL(

677: END delete_all_template_assoc;
678:
679: PROCEDURE add_language IS
680: BEGIN
681: INSERT INTO POR_TEMPLATES_ALL_TL(
682: TEMPLATE_CODE,
683: SOURCE_LANG,
684: LANGUAGE,
685: TEMPLATE_NAME,

Line 701: FROM POR_TEMPLATES_ALL_TL B, FND_LANGUAGES L

697: B.CREATION_DATE,
698: B.LAST_UPDATED_BY,
699: B.LAST_UPDATE_DATE,
700: B.LAST_UPDATE_LOGIN
701: FROM POR_TEMPLATES_ALL_TL B, FND_LANGUAGES L
702: WHERE L.INSTALLED_FLAG in ('I', 'B')
703: AND B.LANGUAGE = USERENV('LANG')
704: AND NOT EXISTS
705: (SELECT NULL

Line 706: FROM POR_TEMPLATES_ALL_TL T

702: WHERE L.INSTALLED_FLAG in ('I', 'B')
703: AND B.LANGUAGE = USERENV('LANG')
704: AND NOT EXISTS
705: (SELECT NULL
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(