APPS.GMF_VALIDATIONS_PVT dependencies on FM_FORM_EFF

Line 1273: --| on fm_form_eff |

1269: --| Validates Fmeff_Id |
1270: --| |
1271: --| DESCRIPTION |
1272: --| This function validates that the Effectivity Id exists |
1273: --| on fm_form_eff |
1274: --| |
1275: --| PARAMETERS |
1276: --| p_fneff_id IN VARCHAR2(8) - Effectivity Id |
1277: --| |

Line 1290: p_Fmeff_Id IN fm_form_eff.Fmeff_Id%TYPE

1286: -- Func end of comments
1287:
1288: FUNCTION Validate_Fmeff_Id
1289: (
1290: p_Fmeff_Id IN fm_form_eff.Fmeff_Id%TYPE
1291: )
1292: RETURN BOOLEAN
1293: IS
1294: CURSOR Cur_fmeff_id

Line 1299: fm_form_eff

1295: IS
1296: SELECT
1297: fmeff_id
1298: FROM
1299: fm_form_eff
1300: WHERE
1301: fmeff_id = p_fmeff_id
1302: AND delete_mark = 0;
1303:

Line 1304: l_fmeff_id fm_form_eff.fmeff_id%TYPE;

1300: WHERE
1301: fmeff_id = p_fmeff_id
1302: AND delete_mark = 0;
1303:
1304: l_fmeff_id fm_form_eff.fmeff_id%TYPE;
1305:
1306: BEGIN
1307:
1308: OPEN Cur_fmeff_id;