[Home] [Help]
PACKAGE: APPS.PO_NOTIFICATIONS_SV3
Source
1 PACKAGE po_notifications_sv3 AUTHID CURRENT_USER 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;