APPS.AHL_GENERIC_APRV_PVT SQL Statements

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

Line: 68

    SELECT resource_id
    FROM ahl_jtf_rs_emp_v
    WHERE user_id = p_requester_userid ;

Line: 1188

PROCEDURE Update_Status(itemtype        IN varchar2,
                        itemkey         IN varchar2,
                        actid           in  number,
                        funcmode        in  varchar2,
                        resultout       out nocopy varchar2    )
IS
dml_str              varchar2(2000);

Line: 1215

	Get_Api_Name('WORKFLOW', l_object, 'UPDATE_STATUS',l_approval_type, l_pkg_name, l_proc_name, l_return_status);

Line: 1240

                    'update_status',
                    itemtype, itemkey,l_error_msg);

Line: 1246

                    'update_status',
                    itemtype, itemkey,'Unexpected Error!');

Line: 1250

END Update_Status;

Line: 1261

PROCEDURE Approved_Update_Status(itemtype        IN varchar2,
                                 itemkey         IN varchar2,
                                 actid           in  number,
                                 funcmode        in  varchar2,
                                 resultout       out nocopy varchar2    )
IS
l_approved_status        VARCHAR(30);

Line: 1281

                             aname      =>  'UPDATE_GEN_STATUS',
                             avalue     =>   l_approved_status  );

Line: 1284

	Update_Status(itemtype => itemtype,
                   itemkey => itemkey,
                     actid => actid,
                  funcmode => funcmode,
                 resultout => resultout);

Line: 1294

                        'Approved_Update_Status',
                        itemtype, itemkey,to_char(actid),'Unexpected Error!');

Line: 1299

END Approved_Update_Status;

Line: 1310

PROCEDURE Rejected_Update_Status(itemtype      IN varchar2,
                        itemkey              IN varchar2,
                        actid                in  number,
                        funcmode             in  varchar2,
                        resultout            out nocopy varchar2    )
IS
l_rejected_status        VARCHAR(30);

Line: 1330

                             aname      =>  'UPDATE_GEN_STATUS',
                             avalue     =>   l_rejected_status  );

Line: 1333

	Update_Status(itemtype => itemtype,
                   itemkey => itemkey,
                     actid => actid,
                  funcmode => funcmode,
                 resultout => resultout);

Line: 1343

                        'Rejected_Update_Status',
                        itemtype, itemkey,to_char(actid),'Unexpected Error!');

Line: 1348

END Rejected_Update_Status;

Line: 1472

	SELECT approval_rule_id, seeded_flag
	FROM ahl_approval_rules_b
	WHERE nvl(operating_unit_id,l_operating_unit_id)  = l_operating_unit_id
	AND approval_object_code                          = p_object
	AND nvl(approval_type_code, l_approval_type_code) = l_approval_type_code
	AND nvl(approval_priority_code,l_priority)        = l_priority
	AND seeded_flag                                   = 'N'
	AND nvl(application_usg_code, l_application_usg_code) = l_application_usg_code
	AND status_code                                   = 'ACTIVE'
	and sysdate between nvl(active_start_date,sysdate -1 ) and nvl(active_end_date,sysdate + 1)
   	order by  (power(2,decode(operating_unit_id,'',0,2)) +
               power(2,decode(approval_priority_code,'',0,1)  )) desc ;

Line: 1487

  SELECT approval_rule_id, seeded_flag
    FROM ahl_approval_rules_b
   WHERE seeded_flag = 'Y'
   AND nvl(application_usg_code, l_application_usg_code) = l_application_usg_code;

Line: 1495

  SELECT min(approver_sequence)
    FROM ahl_approvers
   WHERE approval_rule_id  = x_approval_rule_id;

Line: 1579

	SELECT  approval_approver_id,
			approver_type_code,
			approver_id
	FROM ahl_approvers
	WHERE approval_rule_id = p_rule_id
	AND approver_sequence  = p_current_seq;

Line: 1587

	SELECT rr.ROLE_RESOURCE_ID
	FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb
	WHERE rr.role_id = rb.role_id
	AND rb.role_type_code in( 'AHLGAPPR','AHLAPPR')
	AND rr.ROLE_ID   = x_object_approver_id
	AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
	AND rr.delete_flag = 'N'
	and sysdate between nvl(rr.start_date_active,sysdate -1 ) and nvl(rr.end_date_active,sysdate + 1);

Line: 1597

	SELECT count(1)
	FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb
	WHERE rr.role_id = rb.role_id
    AND rb.role_type_code in( 'AHLGAPPR','AHLAPPR')
	AND rr.ROLE_ID   = x_object_approver_id
	AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
	AND rr.delete_flag = 'N'
	and sysdate between nvl(rr.start_date_active,sysdate -1 ) and nvl(rr.end_date_active,sysdate + 1);

Line: 1607

	SELECT rr.role_id
	FROM jtf_rs_role_relations rr,
			jtf_rs_roles_vl rl
	WHERE rr.role_id = rl.role_id
	and  rl.role_type_code ='AHLAPPR'
	AND rl.role_code   = 'AHL_DEFAULT_APPROVER'
	AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
	AND delete_flag = 'N'
	AND sysdate between rr.start_date_active and nvl(rr.end_date_active,sysdate);

Line: 1700

     SELECT package_name, procedure_name
       FROM ahl_approval_api
      WHERE api_used_by = p_api_used_by
        AND approval_object_type = p_object
        AND activity_type = p_activity_type
	    AND approval_type = p_approval_type;

Line: 1800

    SELECT 1 FROM FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE'
    AND LOOKUP_CODE = p_appl_usg_code;

Line: 1839

	SELECT employee_id source_id
	FROM ahl_jtf_rs_emp_v
	WHERE resource_id = p_resource_id ;

Line: 1889

	SELECT approver_sequence
	FROM ahl_approvers
	WHERE approval_rule_id = p_rule_id
	AND approver_sequence > p_current_seq
	order by approver_sequence  ;