6691: p_item_id IN NUMBER,
6692: p_structure_name IN VARCHAR2,
6693: p_effectivity_date IN DATE,
6694: x_org_list_tbl OUT NOCOPY num_varray,
6695: x_org_code_tbl OUT NOCOPY varchar2_varray,
6696: x_org_name_tbl OUT NOCOPY varchar2_varray,
6697: x_org_structure_tbl OUT NOCOPY num_varray,
6698: x_assembly_type_tbl OUT NOCOPY num_varray,
6699: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6692: p_structure_name IN VARCHAR2,
6693: p_effectivity_date IN DATE,
6694: x_org_list_tbl OUT NOCOPY num_varray,
6695: x_org_code_tbl OUT NOCOPY varchar2_varray,
6696: x_org_name_tbl OUT NOCOPY varchar2_varray,
6697: x_org_structure_tbl OUT NOCOPY num_varray,
6698: x_assembly_type_tbl OUT NOCOPY num_varray,
6699: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6700: x_item_rev_id_tbl OUT NOCOPY num_varray,
6695: x_org_code_tbl OUT NOCOPY varchar2_varray,
6696: x_org_name_tbl OUT NOCOPY varchar2_varray,
6697: x_org_structure_tbl OUT NOCOPY num_varray,
6698: x_assembly_type_tbl OUT NOCOPY num_varray,
6699: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6700: x_item_rev_id_tbl OUT NOCOPY num_varray,
6701: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6702: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6703: x_return_status OUT NOCOPY VARCHAR2,
6697: x_org_structure_tbl OUT NOCOPY num_varray,
6698: x_assembly_type_tbl OUT NOCOPY num_varray,
6699: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6700: x_item_rev_id_tbl OUT NOCOPY num_varray,
6701: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6702: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6703: x_return_status OUT NOCOPY VARCHAR2,
6704: x_error_msg OUT NOCOPY VARCHAR2
6705: )
6698: x_assembly_type_tbl OUT NOCOPY num_varray,
6699: x_item_rev_tbl OUT NOCOPY varchar2_varray,
6700: x_item_rev_id_tbl OUT NOCOPY num_varray,
6701: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6702: x_item_exists_tbl OUT NOCOPY varchar2_varray,
6703: x_return_status OUT NOCOPY VARCHAR2,
6704: x_error_msg OUT NOCOPY VARCHAR2
6705: )
6706: IS
6721: x_org_code_list => x_org_id_tbl
6722: );
6723: IF x_org_id_tbl.FIRST IS NOT NULL THEN
6724: x_org_list_tbl := new num_varray();
6725: x_org_code_tbl := new varchar2_varray();
6726: x_org_name_tbl := new varchar2_varray();
6727: x_org_structure_tbl := new num_varray();
6728: x_assembly_type_tbl := new num_varray();
6729: x_item_rev_tbl := new varchar2_varray();
6722: );
6723: IF x_org_id_tbl.FIRST IS NOT NULL THEN
6724: x_org_list_tbl := new num_varray();
6725: x_org_code_tbl := new varchar2_varray();
6726: x_org_name_tbl := new varchar2_varray();
6727: x_org_structure_tbl := new num_varray();
6728: x_assembly_type_tbl := new num_varray();
6729: x_item_rev_tbl := new varchar2_varray();
6730: x_item_rev_id_tbl := new num_varray();
6725: x_org_code_tbl := new varchar2_varray();
6726: x_org_name_tbl := new varchar2_varray();
6727: x_org_structure_tbl := new num_varray();
6728: x_assembly_type_tbl := new num_varray();
6729: x_item_rev_tbl := new varchar2_varray();
6730: x_item_rev_id_tbl := new num_varray();
6731: x_item_rev_lbl_tbl := new varchar2_varray();
6732: x_item_exists_tbl := new varchar2_varray();
6733: l_index := x_org_id_tbl.FIRST;
6727: x_org_structure_tbl := new num_varray();
6728: x_assembly_type_tbl := new num_varray();
6729: x_item_rev_tbl := new varchar2_varray();
6730: x_item_rev_id_tbl := new num_varray();
6731: x_item_rev_lbl_tbl := new varchar2_varray();
6732: x_item_exists_tbl := new varchar2_varray();
6733: l_index := x_org_id_tbl.FIRST;
6734: WHILE l_index IS NOT NULL
6735: LOOP
6728: x_assembly_type_tbl := new num_varray();
6729: x_item_rev_tbl := new varchar2_varray();
6730: x_item_rev_id_tbl := new num_varray();
6731: x_item_rev_lbl_tbl := new varchar2_varray();
6732: x_item_exists_tbl := new varchar2_varray();
6733: l_index := x_org_id_tbl.FIRST;
6734: WHILE l_index IS NOT NULL
6735: LOOP
6736: x_org_list_tbl.extend();