eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_PS_NODE dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 22: FROM CZ_IMP_LOCALIZED_TEXTS

18: inXFR_GROUP IN VARCHAR2
19: ) IS
20: CURSOR c_imp_intl_text IS
21: SELECT DISTINCT orig_sys_ref, fsk_devlproject_1_1
22: FROM CZ_IMP_LOCALIZED_TEXTS
23: WHERE rec_status IS NULL AND Run_ID = inRUN_ID
24: ORDER BY orig_sys_ref;
25:
26: /* cursor's data found indicator */

Line 36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;

32: x_intl_text_found BOOLEAN := FALSE;
33: x_text_not_matching BOOLEAN := TRUE;
34: x_error BOOLEAN:=FALSE;
35:
36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;

Line 37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;

33: x_text_not_matching BOOLEAN := TRUE;
34: x_error BOOLEAN:=FALSE;
35:
36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;
41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;

Line 38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

34: x_error BOOLEAN:=FALSE;
35:
36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;
41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;

35:
36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;
41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
43:

Line 40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;

36: TYPE tImpIntlTextId IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;
41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
43:
44: nImpIntlTextId tImpIntlTextId;

Line 41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;

37: TYPE tImpLocalizedStr IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tImpLanguage IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
39: TYPE tImpSourceLang IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE INDEX BY BINARY_INTEGER;
40: TYPE tImpFSKDevlProject IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.FSK_DEVLPROJECT_1_1%TYPE INDEX BY BINARY_INTEGER;
41: TYPE tImpOrigSysRef IS TABLE OF CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
43:
44: nImpIntlTextId tImpIntlTextId;
45: sImpLocalizedStr tImpLocalizedStr;

Line 51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;

47: sImpSourceLang tImpSourceLang;
48: sImpFSKDevlProject tImpFSKDevlProject;
49: sImpOrigSysRef tImpOrigSysRef;
50:
51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;

Line 52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;

48: sImpFSKDevlProject tImpFSKDevlProject;
49: sImpOrigSysRef tImpOrigSysRef;
50:
51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;

Line 53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;

49: sImpOrigSysRef tImpOrigSysRef;
50:
51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;

Line 54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;

50:
51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;
58:

Line 55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;

51: nOnlIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;
58:
59: /* Internal vars */

Line 56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;

52: nOnlIntlText CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;
58:
59: /* Internal vars */
60: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;

53: nOnlLanguage CZ_IMP_LOCALIZED_TEXTS.LANGUAGE%TYPE;
54: nOnlSourceLangn CZ_IMP_LOCALIZED_TEXTS.SOURCE_LANG%TYPE;
55: nOnlModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
56: nModelId CZ_IMP_LOCALIZED_TEXTS.MODEL_ID%TYPE;
57: nOnlOrigSysRef CZ_IMP_LOCALIZED_TEXTS.ORIG_SYS_REF%TYPE;
58:
59: /* Internal vars */
60: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
61: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 142: UPDATE cz_imp_localized_texts

138: IF x_onl_intl_text_f THEN /* update */
139:
140: -- get the model_id from this import job
141:
142: UPDATE cz_imp_localized_texts
143: SET intl_text_id = nOnlIntlTextId,
144: model_id = nOnlModelId,
145: disposition = 'M',
146: rec_status = 'PASS'

Line 175: UPDATE cz_imp_localized_texts

171: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
172: END IF;
173: nNextId := nNextValue + nAllocateCounter;
174:
175: UPDATE cz_imp_localized_texts
176: SET intl_text_id = nNextId,
177: model_id = nModelId,
178: disposition = 'I',
179: rec_status = 'PASS'

Line 195: UPDATE cz_imp_localized_texts

191:
192: EXCEPTION
193: WHEN NO_DATA_FOUND THEN
194: FAILED:=FAILED+1;
195: UPDATE cz_imp_localized_texts
196: SET disposition='R',
197: rec_status='FAIL'
198: WHERE orig_sys_ref = sImpOrigSysRef(i)
199: AND fsk_devlproject_1_1 = sImpFSKDevlProject(i)

