[Home] [Help]
3249: PROCEDURE process_part_num_association(
3250: p_commit IN VARCHAR2 := fnd_api.g_false
3251: ,p_organization_id IN NUMBER
3252: ,p_inventory_item_id IN NUMBER
3253: ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
3254: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3255: )
3256: IS
3257: l_count NUMBER := 0;
4002: l_item_number VARCHAR2(2000);
4003: l_output_status inv_ebi_output_status;
4004: l_category_output inv_ebi_category_output_obj;
4005:
4006: l_mfg_part_num_obj inv_ebi_manufacturer_part_obj;
4007: l_master_org_id NUMBER;
4008: l_manufacturer_count NUMBER := 0;
4009: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
4010: l_operating_unit VARCHAR2(240);
4962: l_item_invoice_obj inv_ebi_item_invoice_obj;
4963: l_item_web_opiton inv_ebi_item_web_option_obj;
4964: l_item_asset_obj inv_ebi_item_asset_obj;
4965: l_item_process_obj inv_ebi_item_processmfg_obj;
4966: l_item_mfr_part_obj inv_ebi_manufacturer_part_obj;
4967: l_item_core_obj inv_ebi_item_main_obj;
4968: l_item_custom_obj inv_ebi_item_custom_obj;
4969: l_uda_obj inv_ebi_uda_input_obj;
4970: l_item_obj inv_ebi_item_obj;
5801: END IF;
5802: ctr := 1;
5803: FOR c IN c_mfr_part_cursor(l_item_id,l_org_id)
5804: LOOP
5805: l_item_mfr_part_obj := inv_ebi_manufacturer_part_obj(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
5806: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
5807: l_mfr_part_table.extend();
5808: l_item_mfr_part_obj.manufacturer_id := c.manufacturer_id;
5809: l_item_mfr_part_obj.mfg_part_num := c.mfg_part_num;