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 149: TYPE typeDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%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:
152: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
153: TYPE typeOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15);

Line 150: TYPE typeDevlOrigSysRef IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY VARCHAR2(15);

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:
152: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
153: TYPE typeOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15);
154: TYPE typeTopItemId IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY VARCHAR2(15);

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

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

Line 397: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;

393: sourceTopId PLS_INTEGER;
394: targetOrgId PLS_INTEGER;
395:
396: modelName cz_ps_nodes.name%TYPE;
397: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;
398: modelEngineType cz_devl_projects.config_engine_type%TYPE;
399:
400: modelNameStack typeStringTable;
401: ---------------------------------------------------------------------------------------

Line 398: modelEngineType cz_devl_projects.config_engine_type%TYPE;

394: targetOrgId PLS_INTEGER;
395:
396: modelName cz_ps_nodes.name%TYPE;
397: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;
398: modelEngineType cz_devl_projects.config_engine_type%TYPE;
399:
400: modelNameStack typeStringTable;
401: ---------------------------------------------------------------------------------------
402: --build_structure_map->execute_model->execute_structure_map

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

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

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

1137: END IF;
1138: jRootNode := jhashNodeFirstChild(tabPsNodeId(jRootNode));
1139: END LOOP;
1140:
1141: --Populate candidate tables and rollback hash tables for cz_devl_projects and cz_xfr_project_bills.
1142:
1143: tabCandidateDevl(tabCandidateDevl.COUNT + 1) := p_model_id;
1144: hashRbDevlOrigSysRef(p_model_id) := extract_project_reference(jRootNode);
1145:

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

1188: END; --execute_structure_map
1189: ---------------------------------------------------------------------------------------
1190: --build_structure_map->execute_model->extract_organization_id
1191:
1192: --Extracts organization_id from cz_devl_projects.orig_sys_ref.
1193:
1194: FUNCTION extract_organization_id RETURN PLS_INTEGER IS
1195:
1196: startPos PLS_INTEGER;

Line 1219: FROM cz_devl_projects

1215:
1216: BEGIN
1217:
1218: SELECT orig_sys_ref, name, NVL ( config_engine_type, 'L' ) INTO modelOrigSysRef, modelName, modelEngineType
1219: FROM cz_devl_projects
1220: WHERE deleted_flag = FLAG_NOT_DELETED
1221: AND devl_project_id = p_model_id;
1222:
1223: EXCEPTION

Line 1380: FROM cz_xfr_project_bills b, cz_devl_projects r

1376: BEGIN
1377: BEGIN
1378:
1379: SELECT DISTINCT source_server INTO sourceServer
1380: FROM cz_xfr_project_bills b, cz_devl_projects r
1381: WHERE b.deleted_flag = FLAG_NOT_DELETED
1382: AND r.deleted_flag = FLAG_NOT_DELETED
1383: AND b.model_ps_node_id = r.devl_project_id;
1384:

Line 1460: UPDATE cz_devl_projects SET

1456:
1457: debug('Table cz_item_masters updates rolled back');
1458:
1459: FOR i IN 1..devlRollback LOOP
1460: UPDATE cz_devl_projects SET
1461: orig_sys_ref = hashRbDevlOrigSysRef(tabCandidateDevl(i))
1462: WHERE devl_project_id = tabCandidateDevl(i);
1463: COMMIT;
1464: END LOOP;

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

1462: WHERE devl_project_id = tabCandidateDevl(i);
1463: COMMIT;
1464: END LOOP;
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))

Line 1628: --Update cz_devl_projects table.

1624: segmentStart := segmentEnd + 1;
1625:
1626: END LOOP;
1627:
1628: --Update cz_devl_projects table.
1629:
1630: localCount := tabCandidateDevl.COUNT;
1631: segmentStart := 1;
1632:

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

1629:
1630: localCount := tabCandidateDevl.COUNT;
1631: segmentStart := 1;
1632:
1633: debug('Updating cz_devl_projects table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1634:
1635: WHILE(segmentStart <= localCount)LOOP
1636:
1637: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1642: UPDATE cz_devl_projects SET

1638: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1639: devlRollback := segmentEnd;
1640:
1641: FORALL i IN segmentStart..segmentEnd
1642: UPDATE cz_devl_projects SET
1643: orig_sys_ref = NVL(devlProject_origSysRef(orig_sys_ref), orig_sys_ref)
1644: WHERE devl_project_id = tabCandidateDevl(i);
1645:
1646: COMMIT;

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

2189: v_org_id VARCHAR2(20);
2190: v_expl_type VARCHAR2(20);
2191:
2192: BEGIN
2193: -- format of cz_devl_projects.orig_sys_ref: expl_type:org_id:top_item_id
2194: IF (p_orig_sys_ref IS NOT NULL) THEN
2195: v_delim_pos := instr(v_str, ':');
2196: v_expl_type := substr(v_str, 1, v_delim_pos);
2197: v_str := substr(v_str, v_delim_pos + 1);