APPS.CZ_IMP_SINGLE dependencies on CZ_TYPES

Line 4167: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)

4163: l_current_date := SYSDATE;
4164: FOR i IN (SELECT ps_node_id, detailed_type_id
4165: FROM CZ_UI_TYPEDPSN_V
4166: WHERE devl_project_Id = model.component_id
4167: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)
4168: AND deleted_flag = '0')
4169: LOOP
4170: l_detailed_types_tbl(i.ps_node_id) := i.detailed_type_id;
4171: END LOOP;

Line 4272: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE

4268: AND MODEL.object_type = 'PRJ'
4269: AND parent.devl_project_id IN
4270: (SELECT DISTINCT component_id FROM cz_model_ref_expls
4271: WHERE deleted_flag = '0' AND model_id = nModelId
4272: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
4275: AND PARENT.effective_until > SYSDATE
4276: AND NOT EXISTS

Line 4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))

4269: AND parent.devl_project_id IN
4270: (SELECT DISTINCT component_id FROM cz_model_ref_expls
4271: WHERE deleted_flag = '0' AND model_id = nModelId
4272: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
4275: AND PARENT.effective_until > SYSDATE
4276: AND NOT EXISTS
4277: (SELECT 1 FROM cz_ps_nodes CHILD

Line 4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS

4270: (SELECT DISTINCT component_id FROM cz_model_ref_expls
4271: WHERE deleted_flag = '0' AND model_id = nModelId
4272: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
4275: AND PARENT.effective_until > SYSDATE
4276: AND NOT EXISTS
4277: (SELECT 1 FROM cz_ps_nodes CHILD
4278: WHERE CHILD.deleted_flag = '0'

Line 4317: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)

4313: AND rec_status = 'OK')LOOP
4314: FOR i IN (SELECT ps_node_id, detailed_type_id
4315: FROM CZ_UI_TYPEDPSN_V
4316: WHERE devl_project_Id = model.devl_project_id
4317: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)
4318: AND creation_date <= l_current_date
4319: AND deleted_flag = '0')
4320: LOOP
4321: IF l_detailed_types_tbl.EXISTS( i.ps_node_id ) THEN