APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_FORM_MST

Line 2091: delete from FM_FORM_MST_B where FORMULA_ID = -1;

2087: X_LAST_UPDATE_LOGIN => l_login_id);
2088: */
2089: -- KSHUKLA added the following
2090: -- As per as bug 3843246
2091: delete from FM_FORM_MST_B where FORMULA_ID = -1;
2092:
2093: insert into
2094: FM_FORM_MST_B(FORMULA_ID,
2095: OWNER_ORGANIZATION_ID,

Line 2094: FM_FORM_MST_B(FORMULA_ID,

2090: -- As per as bug 3843246
2091: delete from FM_FORM_MST_B where FORMULA_ID = -1;
2092:
2093: insert into
2094: FM_FORM_MST_B(FORMULA_ID,
2095: OWNER_ORGANIZATION_ID,
2096: DELETE_MARK,
2097: FORMULA_STATUS,
2098: OWNER_ID,

Line 3265: FROM fm_form_mst

3261: WHERE recipe_id = p_copy_from_recipe_id;
3262:
3263: CURSOR Cur_get_frm_hdr IS
3264: SELECT *
3265: FROM fm_form_mst
3266: WHERE formula_id = p_copy_from_formula_id;
3267:
3268: CURSOR Cur_get_frm_dtl IS
3269: SELECT *

Line 3756: l_table_lnk := 'fm_form_mst' || '|' || x_formula_id;

3752:
3753: FOR i IN 1..l_frm_hdr_text_tbl.COUNT LOOP
3754:
3755: l_txt_ind := l_txt_ind + 1;
3756: l_table_lnk := 'fm_form_mst' || '|' || x_formula_id;
3757:
3758: ---
3759: --- Create formula header text
3760: ---

Line 5535: l_owner_organization_id fm_form_mst_b.owner_organization_id%TYPE;

5531: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
5532:
5533: /* Local variable section */
5534: l_entity_status gmd_api_grp.status_rec_type;
5535: l_owner_organization_id fm_form_mst_b.owner_organization_id%TYPE;
5536:
5537: default_status_err EXCEPTION;
5538:
5539: CURSOR get_formula_details(vFormula_id NUMBER) IS

Line 5541: FROM fm_form_mst_b

5537: default_status_err EXCEPTION;
5538:
5539: CURSOR get_formula_details(vFormula_id NUMBER) IS
5540: SELECT owner_organization_id
5541: FROM fm_form_mst_b
5542: WHERE formula_id = vFormula_id;
5543:
5544: CURSOR get_recipe_details(vRecipe_id NUMBER) IS
5545: SELECT owner_organization_id