eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

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:
694:
695: CURSOR l_common_csr

Line 6694: x_org_list_tbl OUT NOCOPY num_varray,

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

Line 6697: x_org_structure_tbl OUT NOCOPY num_varray,

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

Line 6698: x_assembly_type_tbl OUT NOCOPY num_varray,

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,
6701: x_item_rev_lbl_tbl OUT NOCOPY varchar2_varray,
6702: x_item_exists_tbl OUT NOCOPY varchar2_varray,

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

Line 6724: x_org_list_tbl := new num_varray();

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

Line 6727: x_org_structure_tbl := new num_varray();

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

Line 6728: x_assembly_type_tbl := new num_varray();

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

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

Line 7219: l_from_comps num_varray := num_varray();

7215: l_no_access_comp_cnt NUMBER;
7216: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7217: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7218: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
7219: l_from_comps num_varray := num_varray();
7220: l_to_comps num_varray := num_varray();
7221: l_last_copied_comp_seq_id NUMBER := -1;
7222: l_default_wip_params NUMBER;
7223:

Line 7220: l_to_comps num_varray := num_varray();

7216: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7217: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7218: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
7219: l_from_comps num_varray := num_varray();
7220: l_to_comps num_varray := num_varray();
7221: l_last_copied_comp_seq_id NUMBER := -1;
7222: l_default_wip_params NUMBER;
7223:
7224: