eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_FA_BOOKS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7


  SELECT distribution_source_book
    INTO jl_zz_fa_books_pkg.v_dist_book
    FROM fa_book_controls
    WHERE book_type_code = jl_zz_fa_books_pkg.v_book_type_code;

Line: 15


FUNCTION update_insert RETURN BOOLEAN IS
BEGIN

        SELECT global_attribute1,
              global_attribute2,
              global_attribute3,
              global_attribute4,
              global_attribute5,
              global_attribute6,
              global_attribute7,
              global_attribute8,
              global_attribute9,
              global_attribute10,
              global_attribute11,
              global_attribute12,
              global_attribute13,
              global_attribute14,
              global_attribute15,
              global_attribute16,
              global_attribute17,
              global_attribute18,
              global_attribute19,
              global_attribute20,
              global_attribute_category
         INTO jl_zz_fa_books_pkg.v_global_attribute1,
             jl_zz_fa_books_pkg.v_global_attribute2,
             jl_zz_fa_books_pkg.v_global_attribute3,
             jl_zz_fa_books_pkg.v_global_attribute4,
             jl_zz_fa_books_pkg.v_global_attribute5,
             jl_zz_fa_books_pkg.v_global_attribute6,
             jl_zz_fa_books_pkg.v_global_attribute7,
             jl_zz_fa_books_pkg.v_global_attribute8,
             jl_zz_fa_books_pkg.v_global_attribute9,
             jl_zz_fa_books_pkg.v_global_attribute10,
             jl_zz_fa_books_pkg.v_global_attribute11,
             jl_zz_fa_books_pkg.v_global_attribute12,
             jl_zz_fa_books_pkg.v_global_attribute13,
             jl_zz_fa_books_pkg.v_global_attribute14,
             jl_zz_fa_books_pkg.v_global_attribute15,
             jl_zz_fa_books_pkg.v_global_attribute16,
             jl_zz_fa_books_pkg.v_global_attribute17,
             jl_zz_fa_books_pkg.v_global_attribute18,
             jl_zz_fa_books_pkg.v_global_attribute19,
             jl_zz_fa_books_pkg.v_global_attribute20,
             jl_zz_fa_books_pkg.v_global_attribute_category
         FROM fa_books
         WHERE asset_id = jl_zz_fa_books_pkg.v_asset_id
           AND book_type_code = jl_zz_fa_books_pkg.v_book_type_code
           AND transaction_header_id_out = jl_zz_fa_books_pkg.v_transaction_header_id_in ;

Line: 69


END update_insert;

Line: 71


FUNCTION insert_update RETURN BOOLEAN IS
BEGIN

        SELECT global_attribute1,
              global_attribute2,
              global_attribute3,
              global_attribute4,
              global_attribute5,
              global_attribute6,
              global_attribute7,
              global_attribute8,
              global_attribute9,
              global_attribute10,
              global_attribute11,
              global_attribute12,
              global_attribute13,
              global_attribute14,
              global_attribute15,
              global_attribute16,
              global_attribute17,
              global_attribute18,
              global_attribute19,
              global_attribute20,
              global_attribute_category
         INTO jl_zz_fa_books_pkg.v_global_attribute1,
             jl_zz_fa_books_pkg.v_global_attribute2,
             jl_zz_fa_books_pkg.v_global_attribute3,
             jl_zz_fa_books_pkg.v_global_attribute4,
             jl_zz_fa_books_pkg.v_global_attribute5,
             jl_zz_fa_books_pkg.v_global_attribute6,
             jl_zz_fa_books_pkg.v_global_attribute7,
             jl_zz_fa_books_pkg.v_global_attribute8,
             jl_zz_fa_books_pkg.v_global_attribute9,
             jl_zz_fa_books_pkg.v_global_attribute10,
             jl_zz_fa_books_pkg.v_global_attribute11,
             jl_zz_fa_books_pkg.v_global_attribute12,
             jl_zz_fa_books_pkg.v_global_attribute13,
             jl_zz_fa_books_pkg.v_global_attribute14,
             jl_zz_fa_books_pkg.v_global_attribute15,
             jl_zz_fa_books_pkg.v_global_attribute16,
             jl_zz_fa_books_pkg.v_global_attribute17,
             jl_zz_fa_books_pkg.v_global_attribute18,
             jl_zz_fa_books_pkg.v_global_attribute19,
             jl_zz_fa_books_pkg.v_global_attribute20,
             jl_zz_fa_books_pkg.v_global_attribute_category
         FROM fa_books
         WHERE asset_id = jl_zz_fa_books_pkg.v_asset_id
           AND book_type_code = jl_zz_fa_books_pkg.v_book_type_code
           AND date_ineffective IS NULL
           AND transaction_header_id_in <> jl_zz_fa_books_pkg.v_transaction_header_id_in ;

Line: 126


END insert_update;

Line: 128


PROCEDURE update_row IS
   l_country_code VARCHAR2(10);

