APPS.GMF_VALIDATIONS_PVT dependencies on IC_WHSE_MST

Line 603: --| This function validates that the Whse Code exists on ic_whse_mst |

599: --| USAGE |
600: --| Validates Warehouse Code |
601: --| |
602: --| DESCRIPTION |
603: --| This function validates that the Whse Code exists on ic_whse_mst |
604: --| |
605: --| PARAMETERS |
606: --| p_whse_code IN VARCHAR2(4) - Whse Code |
607: --| |

Line 620: p_whse_code IN ic_whse_mst.whse_code%TYPE

616: -- Func end of comments
617:
618: FUNCTION Validate_Whse_Code
619: (
620: p_whse_code IN ic_whse_mst.whse_code%TYPE
621: )
622: RETURN BOOLEAN
623: IS
624: CURSOR Cur_whse_code

Line 629: ic_whse_mst

625: IS
626: SELECT
627: whse_code
628: FROM
629: ic_whse_mst
630: WHERE
631: whse_code = p_whse_code
632: AND delete_mark = 0;
633:

Line 634: l_whse_code ic_whse_mst.whse_code%TYPE ;

630: WHERE
631: whse_code = p_whse_code
632: AND delete_mark = 0;
633:
634: l_whse_code ic_whse_mst.whse_code%TYPE ;
635:
636: BEGIN
637:
638: OPEN Cur_whse_code;

Line 665: --| This function validates that the Item ID exists on ic_whse_mst |

661: --| USAGE |
662: --| Validates Item ID |
663: --| |
664: --| DESCRIPTION |
665: --| This function validates that the Item ID exists on ic_whse_mst |
666: --| |
667: --| PARAMETERS |
668: --| p_item_id IN VARCHAR2(4) - Item ID |
669: --| |

Line 782: --| This function validates that the Item No exists on ic_whse_mst |

778: --| USAGE |
779: --| Validates Item No |
780: --| |
781: --| DESCRIPTION |
782: --| This function validates that the Item No exists on ic_whse_mst |
783: --| |
784: --| PARAMETERS |
785: --| p_item_No IN VARCHAR2(4) - Item No |
786: --| |