564: -- p_item_id IN NUMBER Required
565: -- Target structure's item
566: -- p_structure_name IN NUMBER Required
567: -- Target structure's structure name
568: -- OUT : x_org_list_tbl OUT NUM_VARRAY
569: -- List of organization Ids
570: -- x_org_code_tbl OUT VARCHAR2_VARRAY
571: -- List of organization codes
572: -- x_org_name_tbl OUT VARCHAR2_VARRAY
570: -- x_org_code_tbl OUT VARCHAR2_VARRAY
571: -- List of organization codes
572: -- x_org_name_tbl OUT VARCHAR2_VARRAY
573: -- List of organization names
574: -- x_assembly_type_tbl OUT NUM_VARRAY
575: -- List of assembly types for corresponding orgs
576: -- x_item_rev_tbl OUT VARCHAR2_VARRAY
577: -- List of item revisions in the corresponding orgs
578: -- x_item_rev_id_tbl OUT NUM_VARRAY
574: -- x_assembly_type_tbl OUT NUM_VARRAY
575: -- List of assembly types for corresponding orgs
576: -- x_item_rev_tbl OUT VARCHAR2_VARRAY
577: -- List of item revisions in the corresponding orgs
578: -- x_item_rev_id_tbl OUT NUM_VARRAY
579: -- List of item revision ids in the corresponding orgs
580: -- x_item_rev_lbl_tbl OUT VARCHAR2_VARRAY
581: -- List of item revision labels in the corresponding orgs
582: -- x_item_exists_tbl OUT VARCHAR2_ARRAY
587: p_org_id IN NUMBER,
588: p_item_id IN NUMBER,
589: p_structure_name IN VARCHAR2,
590: p_effectivity_date IN DATE,
591: x_org_list_tbl OUT NOCOPY num_varray,
592: x_org_code_tbl OUT NOCOPY varchar2_varray,
593: x_org_name_tbl OUT NOCOPY varchar2_varray,
594: x_org_structure_tbl OUT NOCOPY num_varray,
595: x_assembly_type_tbl OUT NOCOPY num_varray,
590: p_effectivity_date IN DATE,
591: x_org_list_tbl OUT NOCOPY num_varray,
592: x_org_code_tbl OUT NOCOPY varchar2_varray,
593: x_org_name_tbl OUT NOCOPY varchar2_varray,
594: x_org_structure_tbl OUT NOCOPY num_varray,
595: x_assembly_type_tbl OUT NOCOPY num_varray,
596: x_item_rev_tbl OUT NOCOPY varchar2_varray,
597: x_item_rev_id_tbl OUT NOCOPY num_varray,
598: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
591: x_org_list_tbl OUT NOCOPY num_varray,
592: x_org_code_tbl OUT NOCOPY varchar2_varray,
593: x_org_name_tbl OUT NOCOPY varchar2_varray,
594: x_org_structure_tbl OUT NOCOPY num_varray,
595: x_assembly_type_tbl OUT NOCOPY num_varray,
596: x_item_rev_tbl OUT NOCOPY varchar2_varray,
597: x_item_rev_id_tbl OUT NOCOPY num_varray,
598: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
599: x_item_exists_tbl OUT NOCOPY varchar2_varray,
593: x_org_name_tbl OUT NOCOPY varchar2_varray,
594: x_org_structure_tbl OUT NOCOPY num_varray,
595: x_assembly_type_tbl OUT NOCOPY num_varray,
596: x_item_rev_tbl OUT NOCOPY varchar2_varray,
597: x_item_rev_id_tbl OUT NOCOPY num_varray,
598: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
599: x_item_exists_tbl OUT NOCOPY varchar2_varray,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_error_msg OUT NOCOPY VARCHAR2