eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VALIDATIONS_PVT dependencies on IC_LOTS_MST

Line 1870: --| This function validates the lot and returns Lot ID from ic_lots_mst|

1866: --| USAGE |
1867: --| Validates lot Id |
1868: --| |
1869: --| DESCRIPTION |
1870: --| This function validates the lot and returns Lot ID from ic_lots_mst|
1871: --| |
1872: --| PARAMETERS |
1873: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1874: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |

Line 1874: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |

1870: --| This function validates the lot and returns Lot ID from ic_lots_mst|
1871: --| |
1872: --| PARAMETERS |
1873: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1874: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |
1875: --| p_sublot_no IN ic_lots_mst.sublot_no%TYPE -Sublot No |
1876: --| |
1877: --| RETURNS |
1878: --| Lot Id NUMBER |

Line 1875: --| p_sublot_no IN ic_lots_mst.sublot_no%TYPE -Sublot No |

1871: --| |
1872: --| PARAMETERS |
1873: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1874: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |
1875: --| p_sublot_no IN ic_lots_mst.sublot_no%TYPE -Sublot No |
1876: --| |
1877: --| RETURNS |
1878: --| Lot Id NUMBER |
1879: --| |

Line 1889: , p_lot_no IN ic_lots_mst.lot_no%TYPE

1885:
1886: FUNCTION VALIDATE_LOT_ID
1887: (
1888: p_item_id IN ic_item_mst.item_id%TYPE
1889: , p_lot_no IN ic_lots_mst.lot_no%TYPE
1890: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
1891: )
1892: RETURN NUMBER
1893: IS

Line 1890: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

1886: FUNCTION VALIDATE_LOT_ID
1887: (
1888: p_item_id IN ic_item_mst.item_id%TYPE
1889: , p_lot_no IN ic_lots_mst.lot_no%TYPE
1890: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
1891: )
1892: RETURN NUMBER
1893: IS
1894: l_lot_id ic_lots_mst.lot_id%TYPE;

Line 1894: l_lot_id ic_lots_mst.lot_id%TYPE;

1890: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
1891: )
1892: RETURN NUMBER
1893: IS
1894: l_lot_id ic_lots_mst.lot_id%TYPE;
1895: BEGIN
1896:
1897: BEGIN
1898: SELECT lot_id

Line 1900: FROM ic_lots_mst

1896:
1897: BEGIN
1898: SELECT lot_id
1899: INTO l_lot_id
1900: FROM ic_lots_mst
1901: WHERE item_id = p_item_id
1902: AND lot_no = p_lot_no
1903: AND sublot_no = p_sublot_no
1904: AND ROWNUM = 1;

Line 1923: --| This function validates that the lot ID exists in ic_lots_mst |

1919: --| USAGE |
1920: --| Validates lot Id |
1921: --| |
1922: --| DESCRIPTION |
1923: --| This function validates that the lot ID exists in ic_lots_mst |
1924: --| |
1925: --| PARAMETERS |
1926: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1927: --| p_lot_id IN ic_lots_mst.lot_ID%TYPE - Lot Id |

Line 1927: --| p_lot_id IN ic_lots_mst.lot_ID%TYPE - Lot Id |

1923: --| This function validates that the lot ID exists in ic_lots_mst |
1924: --| |
1925: --| PARAMETERS |
1926: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1927: --| p_lot_id IN ic_lots_mst.lot_ID%TYPE - Lot Id |
1928: --| |
1929: --| RETURNS |
1930: --| TRUE - If Lot Exists in ic_lots_mst |
1931: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |

Line 1930: --| TRUE - If Lot Exists in ic_lots_mst |

1926: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1927: --| p_lot_id IN ic_lots_mst.lot_ID%TYPE - Lot Id |
1928: --| |
1929: --| RETURNS |
1930: --| TRUE - If Lot Exists in ic_lots_mst |
1931: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |
1932: --| |
1933: --| HISTORY |
1934: --| 15-Apr-2004 Anand Thiyagarajan - Created |

