DBA Data[Home] [Help]

APPS.FUN_GLINT_WF SQL Statements

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

Line: 7

 * FUNCTION autonomous_update_ini_complete
 * ----------------------------------------------------
 * Autonomously update the status to XFER_INI_GL in
 * the recipient's system.
 *
 * Returns the new status.
 * ---------------------------------------------------

FUNCTION autonomous_update_ini_complete (
    p_trx_id    IN number) RETURN varchar2
IS
    PRAGMA AUTONOMOUS_TRANSACTION;
Line: 21

    SELECT status INTO l_status
    FROM fun_trx_headers
    WHERE trx_id = p_trx_id
    FOR UPDATE;
Line: 26

    l_status := fun_gl_transfer.update_status(p_trx_id, l_status);
Line: 29

END autonomous_update_ini_complete;
Line: 73

        SELECT rec.party_name
        INTO l_recipient_name
        FROM fun_trx_headers,
             hz_parties rec
        WHERE trx_id = l_trx_id
        AND    recipient_id = rec.party_id;
Line: 96

         select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
                0,h.reci_amount_dr,
                h.reci_amount_cr),'999999999D99'))||' '||b.currency_code
         into l_trx_amount
         from fun_trx_headers h, fun_trx_batches b
         where b.batch_id = l_batch_id
         and h.trx_id = l_trx_id;
Line: 114

        SELECT initiator_id INTO l_init_id
        FROM fun_trx_batches
        WHERE batch_id = l_batch_id;
Line: 123

            UPDATE fun_trx_headers
            SET init_wf_key = itemkey
            WHERE trx_id = l_trx_id;
Line: 131

            UPDATE fun_trx_headers
            SET reci_wf_key = itemkey
            WHERE trx_id = l_trx_id;
Line: 197

        SELECT currency_code, from_ledger_id, gl_date, gl_date,
               exchange_rate_type
          INTO l_trx_currency, l_ledger_id, l_gl_date, l_conv_date,
               l_conv_type
        FROM fun_trx_batches
        WHERE batch_id = l_batch_id;
Line: 208

            SELECT to_ledger_id INTO l_ledger_id
            FROM fun_trx_headers
            WHERE trx_id = l_trx_id;
Line: 224

        SELECT currency_code INTO l_gl_currency
        FROM gl_ledgers
        WHERE ledger_id = l_ledger_id;
Line: 310

        SELECT b.from_ledger_id, b.gl_date, b.currency_code,
               b.exchange_rate_type, b.gl_date, b.description
        INTO l_ledger_id, l_gl_date, l_trx_currency,
             l_conv_type, l_conv_date, l_desc
        FROM fun_trx_batches b
        WHERE b.batch_id = l_batch_id;
Line: 318

            SELECT to_ledger_id, description INTO l_ledger_id, l_desc
            FROM fun_trx_headers
            WHERE trx_id = l_trx_id;
Line: 330

            SELECT status INTO l_status
            FROM fun_trx_headers
            WHERE trx_id = l_trx_id;
Line: 379

        SELECT status INTO l_status
        FROM fun_trx_headers
        WHERE trx_id = l_trx_id;
Line: 433

        SELECT status INTO l_status
        FROM fun_trx_headers
        WHERE trx_id = l_trx_id;
Line: 455

        l_params.delete();
Line: 472

 * PROCEDURE update_ini_complete
 * ----------------------------------------------------
 * Update the status to XFER_INI_GL.
 * ---------------------------------------------------*/

PROCEDURE update_ini_complete (
    itemtype    IN varchar2,
    itemkey     IN varchar2,
    actid       IN number,
    funcmode    IN varchar2,
    resultout   IN OUT NOCOPY varchar2)
IS
    l_party_type    varchar2(1);
Line: 497

        SELECT status INTO l_status
        FROM fun_trx_headers
        WHERE trx_id = l_trx_id
        FOR UPDATE;
Line: 502

        l_status := fun_gl_transfer.update_status(l_trx_id, l_status, l_party_type);
Line: 518

            wf_core.context('FUN_GLINT_WF', 'UPDATE_INI_COMPLETE',
                            itemtype, itemkey, TO_CHAR(actid), funcmode);
Line: 521

END update_ini_complete;