APPS.OKE_K_APPROVAL_WF dependencies on WF_NOTIFICATION

Line 1216: FROM wf_notifications

1212: CURSOR NtfDtls IS
1213: SELECT message_name
1214: , recipient_role
1215: , responder
1216: FROM wf_notifications
1217: WHERE notification_id = WF_ENGINE.CONTEXT_NID;
1218: NtfDtlRec NtfDtls%rowtype;
1219:
1220: Performer VARCHAR2(320);

Line 1261: ActionCode := WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' );

1257: WF_ENGINE.SetItemAttrText( ItemType , ItemKey , 'APPROVER' , Performer );
1258:
1259: IF ( NtfDtlRec.Message_Name = 'MSG_APPROVAL' ) THEN
1260:
1261: ActionCode := WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' );
1262:
1263: ELSIF ( NtfDtlRec.Message_Name = 'MSG_SIGNATURE' ) THEN
1264:
1265: IF ( WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' ) = 'Y' ) THEN

Line 1265: IF ( WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' ) = 'Y' ) THEN

1261: ActionCode := WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' );
1262:
1263: ELSIF ( NtfDtlRec.Message_Name = 'MSG_SIGNATURE' ) THEN
1264:
1265: IF ( WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'RESULT' ) = 'Y' ) THEN
1266: ActionCode := 'SIGNED';
1267: ELSE
1268: ActionCode := 'DID_NOT_SIGN';
1269: END IF;

Line 1282: -- , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'NOTE' )

1278: , ActionDate => sysdate
1279: , ApprovalPathID => G_Aprv_Path
1280: , ApprovalSeq => G_Aprv_Seq
1281: , ApproverRoleID => NULL
1282: -- , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'NOTE' )
1283: , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'WF_NOTE' )
1284: );
1285:
1286: ResultOut := 'COMPLETE:';

Line 1283: , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'WF_NOTE' )

1279: , ApprovalPathID => G_Aprv_Path
1280: , ApprovalSeq => G_Aprv_Seq
1281: , ApproverRoleID => NULL
1282: -- , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'NOTE' )
1283: , NoteText => WF_NOTIFICATION.GetAttrText( nid => WF_ENGINE.CONTEXT_NID , aname => 'WF_NOTE' )
1284: );
1285:
1286: ResultOut := 'COMPLETE:';
1287: RETURN;