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_PS_NODES

Line 120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

116: p_error_flag IN OUT NOCOPY VARCHAR2,
117: p_run_id IN OUT NOCOPY NUMBER)
118: IS
119:
120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

Line 121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

117: p_run_id IN OUT NOCOPY NUMBER)
118: IS
119:
120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;

Line 122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

118: IS
119:
120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

Line 123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi

119:
120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

Line 124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

120: TYPE typePsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;

121: TYPE typePsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

122: TYPE typeInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

Line 127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

123: TYPE typeInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

Line 128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

124: TYPE typeParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

Line 129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

125: TYPE typeItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

Line 130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

126: TYPE typeMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

127: TYPE typeMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

128: TYPE typeMinimumSelected IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;

Line 133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

129: TYPE typeMaximumSelected IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274

Line 134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

130: TYPE typeReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
138: TYPE typeSequenceId IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

Line 135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274

131: TYPE typeEffectiveFrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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

Line 136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;

132: TYPE typeEffectiveUntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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;

Line 137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274

133: TYPE typePsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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:

Line 138: TYPE typeSequenceId IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

134: TYPE typeOrigSysRef IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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;

Line 139: TYPE typeSequenceId_vc2 IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY VARCHAR2(15); --Bug9941274

135: TYPE typeOrigSysRef_vc2 IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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;

Line 140: TYPE typeBomRequiredFlag IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;

136: TYPE typeSequencePath IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY BINARY_INTEGER;
137: TYPE typeSequencePath_vc2 IS TABLE OF cz_ps_nodes.component_sequence_path%TYPE INDEX BY VARCHAR2(15); --Bug9941274
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:

Line 400: modelName cz_ps_nodes.name%TYPE;

396: sourceOrgId PLS_INTEGER;
397: sourceTopId PLS_INTEGER;
398: targetOrgId PLS_INTEGER;
399:
400: modelName cz_ps_nodes.name%TYPE;
401: modelOrigSysRef cz_devl_projects.orig_sys_ref%TYPE;
402: modelEngineType cz_devl_projects.config_engine_type%TYPE;
403:
404: modelNameStack typeStringTable;

Line 478: --Extracts cz_devl_projects.orig_sys_ref part of cz_ps_nodes.orig_sys_ref. Uses the fact

474: END; --extract_item_id
475: ---------------------------------------------------------------------------------------
476: --build_structure_map->execute_model->execute_structure_map->extract_project_reference
477:
478: --Extracts cz_devl_projects.orig_sys_ref part of cz_ps_nodes.orig_sys_ref. Uses the fact
479: --the first is always a part of the second.
480:
481: FUNCTION extract_project_reference(j IN PLS_INTEGER) RETURN VARCHAR2 IS
482: BEGIN

Line 493: localPsNodeId cz_ps_nodes.ps_node_id%TYPE := tabPsNodeId(j);

489: --Makes the actual comparisons intersecting effectivity ranges. Recurse on every option class.
490:
491: PROCEDURE verify_children_list(j IN PLS_INTEGER, inEffectivityDate IN DATE, inDisableDate IN DATE) IS
492:
493: localPsNodeId cz_ps_nodes.ps_node_id%TYPE := tabPsNodeId(j);
494: localParentName cz_ps_nodes.name%TYPE := tabPsNodeName(j);
495: localParentType cz_ps_nodes.ps_node_type%TYPE := tabPsNodeType(j);
496: bomRequiredFlag cz_ps_nodes.bom_required_flag%TYPE;
497: tabInventoryItemId typeInventoryItemId;

Line 494: localParentName cz_ps_nodes.name%TYPE := tabPsNodeName(j);

490:
491: PROCEDURE verify_children_list(j IN PLS_INTEGER, inEffectivityDate IN DATE, inDisableDate IN DATE) IS
492:
493: localPsNodeId cz_ps_nodes.ps_node_id%TYPE := tabPsNodeId(j);
494: localParentName cz_ps_nodes.name%TYPE := tabPsNodeName(j);
495: localParentType cz_ps_nodes.ps_node_type%TYPE := tabPsNodeType(j);
496: bomRequiredFlag cz_ps_nodes.bom_required_flag%TYPE;
497: tabInventoryItemId typeInventoryItemId;
498:

Line 495: localParentType cz_ps_nodes.ps_node_type%TYPE := tabPsNodeType(j);

