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 156: TYPE typeModelPsNodeId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;

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
159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 157: TYPE typeOrganizationId_vc2 IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274

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
159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274
161:

Line 158: TYPE typeTopItemId_vc2 IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274

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
159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274
161:
162: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;

Line 159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%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
159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274
161:
162: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
163: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;

Line 160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274

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
159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274
161:
162: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
163: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
164: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;

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

159: TYPE typeComponentId_vc2 IS TABLE OF cz_xfr_project_bills.component_item_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
160: TYPE typeSourceServer_vc2 IS TABLE OF cz_xfr_project_bills.source_server%TYPE INDEX BY VARCHAR2(15); --Bug9941274
161:
162: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;
163: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
164: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;
165: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;
166:
167: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

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

1245: --This procedure is called for a single model, so we will get and verify the source server
1246: --for this particular model here. If not null, the source server has already been verified
1247: --from verify_source_instance procedure.
1248: --Also this model has to be an original model, not a publishing target model, so it has to
1249: --have its own record in cz_xfr_project_bills.
1250:
1251: BEGIN
1252:
1253: SELECT source_server INTO sourceServer

Line 1254: FROM cz_xfr_project_bills

1250:
1251: BEGIN
1252:
1253: SELECT source_server INTO sourceServer
1254: FROM cz_xfr_project_bills
1255: WHERE model_ps_node_id = p_model_id
1256: AND deleted_flag = FLAG_NOT_DELETED;
1257:
1258: EXCEPTION

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

1262:
1263: verify_source_server;
1264: END IF;
1265:
1266: --We always need organization_id. We cannot always read it from cz_xfr_project_bills
1267: --because publishing targets will not have records there. This why we extracting the
1268: --value from orig_sys_ref rather than reading it from a table.
1269:
1270: sourceOrgId := extract_organization_id;

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

1494:
1495: debug('Table cz_item_types updates rolled back');
1496:
1497: FOR i IN 1..projRollback LOOP
1498: UPDATE cz_xfr_project_bills SET
1499: organization_id = hashRbOrganizationId(tabCandidateProj(i)),
1500: top_item_id = hashRbTopItemId(tabCandidateProj(i)),
1501: component_item_id = hashRbComponentItemId(tabCandidateProj(i)),
1502: source_server = hashRbSourceServer(tabCandidateProj(i))

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

1503: WHERE model_ps_node_id = tabCandidateProj(i);
1504: COMMIT;
1505: END LOOP;
1506:
1507: debug('Table cz_xfr_project_bills updates rolled back');
1508:
1509: FOR i IN 1..publRollback LOOP
1510: UPDATE cz_model_publications SET
1511: organization_id = hashRbPubOrganizationId(tabCandidatePubl(i)),

Line 1708: --Update cz_xfr_project_bills table.

1704: segmentStart := segmentEnd + 1;
1705:
1706: END LOOP;
1707:
1708: --Update cz_xfr_project_bills table.
1709:
1710: localCount := tabCandidateProj.COUNT;
1711: segmentStart := 1;
1712:

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

1709:
1710: localCount := tabCandidateProj.COUNT;
1711: segmentStart := 1;
1712:
1713: debug('Updating cz_xfr_project_bills table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1714:
1715: WHILE(segmentStart <= localCount)LOOP
1716:
1717: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1722: UPDATE cz_xfr_project_bills SET

1718: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1719: projRollback := segmentEnd;
1720:
1721: FORALL i IN segmentStart..segmentEnd
1722: UPDATE cz_xfr_project_bills SET
1723: organization_id = NVL(projectBill_orgId(organization_id), organization_id),
1724: top_item_id = NVL(projectBill_topItemId(top_item_id), top_item_id),
1725: component_item_id = NVL(projectBill_compItemId(component_item_id), component_item_id),
1726: source_server = NVL(projectBill_sourceServer(source_server), source_server)