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_UPGRADE dependencies on CZ_PS_NODES_S

Line 439: UPDATE CZ_PS_NODES SET bom_sort_order=var_string1

435: var_token:='-';
436: END IF;
437: var_string1:=p_string1||getNum(i.tree_seq);
438: var_string2:=p_string2||var_token||TO_CHAR(i.component_sequence_id);
439: UPDATE CZ_PS_NODES SET bom_sort_order=var_string1
440: WHERE ps_node_id=i.ps_node_id AND bom_sort_order is NULL;
441: UPDATE CZ_PS_NODES SET component_sequence_path=var_string2
442: WHERE ps_node_id=i.ps_node_id AND component_sequence_path is NULL;
443: populate(i.ps_node_id,var_string1,var_string2);

Line 441: UPDATE CZ_PS_NODES SET component_sequence_path=var_string2

437: var_string1:=p_string1||getNum(i.tree_seq);
438: var_string2:=p_string2||var_token||TO_CHAR(i.component_sequence_id);
439: UPDATE CZ_PS_NODES SET bom_sort_order=var_string1
440: WHERE ps_node_id=i.ps_node_id AND bom_sort_order is NULL;
441: UPDATE CZ_PS_NODES SET component_sequence_path=var_string2
442: WHERE ps_node_id=i.ps_node_id AND component_sequence_path is NULL;
443: populate(i.ps_node_id,var_string1,var_string2);
444: IF numRecord>BatchSize THEN
445: COMMIT;

Line 456: UPDATE CZ_PS_NODES SET component_sequence_path=NULL,bom_sort_order=var_bom_sort

452:
453: BEGIN
454: var_bom_sort:=getNum(1);
455:
456: UPDATE CZ_PS_NODES SET component_sequence_path=NULL,bom_sort_order=var_bom_sort
457: WHERE ps_node_id = p_model_id;
458:
459: populate(p_model_id,var_bom_sort,'');
460:

Line 487: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;

483: next_expl_id := base_expl_id;
484:
485: --Initialize id allocation for ps_node ids
486:
487: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;
488: next_node_id := base_node_id;
489:
490: --Set the virtual_flag for all the nodes
491:

Line 526: UPDATE cz_ps_nodes SET virtual_flag = flag_virtual

522: );
523:
524: COMMIT;
525:
526: UPDATE cz_ps_nodes SET virtual_flag = flag_virtual
527: WHERE ps_node_type IN (ps_node_type_product, ps_node_type_component, ps_node_type_bom_model);
528:
529: COMMIT;
530:

Line 531: UPDATE cz_ps_nodes SET virtual_flag = flag_non_virtual WHERE ps_node_id IN (

527: WHERE ps_node_type IN (ps_node_type_product, ps_node_type_component, ps_node_type_bom_model);
528:
529: COMMIT;
530:
531: UPDATE cz_ps_nodes SET virtual_flag = flag_non_virtual WHERE ps_node_id IN (
532: SELECT structure.ps_node_id
533: FROM cz_ps_nodes structure, cz_ps_nodes parent
534: WHERE structure.ps_node_type IN (ps_node_type_product, ps_node_type_component, ps_node_type_bom_model)
535: AND parent.ps_node_id = structure.parent_id

Line 533: FROM cz_ps_nodes structure, cz_ps_nodes parent

529: COMMIT;
530:
531: UPDATE cz_ps_nodes SET virtual_flag = flag_non_virtual WHERE ps_node_id IN (
532: SELECT structure.ps_node_id
533: FROM cz_ps_nodes structure, cz_ps_nodes parent
534: WHERE structure.ps_node_type IN (ps_node_type_product, ps_node_type_component, ps_node_type_bom_model)
535: AND parent.ps_node_id = structure.parent_id
536: AND (structure.ps_node_type IN (ps_node_type_product, ps_node_type_component) OR parent.ps_node_type <> ps_node_type_product)
537: AND structure.deleted_flag = flag_not_deleted

Line 580: UPDATE cz_ps_nodes SET

576: AND parent.ps_node_id = child.parent_id
577: AND ROWNUM = 1)
578: WHERE devl_project_id = c_devl.devl_project_id;
579:
580: UPDATE cz_ps_nodes SET
581: orig_sys_ref =
582: (SELECT orig_sys_ref FROM cz_devl_projects WHERE devl_project_id = c_devl.devl_project_id)
583: WHERE ps_node_id = c_devl.devl_project_id
584: returning orig_sys_ref INTO v_origsysref;

Line 882: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;

878: END;
879:
880: current_node_id := next_node_id;
881: IF(next_node_id = base_node_id)THEN
882: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;
883: END IF;
884: next_node_id := next_node_id + 1;
885:
886: BEGIN

Line 905: UPDATE cz_ps_nodes SET

901:
902: ncutstart := instr(ntorigsysref(i), '-', -1, 1) + 1;
903: stopitemid := substr(ntorigsysref(i),ncutstart,instr(ntorigsysref(i),':')-ncutstart);
904:
905: UPDATE cz_ps_nodes SET
906: parent_id = NULL,
907: minimum = 0,
908: maximum = -1,
909: tree_seq = 1,

Line 914: UPDATE cz_ps_nodes SET

910: component_sequence_id = NULL,
911: virtual_flag = flag_virtual
912: WHERE ps_node_id = ntpsnodeid(i);
913:
914: UPDATE cz_ps_nodes SET
915: devl_project_id = ntpsnodeid(i),
916: --orig_sys_ref = SUBSTR(orig_sys_ref, INSTR(orig_sys_ref, '-', 1, inLogicNetLevel + 2) + 1)
917: orig_sys_ref = substr(substr(orig_sys_ref, ncutstart),1,instr(substr(orig_sys_ref, ncutstart),':',-1,1)) || stopitemid
918: WHERE ps_node_id IN