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 282: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

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

Line 296: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

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

Line 373: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

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

Line 682: p_Item_Id IN ic_item_mst.Item_Id%TYPE

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

Line 691: ic_item_mst

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

Line 697: l_Item_Id ic_item_mst.Item_Id%TYPE ;

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

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

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

Line 745: p_Item_Id IN ic_item_mst.Item_Id%TYPE

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

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

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

Line 754: ic_item_mst

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

Line 798: ( p_Item_No IN ic_item_mst.Item_No%TYPE

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

Line 807: ic_item_mst

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

Line 813: l_Item_Id ic_item_mst.Item_Id%TYPE ;

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

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

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

Line 861: p_Item_No IN ic_item_mst.Item_No%TYPE

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

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

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

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

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

Line 871: ic_item_mst

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

Line 915: p_itemcost_class IN ic_item_mst.itemcost_class%TYPE

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

Line 1832: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

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

Line 1844: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

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

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

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

Line 1890: p_item_id IN ic_item_mst.item_id%TYPE

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

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

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

Line 1943: p_item_id IN ic_item_mst.item_id%TYPE

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

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

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

Line 1999: p_item_id IN ic_item_mst.item_id%TYPE

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