TRIGGER: APPS.JL_ZZ_FA_BOOKS_GLOB_FLEX_SL

Source

Description

jl_zz_fa_books_glob_flex_sl
       AFTER INSERT ON fa_books

/* $Header: jlzzffbi.sql 120.3 2006/03/06 22:16:01 svaze ship $ */

Type

AFTER STATEMENT

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE

 x_country_code VARCHAR2(10);

BEGIN

  -------------------------------------------------------------------------
  -- BUG 4650081. Profile for country is replaced by call to JG Shared pkg.
  -------------------------------------------------------------------------
  x_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY;


     IF x_country_code in ('AR','CO','CL','MX') THEN

         IF jl_zz_fa_books_pkg.update_insert OR jl_zz_fa_books_pkg.insert_update THEN
             jl_zz_fa_books_pkg.update_row;
         ELSE
             jl_zz_fa_books_pkg.get_dist_book;
             jl_zz_fa_books_pkg.get_flag_category;
             jl_zz_fa_books_pkg.get_ga_dist_book;
             jl_zz_fa_books_pkg.update_row;
         END IF;

     END IF; -- country code

END jl_zz_fa_books_glob_flex_sl;