APPS.GMD_FORMULA_PUB dependencies on IC_ITEM_MST

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

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

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

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

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

1010: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAHEADER';
1011: l_api_version CONSTANT NUMBER := 2.0;
1012: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1013: l_return_val NUMBER := 0;
1014: l_item_id ic_item_mst.item_id%TYPE := 0;
1015: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1016: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1017:
1018: l_return_status VARCHAR2(1);

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

1011: l_api_version CONSTANT NUMBER := 2.0;
1012: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1013: l_return_val NUMBER := 0;
1014: l_item_id ic_item_mst.item_id%TYPE := 0;
1015: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1016: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1017:
1018: l_return_status VARCHAR2(1);
1019: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

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

1841: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMULAHEADER';
1842: l_api_version CONSTANT NUMBER := 1.0;
1843: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1844: l_return_val NUMBER := 0;
1845: l_item_id ic_item_mst.item_id%TYPE := 0;
1846: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1847: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1848:
1849: l_fm_form_mst_rec fm_form_mst%ROWTYPE;

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

1842: l_api_version CONSTANT NUMBER := 1.0;
1843: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.user_id; -- Bug 4603060
1844: l_return_val NUMBER := 0;
1845: l_item_id ic_item_mst.item_id%TYPE := 0;
1846: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1847: l_formula_id fm_form_mst.formula_id%TYPE := 0;
1848:
1849: l_fm_form_mst_rec fm_form_mst%ROWTYPE;
1850: l_return_status VARCHAR2(1);