APPS.DPP_APPROVAL_PVT SQL Statements

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

Line: 27

SELECT jre.resource_id
FROM   jtf_rs_resource_extns jre
WHERE  jre.resource_id = p_resource_id;

Line: 54

PROCEDURE Update_User_Action(
    p_api_version       IN  NUMBER
   ,p_init_msg_list     IN  VARCHAR2 := FND_API.G_FALSE
   ,p_validation_level  IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL

   ,x_return_status     OUT NOCOPY VARCHAR2
   ,x_msg_data          OUT NOCOPY VARCHAR2
   ,x_msg_count         OUT NOCOPY NUMBER

   ,p_approval_rec      IN  approval_rec_type
)
IS
l_api_name CONSTANT varchar2(80) := 'Update_User_Action';

Line: 82

l_updateItemIn boolean := false;

Line: 84

l_module 		CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.UPDATE_USER_ACTION';

Line: 87

select fu.user_id, fu.user_name
from  fnd_user fu
where fu.employee_id = p_source_id;

Line: 95

SELECT daa.approval_access_id, fu.user_id, fu.user_name
FROM   DPP_APPROVAL_ACCESS daa, FND_USER fu
WHERE  daa.approval_access_flag = 'Y'
AND    object_type = p_object_type
AND    object_id = p_object_id
AND    daa.approver_id = DECODE(daa.approver_type, 'PERSON', fu.employee_id, fu.user_id)
AND    fu.user_id = p_action_performed
AND    rownum < 2;

Line: 105

SELECT count(1)
FROM   DPP_APPROVAL_ACCESS
WHERE  approval_access_flag = 'Y'
AND    object_type = p_object_type
AND    object_id = p_object_id;

Line: 112

SELECT nvl(min(approval_level),0)
FROM   DPP_APPROVAL_ACCESS
WHERE  object_type = p_object_type
AND    approval_access_flag = 'Y'
AND    object_id   = p_object_id;

Line: 119

SELECT nvl(max(approval_level),0)
FROM   DPP_APPROVAL_ACCESS
WHERE  object_type = p_object_type
AND    object_id   = p_object_id;

Line: 128

    SAVEPOINT  Update_User_Action_PVT;

Line: 162

        UPDATE DPP_APPROVAL_ACCESS
        SET    action_code = p_approval_rec.action_code
        ,      action_date = SYSDATE
        ,      action_performed_by = p_approval_rec.action_performed_by
        WHERE  approval_access_id = l_approval_access_id;

Line: 205

       UPDATE DPP_APPROVAL_ACCESS
       SET    action_code = p_approval_rec.action_code
       ,      action_date = SYSDATE
       ,      action_performed_by = p_approval_rec.action_performed_by
       WHERE  object_type = p_approval_rec.object_type
       AND    object_id = p_approval_rec.object_id
       AND    approver_id = p_approval_rec.action_performed_by
       AND    approval_level = l_approver_level;

Line: 261

         l_ame_approver_rec.api_insertion  := ame_util.apiAuthorityInsertion;

Line: 263

         l_ame_approver_rec.api_insertion  := ame_util.oamGenerated;

Line: 267

      AME_API2.updateApprovalStatus(applicationIdIn   => l_application_id
                           ,transactionIdIn   => p_approval_rec.object_id
                           ,approverIn        => l_ame_approver_rec
                           ,transactionTypeIn => p_approval_rec.object_type
                           );

Line: 305

        ROLLBACK TO  Update_User_Action_PVT;

Line: 319

        ROLLBACK TO  Update_User_Action_PVT;

Line: 333

        ROLLBACK TO  Update_User_Action_PVT;

Line: 351

END Update_User_Action;

Line: 389

SELECT nvl(max(approval_level),0)
FROM   DPP_APPROVAL_ACCESS
WHERE  object_type = p_object_type
AND    object_id   = p_object_id;

Line: 443

dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);

Line: 668

           SELECT first_name,
                  last_name
             INTO l_first_name,
                  l_last_name
             FROM per_people_f
            WHERE person_id = l_approver_id
              AND rownum <2;

Line: 710

              SELECT email_address
                INTO l_approver_email
                FROM wf_roles
                WHERE orig_system_id = l_approversOut(i).orig_system_id
                AND orig_system = l_approversOut(i).orig_system;

Line: 742

           SELECT name
             INTO l_approver_group_name
             FROM ame_approval_groups
            WHERE approval_group_id = l_approversOut(i).group_or_chain_id;

Line: 761

           SELECT order_number
             INTO l_approver_sequence
             FROM AME_APPROVAL_GROUP_MEMBERS
            WHERE approval_group_id = l_approversOut(i).group_or_chain_id
              AND orig_system_id = l_approversOut(i).orig_system_id; --nvl(l_approversOut(i).orig_system_id,l_approversOut(i).user_id);

