6787: p_item_id IN NUMBER,
6788: p_structure_name IN VARCHAR2,
6789: p_effectivity_date IN DATE,
6790: x_org_list_tbl OUT NOCOPY num_varray,
6791: x_org_code_tbl OUT NOCOPY varchar2_varray,
6792: x_org_name_tbl OUT NOCOPY varchar2_varray,
6793: x_org_structure_tbl OUT NOCOPY num_varray,
6794: x_assembly_type_tbl OUT NOCOPY num_varray,
6795: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6788: p_structure_name IN VARCHAR2,
6789: p_effectivity_date IN DATE,
6790: x_org_list_tbl OUT NOCOPY num_varray,
6791: x_org_code_tbl OUT NOCOPY varchar2_varray,
6792: x_org_name_tbl OUT NOCOPY varchar2_varray,
6793: x_org_structure_tbl OUT NOCOPY num_varray,
6794: x_assembly_type_tbl OUT NOCOPY num_varray,
6795: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6796: x_item_rev_id_tbl OUT NOCOPY num_varray,
6791: x_org_code_tbl OUT NOCOPY varchar2_varray,
6792: x_org_name_tbl OUT NOCOPY varchar2_varray,
6793: x_org_structure_tbl OUT NOCOPY num_varray,
6794: x_assembly_type_tbl OUT NOCOPY num_varray,
6795: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6796: x_item_rev_id_tbl OUT NOCOPY num_varray,
6797: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6798: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6799: x_return_status OUT NOCOPY VARCHAR2,
6793: x_org_structure_tbl OUT NOCOPY num_varray,
6794: x_assembly_type_tbl OUT NOCOPY num_varray,
6795: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6796: x_item_rev_id_tbl OUT NOCOPY num_varray,
6797: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6798: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6799: x_return_status OUT NOCOPY VARCHAR2,
6800: x_error_msg OUT NOCOPY VARCHAR2
6801: )
6794: x_assembly_type_tbl OUT NOCOPY num_varray,
6795: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6796: x_item_rev_id_tbl OUT NOCOPY num_varray,
6797: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6798: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6799: x_return_status OUT NOCOPY VARCHAR2,
6800: x_error_msg OUT NOCOPY VARCHAR2
6801: )
6802: IS
6817: x_org_code_list => x_org_id_tbl
6818: );
6819: IF x_org_id_tbl.FIRST IS NOT NULL THEN
6820: x_org_list_tbl := new num_varray();
6821: x_org_code_tbl := new varchar2_varray();
6822: x_org_name_tbl := new varchar2_varray();
6823: x_org_structure_tbl := new num_varray();
6824: x_assembly_type_tbl := new num_varray();
6825: x_item_rev_tbl := new varchar2_varray();
6818: );
6819: IF x_org_id_tbl.FIRST IS NOT NULL THEN
6820: x_org_list_tbl := new num_varray();
6821: x_org_code_tbl := new varchar2_varray();
6822: x_org_name_tbl := new varchar2_varray();
6823: x_org_structure_tbl := new num_varray();
6824: x_assembly_type_tbl := new num_varray();
6825: x_item_rev_tbl := new varchar2_varray();
6826: x_item_rev_id_tbl := new num_varray();
6821: x_org_code_tbl := new varchar2_varray();
6822: x_org_name_tbl := new varchar2_varray();
6823: x_org_structure_tbl := new num_varray();
6824: x_assembly_type_tbl := new num_varray();
6825: x_item_rev_tbl := new varchar2_varray();
6826: x_item_rev_id_tbl := new num_varray();
6827: x_item_rev_lbl_tbl := new varchar2_varray();
6828: x_item_exists_tbl := new varchar2_varray();
6829: l_index := x_org_id_tbl.FIRST;
6823: x_org_structure_tbl := new num_varray();
6824: x_assembly_type_tbl := new num_varray();
6825: x_item_rev_tbl := new varchar2_varray();
6826: x_item_rev_id_tbl := new num_varray();
6827: x_item_rev_lbl_tbl := new varchar2_varray();
6828: x_item_exists_tbl := new varchar2_varray();
6829: l_index := x_org_id_tbl.FIRST;
6830: WHILE l_index IS NOT NULL
6831: LOOP
6824: x_assembly_type_tbl := new num_varray();
6825: x_item_rev_tbl := new varchar2_varray();
6826: x_item_rev_id_tbl := new num_varray();
6827: x_item_rev_lbl_tbl := new varchar2_varray();
6828: x_item_exists_tbl := new varchar2_varray();
6829: l_index := x_org_id_tbl.FIRST;
6830: WHILE l_index IS NOT NULL
6831: LOOP
6832: x_org_list_tbl.extend();