PACKAGE: APPS.OKC_TASK_ALERT_ESCL_PVT

Source

1 PACKAGE OKC_TASK_ALERT_ESCL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCPALTS.pls 120.0 2005/05/25 22:29:59 appldev noship $ */
3 	G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKC_TASK_ALERT_ESCALATE';
4  	G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
5 	G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
6   	G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
7   	G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
8 	G_LEVEL	       	       CONSTANT VARCHAR2(4)   := '_PVT';
9 	G_WORKFLOW_ACTIVE      CONSTANT VARCHAR2(200) := 'OKC_WORKFLOW_ACTIVE';
10   	G_WF_NAME_TOKEN        CONSTANT VARCHAR2(200) := 'WF_ITEM';
11   	G_WF_P_NAME_TOKEN      CONSTANT VARCHAR2(200) := 'WF_PROCESS';
12   	G_PROCESS_NOTFOUND     CONSTANT VARCHAR2(200) := 'OKC_PROCESS_NOT_FOUND';
13   	G_INVALID_VALUE	       CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14 
15 	g_api_version			NUMBER := 1.0;
16 	g_msg_count			NUMBER;
17 	g_msg_data			VARCHAR2(240);
18 	g_return_status			VARCHAR2(3);
19 
20 	--Procedure to send notifications to all the task owners before the due date
21 	PROCEDURE task_alert( errbuf   	OUT NOCOPY VARCHAR2,
22 			      retcode    	OUT NOCOPY VARCHAR2,
23 			      p_api_version	IN NUMBER,
24 			      p_init_msg_list	IN VARCHAR2 default OKC_API.G_FALSE,
25 			      p_wf_name		IN VARCHAR2,
26 			      p_wf_process	IN VARCHAR2);
27 
28 	--Procedure to escalate the task (Level 1)
29 	PROCEDURE task_escalation1(errbuf   		OUT NOCOPY VARCHAR2,
30 			      	   retcode    		OUT NOCOPY VARCHAR2,
31 				   p_api_version	IN NUMBER,
32 				   p_init_msg_list	IN VARCHAR2 default OKC_API.G_FALSE,
33 				   p_wf_name		IN VARCHAR2,
34 				   p_wf_process		IN VARCHAR2);
35 
36 	--Procedure to escalate the task (level 2)
37 	PROCEDURE task_escalation2(errbuf   		OUT NOCOPY VARCHAR2,
38 			           retcode    		OUT NOCOPY VARCHAR2,
39 				   p_api_version	IN NUMBER,
40 				   p_init_msg_list	IN VARCHAR2 default OKC_API.G_FALSE,
41 				   p_wf_name		IN VARCHAR2,
42 				   p_wf_process		IN VARCHAR2);
43 
44 	--Procedure to trigger the action assembler when the scheduled planned date is reached
45 	PROCEDURE okc_pdate_reach_pvt(errbuf   		OUT NOCOPY VARCHAR2,
46 			      	      retcode    	OUT NOCOPY VARCHAR2,
47 				      p_api_version	IN NUMBER,
48 				      p_init_msg_list	IN VARCHAR2 default OKC_API.G_FALSE);
49 
50 END OKC_TASK_ALERT_ESCL_PVT;