APPS.GMF_VALIDATIONS_PVT dependencies on SY_ORGN_MST

Line 477: --| on sy_orgn_mst |

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

Line 494: p_Company_Code IN sy_orgn_mst.Co_Code%TYPE

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

Line 503: sy_orgn_mst

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

Line 509: l_Company_Code sy_orgn_mst.Co_Code%TYPE ;

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

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

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

Line 556: ( p_Orgn_Code IN sy_orgn_mst.Orgn_Code%TYPE

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

Line 565: sy_orgn_mst

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

Line 570: l_orgn_code sy_orgn_mst.orgn_code%TYPE ;

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

Line 1526: p_co_code IN sy_orgn_mst.co_code%TYPE

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

Line 1589: , p_co_code IN sy_orgn_mst.co_code%TYPE

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