DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on INV_EBI_ITEM_ATTR_TBL

Line 3428: x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj,

3424: --
3425: ************************************************************************************/
3426: PROCEDURE get_item_attributes(
3427: p_get_item_inp_obj IN inv_ebi_get_item_input,
3428: x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj,
3429: x_return_status OUT NOCOPY VARCHAR2,
3430: x_msg_count OUT NOCOPY NUMBER,
3431: x_msg_data OUT NOCOPY VARCHAR2
3432: )

Line 3476: l_item_attr_tbl inv_ebi_item_attr_tbl;

3472: l_org_id NUMBER;
3473: l_item_id NUMBER;
3474: l_msg_data VARCHAR2(100);
3475: l_msg_count NUMBER;
3476: l_item_attr_tbl inv_ebi_item_attr_tbl;
3477: l_mfr_part_table inv_ebi_mfg_part_obj_tbl_type;
3478: l_return_status VARCHAR2(1);
3479: l_msg VARCHAR2(100);
3480: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

Line 3493: l_item_attr_tbl := inv_ebi_item_attr_tbl();

3489: FROM mtl_mfg_part_numbers
3490: WHERE inventory_item_id = p_item_id AND organization_id=p_org_id;
3491:
3492: BEGIN
3493: l_item_attr_tbl := inv_ebi_item_attr_tbl();
3494: x_return_status := FND_API.G_RET_STS_SUCCESS;
3495: IF p_get_item_inp_obj.p_config_flags IS NULL THEN
3496: l_getitemoprattrs := FND_API.G_TRUE;
3497: ELSE

Line 4555: x_item_tbl_obj:=inv_ebi_item_attr_tbl_obj(l_item_attr_tbl);

4551: ,x_err_msg => x_msg_data
4552: );
4553: END;
4554: END LOOP;
4555: x_item_tbl_obj:=inv_ebi_item_attr_tbl_obj(l_item_attr_tbl);
4556: EXCEPTION
4557: WHEN OTHERS THEN
4558: x_return_status := FND_API.G_RET_STS_ERROR;
4559: IF (x_msg_data IS NOT NULL) THEN