DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on AME_UTIL

Line 873: l_approver_record ame_util.approverRecord2;

869: l_message_type wf_notifications.message_type%TYPE;
870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:
873: l_approver_record ame_util.approverRecord2;
874: l_forwardee_record ame_util.approverRecord2;
875: l_user_id fnd_user.user_id%TYPE;
876: l_existing_forwardee VARCHAR2(1);
877: l_approver_table ame_util.approversTable2;

Line 874: l_forwardee_record ame_util.approverRecord2;

870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:
873: l_approver_record ame_util.approverRecord2;
874: l_forwardee_record ame_util.approverRecord2;
875: l_user_id fnd_user.user_id%TYPE;
876: l_existing_forwardee VARCHAR2(1);
877: l_approver_table ame_util.approversTable2;
878: -- Added for bug 9306359

Line 877: l_approver_table ame_util.approversTable2;

873: l_approver_record ame_util.approverRecord2;
874: l_forwardee_record ame_util.approverRecord2;
875: l_user_id fnd_user.user_id%TYPE;
876: l_existing_forwardee VARCHAR2(1);
877: l_approver_table ame_util.approversTable2;
878: -- Added for bug 9306359
879: l_user_email fnd_user.email_address%TYPE;
880:
881: CURSOR c_get_userid (p_user_name VARCHAR2) IS

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

935: END IF;
936: END IF;
937:
938: IF(l_result = 'APPROVE') or (l_result = 'APPROVED') THEN
939: l_approver_record.approval_status := AME_UTIL.approvedStatus;
940:
941: ame_api2.updateApprovalStatus(
942: applicationIdIn => 435,
943: transactionTypeIn => 'FUN_IC_RECI_TRX',

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

969: SET reject_reason = l_reason
970: WHERE trx_id = l_trx_id;
971:
972: -- Update the AME System with the 'APPROVED' status.
973: l_approver_record.approval_status := AME_UTIL.rejectStatus;
974:
975: ame_api2.updateApprovalStatus(
976: applicationIdIn => 435,
977: transactionTypeIn => 'FUN_IC_RECI_TRX',

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

1037: wf_notification.getInfo(l_nid, l_user_role, l_message_type,
1038: l_message_name, l_priority,
1039: l_due_date, l_ntf_status);
1040:
1041: l_approver_record.approval_status := AME_UTIL.forwardStatus;
1042: l_approver_record.name := l_user_role;
1043: l_forwardee_record.name := l_forward_role;
1044:
1045: ame_api2.updateApprovalStatus(

Line 1833: l_approver_record ame_util.approverRecord2;

1829: l_status varchar2(1);
1830: l_msg_count number;
1831: l_msg_data varchar2(1000);
1832: l_result varchar2(1);
1833: l_approver_record ame_util.approverRecord2;
1834: l_activity_name varchar2(30);
1835: l_user_id NUMBER;
1836: l_resp_id NUMBER;
1837: l_appl_id NUMBER;

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

1883: IF l_activity_name IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF',
1884: 'FIX_ACCT_DIST_NTF_NO_REJ', 'FIX_ACCT_DIST_NTF' )
1885: THEN
1886: l_approver_record.name := FND_GLOBAL.USER_NAME;
1887: l_approver_record.approval_status := AME_UTIL.approvedStatus;
1888:
1889: ame_api2.updateApprovalStatus(
1890: applicationIdIn => 435,
1891: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 1952: l_approver_record ame_util.approverRecord2;

1948: l_msg_count number;
1949: l_msg_data varchar2(1000);
1950: l_result varchar2(1);
1951: l_activity_name varchar2(30);
1952: l_approver_record ame_util.approverRecord2;
1953: BEGIN
1954: --Bug No:5897122.
1955: create_wf_roles(p_trx_id);
1956: --End: 5897122.

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

2004: p_update_status_to => 'REJECTED');
2005:
2006: -- Update the AME System with the 'APPROVED' status.
2007: l_approver_record.name := FND_GLOBAL.USER_NAME;
2008: l_approver_record.approval_status := AME_UTIL.rejectStatus;
2009:
2010: ame_api2.updateApprovalStatus(
2011: applicationIdIn => 435,
2012: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 2062: l_approver_record ame_util.approverRecord2;

2058: l_msg_count number;
2059: l_msg_data varchar2(1000);
2060: l_result varchar2(1);
2061: l_activity_name varchar2(30);
2062: l_approver_record ame_util.approverRecord2;
2063: BEGIN
2064: --Bug No:5897122.
2065: create_wf_roles(p_trx_id);
2066: --End: 5897122.

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

2107: p_update_status_to => 'REJECTED');
2108:
2109: -- Update the AME System with the 'APPROVED' status.
2110: l_approver_record.name := FND_GLOBAL.USER_NAME;
2111: l_approver_record.approval_status := AME_UTIL.rejectStatus;
2112:
2113: ame_api2.updateApprovalStatus(
2114: applicationIdIn => 435,
2115: transactionTypeIn => 'FUN_IC_RECI_TRX',

Line 2441: l_approver_record ame_util.approverRecord2;

2437: funcmode IN VARCHAR2,
2438: resultout OUT NOCOPY VARCHAR2 ) IS
2439:
2440: l_action_type VARCHAR2(20);
2441: l_approver_record ame_util.approverRecord2;
2442: l_trx_id NUMBER;
2443: l_user_id fnd_user.user_id%TYPE;
2444:
2445: l_status varchar2(1);