DBA Data[Home] [Help]

APPS.GMD_FORMULA_DETAIL_PUB dependencies on FND_USER

Line 76: l_user_id fnd_user.user_id%TYPE := 0;

72: IS
73: /* Local Variables definitions */
74: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULADETAIL';
75: l_api_version CONSTANT NUMBER := 1.0;
76: l_user_id fnd_user.user_id%TYPE := 0;
77: l_return_val NUMBER := 0;
78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;

Line 585: l_user_id fnd_user.user_id%TYPE := 0;

581: IS
582: /* Local Variables definitions */
583: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULADETAIL';
584: l_api_version CONSTANT NUMBER := 2.0;
585: l_user_id fnd_user.user_id%TYPE := 0;
586: l_return_val NUMBER := 0;
587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;

Line 1577: l_user_id fnd_user.user_id%TYPE := 0;

1573: IS
1574: /* Local Variables definitions */
1575: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMULADETAIL';
1576: l_api_version CONSTANT NUMBER := 1.1;
1577: l_user_id fnd_user.user_id%TYPE := 0;
1578: l_return_val NUMBER := 0;
1579: l_item_id ic_item_mst.item_id%TYPE := 0;
1580: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1581: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;