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 646: FROM fm_form_mst_b

642: WHERE formulaline_id = vFormulaline_id;
643:
644: CURSOR C_get_orgid (V_formula_id NUMBER) IS
645: SELECT owner_organization_id
646: FROM fm_form_mst_b
647: WHERE formula_id = V_formula_id;
648: l_org_id NUMBER;
649:
650: CURSOR C_get_item_id (V_formulaline_id NUMBER) IS

Line 667: FROM FM_FORM_MST_B

663: l_formula_calc_flag VARCHAR2(1);
664:
665: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
666: SELECT AUTO_PRODUCT_CALC
667: FROM FM_FORM_MST_B
668: WHERE FORMULA_ID = V_formula_id;
669:
670: BEGIN
671: /* Define Savepoint */

Line 1602: FROM FM_FORM_MST_B

1598: l_org_id NUMBER;
1599:
1600: CURSOR C_get_org_id (V_formula_id NUMBER) IS
1601: SELECT OWNER_ORGANIZATION_ID
1602: FROM FM_FORM_MST_B
1603: WHERE FORMULA_ID = V_formula_id;
1604:
1605: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
1606: SELECT AUTO_PRODUCT_CALC

Line 1607: FROM FM_FORM_MST_B

1603: WHERE FORMULA_ID = V_formula_id;
1604:
1605: CURSOR C_get_auto_parameter (V_formula_id NUMBER) IS
1606: SELECT AUTO_PRODUCT_CALC
1607: FROM FM_FORM_MST_B
1608: WHERE FORMULA_ID = V_formula_id;
1609:
1610: BEGIN
1611: /* Define Savepoint */