DBA Data[Home] [Help]

APPS.GMDFMVAL_PUB dependencies on FM_FORM_MST

Line 8: formula_no fm_form_mst.formula_no%TYPE ,

4: /* Type Definition */
5: /* =============== */
6: TYPE formula_info_in IS RECORD
7: (
8: formula_no fm_form_mst.formula_no%TYPE ,
9: formula_vers fm_form_mst.formula_vers%TYPE ,
10: formula_id fm_form_mst.formula_id%TYPE ,
11: recipe_no gmd_recipes.recipe_no%TYPE ,
12: recipe_version gmd_recipes.recipe_version%TYPE ,

Line 9: formula_vers fm_form_mst.formula_vers%TYPE ,

5: /* =============== */
6: TYPE formula_info_in IS RECORD
7: (
8: formula_no fm_form_mst.formula_no%TYPE ,
9: formula_vers fm_form_mst.formula_vers%TYPE ,
10: formula_id fm_form_mst.formula_id%TYPE ,
11: recipe_no gmd_recipes.recipe_no%TYPE ,
12: recipe_version gmd_recipes.recipe_version%TYPE ,
13: recipe_id gmd_recipes.recipe_id%TYPE ,

Line 10: formula_id fm_form_mst.formula_id%TYPE ,

6: TYPE formula_info_in IS RECORD
7: (
8: formula_no fm_form_mst.formula_no%TYPE ,
9: formula_vers fm_form_mst.formula_vers%TYPE ,
10: formula_id fm_form_mst.formula_id%TYPE ,
11: recipe_no gmd_recipes.recipe_no%TYPE ,
12: recipe_version gmd_recipes.recipe_version%TYPE ,
13: recipe_id gmd_recipes.recipe_id%TYPE ,
14: user_name fnd_user.user_name%TYPE ,

Line 20: formula_no fm_form_mst.formula_no%TYPE ,

16: );
17:
18: TYPE formula_info_out IS RECORD
19: (
20: formula_no fm_form_mst.formula_no%TYPE ,
21: formula_vers fm_form_mst.formula_vers%TYPE ,
22: formula_id fm_form_mst.formula_id%TYPE ,
23: formulaline_id fm_matl_dtl.formulaline_id%TYPE ,
24: recipe_id gmd_recipes.recipe_id%TYPE,

Line 21: formula_vers fm_form_mst.formula_vers%TYPE ,

17:
18: TYPE formula_info_out IS RECORD
19: (
20: formula_no fm_form_mst.formula_no%TYPE ,
21: formula_vers fm_form_mst.formula_vers%TYPE ,
22: formula_id fm_form_mst.formula_id%TYPE ,
23: formulaline_id fm_matl_dtl.formulaline_id%TYPE ,
24: recipe_id gmd_recipes.recipe_id%TYPE,
25: user_id fnd_user.user_id%TYPE

Line 22: formula_id fm_form_mst.formula_id%TYPE ,

18: TYPE formula_info_out IS RECORD
19: (
20: formula_no fm_form_mst.formula_no%TYPE ,
21: formula_vers fm_form_mst.formula_vers%TYPE ,
22: formula_id fm_form_mst.formula_id%TYPE ,
23: formulaline_id fm_matl_dtl.formulaline_id%TYPE ,
24: recipe_id gmd_recipes.recipe_id%TYPE,
25: user_id fnd_user.user_id%TYPE
26: );

Line 81: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,

77:
78: PROCEDURE get_element( pElement_name IN VARCHAR2,
79: pRecord_in IN formula_info_in,
80: pDate IN DATE DEFAULT Null, --Bug 4479101
81: xFormulaHeader_rec OUT NOCOPY fm_form_mst%ROWTYPE,
82: xFormulaDetail_tbl OUT NOCOPY formula_detail_tbl,
83: xReturn OUT NOCOPY VARCHAR2);
84: /** Added the following 4 procedures for Item Substitution, bug 4479101 */
85: PROCEDURE get_substitute_items(pFormula_id in NUMBER,