APPS.GMF_VALIDATIONS_PVT dependencies on IC_WHSE_MST

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

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

Line 618: p_whse_code IN ic_whse_mst.whse_code%TYPE

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

Line 627: ic_whse_mst

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

Line 632: l_whse_code ic_whse_mst.whse_code%TYPE ;

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

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

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

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

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