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 751: from fm_form_mst h, fm_matl_dtl d

747: /* Cursor that returns multiple formulas for */
748: /* an item. */
749: CURSOR get_fmitem_cur(pitem_id IN NUMBER) IS
750: select h.formula_no, h.formula_vers, h.formula_id
751: from fm_form_mst h, fm_matl_dtl d
752: where d.inventory_item_id = pitem_id
753: AND h.formula_id = d.formula_id;
754:
755: /* Cursor that returns formulaline_ids for a formula */

Line 764: from fm_form_mst

760:
761: /* Cursor that formula_no and version for a formula_id */
762: CURSOR get_formula_no(pformula_id IN NUMBER) IS
763: select formula_no, formula_vers
764: from fm_form_mst
765: where formula_id = pformula_id;
766:
767: /* Cursor that gets formula_id when formula_no and vers */
768: /* is passed. */

Line 771: from fm_form_mst

767: /* Cursor that gets formula_id when formula_no and vers */
768: /* is passed. */
769: CURSOR get_formula_id IS
770: select formula_id
771: from fm_form_mst
772: where formula_no = UPPER(pRecord_in.formula_no)
773: and formula_vers = pRecord_in.formula_vers;
774:
775: /* Cursor that returns user info */

Line 894: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,

890:
891: PROCEDURE get_element(pElement_name IN VARCHAR2,
892: pRecord_in IN formula_info_in,
893: pDate IN DATE Default Null, --Bug 4479101
894: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,
895: xFormulaDetail_tbl OUT NOCOPY formula_detail_tbl,
896: xReturn OUT NOCOPY VARCHAR2) IS
897:
898: l_formula_id NUMBER;

Line 931: from fm_form_mst

927: get_substitute_items(pFormula_id => l_formula_id,
928: pDate => pDate,
929: xFormulaDetail_tbl => xFormulaDetail_tbl);
930: FOR formula_rec IN (select *
931: from fm_form_mst
932: where formula_id = l_formula_id) LOOP
933: xFormulaHeader_rec := formula_rec;
934: END LOOP;
935: ELSE

Line 2293: from fm_form_mst

2289: -- Find out the formula owner organization and narrow down the query
2290: -- perf
2291: select owner_organization_id
2292: into l_orgid
2293: from fm_form_mst
2294: where formula_id = V_formula_id;
2295: -- Cursor Call need to change inorder to take into account
2296: -- the formula owner org id
2297: