DBA Data[Home] [Help]

APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_MASTERS

Line 139: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;

135: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
136: TYPE typeSequenceId IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeBomRequiredFlag IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
138:
139: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;

Line 140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

136: TYPE typeSequenceId IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeBomRequiredFlag IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
138:
139: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 457: --Extracts item_id from cz_item_masters.orig_sys_ref

453: END; --generate_name
454: ---------------------------------------------------------------------------------------
455: --build_structure_map->execute_model->execute_structure_map->extract_item_id
456:
457: --Extracts item_id from cz_item_masters.orig_sys_ref
458:
459: FUNCTION extract_item_id(j IN PLS_INTEGER) RETURN PLS_INTEGER IS
460: BEGIN
461:

Line 529: --rollback hash tables for cz_ps_nodes, cz_item_masters and cz_localized_texts.

525: ---------------------------------------------------------------------------------------
526: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item
527:
528: --Adds the item that passed all the comparisons to the corresponding hash tables and populates
529: --rollback hash tables for cz_ps_nodes, cz_item_masters and cz_localized_texts.
530:
531: PROCEDURE hash_item(j IN PLS_INTEGER) IS
532:
533: itemId PLS_INTEGER;

Line 606: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im

602: SELECT name, data_type,def_value as property_value,def_num_value as property_num_value,src_application_id
603: FROM cz_properties p
604: WHERE p.property_id IN(
605: SELECT it.property_id FROM cz_item_type_properties it
606: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im
607: WHERE im.item_id=tabItemId(j) AND
608: im.deleted_flag=FLAG_NOT_DELETED) AND
609: it.deleted_flag=FLAG_NOT_DELETED
610: ) AND

Line 1082: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t

1078: tabEffectiveUntil, tabMinimum, tabMaximum, tabMinimumSelected, tabMaximumSelected,
1079: tabInitialValue, tabInitNumVal, tabReferenceId, tabPsNodeName, tabOrigSysRef, tabSequencePath, -- sselahi
1080: tabSequenceId, tabIntlTextId, tabBomRequiredFlag, tabTextOrigSysRef,
1081: tabRefPartNbr, tabItemOrigSysRef, tabItemMasterTypeId
1082: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t
1083: WHERE p.devl_project_id = p_model_id
1084: AND p.deleted_flag = FLAG_NOT_DELETED
1085: AND p.orig_sys_ref IS NOT NULL
1086: AND p.src_application_id = 702

Line 1451: UPDATE cz_item_masters SET

1447:
1448: debug('Table cz_ps_nodes updates rolled back');
1449:
1450: FOR i IN 1..itemRollback LOOP
1451: UPDATE cz_item_masters SET
1452: orig_sys_ref = hashRbItemOrigSysRef(tabCandidateItem(i))
1453: WHERE item_id = tabCandidateItem(i);
1454: COMMIT;
1455: END LOOP;

Line 1457: debug('Table cz_item_masters updates rolled back');

1453: WHERE item_id = tabCandidateItem(i);
1454: COMMIT;
1455: END LOOP;
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))

Line 1605: --Update cz_item_masters table.

1601: segmentStart := segmentEnd + 1;
1602:
1603: END LOOP;
1604:
1605: --Update cz_item_masters table.
1606:
1607: localCount := tabCandidateItem.COUNT;
1608: segmentStart := 1;
1609:

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

1606:
1607: localCount := tabCandidateItem.COUNT;
1608: segmentStart := 1;
1609:
1610: debug('Updating cz_item_masters table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1611:
1612: WHILE(segmentStart <= localCount)LOOP
1613:
1614: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1619: UPDATE cz_item_masters SET

1615: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1616: itemRollback := segmentEnd;
1617:
1618: FORALL i IN segmentStart..segmentEnd
1619: UPDATE cz_item_masters SET
1620: orig_sys_ref = NVL(itemMaster_origSysRef(orig_sys_ref), orig_sys_ref)
1621: WHERE item_id = tabCandidateItem(i);
1622:
1623: COMMIT;

Line 1998: UPDATE cz_item_masters item SET deleted_flag = '1'

1994: --because these items have not been synchronize and may cause problems for consequtive
1995: --BOM import.
1996: --Bug #3634107.
1997:
1998: UPDATE cz_item_masters item SET deleted_flag = '1'
1999: WHERE deleted_flag = FLAG_NOT_DELETED
2000: AND src_application_id = 401
2001: AND NOT EXISTS
2002: (SELECT NULL FROM cz_ps_nodes