APPS.GMF_VALIDATIONS_PVT dependencies on CR_RSRC_MST

Line 1335: --| on cr_rsrc_mst |

1331: --| Validates Resources |
1332: --| |
1333: --| DESCRIPTION |
1334: --| This function validates that the Resources exists |
1335: --| on cr_rsrc_mst |
1336: --| |
1337: --| PARAMETERS |
1338: --| p_Resources IN VARCHAR2(8) - Effectivity Id |
1339: --| |

Line 1352: p_Resources IN cr_rsrc_mst.Resources%TYPE

1348: -- Func end of comments
1349:
1350: FUNCTION Validate_Resources
1351: (
1352: p_Resources IN cr_rsrc_mst.Resources%TYPE
1353: )
1354: RETURN BOOLEAN
1355: IS
1356: CURSOR Cur_resources

Line 1361: cr_rsrc_mst

1357: IS
1358: SELECT
1359: resources
1360: FROM
1361: cr_rsrc_mst
1362: WHERE
1363: resources = p_Resources
1364: AND delete_mark = 0;
1365:

Line 1366: l_Resources cr_rsrc_mst.Resources%TYPE ;

1362: WHERE
1363: resources = p_Resources
1364: AND delete_mark = 0;
1365:
1366: l_Resources cr_rsrc_mst.Resources%TYPE ;
1367:
1368: BEGIN
1369:
1370: OPEN Cur_resources;

Line 1397: --| on cr_rsrc_mst and returns usage UOM |

1393: --| Validates Resources |
1394: --| |
1395: --| DESCRIPTION |
1396: --| This function validates that the Resources exists |
1397: --| on cr_rsrc_mst and returns usage UOM |
1398: --| |
1399: --| PARAMETERS |
1400: --| p_Resources IN VARCHAR2(8) - Resources |
1401: --| x_resource_um OUT VARCHAR2(8) - Usage UOM |

Line 1414: p_Resources IN cr_rsrc_mst.Resources%TYPE

1410: -- Func end of comments
1411:
1412: PROCEDURE Validate_Resources
1413: (
1414: p_Resources IN cr_rsrc_mst.Resources%TYPE
1415: , x_resource_um OUT NOCOPY cr_rsrc_mst.std_usage_um%TYPE
1416: , x_resource_um_type OUT NOCOPY sy_uoms_mst.um_type%TYPE
1417: )
1418: IS

Line 1415: , x_resource_um OUT NOCOPY cr_rsrc_mst.std_usage_um%TYPE

1411:
1412: PROCEDURE Validate_Resources
1413: (
1414: p_Resources IN cr_rsrc_mst.Resources%TYPE
1415: , x_resource_um OUT NOCOPY cr_rsrc_mst.std_usage_um%TYPE
1416: , x_resource_um_type OUT NOCOPY sy_uoms_mst.um_type%TYPE
1417: )
1418: IS
1419: CURSOR Cur_resources

Line 1424: sy_uoms_mst um, cr_rsrc_mst rm

1420: IS
1421: SELECT
1422: rm.std_usage_um, um.um_type
1423: FROM
1424: sy_uoms_mst um, cr_rsrc_mst rm
1425: WHERE
1426: rm.resources = p_Resources
1427: AND um.um_code = rm.std_usage_um
1428: AND rm.delete_mark = 0;

Line 1452: --| on cr_rsrc_mst |

1448: --| Validates Allocation Id |
1449: --| |
1450: --| DESCRIPTION |
1451: --| This function validates that the Allocation Id exists |
1452: --| on cr_rsrc_mst |
1453: --| |
1454: --| PARAMETERS |
1455: --| p_alloc_id IN NUMBER(10) - Allocation Id |
1456: --| |

Line 3357: p_Resources IN cr_rsrc_mst.Resources%TYPE

3353:
3354:
3355: PROCEDURE Validate_Resource
3356: (
3357: p_Resources IN cr_rsrc_mst.Resources%TYPE
3358: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3359: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3360: )
3361: IS

Line 3358: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE

3354:
3355: PROCEDURE Validate_Resource
3356: (
3357: p_Resources IN cr_rsrc_mst.Resources%TYPE
3358: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3359: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3360: )
3361: IS
3362: CURSOR Cur_resources

Line 3367: mtl_units_of_measure uom, cr_rsrc_mst rm

3363: IS
3364: SELECT
3365: rm.std_usage_uom, uom.uom_class
3366: FROM
3367: mtl_units_of_measure uom, cr_rsrc_mst rm
3368: WHERE
3369: rm.resources = p_Resources
3370: AND uom.uom_code = rm.std_usage_uom
3371: AND rm.delete_mark = 0;