APPS.POR_NOTIFICATION_PKG dependencies on WF_NOTIFICATION

Line 32: from WF_NOTIFICATIONS WN

28: and orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');
29:
30: cursor attrs(user in varchar2, origSys in varchar2, origId in number) is
31: select WN.notification_id
32: from WF_NOTIFICATIONS WN
33: where WN.RECIPIENT_ROLE in
34: ((select user from dual) union all
35: (select role_name from wf_user_roles
36: where user_name = user and

Line 47: and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,

43: from PO_DOCUMENT_TYPES
44: union
45: select 'PORCPT' from dual)
46: and wn.status = 'OPEN'
47: and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,
48: WF_MESSAGE_ATTRIBUTES_VL MA,
49: WF_NOTIFICATIONS N
50: where
51: N.NOTIFICATION_ID=WN.NOTIFICATION_ID

Line 49: WF_NOTIFICATIONS N

45: select 'PORCPT' from dual)
46: and wn.status = 'OPEN'
47: and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,
48: WF_MESSAGE_ATTRIBUTES_VL MA,
49: WF_NOTIFICATIONS N
50: where
51: N.NOTIFICATION_ID=WN.NOTIFICATION_ID
52: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
53: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 73: subject1 := wf_notification.Getsubject(dummy_nid);

69: fetch attrs into dummy_nid;
70:
71: if (dummy_nid <>-999) then
72: nid1 := to_char(dummy_nid);
73: subject1 := wf_notification.Getsubject(dummy_nid);
74: end if;
75: dummy_nid := -999;
76: fetch attrs into dummy_nid;
77:

Line 80: subject2 := wf_notification.Getsubject(dummy_nid);

76: fetch attrs into dummy_nid;
77:
78: if (dummy_nid <>-999) then
79: nid2 := to_char(dummy_nid);
80: subject2 := wf_notification.Getsubject(dummy_nid);
81: end if;
82: dummy_nid := -999;
83: fetch attrs into dummy_nid;
84:

Line 87: subject3 := wf_notification.Getsubject(dummy_nid);

83: fetch attrs into dummy_nid;
84:
85: if (dummy_nid <> -999) then
86: nid3 := to_char(dummy_nid);
87: subject3 := wf_notification.Getsubject(dummy_nid);
88: end if;
89:
90: fetch attrs into dummy_nid1;
91: if (dummy_nid1 <> -999) then

Line 115: subject1 := wf_notification.Getsubject(nid1);

111: subject3 out nocopy varchar2) as
112: begin
113:
114: if (nid1 <>-999) then
115: subject1 := wf_notification.Getsubject(nid1);
116: end if;
117: if (nid2 <>-999) then
118: subject2 := wf_notification.Getsubject(nid2);
119: end if;

Line 118: subject2 := wf_notification.Getsubject(nid2);

114: if (nid1 <>-999) then
115: subject1 := wf_notification.Getsubject(nid1);
116: end if;
117: if (nid2 <>-999) then
118: subject2 := wf_notification.Getsubject(nid2);
119: end if;
120: if (nid3 <>-999) then
121: subject3 := wf_notification.Getsubject(nid3);
122: end if;

Line 121: subject3 := wf_notification.Getsubject(nid3);

117: if (nid2 <>-999) then
118: subject2 := wf_notification.Getsubject(nid2);
119: end if;
120: if (nid3 <>-999) then
121: subject3 := wf_notification.Getsubject(nid3);
122: end if;
123:
124:
125: exception