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: 85

select user_id
from jtf_rs_resource_extns
where source_id = p_source_id
and sysdate >= start_date_active
and sysdate <= nvl(end_date_active, sysdate)
and rownum < 2;

Line: 93

SELECT approval_access_id, approver_id, approver_type,action_code
FROM   DPP_APPROVAL_ACCESS
WHERE  approval_access_flag = 'Y'
AND    object_type = p_object_type
AND    object_id = p_object_id;

Line: 100

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: 107

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: 114

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

Line: 122

    SAVEPOINT  Update_User_Action_PVT;

Line: 163

             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: 209

       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: 241

	    -- Update AME with approvers action
	    if  l_approver_type = 'PERSON'  then
	       l_ame_approver_rec.person_id := l_approver_id;

Line: 252

		   l_ame_approver_rec.api_insertion  := ame_util.apiAuthorityInsertion;

Line: 254

		   l_ame_approver_rec.api_insertion  := ame_util.oamGenerated;

Line: 261

		   l_ame_approver_rec.api_insertion  := ame_util.apiAuthorityInsertion;

Line: 263

		   l_ame_approver_rec.api_insertion  := ame_util.oamGenerated;

Line: 267

	    -- Update AME of Approval Status
	    AME_API.updateApprovalStatus(applicationIdIn   => l_application_id
				   ,transactionIdIn   => p_approval_rec.object_id
				   ,approverIn        => l_ame_approver_rec
				   ,transactionTypeIn => p_approval_rec.object_type
				   ,forwardeeIn       => l_ame_forward_rec
				   );

Line: 317

        ROLLBACK TO  Update_User_Action_PVT;

Line: 331

        ROLLBACK TO  Update_User_Action_PVT;

Line: 345

        ROLLBACK TO  Update_User_Action_PVT;

Line: 363

END Update_User_Action;

Line: 398

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

Line: 628

           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: 669

              SELECT email_address
                INTO l_approver_email
                FROM per_all_people_f
               WHERE person_id = l_approversOut(i).person_id
                 AND sysdate BETWEEN effective_start_date AND effective_end_date;

Line: 690

              SELECT email_address
                INTO l_approver_email
                FROM fnd_user
               WHERE user_id = l_approversOut(i).user_id;

Line: 717

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

Line: 736

           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 = nvl(l_approversOut(i).person_id,l_approversOut(i).user_id);

Line: 759

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

Line: 860

SELECT DPP_APPROVAL_ACCESS_seq.NEXTVAL
FROM dual;

Line: 930

             dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');

Line: 933

          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 (
             l_approval_access_id
            ,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: 967

                dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');

Line: 1067

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;

Line: 1105

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

Line: 1186

SELECT name
FROM wf_events
WHERE name = p_event_name;

Line: 1445

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: 1452

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: 1615

    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: 1757

       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: 1785

          dpp_utility_pvt.debug_message( 'Update User Action ' || p_approval_rec.action_code  );

Line: 1789

       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: 1909

           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: 1919

               DPP_UTILITY_PVT.debug_message('Unable to Update  the column transaction_status in dpp_transaction_headers_all Table');