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_ITEM_MST

Line 280: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

276: --+==========================================================================+
277: -- Func end of comments
278:
279: FUNCTION Validate_cost_mthd_code (
280: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
281: )
282: RETURN BOOLEAN
283: IS
284: CURSOR cur_cm_mthd_mst

Line 294: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

290: WHERE
291: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
292: AND cm_mthd_mst.delete_mark = 0;
293:
294: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
295: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
296:
297: BEGIN
298:

Line 371: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

367: WHERE
368: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
369: AND cm_mthd_mst.delete_mark = 0;
370:
371: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
372: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
373:
374: BEGIN
375:

Line 680: p_Item_Id IN ic_item_mst.Item_Id%TYPE

676: -- Func end of comments
677:
678: FUNCTION Validate_Item_Id
679: (
680: p_Item_Id IN ic_item_mst.Item_Id%TYPE
681: )
682: RETURN BOOLEAN
683: IS
684: CURSOR Cur_Item_Id

Line 689: ic_item_mst

685: IS
686: SELECT
687: Item_Id
688: FROM
689: ic_item_mst
690: WHERE
691: Item_Id = p_Item_Id
692: AND delete_mark = 0
693: AND inactive_ind = 0 ;

Line 695: l_Item_Id ic_item_mst.Item_Id%TYPE ;

691: Item_Id = p_Item_Id
692: AND delete_mark = 0
693: AND inactive_ind = 0 ;
694:
695: l_Item_Id ic_item_mst.Item_Id%TYPE ;
696:
697: BEGIN
698:
699: OPEN Cur_Item_Id;

Line 726: --| This function validates that the Item ID exists in ic_item_mst |

722: --| USAGE |
723: --| Validates Item ID |
724: --| |
725: --| DESCRIPTION |
726: --| This function validates that the Item ID exists in ic_item_mst |
727: --| and returns item_um |
728: --| |
729: --| PARAMETERS |
730: --| p_item_id IN VARCHAR2(4) - Item ID |

Line 743: p_Item_Id IN ic_item_mst.Item_Id%TYPE

739: -- Func end of comments
740:
741: PROCEDURE Validate_Item_Id
742: (
743: p_Item_Id IN ic_item_mst.Item_Id%TYPE
744: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
745: )
746: IS
747: CURSOR Cur_Item_UM

Line 744: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE

740:
741: PROCEDURE Validate_Item_Id
742: (
743: p_Item_Id IN ic_item_mst.Item_Id%TYPE
744: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
745: )
746: IS
747: CURSOR Cur_Item_UM
748: IS

Line 752: ic_item_mst

748: IS
749: SELECT
750: Item_UM
751: FROM
752: ic_item_mst
753: WHERE
754: Item_Id = p_Item_Id
755: AND delete_mark = 0
756: AND inactive_ind = 0 ;

Line 796: ( p_Item_No IN ic_item_mst.Item_No%TYPE

792: --+==========================================================================+
793: -- Func end of comments
794:
795: FUNCTION Validate_Item_No
796: ( p_Item_No IN ic_item_mst.Item_No%TYPE
797: )
798: RETURN NUMBER
799: IS
800: CURSOR Cur_Item_Id

Line 805: ic_item_mst

801: IS
802: SELECT
803: Item_Id
804: FROM
805: ic_item_mst
806: WHERE
807: Item_No = p_Item_No
808: AND delete_mark = 0
809: AND inactive_ind = 0 ;

Line 811: l_Item_Id ic_item_mst.Item_Id%TYPE ;

807: Item_No = p_Item_No
808: AND delete_mark = 0
809: AND inactive_ind = 0 ;
810:
811: l_Item_Id ic_item_mst.Item_Id%TYPE ;
812:
813: BEGIN
814:
815: OPEN Cur_Item_Id;

Line 842: --| This function validates that the Item No exists on ic_item_mst |

838: --| USAGE |
839: --| Validates Item No |
840: --| |
841: --| DESCRIPTION |
842: --| This function validates that the Item No exists on ic_item_mst |
843: --| |
844: --| PARAMETERS |
845: --| p_item_No IN VARCHAR2(4) - Item No |
846: --| |

Line 859: p_Item_No IN ic_item_mst.Item_No%TYPE

855: -- Func end of comments
856:
857: PROCEDURE Validate_Item_No
858: (
859: p_Item_No IN ic_item_mst.Item_No%TYPE
860: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
861: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
862: )
863: IS

Line 860: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE

856:
857: PROCEDURE Validate_Item_No
858: (
859: p_Item_No IN ic_item_mst.Item_No%TYPE
860: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
861: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
862: )
863: IS
864: CURSOR Cur_Item

Line 861: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE

857: PROCEDURE Validate_Item_No
858: (
859: p_Item_No IN ic_item_mst.Item_No%TYPE
860: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
861: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
862: )
863: IS
864: CURSOR Cur_Item
865: IS

Line 869: ic_item_mst

865: IS
866: SELECT
867: Item_Id, Item_UM
868: FROM
869: ic_item_mst
870: WHERE
871: Item_No = p_Item_No
872: AND delete_mark = 0
873: AND inactive_ind = 0 ;

Line 913: p_itemcost_class IN ic_item_mst.itemcost_class%TYPE

909: --+==========================================================================+
910: -- Func end of comments
911: FUNCTION Validate_itemcost_class
912: (
913: p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
914: )
915: RETURN BOOLEAN
916: IS
917: /* ANTHIYAG Bug#4906488

Line 1830: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

1826: -- Func end of comments
1827:
1828: FUNCTION Validate_lot_cost_mthd_code
1829: (
1830: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
1831: )
1832: RETURN BOOLEAN
1833: IS
1834: CURSOR cur_cm_mthd_mst

Line 1842: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

1838: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
1839: AND cm_mthd_mst.delete_mark = 0
1840: AND lot_actual_cost = 1;
1841:
1842: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
1843:
1844: BEGIN
1845:
1846: OPEN cur_cm_mthd_mst;

Line 1873: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |

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 |
1875: --| p_sublot_no IN ic_lots_mst.sublot_no%TYPE -Sublot No |
1876: --| |
1877: --| RETURNS |

Line 1888: p_item_id IN ic_item_mst.item_id%TYPE

1884: -- Func end of comments
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

Line 1926: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |

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 |
1928: --| |
1929: --| RETURNS |
1930: --| TRUE - If Lot Exists in ic_lots_mst |

Line 1941: p_item_id IN ic_item_mst.item_id%TYPE

1937: -- Func end of comments
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

Line 1981: --| p_item_id IN ic_item_mst.item_id%TYPE - Item Id |

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 |
1983: --| p_sublot_no IN ic_lots_mst.lot_no%TYPE - sublot No |
1984: --| |
1985: --| RETURNS |

Line 1997: p_item_id IN ic_item_mst.item_id%TYPE

1993: -- Func end of comments
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