[Home] [Help]
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN
22:
23:
24: INSERT INTO pon_auc_doctypes
50: ,p_document_type_code
51: ,p_document_subtype);
52:
53:
54: INSERT INTO pon_auc_doctypes_tl doctl
55: (doctype_id
56: ,name
57: ,language
58: ,created_by
73: fnd_languages l
74: WHERE installed_flag in ('I', 'B')
75: AND NOT EXISTS
76: (SELECT NULL
77: FROM pon_auc_doctypes_tl doctl
78: WHERE doctl.doctype_id = p_doctype_id
79: AND doctl.language = l.language_code);
80:
81: END insert_row;
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:
96: BEGIN
97:
98: UPDATE pon_auc_doctypes doctl
112: RAISE NO_DATA_FOUND;
113: END IF;
114:
115:
116: UPDATE pon_auc_doctypes_tl doctl
117: SET doctl.name = p_name
118: ,doctl.last_updated_by = p_last_updated_by
119: ,doctl.last_update_date = p_last_update_date
120: ,doctl.source_lang = userenv('LANG')
134: -- Translate_row is called during NLS translation during FNDLOAD
135:
136: PROCEDURE translate_row (
137: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
138: p_name IN pon_auc_doctypes_tl.name%TYPE,
139: p_owner IN VARCHAR2,
140: p_custom_mode IN VARCHAR2,
141: p_last_update_date IN VARCHAR2
142: ) IS
154: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
155:
156: select LAST_UPDATED_BY, LAST_UPDATE_DATE
157: into db_luby, db_ludate
158: from pon_auc_doctypes_tl
159: where doctype_id = (
160: SELECT doc.doctype_id
161: FROM pon_auc_doctypes doc
162: WHERE doc.internal_name = p_internal_name)
161: FROM pon_auc_doctypes doc
162: WHERE doc.internal_name = p_internal_name)
163: and userenv('LANG') = LANGUAGE;
164:
165: UPDATE pon_auc_doctypes_tl doctl
166: SET doctl.name = p_name
167: ,doctl.last_updated_by = f_luby
168: ,doctl.last_update_date = f_ludate
169: ,source_lang = userenv('LANG')
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:
201:
202: -- Last update information from the file being uploaded
203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
284: THEN
285: RAISE NO_DATA_FOUND;
286: END IF;
287:
288: DELETE FROM pon_auc_doctypes_tl doctl
289: WHERE doctl.doctype_id = l_doctype_id;
290:
291: END delete_row;
292:
294: PROCEDURE add_language IS
295:
296: BEGIN
297:
298: INSERT INTO PON_AUC_DOCTYPES_TL (
299: doctype_id,
300: name,
301: language,
302: created_by,
313: doctl.creation_date,
314: doctl.last_updated_by,
315: doctl.last_update_date,
316: doctl.source_lang
317: FROM pon_auc_doctypes_tl doctl,
318: fnd_languages lang
319: WHERE doctl.language = USERENV('LANG')
320: AND lang.INSTALLED_FLAG in ('I', 'B')
321: AND NOT EXISTS (SELECT NULL
318: fnd_languages lang
319: WHERE doctl.language = USERENV('LANG')
320: AND lang.INSTALLED_FLAG in ('I', 'B')
321: AND NOT EXISTS (SELECT NULL
322: FROM PON_AUC_DOCTYPES_TL doc2
323: WHERE doc2.doctype_id = doctl.doctype_id
324: AND doc2.language = lang.language_code);
325:
326: END add_language;