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_BOM_SYNCH dependencies on CZ_LOCALIZED_TEXTS

Line 146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeDevlOrigSysRef IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15);

Line 147: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeDevlOrigSysRef IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15);
151:

Line 529: --rollback hash tables for cz_ps_nodes, cz_item_masters and cz_localized_texts.

525: ---------------------------------------------------------------------------------------
526: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item
527:
528: --Adds the item that passed all the comparisons to the corresponding hash tables and populates
529: --rollback hash tables for cz_ps_nodes, cz_item_masters and cz_localized_texts.
530:
531: PROCEDURE hash_item(j IN PLS_INTEGER) IS
532:
533: itemId PLS_INTEGER;

Line 1082: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t

1078: tabEffectiveUntil, tabMinimum, tabMaximum, tabMinimumSelected, tabMaximumSelected,
1079: tabInitialValue, tabInitNumVal, tabReferenceId, tabPsNodeName, tabOrigSysRef, tabSequencePath, -- sselahi
1080: tabSequenceId, tabIntlTextId, tabBomRequiredFlag, tabTextOrigSysRef,
1081: tabRefPartNbr, tabItemOrigSysRef, tabItemMasterTypeId
1082: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t
1083: WHERE p.devl_project_id = p_model_id
1084: AND p.deleted_flag = FLAG_NOT_DELETED
1085: AND p.orig_sys_ref IS NOT NULL
1086: AND p.src_application_id = 702

Line 1469: UPDATE cz_localized_texts SET

1465:
1466: debug('Table cz_devl_projects updates rolled back');
1467:
1468: FOR i IN 1..textRollback LOOP
1469: UPDATE cz_localized_texts SET
1470: orig_sys_ref = hashRbTextOrigSysRef(tabCandidateText(i))
1471: WHERE intl_text_id = tabCandidateText(i);
1472: COMMIT;
1473: END LOOP;

Line 1475: debug('Table cz_localized_texts updates rolled back');

1471: WHERE intl_text_id = tabCandidateText(i);
1472: COMMIT;
1473: END LOOP;
1474:
1475: debug('Table cz_localized_texts updates rolled back');
1476:
1477: FOR i IN 1..typeRollback LOOP
1478: UPDATE cz_item_types SET
1479: orig_sys_ref = hashRbTypeOrigSysRef(tabCandidateType(i))

Line 1569: --Decrease the commit block size for cz_localized_texts according to the number of

1565: WHEN OTHERS THEN
1566: CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE;
1567: END;
1568:
1569: --Decrease the commit block size for cz_localized_texts according to the number of
1570: --installed languages.
1571:
1572: textCommitBlockSize := CommitBlockSize / numberOfLanguages;
1573:

Line 1651: --Update cz_localized_texts table.

1647: segmentStart := segmentEnd + 1;
1648:
1649: END LOOP;
1650:
1651: --Update cz_localized_texts table.
1652:
1653: localCount := tabCandidateText.COUNT;
1654: segmentStart := 1;
1655:

Line 1656: debug('Updating cz_localized_texts table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));

1652:
1653: localCount := tabCandidateText.COUNT;
1654: segmentStart := 1;
1655:
1656: debug('Updating cz_localized_texts table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1657:
1658: WHILE(segmentStart <= localCount)LOOP
1659:
1660: segmentEnd := segmentStart + textCommitBlockSize - 1;

Line 1665: UPDATE cz_localized_texts SET

1661: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1662: textRollback := segmentEnd;
1663:
1664: FORALL i IN segmentStart..segmentEnd
1665: UPDATE cz_localized_texts SET
1666: orig_sys_ref = NVL(locText_origSysRef(orig_sys_ref), orig_sys_ref)
1667: WHERE intl_text_id = tabCandidateText(i);
1668:
1669: COMMIT;

Line 2220: -- format of cz_localized_texts.orig_sys_ref: item_id:expl_type:org_id

2216: v_org_id VARCHAR2(20);
2217: v_expl_type VARCHAR2(20);
2218:
2219: BEGIN
2220: -- format of cz_localized_texts.orig_sys_ref: item_id:expl_type:org_id
2221: IF (p_orig_sys_ref IS NOT NULL) THEN
2222: v_delim_pos := instr(v_str, ':');
2223: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(v_str, 1, v_delim_pos - 1))));
2224: v_str := substr(v_str, v_delim_pos);