APPS.GMD_FORMULA_DESIGNER_PKG dependencies on FM_FORM_MST_B

Line 91: l_fm_orgn_id fm_form_mst_b.owner_organization_id%TYPE;

87: l_status VARCHAR2(30);
88:
89: --3344335
90: l_formula_access VARCHAR2(1);
91: l_fm_orgn_id fm_form_mst_b.owner_organization_id%TYPE;
92:
93: --Get's the organization code of the formula.
94: CURSOR get_formula_orgn_code(vFormula_id NUMBER) IS
95: SELECT owner_organization_id

Line 96: FROM fm_form_mst_b

92:
93: --Get's the organization code of the formula.
94: CURSOR get_formula_orgn_code(vFormula_id NUMBER) IS
95: SELECT owner_organization_id
96: FROM fm_form_mst_b
97: WHERE formula_id = vFormula_id;
98:
99: BEGIN
100:

Line 364: FM_FORM_MST_B

360: IF l_rec.formula_no <> p_formula_no OR
361: l_rec.formula_vers <> p_formula_vers THEN
362:
363: UPDATE
364: FM_FORM_MST_B
365: SET
366: formula_no = p_formula_no,
367: formula_vers = p_formula_vers
368: WHERE

Line 2056: FROM fm_form_mst_b

2052:
2053:
2054: CURSOR get_orgn_id (l_formula_id NUMBER) IS
2055: SELECT owner_organization_id
2056: FROM fm_form_mst_b
2057: WHERE formula_id = l_formula_id;
2058:
2059: BEGIN
2060:

Line 2308: FROM fm_form_mst_b

2304: x_return_code OUT NOCOPY VARCHAR2) IS
2305:
2306: CURSOR Cur_get_orgn IS
2307: SELECT owner_organization_id
2308: FROM fm_form_mst_b
2309: WHERE formula_id = p_formula_id;
2310: --KSHUKLA changed the l_orgn_id data type from NUMBER(4) to Number
2311: l_orgn_id NUMBER;
2312: