APPS.GMD_FORMULA_DETAIL_PUB dependencies on FM_FORM_MST_B

Line 33: FOR C_status_code IN (Select formula_status from fm_form_mst_b

29:
30: l_status_meaning GMD_STATUS.meaning%TYPE;
31:
32: BEGIN
33: FOR C_status_code IN (Select formula_status from fm_form_mst_b
34: where formula_id = vFormula_id) LOOP
35: OPEN get_status_meaning(C_status_code.formula_status);
36: FETCH get_status_meaning INTO l_status_meaning;
37: CLOSE get_status_meaning;

Line 90: FROM fm_form_mst_b

86: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
87:
88: CURSOR C_get_orgid (V_formula_id NUMBER) IS
89: SELECT owner_organization_id
90: FROM fm_form_mst_b
91: WHERE formula_id = V_formula_id;
92: l_org_id NUMBER;
93:
94: -- Kapil ME Auto-Prod :Bug#5716318

Line 100: FROM FM_FORM_MST_B

96: l_formula_calc_flag VARCHAR2(1);
97:
98: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
99: SELECT AUTO_PRODUCT_CALC
100: FROM FM_FORM_MST_B
101: WHERE FORMULA_ID = V_formula_id;
102:
103: v_item_no varchar2(30); -- Added in Bug No.6799624
104: v_recipe_enabled varchar2(1); -- Added in Bug No.6799624

Line 651: FROM fm_form_mst_b

647: WHERE formulaline_id = vFormulaline_id;
648:
649: CURSOR C_get_orgid (V_formula_id NUMBER) IS
650: SELECT owner_organization_id
651: FROM fm_form_mst_b
652: WHERE formula_id = V_formula_id;
653: l_org_id NUMBER;
654:
655: CURSOR C_get_item_id (V_formulaline_id NUMBER) IS

Line 672: FROM FM_FORM_MST_B

668: l_formula_calc_flag VARCHAR2(1);
669:
670: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
671: SELECT AUTO_PRODUCT_CALC
672: FROM FM_FORM_MST_B
673: WHERE FORMULA_ID = V_formula_id;
674:
675: BEGIN
676: /* Define Savepoint */

Line 1621: FROM FM_FORM_MST_B

1617: l_org_id NUMBER;
1618:
1619: CURSOR C_get_org_id (V_formula_id NUMBER) IS
1620: SELECT OWNER_ORGANIZATION_ID
1621: FROM FM_FORM_MST_B
1622: WHERE FORMULA_ID = V_formula_id;
1623:
1624: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
1625: SELECT AUTO_PRODUCT_CALC

Line 1626: FROM FM_FORM_MST_B

1622: WHERE FORMULA_ID = V_formula_id;
1623:
1624: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
1625: SELECT AUTO_PRODUCT_CALC
1626: FROM FM_FORM_MST_B
1627: WHERE FORMULA_ID = V_formula_id;
1628:
1629: BEGIN
1630: /* Define Savepoint */