APPS.GMF_VALIDATIONS_PVT dependencies on SY_UOMS_MST

Line 1416: , x_resource_um_type OUT NOCOPY sy_uoms_mst.um_type%TYPE

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
1420: IS

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 1702: --| in sy_uoms_mst |

1698: --| Validates Usage UOM |
1699: --| |
1700: --| DESCRIPTION |
1701: --| This function validates that the Usage UOM exists |
1702: --| in sy_uoms_mst |
1703: --| |
1704: --| PARAMETERS |
1705: --| p_usage_um IN VARCHAR2(10) - Usage UOM |
1706: --| |

Line 1718: ( p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE

1714: --+==========================================================================+
1715: -- Func end of comments
1716:
1717: FUNCTION Validate_Usage_Um
1718: ( p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE
1719: )
1720: RETURN BOOLEAN
1721: IS
1722: CURSOR Cur_Usage_Um

Line 1727: sy_uoms_mst

1723: IS
1724: SELECT
1725: Um_Code
1726: FROM
1727: sy_uoms_mst
1728: WHERE
1729: Um_Code = p_Usage_Um ;
1730:
1731: l_Um_Code sy_uoms_mst.Um_Code%TYPE ;

Line 1731: l_Um_Code sy_uoms_mst.Um_Code%TYPE ;

1727: sy_uoms_mst
1728: WHERE
1729: Um_Code = p_Usage_Um ;
1730:
1731: l_Um_Code sy_uoms_mst.Um_Code%TYPE ;
1732:
1733: BEGIN
1734:
1735: OPEN Cur_Usage_Um;

Line 1762: --| in sy_uoms_mst and return UOM Type |

1758: --| Validates Usage UOM |
1759: --| |
1760: --| DESCRIPTION |
1761: --| This function validates that the Usage UOM exists |
1762: --| in sy_uoms_mst and return UOM Type |
1763: --| |
1764: --| PARAMETERS |
1765: --| p_usage_um IN VARCHAR2(10) - Usage UOM |
1766: --| x_um_type IN VARCHAR2(10) - UOM Type |

Line 1779: p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE

1775: -- Func end of comments
1776:
1777: PROCEDURE Validate_Usage_Um
1778: (
1779: p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE
1780: , x_Um_Type OUT NOCOPY sy_uoms_mst.Um_Type%TYPE
1781: )
1782: IS
1783: CURSOR Cur_Usage_Um

Line 1780: , x_Um_Type OUT NOCOPY sy_uoms_mst.Um_Type%TYPE

1776:
1777: PROCEDURE Validate_Usage_Um
1778: (
1779: p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE
1780: , x_Um_Type OUT NOCOPY sy_uoms_mst.Um_Type%TYPE
1781: )
1782: IS
1783: CURSOR Cur_Usage_Um
1784: IS

Line 1788: sy_uoms_mst

1784: IS
1785: SELECT
1786: Um_Type
1787: FROM
1788: sy_uoms_mst
1789: WHERE
1790: Um_Code = p_Usage_Um ;
1791:
1792: BEGIN