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_DEVL_PROJECTS

Line 153: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;

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:
156: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
157: TYPE typeOrganizationId_vc2 IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 154: TYPE typeDevlOrigSysRef_vc2 IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274

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:
156: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
157: TYPE typeOrganizationId_vc2 IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
158: TYPE typeTopItemId_vc2 IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 392: --rollback tables for cz_devl_projects and cz_xfr_project_bills, and calls execute_structure_map.

388:
389: --The basic procedure called by build_structure_map after the preparatory work is completed.
390: --Finds the BOM model down the stream if p_model_id is not a BOM model (recursively),
391: --verifies the source server if necessary, populates the organizations hash table and
392: --rollback tables for cz_devl_projects and cz_xfr_project_bills, and calls execute_structure_map.
393:
394: PROCEDURE execute_model(p_model_id IN NUMBER) IS
395:
396: sourceOrgId PLS_INTEGER;

Line 401: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;

397: sourceTopId PLS_INTEGER;
398: targetOrgId PLS_INTEGER;
399:
400: modelName cz_ps_nodes.name%TYPE;
401: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;
402: modelEngineType cz_devl_projects.config_engine_type%TYPE;
403:
404: modelNameStack typeStringTable;
405: ---------------------------------------------------------------------------------------

Line 402: modelEngineType cz_devl_projects.config_engine_type%TYPE;

398: targetOrgId PLS_INTEGER;
399:
400: modelName cz_ps_nodes.name%TYPE;
401: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;
402: modelEngineType cz_devl_projects.config_engine_type%TYPE;
403:
404: modelNameStack typeStringTable;
405: ---------------------------------------------------------------------------------------
406: --build_structure_map->execute_model->execute_structure_map

Line 478: --Extracts cz_devl_projects.orig_sys_ref part of cz_ps_nodes.orig_sys_ref. Uses the fact

474: END; --extract_item_id
475: ---------------------------------------------------------------------------------------
476: --build_structure_map->execute_model->execute_structure_map->extract_project_reference
477:
478: --Extracts cz_devl_projects.orig_sys_ref part of cz_ps_nodes.orig_sys_ref. Uses the fact
479: --the first is always a part of the second.
480:
481: FUNCTION extract_project_reference(j IN PLS_INTEGER) RETURN VARCHAR2 IS
482: BEGIN

Line 1152: --Populate candidate tables and rollback hash tables for cz_devl_projects and cz_xfr_project_bills.

1148: END IF;
1149: jRootNode := jhashNodeFirstChild(tabPsNodeId(jRootNode));
1150: END LOOP;
1151:
1152: --Populate candidate tables and rollback hash tables for cz_devl_projects and cz_xfr_project_bills.
1153:
1154: tabCandidateDevl(tabCandidateDevl.COUNT + 1) := p_model_id;
1155: hashRbDevlOrigSysRef(p_model_id) := extract_project_reference(jRootNode);
1156:

Line 1203: --Extracts organization_id from cz_devl_projects.orig_sys_ref.

1199: END; --execute_structure_map
1200: ---------------------------------------------------------------------------------------
1201: --build_structure_map->execute_model->extract_organization_id
1202:
1203: --Extracts organization_id from cz_devl_projects.orig_sys_ref.
1204:
1205: FUNCTION extract_organization_id RETURN PLS_INTEGER IS
1206:
1207: startPos PLS_INTEGER;

Line 1230: FROM cz_devl_projects

1226:
1227: BEGIN
1228:
1229: SELECT orig_sys_ref, name, NVL ( config_engine_type, 'L' ) INTO modelOrigSysRef, modelName, modelEngineType
1230: FROM cz_devl_projects
1231: WHERE deleted_flag = FLAG_NOT_DELETED
1232: AND devl_project_id = p_model_id;
1233:
1234: EXCEPTION

Line 1391: FROM cz_xfr_project_bills b, cz_devl_projects r

1387: BEGIN
1388: BEGIN
1389:
1390: SELECT DISTINCT source_server INTO sourceServer
1391: FROM cz_xfr_project_bills b, cz_devl_projects r
1392: WHERE b.deleted_flag = FLAG_NOT_DELETED
1393: AND r.deleted_flag = FLAG_NOT_DELETED
1394: AND b.model_ps_node_id = r.devl_project_id;
1395:

Line 1471: UPDATE cz_devl_projects SET

1467:
1468: debug('Table cz_item_masters updates rolled back');
1469:
1470: FOR i IN 1..devlRollback LOOP
1471: UPDATE cz_devl_projects SET
1472: orig_sys_ref = hashRbDevlOrigSysRef(tabCandidateDevl(i))
1473: WHERE devl_project_id = tabCandidateDevl(i);
1474: COMMIT;
1475: END LOOP;

Line 1477: debug('Table cz_devl_projects updates rolled back');

1473: WHERE devl_project_id = tabCandidateDevl(i);
1474: COMMIT;
1475: END LOOP;
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))

Line 1639: --Update cz_devl_projects table.

1635: segmentStart := segmentEnd + 1;
1636:
1637: END LOOP;
1638:
1639: --Update cz_devl_projects table.
1640:
1641: localCount := tabCandidateDevl.COUNT;
1642: segmentStart := 1;
1643:

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

1640:
1641: localCount := tabCandidateDevl.COUNT;
1642: segmentStart := 1;
1643:
1644: debug('Updating cz_devl_projects table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1645:
1646: WHILE(segmentStart <= localCount)LOOP
1647:
1648: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1653: UPDATE cz_devl_projects SET

1649: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1650: devlRollback := segmentEnd;
1651:
1652: FORALL i IN segmentStart..segmentEnd
1653: UPDATE cz_devl_projects SET
1654: orig_sys_ref = NVL(devlProject_origSysRef(orig_sys_ref), orig_sys_ref)
1655: WHERE devl_project_id = tabCandidateDevl(i);
1656:
1657: COMMIT;

Line 2204: -- format of cz_devl_projects.orig_sys_ref: expl_type:org_id:top_item_id

2200: v_org_id VARCHAR2(20);
2201: v_expl_type VARCHAR2(20);
2202:
2203: BEGIN
2204: -- format of cz_devl_projects.orig_sys_ref: expl_type:org_id:top_item_id
2205: IF (p_orig_sys_ref IS NOT NULL) THEN
2206: v_delim_pos := instr(v_str, ':');
2207: v_expl_type := substr(v_str, 1, v_delim_pos);
2208: v_str := substr(v_str, v_delim_pos + 1);