DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on VARCHAR2_VARRAY

Line 6791: x_org_code_tbl OUT NOCOPY varchar2_varray,

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,

Line 6792: x_org_name_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,

Line 6795: x_item_rev_tbl OUT NOCOPY varchar2_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,

Line 6797: x_item_rev_lbl_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,
6800: x_error_msg OUT NOCOPY VARCHAR2
6801: )

Line 6798: x_item_exists_tbl OUT NOCOPY varchar2_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: )
6802: IS

Line 6821: x_org_code_tbl := new varchar2_varray();

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();

Line 6822: x_org_name_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();

Line 6825: x_item_rev_tbl := new varchar2_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;

Line 6827: x_item_rev_lbl_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;
6830: WHILE l_index IS NOT NULL
6831: LOOP

Line 6828: x_item_exists_tbl := new varchar2_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
6832: x_org_list_tbl.extend();