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_XFR_PROJECT_BILLS

Line 152: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%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);
155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);

Line 153: TYPE typeOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15);

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);
155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);
157:

Line 154: TYPE typeTopItemId IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY VARCHAR2(15);

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);
155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);
157:
158: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;

Line 155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%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);
155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);
157:
158: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
159: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;

Line 156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);

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);
155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);
157:
158: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
159: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
160: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 159: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;

155: TYPE typeComponentId IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15);
156: TYPE typeSourceServer IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15);
157:
158: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
159: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
160: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;
161: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;
162:
163: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

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 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 1238: --have its own record in cz_xfr_project_bills.

1234: --This procedure is called for a single model, so we will get and verify the source server
1235: --for this particular model here. If not null, the source server has already been verified
1236: --from verify_source_instance procedure.
1237: --Also this model has to be an original model, not a publishing target model, so it has to
1238: --have its own record in cz_xfr_project_bills.
1239:
1240: BEGIN
1241:
1242: SELECT source_server INTO sourceServer

Line 1243: FROM cz_xfr_project_bills

1239:
1240: BEGIN
1241:
1242: SELECT source_server INTO sourceServer
1243: FROM cz_xfr_project_bills
1244: WHERE model_ps_node_id = p_model_id
1245: AND deleted_flag = FLAG_NOT_DELETED;
1246:
1247: EXCEPTION

Line 1255: --We always need organization_id. We cannot always read it from cz_xfr_project_bills

1251:
1252: verify_source_server;
1253: END IF;
1254:
1255: --We always need organization_id. We cannot always read it from cz_xfr_project_bills
1256: --because publishing targets will not have records there. This why we extracting the
1257: --value from orig_sys_ref rather than reading it from a table.
1258:
1259: sourceOrgId := extract_organization_id;

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 1487: UPDATE cz_xfr_project_bills SET

1483:
1484: debug('Table cz_item_types updates rolled back');
1485:
1486: FOR i IN 1..projRollback LOOP
1487: UPDATE cz_xfr_project_bills SET
1488: organization_id = hashRbOrganizationId(tabCandidateProj(i)),
1489: top_item_id = hashRbTopItemId(tabCandidateProj(i)),
1490: component_item_id = hashRbComponentItemId(tabCandidateProj(i)),
1491: source_server = hashRbSourceServer(tabCandidateProj(i))

Line 1496: debug('Table cz_xfr_project_bills updates rolled back');

1492: WHERE model_ps_node_id = tabCandidateProj(i);
1493: COMMIT;
1494: END LOOP;
1495:
1496: debug('Table cz_xfr_project_bills updates rolled back');
1497:
1498: FOR i IN 1..publRollback LOOP
1499: UPDATE cz_model_publications SET
1500: organization_id = hashRbPubOrganizationId(tabCandidatePubl(i)),

Line 1697: --Update cz_xfr_project_bills table.

1693: segmentStart := segmentEnd + 1;
1694:
1695: END LOOP;
1696:
1697: --Update cz_xfr_project_bills table.
1698:
1699: localCount := tabCandidateProj.COUNT;
1700: segmentStart := 1;
1701:

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

1698:
1699: localCount := tabCandidateProj.COUNT;
1700: segmentStart := 1;
1701:
1702: debug('Updating cz_xfr_project_bills table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1703:
1704: WHILE(segmentStart <= localCount)LOOP
1705:
1706: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1711: UPDATE cz_xfr_project_bills SET

1707: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1708: projRollback := segmentEnd;
1709:
1710: FORALL i IN segmentStart..segmentEnd
1711: UPDATE cz_xfr_project_bills SET
1712: organization_id = NVL(projectBill_orgId(organization_id), organization_id),
1713: top_item_id = NVL(projectBill_topItemId(top_item_id), top_item_id),
1714: component_item_id = NVL(projectBill_compItemId(component_item_id), component_item_id),
1715: source_server = NVL(projectBill_sourceServer(source_server), source_server)