Line: 157


   UPDATE fa_books
     SET  global_attribute1 = decode(global_attribute1,null,
            jl_zz_fa_books_pkg.v_global_attribute1,global_attribute1),
        global_attribute2 = decode(global_attribute2,null,
            jl_zz_fa_books_pkg.v_global_attribute2,global_attribute2),
        global_attribute3 = decode(global_attribute3,null,
            jl_zz_fa_books_pkg.v_global_attribute3,global_attribute3),
        global_attribute4 = decode(global_attribute4,null,
            jl_zz_fa_books_pkg.v_global_attribute4,global_attribute4),
        global_attribute5 = decode(global_attribute5,null,
            jl_zz_fa_books_pkg.v_global_attribute5,global_attribute5),
        global_attribute6 = decode(global_attribute6,null,
            jl_zz_fa_books_pkg.v_global_attribute6,global_attribute6),
        global_attribute7 = decode(global_attribute7,null,
            jl_zz_fa_books_pkg.v_global_attribute7,global_attribute7),
        global_attribute8 = decode(global_attribute8,null,
            jl_zz_fa_books_pkg.v_global_attribute8,global_attribute8),
        global_attribute9 = decode(global_attribute9,null,
            jl_zz_fa_books_pkg.v_global_attribute9,global_attribute9),
        global_attribute10 = decode(global_attribute10,null,
            jl_zz_fa_books_pkg.v_global_attribute10,global_attribute10),
        global_attribute11 = decode(global_attribute11,null,
            jl_zz_fa_books_pkg.v_global_attribute11,global_attribute11),
        global_attribute12 = decode(global_attribute12,null,
            jl_zz_fa_books_pkg.v_global_attribute12,global_attribute12),
        global_attribute13 = decode(global_attribute13,null,
            jl_zz_fa_books_pkg.v_global_attribute13,global_attribute13),
        global_attribute14 = decode(global_attribute14,null,
            jl_zz_fa_books_pkg.v_global_attribute14,global_attribute14),
        global_attribute15 = decode(global_attribute15,null,
            jl_zz_fa_books_pkg.v_global_attribute15,global_attribute15),
        global_attribute16 = decode(global_attribute16,null,
            jl_zz_fa_books_pkg.v_global_attribute16,global_attribute16),
        global_attribute17 = decode(global_attribute17,null,
            jl_zz_fa_books_pkg.v_global_attribute17,global_attribute17),
        global_attribute18 = decode(global_attribute18,null,
            jl_zz_fa_books_pkg.v_global_attribute18,global_attribute18),
        global_attribute19 = decode(global_attribute19,null,
            jl_zz_fa_books_pkg.v_global_attribute19,global_attribute19),
        global_attribute20 = decode(global_attribute20,null,
            jl_zz_fa_books_pkg.v_global_attribute20,global_attribute20),
        global_attribute_category =decode(global_attribute_category,null,
            jl_zz_fa_books_pkg.v_global_attribute_category,global_attribute_category)
         WHERE asset_id = jl_zz_fa_books_pkg.v_asset_id
           AND book_type_code = jl_zz_fa_books_pkg.v_book_type_code
           AND transaction_header_id_in = jl_zz_fa_books_pkg.v_transaction_header_id_in ;

Line: 206


END update_row;

Line: 210


        SELECT a.global_attribute1
         INTO jl_zz_fa_books_pkg.v_global_attribute1
         FROM fa_category_books a, fa_additions b
         WHERE b.asset_id = jl_zz_fa_books_pkg.v_asset_id
           AND a.book_type_code = jl_zz_fa_books_pkg.v_book_type_code
           AND a.category_id = b.asset_category_id;

Line: 223


        SELECT
              global_attribute2,
              global_attribute3,
              global_attribute4,
              global_attribute5,
              global_attribute6,
              global_attribute7,
              global_attribute8,
              global_attribute9,
              global_attribute10,
              global_attribute11,
              global_attribute12,
              global_attribute13,
              global_attribute14,
              global_attribute15,
              global_attribute16,
              global_attribute17,
              global_attribute18,
              global_attribute19,
              global_attribute20,
              global_attribute_category
         INTO
             jl_zz_fa_books_pkg.v_global_attribute2,
             jl_zz_fa_books_pkg.v_global_attribute3,
             jl_zz_fa_books_pkg.v_global_attribute4,
             jl_zz_fa_books_pkg.v_global_attribute5,
             jl_zz_fa_books_pkg.v_global_attribute6,
             jl_zz_fa_books_pkg.v_global_attribute7,
             jl_zz_fa_books_pkg.v_global_attribute8,
             jl_zz_fa_books_pkg.v_global_attribute9,
             jl_zz_fa_books_pkg.v_global_attribute10,
             jl_zz_fa_books_pkg.v_global_attribute11,
             jl_zz_fa_books_pkg.v_global_attribute12,
             jl_zz_fa_books_pkg.v_global_attribute13,
             jl_zz_fa_books_pkg.v_global_attribute14,
             jl_zz_fa_books_pkg.v_global_attribute15,
             jl_zz_fa_books_pkg.v_global_attribute16,
             jl_zz_fa_books_pkg.v_global_attribute17,
             jl_zz_fa_books_pkg.v_global_attribute18,
             jl_zz_fa_books_pkg.v_global_attribute19,
             jl_zz_fa_books_pkg.v_global_attribute20,
             jl_zz_fa_books_pkg.v_global_attribute_category
         FROM fa_books
         WHERE asset_id = jl_zz_fa_books_pkg.v_asset_id
           AND book_type_code = jl_zz_fa_books_pkg.v_dist_book
           AND date_ineffective IS NULL
           AND transaction_header_id_in <> jl_zz_fa_books_pkg.v_transaction_header_id_in ;