APPS.GMF_VALIDATIONS_PVT dependencies on SY_ORGN_MST

Line 479: --| on sy_orgn_mst |

475: --| Validates Company Code |
476: --| |
477: --| DESCRIPTION |
478: --| This function validates that the Company Code exists |
479: --| on sy_orgn_mst |
480: --| |
481: --| PARAMETERS |
482: --| p_Company_Code IN VARCHAR2(4) - Company Code |
483: --| |

Line 496: p_Company_Code IN sy_orgn_mst.Co_Code%TYPE

492: -- Func end of comments
493:
494: FUNCTION Validate_Company_Code
495: (
496: p_Company_Code IN sy_orgn_mst.Co_Code%TYPE
497: )
498: RETURN BOOLEAN
499: IS
500: CURSOR Cur_company_code

Line 505: sy_orgn_mst

501: IS
502: SELECT
503: co_code
504: FROM
505: sy_orgn_mst
506: WHERE
507: co_code = p_Company_Code
508: AND orgn_code = co_code
509: AND delete_mark = 0;

Line 511: l_Company_Code sy_orgn_mst.Co_Code%TYPE ;

507: co_code = p_Company_Code
508: AND orgn_code = co_code
509: AND delete_mark = 0;
510:
511: l_Company_Code sy_orgn_mst.Co_Code%TYPE ;
512:
513: BEGIN
514:
515: OPEN Cur_company_code;

Line 542: --| This function validates that the Orgn Code exists on sy_orgn_mst |

538: --| USAGE |
539: --| Validates Organization Code |
540: --| |
541: --| DESCRIPTION |
542: --| This function validates that the Orgn Code exists on sy_orgn_mst |
543: --| |
544: --| PARAMETERS |
545: --| p_orgn_code IN VARCHAR2(4) - Orgn Code |
546: --| |

Line 558: ( p_Orgn_Code IN sy_orgn_mst.Orgn_Code%TYPE

554: --+==========================================================================+
555: -- Func end of comments
556:
557: FUNCTION Validate_Orgn_Code
558: ( p_Orgn_Code IN sy_orgn_mst.Orgn_Code%TYPE
559: )
560: RETURN BOOLEAN
561: IS
562: CURSOR Cur_orgn_code

Line 567: sy_orgn_mst

563: IS
564: SELECT
565: orgn_code
566: FROM
567: sy_orgn_mst
568: WHERE
569: orgn_code = p_orgn_code
570: AND delete_mark = 0;
571:

Line 572: l_orgn_code sy_orgn_mst.orgn_code%TYPE ;

568: WHERE
569: orgn_code = p_orgn_code
570: AND delete_mark = 0;
571:
572: l_orgn_code sy_orgn_mst.orgn_code%TYPE ;
573:
574: BEGIN
575:
576: OPEN Cur_orgn_code;

Line 1528: p_co_code IN sy_orgn_mst.co_code%TYPE

1524: -- Func end of comments
1525:
1526: FUNCTION Fetch_Alloc_Id
1527: ( p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE,
1528: p_co_code IN sy_orgn_mst.co_code%TYPE
1529: )
1530: RETURN NUMBER
1531: IS
1532: CURSOR Cur_Alloc_Id

Line 1591: , p_co_code IN sy_orgn_mst.co_code%TYPE

1587: -- Func end of comments
1588:
1589: PROCEDURE Validate_Basis_account_key
1590: ( p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE
1591: , p_co_code IN sy_orgn_mst.co_code%TYPE
1592: , p_basis_description OUT NOCOPY VARCHAR2
1593: , p_return_status OUT NOCOPY NUMBER
1594: )
1595: IS