eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTWF_PVT dependencies on WF_NOTIFICATION

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);

Line 1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));

1944: 'OKC_ART_APPROVAL_NTF_SUBJECT_R',
1945: 'OKC_ART_ADOPTED_NTF_SUBJECT',
1946: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1947: fnd_message.set_token( token => 'ARTICLENUMBER',
1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));

Line 1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));

1946: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1947: fnd_message.set_token( token => 'ARTICLENUMBER',
1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1954: 'OKC_ART_APPROVAL_NTF_SUBJECT') then

Line 1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));

1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1954: 'OKC_ART_APPROVAL_NTF_SUBJECT') then
1955: fnd_message.set_token( token => 'APPROVERNAME',
1956: value => wf_engine.GetItemAttrText( itemtype, itemkey, 'REQUESTOR_DISPLAY_NAME'));

Line 1961: value => get_org_name(wf_notification.getAttrText(nid, 'ORGANIZATION$')));

1957: end if;
1958: if message_code in ( 'OKC_ART_ADOPTED_NTF_SUBJECT',
1959: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1960: fnd_message.set_token( token => 'ORGANIZATIONNAME',
1961: value => get_org_name(wf_notification.getAttrText(nid, 'ORGANIZATION$')));
1962: end if;
1963: document := fnd_message.get;
1964: end if;
1965: log('subject exit');

Line 2020: from wf_notification_attributes

2016: is
2017: cursor ntf_attrs(nid in varchar2)
2018: is
2019: select name
2020: from wf_notification_attributes
2021: where notification_id = nid;
2022: begin
2023: for attr in ntf_attrs(document_id) loop
2024: if attr.name like '#HDR%' then

Line 2026: wf_notification.SetAttrText( document_id, attr.name,

2022: begin
2023: for attr in ntf_attrs(document_id) loop
2024: if attr.name like '#HDR%' then
2025: if attr.name = '#HDR_TMPL_ORG_NAME' then
2026: wf_notification.SetAttrText( document_id, attr.name,
2027: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2028: elsif attr.name = '#HDR_ORG_NAME' then
2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));

Line 2027: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));

2023: for attr in ntf_attrs(document_id) loop
2024: if attr.name like '#HDR%' then
2025: if attr.name = '#HDR_TMPL_ORG_NAME' then
2026: wf_notification.SetAttrText( document_id, attr.name,
2027: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2028: elsif attr.name = '#HDR_ORG_NAME' then
2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2031: elsif attr.name = '#HDR_TMPL_INTENT' then

Line 2029: wf_notification.SetAttrText( document_id, attr.name,

2025: if attr.name = '#HDR_TMPL_ORG_NAME' then
2026: wf_notification.SetAttrText( document_id, attr.name,
2027: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2028: elsif attr.name = '#HDR_ORG_NAME' then
2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2031: elsif attr.name = '#HDR_TMPL_INTENT' then
2032: wf_notification.SetAttrText( document_id, attr.name,
2033: get_terms_intent_meaning( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));

Line 2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));

2026: wf_notification.SetAttrText( document_id, attr.name,
2027: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2028: elsif attr.name = '#HDR_ORG_NAME' then
2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2031: elsif attr.name = '#HDR_TMPL_INTENT' then
2032: wf_notification.SetAttrText( document_id, attr.name,
2033: get_terms_intent_meaning( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2034: end if;

Line 2032: wf_notification.SetAttrText( document_id, attr.name,

2028: elsif attr.name = '#HDR_ORG_NAME' then
2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2031: elsif attr.name = '#HDR_TMPL_INTENT' then
2032: wf_notification.SetAttrText( document_id, attr.name,
2033: get_terms_intent_meaning( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2034: end if;
2035: end if;
2036: end loop;

Line 2033: get_terms_intent_meaning( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));

2029: wf_notification.SetAttrText( document_id, attr.name,
2030: get_terms_org_name( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2031: elsif attr.name = '#HDR_TMPL_INTENT' then
2032: wf_notification.SetAttrText( document_id, attr.name,
2033: get_terms_intent_meaning( wf_notification.GetAttrNumber( document_id, 'TEMPLATE_ID')));
2034: end if;
2035: end if;
2036: end loop;
2037: document := null;