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 158: TYPE typePublicationId IS TABLE OF cz_model_publications.publication_id%TYPE INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

1278: ELSE
1279: targetOrgId := organization_id_map(sourceOrgId);
1280: END IF;
1281:
1282: --Populate the candidate and rollback tables for cz_model_publications. We need to do that
1283: --only in the SYNC mode, because we have nothing to verify.
1284:
1285: IF(p_execution_mode = EXECUTION_MODE_SYNC)THEN
1286:

Line 1288: FROM cz_model_publications

1284:
1285: IF(p_execution_mode = EXECUTION_MODE_SYNC)THEN
1286:
1287: FOR c_pub IN (SELECT publication_id, top_item_id, organization_id, product_key
1288: FROM cz_model_publications
1289: WHERE model_id = p_model_id
1290: AND deleted_flag = FLAG_NOT_DELETED)LOOP
1291:
1292: tabCandidatePubl(tabCandidatePubl.COUNT + 1) := c_pub.publication_id;

Line 1398: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

1394: END;
1395:
1396: --Check if any publication is currently processing.
1397:
1398: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
1399: WHERE deleted_flag = FLAG_NOT_DELETED
1400: AND export_status = PUBLICATION_STATUS_PROCESSING)LOOP
1401:
1402: --'Synchronization cannot be done while a publication is processing. At least one publication (%PUBLICATIONID) is currently in processing status'

Line 1499: UPDATE cz_model_publications SET

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)),
1501: top_item_id = hashRbPubTopItemId(tabCandidatePubl(i)),
1502: product_key = hashRbPubProductKey(tabCandidatePubl(i))
1503: WHERE publication_id = tabCandidatePubl(i);

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

1503: WHERE publication_id = tabCandidatePubl(i);
1504: COMMIT;
1505: END LOOP;
1506:
1507: debug('Table cz_model_publications updates rolled back');
1508: FOR i IN 1..tabRbItmPropValItemId.count LOOP
1509: UPDATE cz_item_property_values SET
1510: orig_sys_ref = tabRbItmPropValOrigSysRef(i)
1511: WHERE item_id = tabRbItmPropValItemId(i)

Line 1723: --Update cz_model_publications table.

1719: segmentStart := segmentEnd + 1;
1720:
1721: END LOOP;
1722:
1723: --Update cz_model_publications table.
1724:
1725: localCount := tabCandidatePubl.COUNT;
1726: segmentStart := 1;
1727:

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

1724:
1725: localCount := tabCandidatePubl.COUNT;
1726: segmentStart := 1;
1727:
1728: debug('Updating cz_model_publications table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1729:
1730: WHILE(segmentStart <= localCount)LOOP
1731:
1732: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1737: UPDATE cz_model_publications SET

1733: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1734: publRollback := segmentEnd;
1735:
1736: FORALL i IN segmentStart..segmentEnd
1737: UPDATE cz_model_publications SET
1738: organization_id = NVL(modelPublication_orgId(organization_id), organization_id),
1739: top_item_id = NVL(modelPublication_topItemId(top_item_id), top_item_id),
1740: product_key = NVL(modelPublication_productKey(product_key), product_key)
1741: WHERE publication_id = tabCandidatePubl(i);

Line 1977: FOR c_model IN (SELECT model_id FROM cz_model_publications

1973: --the models created by publishing.
1974:
1975: IF(g_target_instance = LOCAL_SERVER_SEED_ID)THEN
1976:
1977: FOR c_model IN (SELECT model_id FROM cz_model_publications
1978: WHERE deleted_flag = FLAG_NOT_DELETED
1979: AND source_target_flag = PUBLICATION_TARGET_FLAG
1980: AND export_status = PUBLICATION_STATUS_OK) LOOP
1981:

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

2289: v_item_id VARCHAR2(20);
2290: v_org_id VARCHAR2(20);
2291:
2292: BEGIN
2293: --format of cz_model_publications.product_key: org_id:inv_item_id
2294: IF (p_product_key IS NOT NULL) THEN
2295: v_delim_pos := instr(p_product_key, ':');
2296: v_org_id := TO_CHAR(organization_id_map(TO_NUMBER(substr(p_product_key, 1, v_delim_pos - 1))));
2297: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_product_key, v_delim_pos + 1))));

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

2361: v_item_id VARCHAR2(20);
2362: v_org_id VARCHAR2(20);
2363:
2364: BEGIN
2365: --format of cz_model_publications.product_key: org_id:inv_item_id
2366: IF (p_product_key IS NOT NULL) THEN
2367: v_delim_pos := instr(p_product_key, ':');
2368: v_org_id := TO_CHAR(organization_id_map(TO_NUMBER(substr(p_product_key, 1, v_delim_pos - 1))));
2369: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_product_key, v_delim_pos + 1))));