APPS.GMD_FORMULA_PUB dependencies on IC_ITEM_MST

Line 112: l_item_id ic_item_mst.item_id%TYPE := 0;

108: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULA';
109: l_api_version CONSTANT NUMBER := 1.0;
110: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
111: l_return_val NUMBER := 0;
112: l_item_id ic_item_mst.item_id%TYPE := 0;
113: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
114: l_formula_id fm_form_mst.formula_id%TYPE := 0;
115: l_surrogate fm_form_mst.formula_id%TYPE := 0;
116: l_header_exists_flag VARCHAR2(1) ;

Line 113: l_inv_uom ic_item_mst.item_um%TYPE := NULL;

109: l_api_version CONSTANT NUMBER := 1.0;
110: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
111: l_return_val NUMBER := 0;
112: l_item_id ic_item_mst.item_id%TYPE := 0;
113: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
114: l_formula_id fm_form_mst.formula_id%TYPE := 0;
115: l_surrogate fm_form_mst.formula_id%TYPE := 0;
116: l_header_exists_flag VARCHAR2(1) ;
117: l_orgn_code VARCHAR2(4) ;

Line 946: l_item_id ic_item_mst.item_id%TYPE := 0;

942: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAHEADER';
943: l_api_version CONSTANT NUMBER := 2.0;
944: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
945: l_return_val NUMBER := 0;
946: l_item_id ic_item_mst.item_id%TYPE := 0;
947: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
948: l_formula_id fm_form_mst.formula_id%TYPE := 0;
949:
950: l_return_status VARCHAR2(1);

Line 947: l_inv_uom ic_item_mst.item_um%TYPE := NULL;

943: l_api_version CONSTANT NUMBER := 2.0;
944: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
945: l_return_val NUMBER := 0;
946: l_item_id ic_item_mst.item_id%TYPE := 0;
947: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
948: l_formula_id fm_form_mst.formula_id%TYPE := 0;
949:
950: l_return_status VARCHAR2(1);
951: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

Line 1770: l_item_id ic_item_mst.item_id%TYPE := 0;

1766: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMULAHEADER';
1767: l_api_version CONSTANT NUMBER := 1.0;
1768: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1769: l_return_val NUMBER := 0;
1770: l_item_id ic_item_mst.item_id%TYPE := 0;
1771: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1772: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1773:
1774: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

Line 1771: l_inv_uom ic_item_mst.item_um%TYPE := NULL;

1767: l_api_version CONSTANT NUMBER := 1.0;
1768: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1769: l_return_val NUMBER := 0;
1770: l_item_id ic_item_mst.item_id%TYPE := 0;
1771: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1772: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1773:
1774: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1775: l_return_status VARCHAR2(1);