PACKAGE: APPS.PO_NOTIFICATIONS_SV3

Source

1 PACKAGE po_notifications_sv3 AS
2 /* $Header: POXBWN3S.pls 120.0.12010000.1 2008/09/18 12:20:43 appldev noship $*/
3 
4 /*===========================================================================
5   PROCEDURE NAME: 	forward_all
6 
7   DESCRIPTION:		Forwards all notifications with message name
8 			'AWAITING_YOUR_APPROVAL' from one approval queue
9 			to another.
10 
11   PARAMETERS:		x_old_employee_id  IN NUMBER,
12 		        x_new_employee_id  IN NUMBER,
13 		        x_note	           IN VARCHAR2 DEFAULT NULL
14 
15   DESIGN REFERENCES:
16 
17   ALGORITHM:
18 
19   NOTES:
20 
21   OPEN ISSUES:
22 
23   CLOSED ISSUES:
24 
25   CHANGE HISTORY:	cmok	5/25	created
26 ===========================================================================*/
27 
28   PROCEDURE forward_all (x_old_employee_id  IN NUMBER,
29 		       x_new_employee_id  IN NUMBER,
30 		       x_note	          IN VARCHAR2 DEFAULT NULL);
31 
32 /*===========================================================================
33   PROCEDURE NAME: 	forward_document
34 
35   DESCRIPTION:		Forwards a notification with message name
36 			'AWAITING_YOUR_APPROVAL' from one approver
37 			to another.
38 
39   PARAMETERS:		x_new_employee_id      IN NUMBER,
40 			x_doc_type	       IN VARCHAR2,
41 			x_object_id	       IN NUMBER,
42 			x_note		       IN VARCHAR2
43 
44   DESIGN REFERENCES:
45 
46   ALGORITHM:
47 
48   NOTES:
49 
50   OPEN ISSUES:
51 
52   CLOSED ISSUES:
53 
54   CHANGE HISTORY:	cmok	5/25	created
55 ===========================================================================*/
56 
57   PROCEDURE forward_document (x_new_employee_id  IN NUMBER,
58 			    x_doc_type	       IN VARCHAR2,
59 			    x_object_id	       IN NUMBER,
60 			    x_note	       IN VARCHAR2 DEFAULT NULL);
61 
62 /*===========================================================================
63   PROCEDURE NAME: 	delete_from_fnd_notif
64 
65   DESCRIPTION:		This procedure is called by the post-delete trigger
66 			on po_notifications to delete the same notification
67 			from fnd_notifications.
68 
69   PARAMETERS:		n_object_type_lookup_code  IN VARCHAR2,
70 			n_object_id	           IN NUMBER
71 
72   DESIGN REFERENCES:
73 
74   ALGORITHM:
75 
76   NOTES:
77 
78   OPEN ISSUES:
79 
80   CLOSED ISSUES:
81 
82   CHANGE HISTORY:	cmok	5/25	created
83 ===========================================================================*/
84 
85   PROCEDURE delete_from_fnd_notif (n_object_type_lookup_code  IN VARCHAR2,
86 			   	   n_object_id	              IN NUMBER);
87 
88   FUNCTION get_emp_name (x_emp_id  NUMBER)
89 	return VARCHAR2;
90 
91 --  pragma restrict_references (get_emp_name, WNDS,WNPS);
92 
93   FUNCTION get_wf_role_id (x_role_name VARCHAR2)
94 	return number;
95 
96 --  pragma restrict_references (get_wf_role_id, WNDS,WNPS);
97 
98   FUNCTION get_doc_total (x_document_type_code	VARCHAR2,
99 			  x_object_id		NUMBER)
100 	return NUMBER;
101 --  pragma restrict_references (get_doc_total, WNDS);
102 
103 END po_notifications_sv3;