DBA Data[Home] [Help]

APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_MASTERS

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

138: TYPE typeSequenceId IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
139: TYPE typeSequenceId_vc2 IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
140: TYPE typeBomRequiredFlag IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;

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

139: TYPE typeSequenceId_vc2 IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274
140: TYPE typeBomRequiredFlag IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 461: --Extracts item_id from cz_item_masters.orig_sys_ref

457: END; --generate_name
458: ---------------------------------------------------------------------------------------
459: --build_structure_map->execute_model->execute_structure_map->extract_item_id
460:
461: --Extracts item_id from cz_item_masters.orig_sys_ref
462:
463: FUNCTION extract_item_id(j IN PLS_INTEGER) RETURN PLS_INTEGER IS
464: BEGIN
465:

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

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

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

607: SELECT name, data_type,def_value as property_value,def_num_value as property_num_value,src_application_id
608: FROM cz_properties p
609: WHERE p.property_id IN(
610: SELECT it.property_id FROM cz_item_type_properties it
611: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im
612: WHERE im.item_id=tabItemId(j) AND
613: im.deleted_flag=FLAG_NOT_DELETED) AND
614: it.deleted_flag=FLAG_NOT_DELETED
615: ) AND

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

1089: tabEffectiveUntil, tabMinimum, tabMaximum, tabMinimumSelected, tabMaximumSelected,
1090: tabInitialValue, tabInitNumVal, tabReferenceId, tabPsNodeName, tabOrigSysRef, tabSequencePath, -- sselahi
1091: tabSequenceId, tabIntlTextId, tabBomRequiredFlag, tabTextOrigSysRef,
1092: tabRefPartNbr, tabItemOrigSysRef, tabItemMasterTypeId
1093: FROM cz_item_masters i, cz_ps_nodes p, cz_localized_texts t
1094: WHERE p.devl_project_id = p_model_id
1095: AND p.deleted_flag = FLAG_NOT_DELETED
1096: AND p.orig_sys_ref IS NOT NULL
1097: AND p.src_application_id = 702

Line 1462: UPDATE cz_item_masters SET

1458:
1459: debug('Table cz_ps_nodes updates rolled back');
1460:
1461: FOR i IN 1..itemRollback LOOP
1462: UPDATE cz_item_masters SET
1463: orig_sys_ref = hashRbItemOrigSysRef(tabCandidateItem(i))
1464: WHERE item_id = tabCandidateItem(i);
1465: COMMIT;
1466: END LOOP;

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

1464: WHERE item_id = tabCandidateItem(i);
1465: COMMIT;
1466: END LOOP;
1467:
1468: debug('Table cz_item_masters updates rolled back');
1469:
1470: FOR i IN 1..devlRollback LOOP
1471: UPDATE cz_devl_projects SET
1472: orig_sys_ref = hashRbDevlOrigSysRef(tabCandidateDevl(i))

Line 1616: --Update cz_item_masters table.

1612: segmentStart := segmentEnd + 1;
1613:
1614: END LOOP;
1615:
1616: --Update cz_item_masters table.
1617:
1618: localCount := tabCandidateItem.COUNT;
1619: segmentStart := 1;
1620:

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

1617:
1618: localCount := tabCandidateItem.COUNT;
1619: segmentStart := 1;
1620:
1621: debug('Updating cz_item_masters table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1622:
1623: WHILE(segmentStart <= localCount)LOOP
1624:
1625: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1630: UPDATE cz_item_masters SET

1626: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1627: itemRollback := segmentEnd;
1628:
1629: FORALL i IN segmentStart..segmentEnd
1630: UPDATE cz_item_masters SET
1631: orig_sys_ref = NVL(itemMaster_origSysRef(orig_sys_ref), orig_sys_ref)
1632: WHERE item_id = tabCandidateItem(i);
1633:
1634: COMMIT;

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

2005: --because these items have not been synchronize and may cause problems for consequtive
2006: --BOM import.
2007: --Bug #3634107.
2008:
2009: UPDATE cz_item_masters item SET deleted_flag = '1'
2010: WHERE deleted_flag = FLAG_NOT_DELETED
2011: AND src_application_id = 401
2012: AND NOT EXISTS
2013: (SELECT NULL FROM cz_ps_nodes