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 ,
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 ,
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 ,
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,
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
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: );
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,