APPS.GMD_FORMULA_HEADER_PVT dependencies on FM_FORM_MST

Line 35: ,p_formula_header_rec IN FM_FORM_MST%ROWTYPE

31: ,p_commit IN VARCHAR2
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER
34: ,x_msg_data OUT NOCOPY VARCHAR2
35: ,p_formula_header_rec IN FM_FORM_MST%ROWTYPE
36: )
37: IS
38: /* Local Variables definitions */
39: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULAHEADER';

Line 77: /* fm_form_mst and vl table. However at a later time fm_form_mst will */

73: /* New changes to include MLS */
74: /* This package inserts into the and table. */
75: /* is a view of the <_b> and <_tl> table. */
76: /* currently we have no relationship between the */
77: /* fm_form_mst and vl table. However at a later time fm_form_mst will */
78: /* be a compatible synonym of this view. */
79:
80: IF (l_debug = 'Y') THEN
81: gmd_debug.put_line(' ');

Line 89: FM_FORM_MST_MLS.INSERT_ROW(

85: gmd_debug.put_line(' In formula header Pvt - About to insert fm id = '
86: ||p_formula_header_rec.formula_id);
87: END IF;
88:
89: FM_FORM_MST_MLS.INSERT_ROW(
90: X_ROWID => formula_rowid,
91: X_FORMULA_ID => p_formula_header_rec.formula_id,
92: X_MASTER_FORMULA_ID => p_formula_header_rec.master_formula_id,
93: X_OWNER_ORGANIZATION_ID => p_formula_header_rec.owner_organization_id,

Line 211: ,p_formula_header_rec IN fm_form_mst%ROWTYPE

207: ,p_commit IN VARCHAR2
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2
211: ,p_formula_header_rec IN fm_form_mst%ROWTYPE
212: )
213: IS
214: /* Local Variables definitions */
215: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAHEADER';

Line 217: l_scale_type fm_form_mst.scale_type%TYPE;

213: IS
214: /* Local Variables definitions */
215: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAHEADER';
216: l_api_version CONSTANT NUMBER := 1.0;
217: l_scale_type fm_form_mst.scale_type%TYPE;
218: l_formula_desc1 fm_form_mst.formula_desc1%TYPE;
219: l_return_val NUMBER := 0 ;
220:
221: X_msg_cnt NUMBER;

Line 218: l_formula_desc1 fm_form_mst.formula_desc1%TYPE;

214: /* Local Variables definitions */
215: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAHEADER';
216: l_api_version CONSTANT NUMBER := 1.0;
217: l_scale_type fm_form_mst.scale_type%TYPE;
218: l_formula_desc1 fm_form_mst.formula_desc1%TYPE;
219: l_return_val NUMBER := 0 ;
220:
221: X_msg_cnt NUMBER;
222: X_msg_dat VARCHAR2(100);

Line 252: gmd_debug.put_line(' In Formula Header Pvt - Before updating fm_form_mst table '

248:
249: /* Call the Update_row procedure for mls */
250: /* To modify to call the approp variables */
251: IF (l_debug = 'Y') THEN
252: gmd_debug.put_line(' In Formula Header Pvt - Before updating fm_form_mst table '
253: ||p_formula_header_rec.formula_id);
254: END IF;
255: FM_FORM_MST_MLS.UPDATE_ROW(
256: X_FORMULA_ID => p_formula_header_rec.formula_id,

Line 255: FM_FORM_MST_MLS.UPDATE_ROW(

251: IF (l_debug = 'Y') THEN
252: gmd_debug.put_line(' In Formula Header Pvt - Before updating fm_form_mst table '
253: ||p_formula_header_rec.formula_id);
254: END IF;
255: FM_FORM_MST_MLS.UPDATE_ROW(
256: X_FORMULA_ID => p_formula_header_rec.formula_id,
257: X_OWNER_ORGANIZATION_ID => p_formula_header_rec.owner_organization_id,
258: X_TEXT_CODE => p_formula_header_rec.text_code,
259: X_DELETE_MARK => p_formula_header_rec.delete_mark,

Line 315: gmd_debug.put_line(' In Formula Header Pvt - After updating fm_form_mst table ');

311: X_AUTO_PRODUCT_CALC => p_formula_header_rec.auto_product_calc);
312:
313: /* End API body */
314: IF (l_debug = 'Y') THEN
315: gmd_debug.put_line(' In Formula Header Pvt - After updating fm_form_mst table ');
316: END IF;
317:
318: /* Check if p_commit is set to TRUE */
319: IF FND_API.To_Boolean( p_commit ) THEN