DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on VARCHAR2_VARRAY

Line 6695: x_org_code_tbl OUT NOCOPY varchar2_varray,

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,

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

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

Line 6701: x_item_rev_lbl_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,
6704: x_error_msg OUT NOCOPY VARCHAR2
6705: )

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

Line 6725: x_org_code_tbl := new varchar2_varray();

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

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

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

Line 6731: x_item_rev_lbl_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;
6734: WHILE l_index IS NOT NULL
6735: LOOP

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