APPS.GMF_VALIDATIONS_PVT dependencies on SY_UOMS_MST

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

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

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

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

Line 1716: ( p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE

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

Line 1725: sy_uoms_mst

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

Line 1729: l_Um_Code sy_uoms_mst.Um_Code%TYPE ;

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

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

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

Line 1777: p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE

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

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

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

Line 1786: sy_uoms_mst

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