DBA Data[Home] [Help]

APPS.GMD_FORMULA_PUB dependencies on FM_FORM_MST_B

Line 34: FOR C_status_code IN (Select formula_status from fm_form_mst_b

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

Line 147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE

143: l_formula_detail_tbl GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
144:
145: --kkillams, bug 3408799
146: TYPE rec_formula IS RECORD
147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
149: );
150: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
151:

Line 148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE

144:
145: --kkillams, bug 3408799
146: TYPE rec_formula IS RECORD
147: (formula_id FM_FORM_MST_B.FORMULA_ID%TYPE
148: ,owner_organization_id FM_FORM_MST_B.owner_organization_id%TYPE
149: );
150: TYPE tbl_formula_id IS TABLE OF rec_formula INDEX BY BINARY_INTEGER;
151:
152: l_entity_status gmd_api_grp.status_rec_type;