491: PROCEDURE verify_children_list(j IN PLS_INTEGER, inEffectivityDate IN DATE, inDisableDate IN DATE) IS
492:
493: localPsNodeId cz_ps_nodes.ps_node_id%TYPE := tabPsNodeId(j);
494: localParentName cz_ps_nodes.name%TYPE := tabPsNodeName(j);
495: localParentType cz_ps_nodes.ps_node_type%TYPE := tabPsNodeType(j);
496: bomRequiredFlag cz_ps_nodes.bom_required_flag%TYPE;
497: tabInventoryItemId typeInventoryItemId;
498:
499: l_item_type_msg VARCHAR2(4000);

Line 496: bomRequiredFlag cz_ps_nodes.bom_required_flag%TYPE;

492:
493: localPsNodeId cz_ps_nodes.ps_node_id%TYPE := tabPsNodeId(j);
494: localParentName cz_ps_nodes.name%TYPE := tabPsNodeName(j);
495: localParentType cz_ps_nodes.ps_node_type%TYPE := tabPsNodeType(j);
496: bomRequiredFlag cz_ps_nodes.bom_required_flag%TYPE;
497: tabInventoryItemId typeInventoryItemId;
498:
499: l_item_type_msg VARCHAR2(4000);
500: l_parent_type_msg VARCHAR2(4000);

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 843: --invert the value to compare to cz_ps_nodes.bom_required_flag.

839: IF(bomDisableDate IS NULL OR bomDisableDate > EpochEndDate)THEN bomDisableDate := EpochEndDate; END IF;
840: IF(bomEffectivityDate < EpochBeginDate)THEN bomEffectivityDate := EpochBeginDate; END IF;
841:
842: --bom_inventory_components.optional can be null which means optional. Also we need to
843: --invert the value to compare to cz_ps_nodes.bom_required_flag.
844:
845: IF(bomOptional = ORACLE_NO)THEN
846: bomRequiredFlag := FLAG_BOM_REQUIRED;
847: ELSE

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 1451: UPDATE cz_ps_nodes SET

1447: PROCEDURE rollback_structure IS
1448: BEGIN
1449:
1450: FOR i IN 1..nodeRollback LOOP
1451: UPDATE cz_ps_nodes SET
1452: orig_sys_ref = hashRbNodeOrigSysRef(tabCandidateNode(i)),
1453: component_sequence_path = hashRbNodeSequencePath(tabCandidateNode(i)),
1454: component_sequence_id = hashRbNodeSequenceId(tabCandidateNode(i))
1455: WHERE ps_node_id = tabCandidateNode(i);

Line 1459: debug('Table cz_ps_nodes updates rolled back');

1455: WHERE ps_node_id = tabCandidateNode(i);
1456: COMMIT;
1457: END LOOP;
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))

Line 1585: --Update cz_ps_nodes table.

1581: --installed languages.
1582:
1583: textCommitBlockSize := CommitBlockSize / numberOfLanguages;
1584:
1585: --Update cz_ps_nodes table.
1586:
1587: localCount := tabCandidateNode.COUNT;
1588: segmentStart := 1;
1589:

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

1586:
1587: localCount := tabCandidateNode.COUNT;
1588: segmentStart := 1;
1589:
1590: debug('Updating cz_ps_nodes table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1591:
1592: --Have to use NVL in the following update statements, because FORALL construct is extremely
1593: --tolerant to any exceptions occurring inside the functions, including data not found. When
1594: --the exception occurs it is just like the function returned null. This may result in lost

Line 1605: UPDATE cz_ps_nodes SET

1601: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1602: nodeRollback := segmentEnd;
1603:
1604: FORALL i IN segmentStart..segmentEnd
1605: UPDATE cz_ps_nodes SET
1606: orig_sys_ref = NVL(psnode_origSysRef(orig_sys_ref), orig_sys_ref),
1607: component_sequence_path = NVL(psnode_compSeqPath(component_sequence_path), component_sequence_path),
1608: component_sequence_id = NVL(psnode_compSeqId(component_sequence_id), component_sequence_id)
1609: WHERE ps_node_id = tabCandidateNode(i);

Line 2013: (SELECT NULL FROM cz_ps_nodes

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
2014: WHERE deleted_flag = FLAG_NOT_DELETED
2015: AND item_id = item.item_id);
2016:
2017: COMMIT;

Line 2052: -- format of cz_ps_nodes.orig_sys_ref: comp_code:expl_type:org_id:top_item_id

2048: v_delim_pos INTEGER;
2049: v_ret_val VARCHAR2(1200);
2050:
2051: BEGIN
2052: -- format of cz_ps_nodes.orig_sys_ref: comp_code:expl_type:org_id:top_item_id
2053: IF (p_orig_sys_ref IS NOT NULL) THEN
2054: v_delim_pos := instr(v_str, ':', -1);
2055: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(v_str, v_delim_pos + 1))));
2056: v_str := substr(v_str, 1, v_delim_pos - 1);