2094: x_formula_id OUT NOCOPY NUMBER
2095: ) IS
2096:
2097: /* Defining all local variables */
2098: l_fm_rec_in GMDFMVAL_PUB.formula_info_in;
2099: l_fm_tab_out GMDFMVAL_PUB.formula_table_out;
2100: l_return_status VARCHAR2(1);
2101: BEGIN
2102: /* Initialize return status */
2095: ) IS
2096:
2097: /* Defining all local variables */
2098: l_fm_rec_in GMDFMVAL_PUB.formula_info_in;
2099: l_fm_tab_out GMDFMVAL_PUB.formula_table_out;
2100: l_return_status VARCHAR2(1);
2101: BEGIN
2102: /* Initialize return status */
2103: x_return_status := FND_API.G_RET_STS_SUCCESS;
2110: l_fm_rec_in.formula_no := p_formula_no;
2111: l_fm_rec_in.formula_vers := p_formula_vers;
2112: l_fm_rec_in.formula_id := p_formula_id;
2113:
2114: GMDFMVAL_PUB.get_element(pElement_name => 'FORMULA',
2115: pRecord_in => l_fm_rec_in,
2116: xTable_out => l_fm_tab_out,
2117: xReturn => l_return_status);
2118: IF (l_return_status <> FND_API.g_ret_sts_success) THEN