APPS.OKC_ARTWF_PVT dependencies on WF_NOTIFICATIONS

Line 1857: str wf_notifications.context%type;

1853: end transfer;
1854:
1855: function itemtype(nid in number) return varchar2
1856: is
1857: str wf_notifications.context%type;
1858: s number;
1859: begin
1860: select context into str
1861: from wf_notifications

Line 1861: from wf_notifications

1857: str wf_notifications.context%type;
1858: s number;
1859: begin
1860: select context into str
1861: from wf_notifications
1862: where notification_id = nid;
1863: s := instr(str,':',1,1)-1;
1864: return SUBSTR(str,1,s);
1865: exception when others then

Line 1871: str wf_notifications.context%type;

1867: end;
1868:
1869: function itemkey(nid in number) return varchar2
1870: is
1871: str wf_notifications.context%type;
1872: f number;
1873: s number;
1874: begin
1875: select context into str

Line 1876: from wf_notifications

1872: f number;
1873: s number;
1874: begin
1875: select context into str
1876: from wf_notifications
1877: where notification_id = nid;
1878: f := instr(str,':',1,1);
1879: s := instr(str,':',1,2)-f-1;
1880: return substr(str,f+1,s);