PACKAGE: APPS.AMW_PROCCERT_REMINDER_PKG

Source

1 PACKAGE AMW_PROCCERT_REMINDER_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwpsrms.pls 120.0.12000000.1 2007/01/16 20:40:54 appldev ship $ */
3 
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 --          AMW_PROCCERT_REMINDER_PKG
8 -- Purpose
9 --          Contains the PL/Sql Procedures that suppots Sending Process
10 --          Certification Reminders
11 -- History
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 PROCEDURE send_reminder_to_all_owners(
18 		  errbuf OUT NOCOPY  VARCHAR2,
19 		  retcode OUT NOCOPY      VARCHAR2) ;
20 
21 PROCEDURE update_lastreminder_date(
22 		  p_certificaion_id IN number,
23 		  x_return_status OUT NOCOPY VARCHAR2);
24 
25 PROCEDURE send_reminder_to_owner(
26 		  p_item_type           IN  VARCHAR2 := 'AMWNOTIF',
27 		  p_message_name        IN  VARCHAR2 := 'PROCESSCERTIFICATIONREMINDER',
28                   p_certification_id	in NUMBER,
29 		  p_process_owner_id	in NUMBER,
30 		  p_organization_id	in NUMBER := null,
31 		  p_process_id		in NUMBER := null,
32 		  x_return_status OUT NOCOPY VARCHAR2);
33 
34 PROCEDURE send_reminder_selected_procs(
35 		p_organization_id IN Number,
36 		p_entity_id IN Number,
37 		p_process_id In Number,
38 		x_return_status OUT NOCOPY VARCHAR2);
39 
40 END AMW_PROCCERT_REMINDER_PKG;