Line 1931: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |

1927: --| p_lot_id IN ic_lots_mst.lot_ID%TYPE - Lot Id |
1928: --| |
1929: --| RETURNS |
1930: --| TRUE - If Lot Exists in ic_lots_mst |
1931: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |
1932: --| |
1933: --| HISTORY |
1934: --| 15-Apr-2004 Anand Thiyagarajan - Created |
1935: --| |

Line 1942: , p_lot_id IN ic_lots_mst.lot_id%TYPE

1938:
1939: FUNCTION VALIDATE_LOT_ID
1940: (
1941: p_item_id IN ic_item_mst.item_id%TYPE
1942: , p_lot_id IN ic_lots_mst.lot_id%TYPE
1943: )
1944: RETURN BOOLEAN
1945: IS
1946: l_cnt NUMBER;

Line 1952: FROM ic_lots_mst

1948:
1949: BEGIN
1950: SELECT 1
1951: INTO l_cnt
1952: FROM ic_lots_mst
1953: WHERE item_id = p_item_id
1954: AND lot_id = p_lot_id
1955: AND ROWNUM = 1;
1956: EXCEPTION

Line 1978: --| This function validates that the lot No exists in ic_lots_mst |

1974: --| USAGE |
1975: --| Validates lot No |
1976: --| |
1977: --| DESCRIPTION |
1978: --| This function validates that the lot No exists in ic_lots_mst |
1979: --| |
1980: --| PARAMETERS |
1981: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1982: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |

Line 1982: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |

1978: --| This function validates that the lot No exists in ic_lots_mst |
1979: --| |
1980: --| PARAMETERS |
1981: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1982: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |
1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |
1984: --| |
1985: --| RETURNS |
1986: --| TRUE - If Lot Exists in ic_lots_mst |

Line 1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |

1979: --| |
1980: --| PARAMETERS |
1981: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |
1982: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |
1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |
1984: --| |
1985: --| RETURNS |
1986: --| TRUE - If Lot Exists in ic_lots_mst |
1987: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |

Line 1986: --| TRUE - If Lot Exists in ic_lots_mst |

1982: --| p_lot_no IN ic_lots_mst.lot_no%TYPE - Lot No |
1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |
1984: --| |
1985: --| RETURNS |
1986: --| TRUE - If Lot Exists in ic_lots_mst |
1987: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |
1988: --| |
1989: --| HISTORY |
1990: --| 15-Apr-2004 Anand Thiyagarajan - Created |

Line 1987: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |

1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |
1984: --| |
1985: --| RETURNS |
1986: --| TRUE - If Lot Exists in ic_lots_mst |
1987: --| FALSE - If Lot Doesnt Exist in ic_lots_mst |
1988: --| |
1989: --| HISTORY |
1990: --| 15-Apr-2004 Anand Thiyagarajan - Created |
1991: --| |

Line 1998: , p_lot_no IN ic_lots_mst.lot_no%TYPE

1994:
1995: FUNCTION VALIDATE_LOT_NO
1996: (
1997: p_item_id IN ic_item_mst.item_id%TYPE
1998: , p_lot_no IN ic_lots_mst.lot_no%TYPE
1999: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2000: )
2001: RETURN BOOLEAN
2002: IS

Line 1999: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

1995: FUNCTION VALIDATE_LOT_NO
1996: (
1997: p_item_id IN ic_item_mst.item_id%TYPE
1998: , p_lot_no IN ic_lots_mst.lot_no%TYPE
1999: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2000: )
2001: RETURN BOOLEAN
2002: IS
2003: l_cnt NUMBER;

Line 2009: FROM ic_lots_mst

2005:
2006: BEGIN
2007: SELECT 1
2008: INTO l_cnt
2009: FROM ic_lots_mst
2010: WHERE item_id = p_item_id
2011: AND lot_no = p_lot_no
2012: AND sublot_no = p_sublot_no
2013: AND ROWNUM = 1;