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 1872: --| This function validates the lot and returns Lot ID from ic_lots_mst|

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

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

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

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

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

Line 1891: , p_lot_no IN ic_lots_mst.lot_no%TYPE

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

Line 1892: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

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

Line 1896: l_lot_id ic_lots_mst.lot_id%TYPE;

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

Line 1902: FROM ic_lots_mst

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

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

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

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

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

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

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

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

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

Line 1944: , p_lot_id IN ic_lots_mst.lot_id%TYPE

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

Line 1954: FROM ic_lots_mst

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

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

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

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

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

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

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

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

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

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

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

Line 2000: , p_lot_no IN ic_lots_mst.lot_no%TYPE

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

Line 2001: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

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

Line 2011: FROM ic_lots_mst

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