Line: 784

          p_approversOut(i).api_insertion := l_approversOut(i).api_insertion;

Line: 1069

		 dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module,  'before Inserting data into DPP_APPROVAL_ACCESS table');

Line: 1080

          INSERT INTO DPP_APPROVAL_ACCESS(
             approval_access_id
            ,object_version_number
            ,last_update_date
            ,last_updated_by
            ,creation_date
            ,created_by
            ,last_update_login
            ,object_type
            ,object_id
            ,approval_level
            ,approver_type
            ,approver_id
            ,approval_access_flag
            ,workflow_itemkey
          ) VALUES (
             DPP_APPROVAL_ACCESS_seq.NEXTVAL
            ,1
            ,SYSDATE
            ,G_USER_ID
            ,SYSDATE
            ,G_USER_ID
            ,G_LOGIN_ID
            ,p_approval_rec.object_type
            ,p_approval_rec.object_id
            ,p_approvers(i).approver_level
            ,p_approvers(i).approver_type
            ,p_approvers(i).approver_id
            ,'Y'
            ,l_workflow_itemkey
          );

Line: 1112

          dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module,  'after Inserting data into DPP_APPROVAL_ACCESS table');

Line: 1117

                dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');

Line: 1218

SELECT approval_access_id
FROM   DPP_APPROVAL_ACCESS
WHERE  approval_access_flag = 'Y'
AND    object_type = p_object_type
AND    object_id = p_object_id
AND action_code is not null;

Line: 1262

          UPDATE DPP_APPROVAL_ACCESS
          SET    approval_access_flag = 'N'
          WHERE  approval_access_id = l_approval_access_id;

Line: 1346

SELECT name
FROM wf_events
WHERE name = p_event_name;

Line: 1609

SELECT count(1)
FROM   dpp_approval_access
WHERE  object_type = p_object_type
AND    object_id = p_object_id
AND    approval_access_flag = 'Y';

Line: 1616

SELECT fu.user_name
FROM   dpp_approval_access oaa
,      fnd_user fu
WHERE  oaa.object_type = p_object_type
AND    oaa.object_id = p_object_id
AND    oaa.approver_type = 'USER'
AND    oaa.approver_id = fu.user_id
AND    oaa.approval_access_flag = 'Y'
UNION
SELECT jre.user_name
FROM   dpp_approval_access oaa
,      jtf_rs_resource_extns jre
WHERE  oaa.object_type = p_object_type
AND    oaa.object_id = p_object_id
AND    oaa.approver_type = 'PERSON'
AND    oaa.approver_id = jre.source_id
AND    oaa.approval_access_flag = 'Y'
group by jre.user_name;

Line: 1765

    update DPP_APPROVAL_ACCESS
    set workflow_itemkey = substr(l_item_key,1,239)
    where object_type = l_object_type
    and object_id = l_object_id
    and approval_level = ( select max (approval_level)
              from DPP_APPROVAL_ACCESS
              where object_type = l_object_type
              and object_id = l_object_id);

Line: 1908

       SELECT transaction_number,
              effective_start_date,
              to_number(org_id)
         INTO l_txn_number,
              l_effective_date,
              l_org_id
         FROM dpp_transaction_headers_all
        WHERE transaction_header_id = p_approval_rec.object_id;

Line: 1937

       dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module,  'Update User Action ' || p_approval_rec.action_code  );

Line: 1940

       Update_User_Action(
           p_api_version       => p_api_version
          ,p_init_msg_list     => FND_API.G_FALSE
          ,p_validation_level  => p_validation_level
          ,x_return_status     => l_return_status
          ,x_msg_data          => x_msg_data
          ,x_msg_count         => x_msg_count
          ,p_approval_rec      => p_approval_rec);

Line: 2064

           UPDATE dpp_transaction_headers_all
              SET transaction_status = 'APPROVED',
                  object_version_number = object_version_number + 1,
                  last_updated_by = l_user_id,
                  last_update_date = sysdate,
                  last_update_login = l_login_id
            WHERE transaction_header_id = p_approval_rec.object_id;

Line: 2074

               dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update  the column transaction_status in dpp_transaction_headers_all Table');

Line: 2078

           DPP_EXECUTIONPROCESS_PVT.Update_HeaderLog(
                  p_api_version_number => 1.0
              ,   p_init_msg_list      => FND_API.G_FALSE
              ,   p_commit             => FND_API.G_FALSE
              ,   p_validation_level   => FND_API.G_VALID_LEVEL_FULL
              ,   x_return_status      => l_return_status
              ,   x_msg_count          => x_msg_count
              ,   x_msg_data           => x_msg_data
              ,   p_transaction_header_id => p_approval_rec.object_id
            ) ;

Line: 2090

              fnd_file.put_line(fnd_file.log, ' Update_HeaderLog. Return Status: ' || l_return_status || ' Error Msg: ' || x_msg_data);