16:
17:
18: IF x_country_code in ('AR','CO','CL','MX') THEN
19:
20: IF jl_zz_fa_books_pkg.update_insert OR jl_zz_fa_books_pkg.insert_update THEN
21: jl_zz_fa_books_pkg.update_row;
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
17:
18: IF x_country_code in ('AR','CO','CL','MX') THEN
19:
20: IF jl_zz_fa_books_pkg.update_insert OR jl_zz_fa_books_pkg.insert_update THEN
21: jl_zz_fa_books_pkg.update_row;
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
25: jl_zz_fa_books_pkg.get_ga_dist_book;
19:
20: IF jl_zz_fa_books_pkg.update_insert OR jl_zz_fa_books_pkg.insert_update THEN
21: jl_zz_fa_books_pkg.update_row;
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
25: jl_zz_fa_books_pkg.get_ga_dist_book;
26: jl_zz_fa_books_pkg.update_row;
27: END IF;
20: IF jl_zz_fa_books_pkg.update_insert OR jl_zz_fa_books_pkg.insert_update THEN
21: jl_zz_fa_books_pkg.update_row;
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
25: jl_zz_fa_books_pkg.get_ga_dist_book;
26: jl_zz_fa_books_pkg.update_row;
27: END IF;
28:
21: jl_zz_fa_books_pkg.update_row;
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
25: jl_zz_fa_books_pkg.get_ga_dist_book;
26: jl_zz_fa_books_pkg.update_row;
27: END IF;
28:
29: END IF; -- country code
22: ELSE
23: jl_zz_fa_books_pkg.get_dist_book;
24: jl_zz_fa_books_pkg.get_flag_category;
25: jl_zz_fa_books_pkg.get_ga_dist_book;
26: jl_zz_fa_books_pkg.update_row;
27: END IF;
28:
29: END IF; -- country code
30: