APPS.OTA_WF dependencies on WF_NOTIFICATION

Line 1925: wf_notification.setAttrText ( p_nid

1921: (trunc
1922: (l_attribute_length/1950), l_max_no_of_attribs)
1923: LOOP
1924: l_counter := l_counter + 1;
1925: wf_notification.setAttrText ( p_nid
1926: , p_wf_attribute_name|| '_' ||x
1927: , substr( p_wf_attribute_value
1928: , ((x * 1950) - 1949)
1929: , 1950

Line 1940: wf_notification.setAttrText ( p_nid

1936: -- hold the remainder to the value.
1937: IF ((l_counter < l_max_no_of_attribs)
1938: AND mod(l_attribute_length,1950)<> 0) THEN
1939: l_next_attrib := l_counter + 1;
1940: wf_notification.setAttrText ( p_nid
1941: , p_wf_attribute_name|| '_' ||l_next_attrib
1942: , substr( p_wf_attribute_value
1943: , l_attribute_length
1944: - (mod (l_attribute_length,1950)- 1)

Line 1952: wf_notification.setAttrText ( p_nid

1948: END IF;
1949: ELSE
1950: -- There are less than 1950 chars in the value, so it can be stored
1951: -- whole in the first workflow attribute.
1952: wf_notification.setAttrText ( p_nid
1953: , p_wf_attribute_name|| '_' ||'1'
1954: , p_wf_attribute_value
1955: );
1956: END IF;

Line 1977: l_nid:=wf_notification.send( upper(p_user_name)

1973: l_nid number;
1974: BEGIN
1975: --
1976: l_message_type := 'OTWF';
1977: l_nid:=wf_notification.send( upper(p_user_name)
1978: , l_message_type
1979: , l_message_name
1980: );
1981: --

Line 1987: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);

1983: -- Notification
1984: --
1985: if(p_from_role is not null)
1986: then
1987: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
1988: end if;
1989: --
1990: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
1991: set_v2_attributes

Line 1990: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);

1986: then
1987: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
1988: end if;
1989: --
1990: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
1991: set_v2_attributes
1992: (p_wf_attribute_value => p_text_body
1993: ,p_wf_attribute_name => 'TEXT_BODY'
1994: ,p_nid => l_nid);

Line 1995: wf_notification.denormalize_notification(l_nid);

1991: set_v2_attributes
1992: (p_wf_attribute_value => p_text_body
1993: ,p_wf_attribute_name => 'TEXT_BODY'
1994: ,p_nid => l_nid);
1995: wf_notification.denormalize_notification(l_nid);
1996: commit;
1997: RETURN l_nid;
1998: END send_text_notification;
1999: --

Line 2020: l_nid:=wf_notification.send( upper(p_user_name)

2016: l_nid number;
2017: BEGIN
2018: --
2019: l_message_type := 'OTWF';
2020: l_nid:=wf_notification.send( upper(p_user_name)
2021: , l_message_type
2022: , l_message_name
2023: );
2024: --

Line 2030: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);

2026: -- Notification
2027: --
2028: if(p_from_role is not null)
2029: then
2030: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
2031: end if;
2032: --
2033: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
2034: set_v2_attributes

Line 2033: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);

2029: then
2030: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
2031: end if;
2032: --
2033: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
2034: set_v2_attributes
2035: (p_wf_attribute_value => p_html_body
2036: ,p_wf_attribute_name => 'HTML_BODY'
2037: ,p_nid => l_nid);

Line 2044: wf_notification.denormalize_notification(l_nid);

2040: (p_wf_attribute_value => p_text_body
2041: ,p_wf_attribute_name => 'TEXT_BODY'
2042: ,p_nid => l_nid);
2043: end if;
2044: wf_notification.denormalize_notification(l_nid);
2045: commit;
2046: RETURN l_nid;
2047: END send_html_text_notification;
2048: -- --------------------------------------------------------------------- *