Line 235: UPDATE cz_imp_localized_texts

231:
232: IF x_onl_intl_text_f THEN /* update */
233: -- get the model_id from this import job
234:
235: UPDATE cz_imp_localized_texts
236: SET intl_text_id = nOnlIntlTextId,
237: model_id = 0,
238: disposition = 'M',
239: rec_status = 'PASS'

Line 262: UPDATE cz_imp_localized_texts

258: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
259: END IF;
260: nNextId := nNextValue + nAllocateCounter;
261:
262: UPDATE cz_imp_localized_texts
263: SET intl_text_id = nNextId,
264: model_id = 0,
265: disposition = 'I',
266: rec_status = 'PASS'

Line 276: UPDATE cz_imp_localized_texts

272:
273: EXCEPTION
274: WHEN NO_DATA_FOUND THEN
275: FAILED:=FAILED+1;
276: UPDATE cz_imp_localized_texts
277: SET disposition='R',
278: rec_status='FAIL'
279: WHERE orig_sys_ref = sImpOrigSysRef(i)
280: AND run_id = inRUN_ID;

Line 324: SELECT DISTINCT orig_sys_ref FROM cz_imp_localized_texts

320: FAILED IN OUT NOCOPY PLS_INTEGER
321: ) IS
322: -- passing records of this phase
323: CURSOR l_csr_1 IS
324: SELECT DISTINCT orig_sys_ref FROM cz_imp_localized_texts
325: WHERE rec_status IS NULL AND run_id = inRUN_ID AND orig_sys_ref IS NOT NULL
326: AND fsk_devlproject_1_1 IS NOT NULL AND language IS NOT NULL AND source_lang IS NOT NULL;
327:
328: -- failing records of this phase

Line 330: SELECT DISTINCT orig_sys_ref FROM cz_imp_localized_texts

326: AND fsk_devlproject_1_1 IS NOT NULL AND language IS NOT NULL AND source_lang IS NOT NULL;
327:
328: -- failing records of this phase
329: CURSOR l_csr_2 IS
330: SELECT DISTINCT orig_sys_ref FROM cz_imp_localized_texts
331: WHERE rec_status IS NULL AND run_id = inRUN_ID
332: AND (orig_sys_ref IS NULL OR language IS NULL OR source_lang IS NULL);
333: -- APC changes AND (orig_sys_ref IS NULL OR fsk_devlproject_1_1 IS NULL OR language IS NULL OR source_lang IS NULL);
334:

Line 336: TYPE orig_sys_ref_tbl_type IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

332: AND (orig_sys_ref IS NULL OR language IS NULL OR source_lang IS NULL);
333: -- APC changes AND (orig_sys_ref IS NULL OR fsk_devlproject_1_1 IS NULL OR language IS NULL OR source_lang IS NULL);
334:
335:
336: TYPE orig_sys_ref_tbl_type IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
337:
338: l_orig_sys_ref_tbl orig_sys_ref_tbl_type;
339: x_error BOOLEAN:=FALSE;
340: l_msg VARCHAR2(2000);

Line 351: UPDATE cz_imp_localized_texts

347: LIMIT COMMIT_SIZE;
348: EXIT WHEN l_csr_1%NOTFOUND AND l_orig_sys_ref_tbl.COUNT = 0;
349: IF l_orig_sys_ref_tbl.COUNT > 0 THEN
350: FORALL i IN l_orig_sys_ref_tbl.FIRST..l_orig_sys_ref_tbl.LAST
351: UPDATE cz_imp_localized_texts
352: SET deleted_flag = '0'
353: WHERE orig_sys_ref = l_orig_sys_ref_tbl(i)
354: AND run_id = inRUN_ID
355: AND deleted_flag IS NULL;

Line 370: UPDATE cz_imp_localized_texts

366: LIMIT COMMIT_SIZE;
367: EXIT WHEN l_csr_2%NOTFOUND AND l_orig_sys_ref_tbl.COUNT = 0;
368: IF l_orig_sys_ref_tbl.COUNT > 0 THEN
369: FORALL i IN l_orig_sys_ref_tbl.FIRST..l_orig_sys_ref_tbl.LAST
370: UPDATE cz_imp_localized_texts
371: SET disposition = 'R',
372: rec_status = 'FAIL',
373: message = l_msg
374: WHERE orig_sys_ref = l_orig_sys_ref_tbl(i) AND run_id = inRUN_ID;

