PACKAGE: APPS.CUG_INCIDNT_ATTR_VALS_PVT

Source

1 package CUG_INCIDNT_ATTR_VALS_PVT AUTHID CURRENT_USER as
2 /* $Header: CUGRINTS.pls 115.5 2003/06/24 17:46:46 pkesani ship $ */
3 
4 TYPE sr_rec is RECORD (
5      incidnt_attr_val_id	        NUMBER:=FND_API.G_MISS_NUM,
6      incident_id              	        NUMBER:=FND_API.G_MISS_NUM,
7      sr_question              VARCHAR2(240):=FND_API.G_MISS_CHAR,
8      override_addr_valid_flag              VARCHAR2(1):=FND_API.G_MISS_CHAR,
9      sr_answer              VARCHAR2(1997):=FND_API.G_MISS_CHAR,
10      start_date		       DATE        :=   FND_API.G_MISS_DATE,
11      end_date		        DATE        :=   FND_API.G_MISS_DATE,
12 	ATTRIBUTE_CATEGORY    VARCHAR2(150) := FND_API.G_MISS_CHAR,
13 	ATTRIBUTE1            VARCHAR2(150) := FND_API.G_MISS_CHAR,
14 	ATTRIBUTE2            VARCHAR2(150) := FND_API.G_MISS_CHAR,
15 	ATTRIBUTE3            VARCHAR2(150) := FND_API.G_MISS_CHAR,
16 	ATTRIBUTE4            VARCHAR2(150) := FND_API.G_MISS_CHAR,
17 	ATTRIBUTE5            VARCHAR2(150) := FND_API.G_MISS_CHAR,
18 	ATTRIBUTE6            VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 	ATTRIBUTE7            VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 	ATTRIBUTE8            VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 	ATTRIBUTE9            VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 	ATTRIBUTE10           VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 	ATTRIBUTE11           VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 	ATTRIBUTE12           VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 	ATTRIBUTE13           VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 	ATTRIBUTE14           VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 	ATTRIBUTE15           VARCHAR2(150) := FND_API.G_MISS_CHAR,
28   	OBJECT_VERSION_NUMBER 	NUMBER        := FND_API.G_MISS_NUM
29 );
30 
31 TYPE sr_tbl IS TABLE OF sr_rec INDEX BY BINARY_INTEGER;
32 
33 procedure CREATE_RUNTIME_DATA  (
34 	p_api_version     IN   NUMBER,
35 	p_init_msg_list          IN   VARCHAR2  := FND_API.G_FALSE,
36 	p_commit       IN VARCHAR          := FND_API.G_FALSE,
37 	p_sr_tbl  IN 	OUT NOCOPY sr_tbl,
38         x_msg_count	OUT     NOCOPY NUMBER,
39         x_msg_data	OUT     NOCOPY VARCHAR2,
40   	x_return_status	OUT     NOCOPY VARCHAR2 );
41 
42 
43   PROCEDURE launch_workflow 	  (
44     				   p_api_version        IN      NUMBER                                      ,
45     				   p_init_msg_list      IN      VARCHAR2    := FND_API.G_FALSE              ,
46     				   p_commit             IN      VARCHAR2    := FND_API.G_FALSE              ,
47     				   x_return_status      OUT     NOCOPY VARCHAR2                                    ,
48     				   x_msg_count          OUT     NOCOPY NUMBER                                      ,
49     				   x_msg_data           OUT     NOCOPY VARCHAR2                                    ,
50     				   p_incident_id        IN      NUMBER                                      ,
51                        p_source             IN      VARCHAR2 DEFAULT NULL                       );
52 
53 
54 
55 
56 
57  PROCEDURE Create_Address_Note (
58 		p_api_version    IN   NUMBER,
59 		p_init_msg_list  IN   VARCHAR2  := FND_API.G_FALSE,
60 		p_commit	 IN 	VARCHAR   := FND_API.G_FALSE,
61 		p_incident_id IN Number,
62 		x_msg_count		OUT  NOCOPY NUMBER,
63 		x_msg_data		OUT  NOCOPY VARCHAR2,
64   		x_return_status	OUT     NOCOPY VARCHAR2 ,
65 		x_note_id OUT NOCOPY NUMBER );
66 
67 end CUG_INCIDNT_ATTR_VALS_PVT ;