APPS.GMDFMVAL_PUB dependencies on FM_FORM_MST

Line 38: l_formula_id fm_form_mst.formula_id%TYPE := 0;

34: xreturn_code OUT NOCOPY NUMBER) IS
35:
36: /* Local variables. */
37: /* ================ */
38: l_formula_id fm_form_mst.formula_id%TYPE := 0;
39:
40: /* Cursor Definitions. */
41: /* =================== */
42: CURSOR get_id IS

Line 44: FROM fm_form_mst

40: /* Cursor Definitions. */
41: /* =================== */
42: CURSOR get_id IS
43: SELECT formula_id
44: FROM fm_form_mst
45: WHERE formula_no = UPPER(pformula_no)
46: AND formula_vers = pversion;
47:
48: /* ================================================ */

Line 761: from fm_form_mst h,

757: /* Cursor that returns multiple formulas for */
758: /* an item. */
759: CURSOR get_fmitem_cur(pitem_id IN NUMBER) IS
760: select h.formula_no, h.formula_vers, h.formula_id
761: from fm_form_mst h,
762: fm_matl_dtl d
763: where d.inventory_item_id = pitem_id AND
764: h.formula_id = d.formula_id;
765:

Line 775: from fm_form_mst

771:
772: /* Cursor that formula_no and version for a formula_id */
773: CURSOR get_formula_no(pformula_id IN NUMBER) IS
774: select formula_no, formula_vers
775: from fm_form_mst
776: where formula_id = pformula_id;
777:
778: /* Cursor that gets formula_id when formula_no and vers */
779: /* is passed. */

Line 782: from fm_form_mst

778: /* Cursor that gets formula_id when formula_no and vers */
779: /* is passed. */
780: CURSOR get_formula_id IS
781: select formula_id
782: from fm_form_mst
783: where formula_no = UPPER(pRecord_in.formula_no)
784: and formula_vers = pRecord_in.formula_vers;
785:
786: /* Cursor that returns user info */

Line 910: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,

906:
907: PROCEDURE get_element(pElement_name IN VARCHAR2,
908: pRecord_in IN formula_info_in,
909: pDate IN DATE Default Null, --Bug 4479101
910: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,
911: xFormulaDetail_tbl OUT NOCOPY formula_detail_tbl,
912: xReturn OUT NOCOPY VARCHAR2) IS
913:
914: l_formula_id NUMBER;

Line 945: FOR formula_rec IN (select * from fm_form_mst where formula_id = l_formula_id) LOOP

941: -- Call substitute item codeset, Bug 4479101
942: get_substitute_items(pFormula_id => l_formula_id,
943: pDate => pDate,
944: xFormulaDetail_tbl => xFormulaDetail_tbl);
945: FOR formula_rec IN (select * from fm_form_mst where formula_id = l_formula_id) LOOP
946: xFormulaHeader_rec := formula_rec;
947: END LOOP;
948: ELSE
949: xReturn := 'E';

Line 2132: from fm_form_mst

2128: -- Find out the formula owner organization and narrow down the query
2129: -- perf
2130: select owner_organization_id
2131: into l_orgid
2132: from fm_form_mst
2133: where formula_id=V_formula_id;
2134: -- Cursor Call need to change inorder to take into account
2135: -- the formula owner org id
2136: