APPS.FUN_NET_APPROVAL_WF SQL Statements

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

Line: 43

        l_parameter_list.DELETE;

Line: 59

            SELECT batch_number,
                    batch_name,
                    response_date,
                    created_by,
                    total_netted_amt,
                    agreement_id,
                    batch_currency
            FROM fun_net_batches_all
            WHERE batch_id = cp_batch_id;

Line: 70

            SELECT employee_id
            FROM FND_USER
            WHERE user_id = cp_user_id;

Line: 75

            SELECT approver_name
            FROM fun_net_agreements_all
            WHERE agreement_id = cp_agreement_id;

Line: 167

           SELECT ORG_ID
             INTO L_ORG_ID
             FROM FUN_NET_BATCHES_ALL
            WHERE BATCH_ID = L_BATCH_ID;

Line: 188

            select batch_status_code into l_status from fun_net_batches_all
            where batch_id=l_batch_id;

Line: 208

        SELECT a.non_response_action_code
        FROM fun_net_agreements_all a
        WHERE a.agreement_id = (SELECT b.agreement_id
                                FROM fun_net_batches_all b
                                WHERE b.batch_id = cp_batch_id);

Line: 237

    PROCEDURE Update_Batch_status_rej(p_item_type    IN VARCHAR2,
                        p_item_key     IN VARCHAR2,
                        p_actid        IN NUMBER,
                        p_funmode      IN VARCHAR2,
                        p_result       OUT NOCOPY VARCHAR2) IS

        l_batch_id fun_net_batches_all.batch_id%TYPE;

Line: 247

        l_path := g_path||'Update_Batch_status';

Line: 249

        fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');

Line: 253

           FUN_NET_BATCHES_PKG.Update_Row
            (x_batch_id => l_batch_id,
            x_batch_status_code => 'REJECTED');

Line: 259

        fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');

Line: 261

    END Update_Batch_status_rej;

Line: 263

    PROCEDURE Update_Batch_status_err(p_item_type    IN VARCHAR2,
                        p_item_key     IN VARCHAR2,
                        p_actid        IN NUMBER,
                        p_funmode      IN VARCHAR2,
                        p_result       OUT NOCOPY VARCHAR2) IS

        l_batch_id fun_net_batches_all.batch_id%TYPE;

Line: 273

        l_path := g_path||'Update_Batch_status';

Line: 275

        fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');

Line: 279

           FUN_NET_BATCHES_PKG.Update_Row
            (x_batch_id => l_batch_id,
            x_batch_status_code => 'ERROR');

Line: 285

        fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');

Line: 287

    END Update_Batch_status_err;