[Home] [Help]
276: -- Bug: 14622502 - Removed created_by, added last_updated_by
277: SELECT p.PARTY_NAME PERSON_NAME
278: INTO l_initiator_person
279: FROM hz_parties p,
280: fnd_user fu,
281: fun_trx_batches b
282: WHERE fu.person_party_id = p.party_id
283: AND fu.user_id = b.last_updated_by
284: AND b.batch_id = l_batch_id;
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
879: l_user_email fnd_user.email_address%TYPE;
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
882: SELECT usr.user_id
883: FROM fnd_user usr
879: l_user_email fnd_user.email_address%TYPE;
880:
881: CURSOR c_get_userid (p_user_name VARCHAR2) IS
882: SELECT usr.user_id
883: FROM fnd_user usr
884: WHERE usr.user_name = p_user_name;
885:
886: -- Added for bug 9306359
887: CURSOR c_get_email_userid (p_user_email VARCHAR2) IS
885:
886: -- Added for bug 9306359
887: CURSOR c_get_email_userid (p_user_email VARCHAR2) IS
888: SELECT usr.user_id
889: FROM fnd_user usr
890: WHERE usr.email_address = p_user_email;
891: BEGIN
892: l_nid := wf_engine.context_nid;
893: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
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);
2446: l_msg_count number;
2447: l_msg_data varchar2(1000);