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_MODEL_PUBLICATIONS

Line 162: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;

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;
165: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;
166:

Line 164: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;

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;
168: TYPE typePropertyId IS TABLE OF CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;

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;
168: TYPE typePropertyId IS TABLE OF CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID%TYPE INDEX BY BINARY_INTEGER;
169:

Line 1293: --Populate the candidate and rollback tables for cz_model_publications. We need to do that

1289: ELSE
1290: targetOrgId := organization_id_map(sourceOrgId);
1291: END IF;
1292:
1293: --Populate the candidate and rollback tables for cz_model_publications. We need to do that
1294: --only in the SYNC mode, because we have nothing to verify.
1295:
1296: IF(p_execution_mode = EXECUTION_MODE_SYNC)THEN
1297:

Line 1299: FROM cz_model_publications

1295:
1296: IF(p_execution_mode = EXECUTION_MODE_SYNC)THEN
1297:
1298: FOR c_pub IN (SELECT publication_id, top_item_id, organization_id, product_key
1299: FROM cz_model_publications
1300: WHERE model_id = p_model_id
1301: AND deleted_flag = FLAG_NOT_DELETED)LOOP
1302:
1303: tabCandidatePubl(tabCandidatePubl.COUNT + 1) := c_pub.publication_id;

Line 1409: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

1405: END;
1406:
1407: --Check if any publication is currently processing.
1408:
1409: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
1410: WHERE deleted_flag = FLAG_NOT_DELETED
1411: AND export_status = PUBLICATION_STATUS_PROCESSING)LOOP
1412:
1413: --'Synchronization cannot be done while a publication is processing. At least one publication (%PUBLICATIONID) is currently in processing status'

Line 1510: UPDATE cz_model_publications SET

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)),
1512: top_item_id = hashRbPubTopItemId(tabCandidatePubl(i)),
1513: product_key = hashRbPubProductKey(tabCandidatePubl(i))
1514: WHERE publication_id = tabCandidatePubl(i);

Line 1518: debug('Table cz_model_publications updates rolled back');

1514: WHERE publication_id = tabCandidatePubl(i);
1515: COMMIT;
1516: END LOOP;
1517:
1518: debug('Table cz_model_publications updates rolled back');
1519: FOR i IN 1..tabRbItmPropValItemId.count LOOP
1520: UPDATE cz_item_property_values SET
1521: orig_sys_ref = tabRbItmPropValOrigSysRef(i)
1522: WHERE item_id = tabRbItmPropValItemId(i)

Line 1734: --Update cz_model_publications table.

1730: segmentStart := segmentEnd + 1;
1731:
1732: END LOOP;
1733:
1734: --Update cz_model_publications table.
1735:
1736: localCount := tabCandidatePubl.COUNT;
1737: segmentStart := 1;
1738:

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

1735:
1736: localCount := tabCandidatePubl.COUNT;
1737: segmentStart := 1;
1738:
1739: debug('Updating cz_model_publications table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1740:
1741: WHILE(segmentStart <= localCount)LOOP
1742:
1743: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1748: UPDATE cz_model_publications SET

1744: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1745: publRollback := segmentEnd;
1746:
1747: FORALL i IN segmentStart..segmentEnd
1748: UPDATE cz_model_publications SET
1749: organization_id = NVL(modelPublication_orgId(organization_id), organization_id),
1750: top_item_id = NVL(modelPublication_topItemId(top_item_id), top_item_id),
1751: product_key = NVL(modelPublication_productKey(product_key), product_key)
1752: WHERE publication_id = tabCandidatePubl(i);

Line 1988: FOR c_model IN (SELECT model_id FROM cz_model_publications

1984: --the models created by publishing.
1985:
1986: IF(g_target_instance = LOCAL_SERVER_SEED_ID)THEN
1987:
1988: FOR c_model IN (SELECT model_id FROM cz_model_publications
1989: WHERE deleted_flag = FLAG_NOT_DELETED
1990: AND source_target_flag = PUBLICATION_TARGET_FLAG
1991: AND export_status = PUBLICATION_STATUS_OK) LOOP
1992:

Line 2308: --format of cz_model_publications.product_key: org_id:inv_item_id

2304: v_item_id VARCHAR2(20);
2305: v_org_id VARCHAR2(20);
2306:
2307: BEGIN
2308: --format of cz_model_publications.product_key: org_id:inv_item_id
2309: IF (p_product_key IS NOT NULL) THEN
2310: v_delim_pos := instr(p_product_key, ':');
2311: v_org_id := TO_CHAR(organization_id_map(TO_NUMBER(substr(p_product_key, 1, v_delim_pos - 1))));
2312: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_product_key, v_delim_pos + 1))));

Line 2380: --format of cz_model_publications.product_key: org_id:inv_item_id

2376: v_item_id VARCHAR2(20);
2377: v_org_id VARCHAR2(20);
2378:
2379: BEGIN
2380: --format of cz_model_publications.product_key: org_id:inv_item_id
2381: IF (p_product_key IS NOT NULL) THEN
2382: v_delim_pos := instr(p_product_key, ':');
2383: v_org_id := TO_CHAR(organization_id_map(TO_NUMBER(substr(p_product_key, 1, v_delim_pos - 1))));
2384: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_product_key, v_delim_pos + 1))));