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

Line 411: var_bom_sort CZ_PS_NODES.bom_sort_order%TYPE;

407:
408: v_ps_node_id INTEGER;
409: numRecord INTEGER:=0;
410: BatchSize INTEGER:=p_batch_size;
411: var_bom_sort CZ_PS_NODES.bom_sort_order%TYPE;
412: xERROR BOOLEAN:=FALSE;
413:
414:
415: FUNCTION getNum(p_number IN INTEGER) RETURN VARCHAR2 IS

Line 424: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;

420: END getNum;
421:
422: PROCEDURE populate(p_ps_node_id IN INTEGER,p_string1 IN VARCHAR2,p_string2 IN VARCHAR2) IS
423: var_token VARCHAR2(1);
424: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;
425: var_string2 CZ_PS_NODES.component_sequence_path%TYPE;
426: BEGIN
427: FOR i IN (SELECT ps_node_id,parent_id,tree_seq,ps_node_type,
428: component_sequence_id,component_sequence_path FROM CZ_PS_NODES

Line 425: var_string2 CZ_PS_NODES.component_sequence_path%TYPE;

421:
422: PROCEDURE populate(p_ps_node_id IN INTEGER,p_string1 IN VARCHAR2,p_string2 IN VARCHAR2) IS
423: var_token VARCHAR2(1);
424: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;
425: var_string2 CZ_PS_NODES.component_sequence_path%TYPE;
426: BEGIN
427: FOR i IN (SELECT ps_node_id,parent_id,tree_seq,ps_node_type,
428: component_sequence_id,component_sequence_path FROM CZ_PS_NODES
429: WHERE parent_id=p_ps_node_id AND ps_node_type IN(263,436,437,438)

Line 428: component_sequence_id,component_sequence_path FROM CZ_PS_NODES

424: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;
425: var_string2 CZ_PS_NODES.component_sequence_path%TYPE;
426: BEGIN
427: FOR i IN (SELECT ps_node_id,parent_id,tree_seq,ps_node_type,
428: component_sequence_id,component_sequence_path FROM CZ_PS_NODES
429: WHERE parent_id=p_ps_node_id AND ps_node_type IN(263,436,437,438)
430: AND deleted_flag='0')
431: LOOP
432: IF p_string2='' OR p_string2 IS NULL THEN

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 473: v_origsysref cz_ps_nodes.orig_sys_ref%TYPE;

469: -----------------------------------------------------
470:
471: PROCEDURE generate_explosion IS
472:
473: v_origsysref cz_ps_nodes.orig_sys_ref%TYPE;
474: x_error BOOLEAN;
475:
476: schema_version NUMBER;
477:

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 557: SELECT NULL FROM cz_ps_nodes

553: FOR c_devl IN (SELECT devl_project_id, orig_sys_ref FROM cz_devl_projects p
554: WHERE deleted_flag = flag_not_deleted
555: AND devl_project_id <> 0
556: AND EXISTS (
557: SELECT NULL FROM cz_ps_nodes
558: WHERE deleted_flag = flag_not_deleted
559: AND ps_node_type = ps_node_type_product
560: AND devl_project_id = p.devl_project_id)
561: AND NOT EXISTS

Line 572: FROM cz_ps_nodes parent, cz_ps_nodes child

568: UPDATE cz_devl_projects SET
569: orig_sys_ref =
570: (SELECT nvl(substr(parent.orig_sys_ref,instr(parent.orig_sys_ref,':',-1,3)+1),
571: substr(child.orig_sys_ref,instr(child.orig_sys_ref,':',-1,3)+1))
572: FROM cz_ps_nodes parent, cz_ps_nodes child
573: WHERE parent.ps_node_id = c_devl.devl_project_id
574: AND parent.ps_node_type = 258
575: AND child.ps_node_type IN (258, 436)
576: AND parent.ps_node_id = child.parent_id

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 648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

644: inparentcomponentid IN NUMBER,
645: inreferringnodeid IN NUMBER)
646: IS
647:
648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

Line 649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

645: inreferringnodeid IN NUMBER)
646: IS
647:
648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;

Line 650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

646: IS
647:
648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

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

647:
648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

Line 652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

648: TYPE tpsnodeid IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

Line 653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;

649: TYPE tpsnodetype IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

650: TYPE tinitialvalue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

651: TYPE tinitnumval IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;

Line 656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

652: TYPE tparentid IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

Line 657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

653: TYPE tvirtualflag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;

Line 658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

654: TYPE tfeaturetype IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;

655: TYPE tname IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

Line 660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

656: TYPE tdescriptionid IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

Line 661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;

657: TYPE tminimumsel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

Line 662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

658: TYPE tmaximumsel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
666:

Line 663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

659: TYPE tbomrequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
666:
667: ntpsnodeid tpsnodeid;

Line 664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

660: TYPE treferenceid IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
666:
667: ntpsnodeid tpsnodeid;
668: ntpsnodetype tpsnodetype;

Line 665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

661: TYPE ttreeseq IS TABLE OF cz_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
662: TYPE torigsysref IS TABLE OF cz_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
663: TYPE teffectivefrom IS TABLE OF cz_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
664: TYPE teffectiveuntil IS TABLE OF cz_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
665: TYPE tcomponentsequenceid IS TABLE OF cz_ps_nodes.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
666:
667: ntpsnodeid tpsnodeid;
668: ntpsnodetype tpsnodetype;
669: nvpsnodetype tpsnodetype;

Line 693: genname cz_ps_nodes.name%TYPE;

689: save_expl_id NUMBER;
690: localmodelid NUMBER;
691: modelpsnodeid NUMBER;
692: ncount NUMBER;
693: genname cz_ps_nodes.name%TYPE;
694:
695: stopitemid VARCHAR2(25);
696: ncutstart PLS_INTEGER;
697:

Line 714: FROM cz_ps_nodes WHERE ps_node_id = incomponentid;

710: currentmodelid := incomponentid;
711: END IF;
712:
713: SELECT ps_node_type, virtual_flag INTO npsnodetype, svirtualflag
714: FROM cz_ps_nodes WHERE ps_node_id = incomponentid;
715:
716: localmodelid := currentmodelid;
717: IF(npsnodetype IN (ps_node_type_bom_model/*, ps_node_type_product*/))THEN
718: localmodelid := incomponentid;

Line 790: FROM cz_ps_nodes

786: bulk collect INTO ntpsnodeid, ntparentid, ntname, ntdescriptionid, nttreeseq,
787: ntminimumsel, ntmaximumsel, ntpsnodetype, ntinitialvalue, ntinitnumval, -- sselahi
788: ntvirtualflag, ntfeaturetype, ntbomrequired, ntreferenceid, ntorigsysref,
789: nteffectivefrom, nteffectiveuntil, ntcomponentsequenceid
790: FROM cz_ps_nodes
791: WHERE deleted_flag = flag_not_deleted
792: START WITH parent_id = incomponentid
793: CONNECT BY
794: (PRIOR virtual_flag IS NULL OR PRIOR virtual_flag = flag_virtual)

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 890: INSERT INTO cz_ps_nodes

886: BEGIN
887:
888: --Insert the reference node
889:
890: INSERT INTO cz_ps_nodes
891: (ps_node_id, parent_id, ps_node_type, minimum, maximum, minimum_selected, maximum_selected,
892: name, tree_seq, deleted_flag, devl_project_id, virtual_flag, reference_id,
893: system_node_flag, ui_omit, effective_from, effective_until, orig_sys_ref,
894: component_sequence_id)

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

Line 919: (SELECT ps_node_id FROM cz_ps_nodes

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
919: (SELECT ps_node_id FROM cz_ps_nodes
920: WHERE deleted_flag = flag_not_deleted
921: START WITH ps_node_id = ntpsnodeid(i)
922: CONNECT BY PRIOR ps_node_id = parent_id);
923:

Line 1136: FROM cz_ps_nodes

1132: WHERE cz_lce_headers.deleted_flag = '0'
1133: AND cz_lce_headers.component_id IN
1134: (
1135: SELECT ps_node_id
1136: FROM cz_ps_nodes
1137: WHERE cz_ps_nodes.deleted_flag = '0'
1138: AND cz_ps_nodes.devl_project_id IN
1139: (
1140: SELECT object_id

Line 1137: WHERE cz_ps_nodes.deleted_flag = '0'

1133: AND cz_lce_headers.component_id IN
1134: (
1135: SELECT ps_node_id
1136: FROM cz_ps_nodes
1137: WHERE cz_ps_nodes.deleted_flag = '0'
1138: AND cz_ps_nodes.devl_project_id IN
1139: (
1140: SELECT object_id
1141: FROM cz_rp_entries

Line 1138: AND cz_ps_nodes.devl_project_id IN

1134: (
1135: SELECT ps_node_id
1136: FROM cz_ps_nodes
1137: WHERE cz_ps_nodes.deleted_flag = '0'
1138: AND cz_ps_nodes.devl_project_id IN
1139: (
1140: SELECT object_id
1141: FROM cz_rp_entries
1142: WHERE cz_rp_entries.deleted_flag = '0'

Line 1281: ----get the devl_project_id from cz_ps_nodes where ps_node_id is the v_component_id

1277: RAISE;
1278: END;
1279:
1280: IF (v_net_type = 1) THEN
1281: ----get the devl_project_id from cz_ps_nodes where ps_node_id is the v_component_id
1282: BEGIN
1283: SELECT devl_project_id
1284: INTO v_model_id
1285: FROM cz_ps_nodes

Line 1285: FROM cz_ps_nodes

1281: ----get the devl_project_id from cz_ps_nodes where ps_node_id is the v_component_id
1282: BEGIN
1283: SELECT devl_project_id
1284: INTO v_model_id
1285: FROM cz_ps_nodes
1286: WHERE cz_ps_nodes.deleted_flag = '0'
1287: AND cz_ps_nodes.ps_node_id = v_component_id;
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN

Line 1286: WHERE cz_ps_nodes.deleted_flag = '0'

1282: BEGIN
1283: SELECT devl_project_id
1284: INTO v_model_id
1285: FROM cz_ps_nodes
1286: WHERE cz_ps_nodes.deleted_flag = '0'
1287: AND cz_ps_nodes.ps_node_id = v_component_id;
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN
1290: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

Line 1287: AND cz_ps_nodes.ps_node_id = v_component_id;

1283: SELECT devl_project_id
1284: INTO v_model_id
1285: FROM cz_ps_nodes
1286: WHERE cz_ps_nodes.deleted_flag = '0'
1287: AND cz_ps_nodes.ps_node_id = v_component_id;
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN
1290: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1291: RAISE;

Line 1290: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

1286: WHERE cz_ps_nodes.deleted_flag = '0'
1287: AND cz_ps_nodes.ps_node_id = v_component_id;
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN
1290: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1291: RAISE;
1292: WHEN OTHERS THEN
1293: RAISE;
1294: END;

Line 1322: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

1318: WHERE cz_model_ref_expls.model_ref_expl_id = v_model_ref_expl_id
1319: AND cz_model_ref_expls.deleted_flag = '0';
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1323: RAISE;
1324: WHEN OTHERS THEN
1325: RAISE;
1326: END;

Line 1332: FROM cz_ps_nodes

1328: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id
1329: BEGIN
1330: SELECT devl_project_id
1331: INTO v_model_id
1332: FROM cz_ps_nodes
1333: WHERE cz_ps_nodes.deleted_flag = '0'
1334: AND cz_ps_nodes.ps_node_id = v_component_id;
1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN

Line 1333: WHERE cz_ps_nodes.deleted_flag = '0'

1329: BEGIN
1330: SELECT devl_project_id
1331: INTO v_model_id
1332: FROM cz_ps_nodes
1333: WHERE cz_ps_nodes.deleted_flag = '0'
1334: AND cz_ps_nodes.ps_node_id = v_component_id;
1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN
1337: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

Line 1334: AND cz_ps_nodes.ps_node_id = v_component_id;

1330: SELECT devl_project_id
1331: INTO v_model_id
1332: FROM cz_ps_nodes
1333: WHERE cz_ps_nodes.deleted_flag = '0'
1334: AND cz_ps_nodes.ps_node_id = v_component_id;
1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN
1337: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1338: RAISE;

Line 1337: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

1333: WHERE cz_ps_nodes.deleted_flag = '0'
1334: AND cz_ps_nodes.ps_node_id = v_component_id;
1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN
1337: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1338: RAISE;
1339: WHEN OTHERS THEN
1340: RAISE;
1341: END;

Line 1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

1619: TYPE tStringArray IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
1620: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1621: TYPE tDateArray IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1622:
1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

Line 1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;

1620: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1621: TYPE tDateArray IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1622:
1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

Line 1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;

1621: TYPE tDateArray IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1622:
1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi

Line 1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920

1622:
1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

Line 1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

1623: TYPE tPsNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

Line 1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

1624: TYPE tItemId IS TABLE OF cz_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

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

1625: TYPE tPersistentId IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY BINARY_INTEGER;
1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

1626: TYPE tPersistentId_idx_vc2 IS TABLE OF cz_ps_nodes.persistent_node_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

Line 1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

1627: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

Line 1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

1628: TYPE tInitialValue IS TABLE OF cz_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

Line 1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;

1629: TYPE tInitNumVal IS TABLE OF cz_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

1630: TYPE tParentId IS TABLE OF cz_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

Line 1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

1631: TYPE tMinimum IS TABLE OF cz_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

1632: TYPE tMaximum IS TABLE OF cz_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

Line 1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;

1633: TYPE tVirtualFlag IS TABLE OF cz_ps_nodes.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920

Line 1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;

1634: TYPE tFeatureType IS TABLE OF cz_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;

Line 1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;

1635: TYPE tName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

1636: TYPE tDescriptionId IS TABLE OF cz_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;
1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920

Line 1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920

1637: TYPE tMinimumSel IS TABLE OF cz_ps_nodes.minimum_selected%TYPE INDEX BY BINARY_INTEGER;
1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;
1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1645:

Line 1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;

1638: TYPE tMaximumSel IS TABLE OF cz_ps_nodes.maximum_selected%TYPE INDEX BY BINARY_INTEGER;
1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;
1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1645:
1646: TYPE tSetEffFrom IS TABLE OF cz_effectivity_sets.effective_from%TYPE INDEX BY BINARY_INTEGER;

Line 1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;

1639: TYPE tBomRequired IS TABLE OF cz_ps_nodes.bom_required_flag%TYPE INDEX BY BINARY_INTEGER;
1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;
1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1645:
1646: TYPE tSetEffFrom IS TABLE OF cz_effectivity_sets.effective_from%TYPE INDEX BY BINARY_INTEGER;
1647: TYPE tSetEffUntil IS TABLE OF cz_effectivity_sets.effective_until%TYPE INDEX BY BINARY_INTEGER;

Line 1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920

1640: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
1641: TYPE tReferenceId_idx_vc2 IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1642: TYPE tUsageMask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
1643: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;
1644: TYPE tDecimalQty_idx_vc2 IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY VARCHAR2(15); --jonatara:int2long:bug6054920
1645:
1646: TYPE tSetEffFrom IS TABLE OF cz_effectivity_sets.effective_from%TYPE INDEX BY BINARY_INTEGER;
1647: TYPE tSetEffUntil IS TABLE OF cz_effectivity_sets.effective_until%TYPE INDEX BY BINARY_INTEGER;
1648: TYPE tSetEffId IS TABLE OF cz_effectivity_sets.effectivity_set_id%TYPE INDEX BY BINARY_INTEGER;

Line 1959: --For reporting purposes store the cz_ps_nodes indexes of the instantiable component

1955: IF(InstantiableIndex < ConnectorIndex)THEN
1956:
1957: --There are D nodes under connectors on the path - this explosion cannot participate
1958: --in any rule because it would be impossible to assign such a rule. No downpath.
1959: --For reporting purposes store the cz_ps_nodes indexes of the instantiable component
1960: --and the connector, corresponding exception/message is CZ_R_UNASSIGNABLE_RULE.
1961:
1962: v_ProhibitInRules(v_NodeId(i)) := glIndexByPsNodeId(v_tPsNodeId(v_NodeIndexPath(InstantiableIndex)));
1963: v_ProhibitConnector(v_NodeId(i)) := glIndexByPsNodeId(v_tReferringId(v_NodeIndexPath(ConnectorIndex)));

Line 2781: FROM cz_ps_nodes

2777: BULK COLLECT INTO ntPsNodeId, ntParentId, ntItemId, ntMinimum, ntMaximum, ntName, ntDescriptionId,
2778: ntMinimumSel, ntMaximumSel, ntPsNodeType, ntInitialValue, ntInitNumVal, -- sselahi
2779: ntVirtualFlag, ntFeatureType, ntBomRequired, ntReferenceId, ntPersistentId,
2780: dtEffFrom, dtEffUntil, vtUsageMask, ntEffSetId, ntDecimalQty
2781: FROM cz_ps_nodes
2782: WHERE deleted_flag = FLAG_NOT_DELETED
2783: START WITH ps_node_id = inComponentId
2784: CONNECT BY
2785: (PRIOR virtual_flag IS NULL OR PRIOR virtual_flag = FLAG_VIRTUAL OR

Line 3050: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;

3046: p_config_rev_nbr IN INTEGER,
3047: p_string1 IN VARCHAR2)
3048: IS
3049:
3050: var_string1 CZ_PS_NODES.bom_sort_order%TYPE;
3051: sequenceNbr PLS_INTEGER := 1;
3052:
3053: BEGIN
3054: FOR i IN (SELECT config_item_id