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 149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
151: TYPE typeTextOrigSysRef_vc2 IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
152:
153: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;

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

146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
151: TYPE typeTextOrigSysRef_vc2 IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
152:
153: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
154: TYPE typeDevlOrigSysRef_vc2 IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 151: TYPE typeTextOrigSysRef_vc2 IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274

147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
151: TYPE typeTextOrigSysRef_vc2 IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
152:
153: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
154: TYPE typeDevlOrigSysRef_vc2 IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
155:

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

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

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

1089: tabEffectiveUntil, tabMinimum, tabMaximum, tabMinimumSelected, tabMaximumSelected,
1090: tabInitialValue, tabInitNumVal, tabReferenceId, tabPsNodeName, tabOrigSysRef, tabSequencePath, -- sselahi
1091: tabSequenceId, tabIntlTextId, tabBomRequiredFlag, tabTextOrigSysRef,
1092: tabRefPartNbr, tabItemOrigSysRef, tabItemMasterTypeId
1093: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t
1094: WHERE p.devl_project_id = p_model_id
1095: AND p.deleted_flag = FLAG_NOT_DELETED
1096: AND p.orig_sys_ref IS NOT NULL
1097: AND p.src_application_id = 702

Line 1480: UPDATE cz_localized_texts SET

1476:
1477: debug('Table cz_devl_projects updates rolled back');
1478:
1479: FOR i IN 1..textRollback LOOP
1480: UPDATE cz_localized_texts SET
1481: orig_sys_ref = hashRbTextOrigSysRef(tabCandidateText(i))
1482: WHERE intl_text_id = tabCandidateText(i);
1483: COMMIT;
1484: END LOOP;

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

1482: WHERE intl_text_id = tabCandidateText(i);
1483: COMMIT;
1484: END LOOP;
1485:
1486: debug('Table cz_localized_texts updates rolled back');
1487:
1488: FOR i IN 1..typeRollback LOOP
1489: UPDATE cz_item_types SET
1490: orig_sys_ref = hashRbTypeOrigSysRef(tabCandidateType(i))

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

1576: WHEN OTHERS THEN
1577: CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE;
1578: END;
1579:
1580: --Decrease the commit block size for cz_localized_texts according to the number of
1581: --installed languages.
1582:
1583: textCommitBlockSize := CommitBlockSize / numberOfLanguages;
1584:

Line 1662: --Update cz_localized_texts table.

1658: segmentStart := segmentEnd + 1;
1659:
1660: END LOOP;
1661:
1662: --Update cz_localized_texts table.
1663:
1664: localCount := tabCandidateText.COUNT;
1665: segmentStart := 1;
1666:

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

1663:
1664: localCount := tabCandidateText.COUNT;
1665: segmentStart := 1;
1666:
1667: debug('Updating cz_localized_texts table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1668:
1669: WHILE(segmentStart <= localCount)LOOP
1670:
1671: segmentEnd := segmentStart + textCommitBlockSize - 1;

Line 1676: UPDATE cz_localized_texts SET

1672: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1673: textRollback := segmentEnd;
1674:
1675: FORALL i IN segmentStart..segmentEnd
1676: UPDATE cz_localized_texts SET
1677: orig_sys_ref = NVL(locText_origSysRef(orig_sys_ref), orig_sys_ref)
1678: WHERE intl_text_id = tabCandidateText(i);
1679:
1680: COMMIT;

Line 2232: -- format of cz_localized_texts.orig_sys_ref: item_id:expl_type:org_id:comp_seq_id

2228: v_compSeqId VARCHAR2(20);
2229: v_expl_type VARCHAR2(20);
2230:
2231: BEGIN
2232: -- format of cz_localized_texts.orig_sys_ref: item_id:expl_type:org_id:comp_seq_id
2233: IF (p_orig_sys_ref IS NOT NULL) THEN
2234: v_delim_pos := instr(v_str, ':');
2235: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(v_str, 1, v_delim_pos - 1))));
2236: v_str := substr(v_str, v_delim_pos);