Line 510: FROM CZ_IMP_LOCALIZED_TEXTS

506: CURSOR c_xfr_intl_text IS
507: SELECT intl_text_id, localized_str, language, source_lang, deleted_flag,creation_date
508: last_update_date, created_by, last_updated_by,orig_sys_ref, model_id, disposition,
509: rec_status, ROWID
510: FROM CZ_IMP_LOCALIZED_TEXTS
511: WHERE Run_ID=inRUN_ID AND rec_status = 'PASS';
512:
513: x_xfr_intl_text_f BOOLEAN:=FALSE;
514: x_error BOOLEAN:=FALSE;

Line 517: sIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;

513: x_xfr_intl_text_f BOOLEAN:=FALSE;
514: x_error BOOLEAN:=FALSE;
515: p_xfr_intl_text c_xfr_intl_text%ROWTYPE;
516:
517: sIntlTextId CZ_IMP_LOCALIZED_TEXTS.INTL_TEXT_ID%TYPE;
518:
519: -- Internal vars --
520: nCommitCount PLS_INTEGER:=0; -- COMMIT buffer index --
521: nInsertCount PLS_INTEGER:=0; -- Inserts --

Line 586: UPDATE cz_imp_localized_texts

582: sysdate, sysdate, -UID, -UID,p_xfr_intl_text.orig_sys_ref, p_xfr_intl_text.model_id);
583:
584: nInsertCount:=nInsertCount+1;
585:
586: UPDATE cz_imp_localized_texts
587: SET intl_text_id=p_xfr_intl_text.intl_text_id,
588: REC_STATUS='OK'
589: WHERE ROWID = p_xfr_intl_text.ROWID;
590:

Line 593: UPDATE cz_imp_localized_texts

589: WHERE ROWID = p_xfr_intl_text.ROWID;
590:
591: EXCEPTION
592: WHEN DUP_VAL_ON_INDEX THEN
593: UPDATE cz_imp_localized_texts
594: SET DISPOSITION='R',
595: REC_STATUS='DUPL'
596: WHERE ROWID = p_xfr_intl_text.ROWID;
597: WHEN OTHERS THEN

Line 599: UPDATE cz_imp_localized_texts

595: REC_STATUS='DUPL'
596: WHERE ROWID = p_xfr_intl_text.ROWID;
597: WHEN OTHERS THEN
598: FAILED:=FAILED +1;
599: UPDATE cz_imp_localized_texts
600: SET REC_STATUS='ERR'
601: WHERE ROWID = p_xfr_intl_text.ROWID;
602: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:INSERT',11276,inRun_Id);
603: END;

Line 620: UPDATE cz_imp_localized_texts

616: IF(SQL%NOTFOUND) THEN
617: FAILED:=FAILED+1;
618: ELSE
619: nUpdateCount:=nUpdateCount+1;
620: UPDATE cz_imp_localized_texts
621: SET REC_STATUS='OK'
622: WHERE ROWID = p_xfr_intl_text.ROWID;
623: END IF;
624:

Line 628: UPDATE cz_imp_localized_texts

624:
625: EXCEPTION
626: WHEN OTHERS THEN
627: FAILED:=FAILED +1;
628: UPDATE cz_imp_localized_texts
629: SET REC_STATUS='ERR'
630: WHERE ROWID = p_xfr_intl_text.ROWID;
631: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:UPDATE',11276,inRun_Id);
632: END;

Line 661: FROM cz_imp_localized_texts

657: v_completed VARCHAR2(1) := '1';
658:
659: CURSOR c_xfr_run_result IS
660: SELECT DISPOSITION,REC_STATUS,COUNT(*)
661: FROM cz_imp_localized_texts
662: WHERE RUN_ID = inRUN_ID
663: GROUP BY DISPOSITION,REC_STATUS;
664:
665: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;