DBA Data[Home] [Help]

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_FORM_MST_B

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 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