DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on AME_UTIL

Line 831: l_approver_record ame_util.approverRecord2;

827: l_message_type wf_notifications.message_type%TYPE;
828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:
831: l_approver_record ame_util.approverRecord2;
832: l_forwardee_record ame_util.approverRecord2;
833: l_user_id fnd_user.user_id%TYPE;
834:
835: CURSOR c_get_userid (p_user_name VARCHAR2) IS

Line 832: l_forwardee_record ame_util.approverRecord2;

828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:
831: l_approver_record ame_util.approverRecord2;
832: l_forwardee_record ame_util.approverRecord2;
833: l_user_id fnd_user.user_id%TYPE;
834:
835: CURSOR c_get_userid (p_user_name VARCHAR2) IS
836: SELECT usr.user_id

Line 872: l_approver_record.approval_status := AME_UTIL.approvedStatus;

868: CLOSE c_get_userid;
869: END IF;
870:
871: IF(l_result = 'APPROVE') or (l_result = 'APPROVED') THEN
872: l_approver_record.approval_status := AME_UTIL.approvedStatus;
873:
874: ame_api2.updateApprovalStatus(
875: applicationIdIn => 435,
876: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 906: l_approver_record.approval_status := AME_UTIL.rejectStatus;

902: SET reject_reason = l_reason
903: WHERE trx_id = l_trx_id;
904:
905: -- Update the AME System with the 'APPROVED' status.
906: l_approver_record.approval_status := AME_UTIL.rejectStatus;
907:
908: ame_api2.updateApprovalStatus(
909: applicationIdIn => 435,
910: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 952: l_approver_record.approval_status := AME_UTIL.forwardStatus;

948: l_message_name, l_priority,
949: l_due_date, l_ntf_status);
950:
951:
952: l_approver_record.approval_status := AME_UTIL.forwardStatus;
953: l_approver_record.name := l_user_role;
954: l_forwardee_record.name := l_forward_role;
955:
956: ame_api2.updateApprovalStatus(

Line 1718: l_approver_record ame_util.approverRecord2;

1714: l_status varchar2(1);
1715: l_msg_count number;
1716: l_msg_data varchar2(1000);
1717: l_result varchar2(1);
1718: l_approver_record ame_util.approverRecord2;
1719: l_activity_name varchar2(30);
1720:
1721: BEGIN
1722: --Bug No:5897122.

Line 1762: l_approver_record.approval_status := AME_UTIL.approvedStatus;

1758: IF l_activity_name IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF',
1759: 'FIX_ACCT_DIST_NTF_NO_REJ', 'FIX_ACCT_DIST_NTF' )
1760: THEN
1761: l_approver_record.name := FND_GLOBAL.USER_NAME;
1762: l_approver_record.approval_status := AME_UTIL.approvedStatus;
1763:
1764: ame_api2.updateApprovalStatus(
1765: applicationIdIn => 435,
1766: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 1827: l_approver_record ame_util.approverRecord2;

1823: l_msg_count number;
1824: l_msg_data varchar2(1000);
1825: l_result varchar2(1);
1826: l_activity_name varchar2(30);
1827: l_approver_record ame_util.approverRecord2;
1828: BEGIN
1829: --Bug No:5897122.
1830: create_wf_roles(p_trx_id);
1831: --End: 5897122.

Line 1883: l_approver_record.approval_status := AME_UTIL.rejectStatus;

1879: p_update_status_to => 'REJECTED');
1880:
1881: -- Update the AME System with the 'APPROVED' status.
1882: l_approver_record.name := FND_GLOBAL.USER_NAME;
1883: l_approver_record.approval_status := AME_UTIL.rejectStatus;
1884:
1885: ame_api2.updateApprovalStatus(
1886: applicationIdIn => 435,
1887: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 2213: l_approver_record ame_util.approverRecord2;

2209: funcmode IN VARCHAR2,
2210: resultout OUT NOCOPY VARCHAR2 ) IS
2211:
2212: l_action_type VARCHAR2(20);
2213: l_approver_record ame_util.approverRecord2;
2214: l_trx_id NUMBER;
2215: l_user_id fnd_user.user_id%TYPE;
2216:
2217: l_status varchar2(1);