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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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:
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,
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 ,
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 ,
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,
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 ,