APPS.GMF_VALIDATIONS_PVT dependencies on CR_RSRC_MST

Line 1333: --| on cr_rsrc_mst |

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

Line 1350: p_Resources IN cr_rsrc_mst.Resources%TYPE

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

Line 1359: cr_rsrc_mst

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

Line 1364: l_Resources cr_rsrc_mst.Resources%TYPE ;

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

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

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

Line 1412: p_Resources IN cr_rsrc_mst.Resources%TYPE

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

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

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

Line 1422: sy_uoms_mst um, cr_rsrc_mst rm

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

Line 1450: --| on cr_rsrc_mst |

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

Line 3285: p_Resources IN cr_rsrc_mst.Resources%TYPE

3281:
3282:
3283: PROCEDURE Validate_Resource
3284: (
3285: p_Resources IN cr_rsrc_mst.Resources%TYPE
3286: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3287: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3288: )
3289: IS

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

3282:
3283: PROCEDURE Validate_Resource
3284: (
3285: p_Resources IN cr_rsrc_mst.Resources%TYPE
3286: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3287: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3288: )
3289: IS
3290: CURSOR Cur_resources

Line 3295: mtl_units_of_measure uom, cr_rsrc_mst rm

3291: IS
3292: SELECT
3293: rm.std_usage_uom, uom.uom_class
3294: FROM
3295: mtl_units_of_measure uom, cr_rsrc_mst rm
3296: WHERE
3297: rm.resources = p_Resources
3298: AND uom.uom_code = rm.std_usage_uom
3299: AND rm.delete_mark = 0;