APPS.OKC_REP_SIGN_WF_PVT dependencies on WF_NOTIFICATION

Line 923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

919:
920: CURSOR notif_csr (p_notification_id NUMBER) IS
921: SELECT fu.user_id user_id, fu.user_name user_name,
922: fu1.user_id original_user_id,fu1.user_name original_user_name
923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
924: WHERE fu.user_name = wfn.recipient_role
925: AND fu1.user_name = wfn.original_recipient
926: AND wfn.notification_id = p_notification_id ;
927:

Line 1000: l_wf_note := WF_NOTIFICATION.GetAttrText(

996: itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'CONTRACT_VERSION');
999: -- Get the signer comments
1000: l_wf_note := WF_NOTIFICATION.GetAttrText(
1001: nid => WF_ENGINE.context_nid,
1002: aname => 'WF_NOTE');
1003: -- Get the sign status
1004: l_SIGN_status := WF_NOTIFICATION.GetAttrText(

Line 1004: l_SIGN_status := WF_NOTIFICATION.GetAttrText(

1000: l_wf_note := WF_NOTIFICATION.GetAttrText(
1001: nid => WF_ENGINE.context_nid,
1002: aname => 'WF_NOTE');
1003: -- Get the sign status
1004: l_SIGN_status := WF_NOTIFICATION.GetAttrText(
1005: nid => WF_ENGINE.context_nid,
1006: aname => 'RESULT');
1007:
1008: OPEN c_get_contract_details_csr(l_contract_id);

Line 1014: l_control_number := WF_NOTIFICATION.GetAttrText(

1010: CLOSE c_get_contract_details_csr;
1011:
1012: IF(l_contract_type = 'REP_SBCR') THEN
1013:
1014: l_control_number := WF_NOTIFICATION.GetAttrText(
1015: nid => WF_ENGINE.context_nid,
1016: aname => 'CONTROL_NUMBER');
1017:
1018: IF (l_control_number IS NOT NULL) THEN