DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on NUM_VARRAY

Line 658: l_copied_comp_seq num_varray := num_varray

654: l_count2 NUMBER;
655: l_count3 NUMBER;
656: l_comp_ctr NUMBER;
657: /*
658: l_copied_comp_seq num_varray := num_varray
659: ();
660: l_copied_comp_item_id num_varray := num_varray
661: ();
662: l_copied_op_seq_num num_varray := num_varray

Line 660: l_copied_comp_item_id num_varray := num_varray

656: l_comp_ctr NUMBER;
657: /*
658: l_copied_comp_seq num_varray := num_varray
659: ();
660: l_copied_comp_item_id num_varray := num_varray
661: ();
662: l_copied_op_seq_num num_varray := num_varray
663: ();
664: l_mapped_comp_seq num_varray := num_varray

Line 662: l_copied_op_seq_num num_varray := num_varray

658: l_copied_comp_seq num_varray := num_varray
659: ();
660: l_copied_comp_item_id num_varray := num_varray
661: ();
662: l_copied_op_seq_num num_varray := num_varray
663: ();
664: l_mapped_comp_seq num_varray := num_varray
665: ();
666: */

Line 664: l_mapped_comp_seq num_varray := num_varray

660: l_copied_comp_item_id num_varray := num_varray
661: ();
662: l_copied_op_seq_num num_varray := num_varray
663: ();
664: l_mapped_comp_seq num_varray := num_varray
665: ();
666: */
667: -- l_from_end_item_minor_rev_code VARCHAR2(30);
668: -- l_from_bom_item_minor_rev_code VARCHAR2 (30);

Line 684: copy_rfds_arr num_varray := num_varray

680: -- l_to_end_item_min_revision_id NUMBER;
681: ---- Bug Fix 4279959 Install testing issue
682: /*
683: ();
684: copy_rfds_arr num_varray := num_varray
685: ();
686: copy_subcomps_arr num_varray := num_varray
687: ();
688: */

Line 686: copy_subcomps_arr num_varray := num_varray

682: /*
683: ();
684: copy_rfds_arr num_varray := num_varray
685: ();
686: copy_subcomps_arr num_varray := num_varray
687: ();
688: */
689: l_from_comps num_varray := num_varray
690: ();

Line 689: l_from_comps num_varray := num_varray

685: ();
686: copy_subcomps_arr num_varray := num_varray
687: ();
688: */
689: l_from_comps num_varray := num_varray
690: ();
691: l_to_comps num_varray := num_varray
692: ();
693: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';

Line 691: l_to_comps num_varray := num_varray

687: ();
688: */
689: l_from_comps num_varray := num_varray
690: ();
691: l_to_comps num_varray := num_varray
692: ();
693: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
694: l_data_level_id_comp NUMBER;
695: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 6790: x_org_list_tbl OUT NOCOPY num_varray,

6786: p_org_id IN NUMBER,
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,

Line 6793: x_org_structure_tbl OUT NOCOPY num_varray,

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,
6797: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,

Line 6794: x_assembly_type_tbl OUT NOCOPY num_varray,

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,
6797: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6798: x_item_exists_tbl OUT NOCOPY varchar2_varray,

Line 6796: x_item_rev_id_tbl OUT NOCOPY num_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,
6800: x_error_msg OUT NOCOPY VARCHAR2

Line 6820: x_org_list_tbl := new num_varray();

6816: p_org_hier_level_id => p_org_id,
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();

Line 6823: x_org_structure_tbl := new num_varray();

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();
6827: x_item_rev_lbl_tbl := new varchar2_varray();

Line 6824: x_assembly_type_tbl := new num_varray();

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();
6827: x_item_rev_lbl_tbl := new varchar2_varray();
6828: x_item_exists_tbl := new varchar2_varray();

Line 6826: x_item_rev_id_tbl := new num_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;
6830: WHILE l_index IS NOT NULL

Line 7315: l_from_comps num_varray := num_varray();

7311: l_no_access_comp_cnt NUMBER;
7312: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7313: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7314: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
7315: l_from_comps num_varray := num_varray();
7316: l_to_comps num_varray := num_varray();
7317: l_last_copied_comp_seq_id NUMBER := -1;
7318: l_default_wip_params NUMBER;
7319: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';

Line 7316: l_to_comps num_varray := num_varray();

7312: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7313: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7314: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
7315: l_from_comps num_varray := num_varray();
7316: l_to_comps num_varray := num_varray();
7317: l_last_copied_comp_seq_id NUMBER := -1;
7318: l_default_wip_params NUMBER;
7319: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
7320: l_data_level_id_comp NUMBER;