5: -- Declare Data Types
6: -- ---------------------------------------------------------
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
6: -- ---------------------------------------------------------
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
8: (
9: context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
9: context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
17: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
25: );
18: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
25: );
26:
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
25: );
26:
27: TYPE OrderInfo_Rec_Type IS RECORD
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
25: );
26:
27: TYPE OrderInfo_Rec_Type IS RECORD
28: (
25: );
26:
27: TYPE OrderInfo_Rec_Type IS RECORD
28: (
29: line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
30: line_service_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM
31: );
32:
33: TYPE PRICE_ATT_Rec_Type IS RECORD
26:
27: TYPE OrderInfo_Rec_Type IS RECORD
28: (
29: line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
30: line_service_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM
31: );
32:
33: TYPE PRICE_ATT_Rec_Type IS RECORD
34: (
31: );
32:
33: TYPE PRICE_ATT_Rec_Type IS RECORD
34: (
35: PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32:
33: TYPE PRICE_ATT_Rec_Type IS RECORD
34: (
35: PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: TYPE PRICE_ATT_Rec_Type IS RECORD
34: (
35: PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: (
35: PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117: PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118: PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119: PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120: PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121: PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123: PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126: PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127: PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135: PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
128: PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135: PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
136: );
129: PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135: PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
136: );
137:
130: PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135: PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
136: );
137:
138: TYPE ReturnInfo_Rec_Type IS RECORD
131: PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134: PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135: PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
136: );
137:
138: TYPE ReturnInfo_Rec_Type IS RECORD
139: (
136: );
137:
138: TYPE ReturnInfo_Rec_Type IS RECORD
139: (
140: return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
141: rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
142: actual_returned_date DATE DEFAULT FND_API.G_MISS_DATE
143: );
144:
137:
138: TYPE ReturnInfo_Rec_Type IS RECORD
139: (
140: return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
141: rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
142: actual_returned_date DATE DEFAULT FND_API.G_MISS_DATE
143: );
144:
145: TYPE CP_Prod_Rec_Type IS RECORD
138: TYPE ReturnInfo_Rec_Type IS RECORD
139: (
140: return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
141: rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
142: actual_returned_date DATE DEFAULT FND_API.G_MISS_DATE
143: );
144:
145: TYPE CP_Prod_Rec_Type IS RECORD
146: (
143: );
144:
145: TYPE CP_Prod_Rec_Type IS RECORD
146: (
147: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149: cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
144:
145: TYPE CP_Prod_Rec_Type IS RECORD
146: (
147: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149: cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
145: TYPE CP_Prod_Rec_Type IS RECORD
146: (
147: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149: cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
146: (
147: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149: cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
147: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149: cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
150: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
151: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
152: misc_order_info OrderInfo_Rec_Type,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
153: misc_return_info ReturnInfo_Rec_Type,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
154: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
156: net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
158: po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
160: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
162: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165: bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166: install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
167: installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
168: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
169: config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
170: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
171: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173: platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
175: merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176: desc_flex DFF_Rec_Type,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: price_attribs PRICE_ATT_Rec_Type,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
178: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
179: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
187: );
180: invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
187: );
188:
181: expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
187: );
188:
189:
182: customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183: split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
187: );
188:
189:
190: TYPE CP_Ship_Rec_Type IS RECORD
188:
189:
190: TYPE CP_Ship_Rec_Type IS RECORD
191: (
192: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
189:
190: TYPE CP_Ship_Rec_Type IS RECORD
191: (
192: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
190: TYPE CP_Ship_Rec_Type IS RECORD
191: (
192: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
191: (
192: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
192: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200: revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
193: cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200: revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
201: );
194: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200: revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
201: );
202:
195: shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200: revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
201: );
202:
203:
196: shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200: revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
201: );
202:
203:
204: TYPE Cascade_Upd_Flag_Rec_Type IS RECORD
202:
203:
204: TYPE Cascade_Upd_Flag_Rec_Type IS RECORD
205: (
206: cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
203:
204: TYPE Cascade_Upd_Flag_Rec_Type IS RECORD
205: (
206: cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
204: TYPE Cascade_Upd_Flag_Rec_Type IS RECORD
205: (
206: cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
205: (
206: cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
206: cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207: start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208: end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209: misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210: misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211: delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212: system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213: prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214: ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222: task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
215: bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222: task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
223: );
216: install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222: task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
223: );
224:
217: installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222: task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
223: );
224:
225:
218: config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219: config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220: shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221: project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222: task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
223: );
224:
225:
226: TYPE Abort_Upd_On_Warn_Rec_Type IS RECORD
224:
225:
226: TYPE Abort_Upd_On_Warn_Rec_Type IS RECORD
227: (
228: srl_owned_by_diff_cust VARCHAR2(1) DEFAULT FND_API.G_TRUE,
229: srl_exists_for_diff_item VARCHAR2(1) DEFAULT FND_API.G_TRUE
230: );
231:
232:
225:
226: TYPE Abort_Upd_On_Warn_Rec_Type IS RECORD
227: (
228: srl_owned_by_diff_cust VARCHAR2(1) DEFAULT FND_API.G_TRUE,
229: srl_exists_for_diff_item VARCHAR2(1) DEFAULT FND_API.G_TRUE
230: );
231:
232:
233: TYPE Config_Rec_Type IS RECORD
231:
232:
233: TYPE Config_Rec_Type IS RECORD
234: (
235: config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
232:
233: TYPE Config_Rec_Type IS RECORD
234: (
235: config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
233: TYPE Config_Rec_Type IS RECORD
234: (
235: config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
234: (
235: config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
242: );
235: config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
242: );
243:
236: config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
242: );
243:
244: TYPE Config_Tbl_Type IS TABLE OF Config_Rec_Type
237: config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
242: );
243:
244: TYPE Config_Tbl_Type IS TABLE OF Config_Rec_Type
245: INDEX BY BINARY_INTEGER;
246:
247:
248: TYPE CP_Param_Rec_Type IS RECORD
249: (
250: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
247:
248: TYPE CP_Param_Rec_Type IS RECORD
249: (
250: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
248: TYPE CP_Param_Rec_Type IS RECORD
249: (
250: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
249: (
250: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257: end_date_active DATE DEFAULT FND_API.G_MISS_DATE
250: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257: end_date_active DATE DEFAULT FND_API.G_MISS_DATE
258: );
251: parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257: end_date_active DATE DEFAULT FND_API.G_MISS_DATE
258: );
259:
252: name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257: end_date_active DATE DEFAULT FND_API.G_MISS_DATE
258: );
259:
260:
253: value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254: status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255: application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257: end_date_active DATE DEFAULT FND_API.G_MISS_DATE
258: );
259:
260:
261: TYPE CP_Query_IP_Rec_Type IS RECORD
261: TYPE CP_Query_IP_Rec_Type IS RECORD
262: (
263: cp_rec CP_Prod_Rec_Type,
264: ship_rec CP_Ship_Rec_Type,
265: party_id NUMBER DEFAULT FND_API.G_MISS_NUM,
266: svc_provider_id NUMBER DEFAULT FND_API.G_MISS_NUM
267: );
268:
269:
262: (
263: cp_rec CP_Prod_Rec_Type,
264: ship_rec CP_Ship_Rec_Type,
265: party_id NUMBER DEFAULT FND_API.G_MISS_NUM,
266: svc_provider_id NUMBER DEFAULT FND_API.G_MISS_NUM
267: );
268:
269:
270: TYPE CP_Query_OP_Rec_Type IS RECORD
268:
269:
270: TYPE CP_Query_OP_Rec_Type IS RECORD
271: (
272: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
269:
270: TYPE CP_Query_OP_Rec_Type IS RECORD
271: (
272: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
270: TYPE CP_Query_OP_Rec_Type IS RECORD
271: (
272: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278: ship_date DATE DEFAULT FND_API.G_MISS_DATE
271: (
272: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278: ship_date DATE DEFAULT FND_API.G_MISS_DATE
279: );
272: cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278: ship_date DATE DEFAULT FND_API.G_MISS_DATE
279: );
280:
273: account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278: ship_date DATE DEFAULT FND_API.G_MISS_DATE
279: );
280:
281:
274: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275: inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278: ship_date DATE DEFAULT FND_API.G_MISS_DATE
279: );
280:
281:
282: TYPE CP_Query_OP_Tbl_Type IS TABLE OF CP_Query_OP_Rec_Type
284:
285:
286: TYPE CP_Contact_Rec_Type IS RECORD
287: (
288: source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
285:
286: TYPE CP_Contact_Rec_Type IS RECORD
287: (
288: source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
286: TYPE CP_Contact_Rec_Type IS RECORD
287: (
288: source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
287: (
288: source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
288: source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
289: source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
290: contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
298: desc_flex DFF_Rec_Type
291: contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
298: desc_flex DFF_Rec_Type
299: );
292: contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
298: desc_flex DFF_Rec_Type
299: );
300:
293: svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294: primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295: preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
298: desc_flex DFF_Rec_Type
299: );
300:
301: -- Added the line_inst_detail_id to this record type becoz this same record type
306:
307:
308: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
309: (
310: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
307:
308: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
309: (
310: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
308: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
309: (
310: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
309: (
310: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
310: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
311: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
313: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
316: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
317: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
325: --desc_flex DFF_Rec_Type
318: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
325: --desc_flex DFF_Rec_Type
326: );
319: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
325: --desc_flex DFF_Rec_Type
326: );
327:
320: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
325: --desc_flex DFF_Rec_Type
326: );
327:
328: TYPE Line_Inst_Dtl_Tbl_Type is TABLE OF Line_Inst_Dtl_Rec_Type
340: --
341: -- Standard IN Parameters:
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Optional
344: -- Default = FND_API.G_FALSE
345: -- p_commit IN VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: --
348: -- Standard OUT NOCOPY Parameters:
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Optional
344: -- Default = FND_API.G_FALSE
345: -- p_commit IN VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: --
348: -- Standard OUT NOCOPY Parameters:
349: -- x_return_status OUT NOCOPY VARCHAR2(1)
350: -- x_msg_count OUT NOCOPY NUMBER
366:
367: PROCEDURE Create_Base_Product
368: (
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
371: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
367: PROCEDURE Create_Base_Product
368: (
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
371: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_cp_rec IN CP_Prod_Rec_Type,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_cp_rec IN CP_Prod_Rec_Type,
376: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
377: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
378: x_cp_id OUT NOCOPY NUMBER,
379: x_object_version_number OUT NOCOPY NUMBER
380: );
381:
390: --
391: -- Standard IN Parameters:
392: -- p_api_version IN NUMBER Required
393: -- p_init_msg_list IN VARCHAR2 Optional
394: -- Default = FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: --
398: -- Standard OUT NOCOPY Parameters:
392: -- p_api_version IN NUMBER Required
393: -- p_init_msg_list IN VARCHAR2 Optional
394: -- Default = FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: --
398: -- Standard OUT NOCOPY Parameters:
399: -- x_return_status OUT NOCOPY VARCHAR2(1)
400: -- x_msg_count OUT NOCOPY NUMBER
416:
417: PROCEDURE Record_Shipment_Info
418: (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
417: PROCEDURE Record_Shipment_Info
418: (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_ship_rec IN CP_Ship_Rec_Type,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_ship_rec IN CP_Ship_Rec_Type,
426: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: x_new_cp_id OUT NOCOPY NUMBER
428: );
429:
430: --------------------------------------------------------------------------
439: --
440: -- Standard IN Parameters:
441: -- p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_commit IN VARCHAR2 Optional
445: -- Default = FND_API.G_FALSE
446: --
447: -- Standard OUT NOCOPY Parameters:
441: -- p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_commit IN VARCHAR2 Optional
445: -- Default = FND_API.G_FALSE
446: --
447: -- Standard OUT NOCOPY Parameters:
448: -- x_return_status OUT NOCOPY VARCHAR2(1)
449: -- x_msg_count OUT NOCOPY NUMBER
453: -- p_cp_id IN NUMBER Required
454: -- p_old_cp_status_id IN NUMBER Required
455: -- p_cp_rec IN CP_Prod_Rec_Type Required
456: -- p_inherit_contacts IN VARCHAR2 Optional
457: -- Default = FND_API.G_FALSE
458: -- p_upgrade IN VARCHAR2 Optional
459: -- Default = FND_API.G_FALSE
460: --
461: -- Replace_Product OUT NOCOPY Parameters:
455: -- p_cp_rec IN CP_Prod_Rec_Type Required
456: -- p_inherit_contacts IN VARCHAR2 Optional
457: -- Default = FND_API.G_FALSE
458: -- p_upgrade IN VARCHAR2 Optional
459: -- Default = FND_API.G_FALSE
460: --
461: -- Replace_Product OUT NOCOPY Parameters:
462: -- x_new_cp_id OUT NOCOPY NUMBER
463: --
470:
471: PROCEDURE Replace_Product
472: (
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
475: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
471: PROCEDURE Replace_Product
472: (
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
475: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
479: p_cp_id IN NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
479: p_cp_id IN NUMBER,
480: p_old_cp_status_id IN NUMBER,
481: p_cp_rec IN CP_Prod_Rec_Type,
482: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
485: x_new_cp_id OUT NOCOPY NUMBER,
486: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: p_cp_id IN NUMBER,
480: p_old_cp_status_id IN NUMBER,
481: p_cp_rec IN CP_Prod_Rec_Type,
482: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
485: x_new_cp_id OUT NOCOPY NUMBER,
486: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
487: );
480: p_old_cp_status_id IN NUMBER,
481: p_cp_rec IN CP_Prod_Rec_Type,
482: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
485: x_new_cp_id OUT NOCOPY NUMBER,
486: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
487: );
488:
482: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
485: x_new_cp_id OUT NOCOPY NUMBER,
486: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
487: );
488:
489: --------------------------------------------------------------------------
490:
499: --
500: -- Standard IN Parameters:
501: -- p_api_version IN NUMBER Required
502: -- p_init_msg_list IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_commit IN VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: --
507: -- Standard OUT OCOPY Parameters:
501: -- p_api_version IN NUMBER Required
502: -- p_init_msg_list IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_commit IN VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: --
507: -- Standard OUT OCOPY Parameters:
508: -- x_return_status OUT NOCOPY VARCHAR2(1)
509: -- x_msg_count OUT NOCOPY NUMBER
517: -- p_ship_rec IN CP_Ship_Rec_Type Required
518: -- p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type Required
519: -- p_cascade_updates_flagIN Cascade_Upd_Flag_Rec_Type Required
520: -- p_cascade_inst_date_change_war IN VARCHAR2 Optional
521: -- Default=FND_API.G_TRUE,
522: -- p_comments IN VARCHAR2 Optional
523: -- Default=NULL,
524: -- p_update_by_customer_flag IN VARCHAR2 Optional
525: -- Default=FND_API.G_TRUE
521: -- Default=FND_API.G_TRUE,
522: -- p_comments IN VARCHAR2 Optional
523: -- Default=NULL,
524: -- p_update_by_customer_flag IN VARCHAR2 Optional
525: -- Default=FND_API.G_TRUE
526: -- The last parameter indicates whether this update to the record is being made
527: -- by a customer (from iSupport UI) or by an agent of the merchant. A customer
528: -- will be able to update only those records in the customer's view but a
529: -- merchant will be able to update both records in the merchant's view as well
541:
542: PROCEDURE Update_Product
543: (
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
546: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
542: PROCEDURE Update_Product
543: (
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
546: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_cp_id IN NUMBER,
551: p_as_of_date IN DATE DEFAULT sysdate,
552: p_cp_rec IN CP_Prod_Rec_Type,
553: p_ship_rec IN CP_Ship_Rec_Type,
554: p_comments IN VARCHAR2 DEFAULT NULL,
555: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
556: p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type,
557: p_cascade_updates_flag IN Cascade_Upd_Flag_Rec_Type,
558: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
559: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
554: p_comments IN VARCHAR2 DEFAULT NULL,
555: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
556: p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type,
557: p_cascade_updates_flag IN Cascade_Upd_Flag_Rec_Type,
558: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
559: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
560: );
561: --------------------------------------------------------------------------
562:
555: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
556: p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type,
557: p_cascade_updates_flag IN Cascade_Upd_Flag_Rec_Type,
558: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
559: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
560: );
561: --------------------------------------------------------------------------
562:
563: -- Start of comments
568: --
569: -- Standard IN Parameters:
570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Optional
572: -- Default = FND_API.G_FALSE
573: -- p_commit IN VARCHAR2 Optional
574: -- Default = FND_API.G_FALSE
575: --
576: -- Standard OUT NOCOPY Parameters:
570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Optional
572: -- Default = FND_API.G_FALSE
573: -- p_commit IN VARCHAR2 Optional
574: -- Default = FND_API.G_FALSE
575: --
576: -- Standard OUT NOCOPY Parameters:
577: -- x_return_status OUT NOCOPY VARCHAR2(1)
578: -- x_msg_count OUT NOCOPY NUMBER
584: -- p_quantity IN NUMBER Required
585: -- p_order_info IN OrderInfo_Rec_Type Required
586: -- p_desc_flex IN DFF_Rec_Type Required
587: -- p_start_date_active IN DATE Optional
588: -- Default = FND_API.G_MISS_DATE
589: -- p_end_date_active IN DATE Optional
590: -- Default = FND_API.G_MISS_DATE
591: -- p_delivered_flag IN VARCHAR2(1) Optional
592: -- Default = FND_API.G_MISS_CHAR
586: -- p_desc_flex IN DFF_Rec_Type Required
587: -- p_start_date_active IN DATE Optional
588: -- Default = FND_API.G_MISS_DATE
589: -- p_end_date_active IN DATE Optional
590: -- Default = FND_API.G_MISS_DATE
591: -- p_delivered_flag IN VARCHAR2(1) Optional
592: -- Default = FND_API.G_MISS_CHAR
593:
594: -- Create_Revision OUT NOCOPY Parameters:
588: -- Default = FND_API.G_MISS_DATE
589: -- p_end_date_active IN DATE Optional
590: -- Default = FND_API.G_MISS_DATE
591: -- p_delivered_flag IN VARCHAR2(1) Optional
592: -- Default = FND_API.G_MISS_CHAR
593:
594: -- Create_Revision OUT NOCOPY Parameters:
595: -- x_cp_rev_id OUT NOCOPY NUMBER
596: -- x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2
604:
605: PROCEDURE Create_Revision
606: (
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
609: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
605: PROCEDURE Create_Revision
606: (
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
609: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: p_cp_id IN NUMBER,
613: p_cp_id IN NUMBER,
614: p_rev_inv_item_id IN NUMBER,
615: p_order_info IN OrderInfo_Rec_Type,
616: p_desc_flex IN DFF_Rec_Type,
617: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
618: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
619: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
620: x_cp_rev_id OUT NOCOPY NUMBER,
621: x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2,
614: p_rev_inv_item_id IN NUMBER,
615: p_order_info IN OrderInfo_Rec_Type,
616: p_desc_flex IN DFF_Rec_Type,
617: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
618: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
619: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
620: x_cp_rev_id OUT NOCOPY NUMBER,
621: x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2,
622: x_object_version_number OUT NOCOPY NUMBER
615: p_order_info IN OrderInfo_Rec_Type,
616: p_desc_flex IN DFF_Rec_Type,
617: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
618: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
619: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
620: x_cp_rev_id OUT NOCOPY NUMBER,
621: x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2,
622: x_object_version_number OUT NOCOPY NUMBER
623: );
625:
626: PROCEDURE Update_Revision
627: (
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
630: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
631: x_return_status OUT NOCOPY VARCHAR2,
632: x_msg_count OUT NOCOPY NUMBER,
633: x_msg_data OUT NOCOPY VARCHAR2,
626: PROCEDURE Update_Revision
627: (
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
630: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
631: x_return_status OUT NOCOPY VARCHAR2,
632: x_msg_count OUT NOCOPY NUMBER,
633: x_msg_data OUT NOCOPY VARCHAR2,
634: p_cp_rev_id IN NUMBER,
632: x_msg_count OUT NOCOPY NUMBER,
633: x_msg_data OUT NOCOPY VARCHAR2,
634: p_cp_rev_id IN NUMBER,
635: p_object_version_number IN NUMBER,
636: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
637: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
638: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
639: x_object_version_number OUT NOCOPY NUMBER
640: );
633: x_msg_data OUT NOCOPY VARCHAR2,
634: p_cp_rev_id IN NUMBER,
635: p_object_version_number IN NUMBER,
636: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
637: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
638: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
639: x_object_version_number OUT NOCOPY NUMBER
640: );
641: --------------------------------------------------------------------------
648: --
649: -- Standard IN Parameters:
650: -- p_api_version IN NUMBER Required
651: -- p_init_msg_list IN VARCHAR2 Optional
652: -- Default = FND_API.G_FALSE
653: -- p_commit IN VARCHAR2 Optional
654: -- Default = FND_API.G_FALSE
655: --
656: -- Standard OUT NOCOPY Parameters:
650: -- p_api_version IN NUMBER Required
651: -- p_init_msg_list IN VARCHAR2 Optional
652: -- Default = FND_API.G_FALSE
653: -- p_commit IN VARCHAR2 Optional
654: -- Default = FND_API.G_FALSE
655: --
656: -- Standard OUT NOCOPY Parameters:
657: -- x_return_status OUT NOCOPY VARCHAR2(1)
658: -- x_msg_count OUT NOCOPY NUMBER
673:
674: PROCEDURE Specify_Contact
675: (
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
678: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
679: x_return_status OUT NOCOPY VARCHAR2,
680: x_msg_count OUT NOCOPY NUMBER,
681: x_msg_data OUT NOCOPY VARCHAR2,
674: PROCEDURE Specify_Contact
675: (
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
678: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
679: x_return_status OUT NOCOPY VARCHAR2,
680: x_msg_count OUT NOCOPY NUMBER,
681: x_msg_data OUT NOCOPY VARCHAR2,
682: p_contact_rec IN CP_Contact_Rec_Type,
695: --
696: -- Standard IN Parameters:
697: -- p_api_version IN NUMBER Required
698: -- p_init_msg_list IN VARCHAR2 Optional
699: -- Default = FND_API.G_FALSE
700: -- p_commit IN VARCHAR2 Optional
701: -- Default = FND_API.G_FALSE
702: --
703: -- Standard OUT NOCOPY Parameters:
697: -- p_api_version IN NUMBER Required
698: -- p_init_msg_list IN VARCHAR2 Optional
699: -- Default = FND_API.G_FALSE
700: -- p_commit IN VARCHAR2 Optional
701: -- Default = FND_API.G_FALSE
702: --
703: -- Standard OUT NOCOPY Parameters:
704: -- x_return_status OUT NOCOPY VARCHAR2(1)
705: -- x_msg_count OUT NOCOPY NUMBER
720:
721: PROCEDURE Update_Contact
722: (
723: p_api_version IN NUMBER,
724: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
725: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
721: PROCEDURE Update_Contact
722: (
723: p_api_version IN NUMBER,
724: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
725: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_cs_contact_id IN NUMBER,
742: --
743: -- Standard IN Parameters:
744: -- p_api_version IN NUMBER Required
745: -- p_init_msg_list IN VARCHAR2 Optional
746: -- Default = FND_API.G_FALSE
747: -- p_commit IN VARCHAR2 Optional
748: -- Default = FND_API.G_FALSE
749: --
750: -- Standard OUT NOCOPY Parameters:
744: -- p_api_version IN NUMBER Required
745: -- p_init_msg_list IN VARCHAR2 Optional
746: -- Default = FND_API.G_FALSE
747: -- p_commit IN VARCHAR2 Optional
748: -- Default = FND_API.G_FALSE
749: --
750: -- Standard OUT NOCOPY Parameters:
751: -- x_return_status OUT NOCOPY VARCHAR2(1)
752: -- x_msg_count OUT NOCOPY NUMBER
766:
767: PROCEDURE Delete_Contact
768: (
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
771: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
772: x_return_status OUT NOCOPY VARCHAR2,
773: x_msg_count OUT NOCOPY NUMBER,
774: x_msg_data OUT NOCOPY VARCHAR2,
767: PROCEDURE Delete_Contact
768: (
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
771: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
772: x_return_status OUT NOCOPY VARCHAR2,
773: x_msg_count OUT NOCOPY NUMBER,
774: x_msg_data OUT NOCOPY VARCHAR2,
775: p_cs_contact_id IN NUMBER
787: --
788: -- Standard IN Parameters:
789: -- p_api_version IN NUMBER Required
790: -- p_init_msg_list IN VARCHAR2 Optional
791: -- Default = FND_API.G_FALSE
792: --
793: -- Standard OUT NOCOPY Parameters:
794: -- x_return_status OUT NOCOPY VARCHAR2(1)
795: -- x_msg_count OUT NOCOPY NUMBER
809:
810: PROCEDURE Get_CP_ID
811: (
812: p_api_version IN NUMBER,
813: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
814: x_return_status OUT NOCOPY VARCHAR2,
815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_reference_number IN NUMBER,
830: --
831: -- Standard IN Parameters:
832: -- p_api_version IN NUMBER Required
833: -- p_init_msg_list IN VARCHAR2 Optional
834: -- Default = FND_API.G_FALSE
835: --
836: -- Standard OUT NOCOPY Parameters:
837: -- x_return_status OUT NOCOPY VARCHAR2(1)
838: -- x_msg_count OUT NOCOPY NUMBER
852:
853: PROCEDURE Get_Reference_Number
854: (
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,
860: p_cp_id IN NUMBER,
872: --
873: -- Standard IN Parameters:
874: -- p_api_version IN NUMBER Required
875: -- p_init_msg_list IN VARCHAR2 Optional
876: -- Default = FND_API.G_FALSE
877: --
878: -- Standard OUT OCOPY Parameters:
879: -- x_return_status OUT NOCOPY VARCHAR2(1)
880: -- x_msg_count OUT NOCOPY NUMBER
881: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
882: --
883: -- Get_CP_ID IN Parameters:
884: -- p_serial_number IN VARCHAR2 Optional
885: -- Default = FND_API.G_MISS_CHAR
886: -- p_config_type IN VARCHAR2 Optional
887: -- Default = FND_API.G_MISS_CHAR
888: -- p_as_of_date IN DATE Optional
889: -- Default = FND_API.G_MISS_DATE
883: -- Get_CP_ID IN Parameters:
884: -- p_serial_number IN VARCHAR2 Optional
885: -- Default = FND_API.G_MISS_CHAR
886: -- p_config_type IN VARCHAR2 Optional
887: -- Default = FND_API.G_MISS_CHAR
888: -- p_as_of_date IN DATE Optional
889: -- Default = FND_API.G_MISS_DATE
890: -- p_customer_id IN NUMBER Optional
891: -- Default = FND_API.G_MISS_NUM
885: -- Default = FND_API.G_MISS_CHAR
886: -- p_config_type IN VARCHAR2 Optional
887: -- Default = FND_API.G_MISS_CHAR
888: -- p_as_of_date IN DATE Optional
889: -- Default = FND_API.G_MISS_DATE
890: -- p_customer_id IN NUMBER Optional
891: -- Default = FND_API.G_MISS_NUM
892: -- p_inv_item_id IN NUMBER Optional
893: -- Default = FND_API.G_MISS_NUM
887: -- Default = FND_API.G_MISS_CHAR
888: -- p_as_of_date IN DATE Optional
889: -- Default = FND_API.G_MISS_DATE
890: -- p_customer_id IN NUMBER Optional
891: -- Default = FND_API.G_MISS_NUM
892: -- p_inv_item_id IN NUMBER Optional
893: -- Default = FND_API.G_MISS_NUM
894:
895: -- Get_CP_ID OUT NOCOPY Parameters:
889: -- Default = FND_API.G_MISS_DATE
890: -- p_customer_id IN NUMBER Optional
891: -- Default = FND_API.G_MISS_NUM
892: -- p_inv_item_id IN NUMBER Optional
893: -- Default = FND_API.G_MISS_NUM
894:
895: -- Get_CP_ID OUT NOCOPY Parameters:
896: -- x_cp_id OUT NOCOPY NUMBER
897: -- x_reference_number OUT NOCOPY NUMBER
905:
906: PROCEDURE Get_CP_ID
907: (
908: p_api_version IN NUMBER,
909: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
909: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914: p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915: p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916: p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917: p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914: p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915: p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916: p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917: p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
918: x_unique_flag OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914: p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915: p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916: p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917: p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
918: x_unique_flag OUT NOCOPY VARCHAR2,
919: x_reference_number OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914: p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915: p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916: p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917: p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
918: x_unique_flag OUT NOCOPY VARCHAR2,
919: x_reference_number OUT NOCOPY NUMBER,
920: x_cp_id OUT NOCOPY NUMBER
913: p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914: p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915: p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916: p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917: p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
918: x_unique_flag OUT NOCOPY VARCHAR2,
919: x_reference_number OUT NOCOPY NUMBER,
920: x_cp_id OUT NOCOPY NUMBER
921: );
932: --
933: -- Standard IN Parameters:
934: -- p_api_version IN NUMBER Required
935: -- p_init_msg_list IN VARCHAR2 Optional
936: -- Default = FND_API.G_FALSE
937: --
938: -- Standard OUT NOCOPY Parameters:
939: -- x_return_status OUT NOCOPY VARCHAR2(1)
940: -- x_msg_count OUT NOCOPY NUMBER
957:
958: PROCEDURE Get_Configuration
959: (
960: p_api_version IN NUMBER,
961: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
962: x_return_status OUT NOCOPY VARCHAR2,
963: x_msg_count OUT NOCOPY NUMBER,
964: x_msg_data OUT NOCOPY VARCHAR2,
965: p_cp_id IN NUMBER,
980: --
981: -- Standard IN Parameters:
982: -- p_api_version IN NUMBER Required
983: -- p_init_msg_list IN VARCHAR2 Optional
984: -- Default = FND_API.G_FALSE
985: --
986: -- Standard OUT NOCOPY Parameters:
987: -- x_return_status OUT NOCOPY VARCHAR2(1)
988: -- x_msg_count OUT NOCOPY NUMBER
1005:
1006: PROCEDURE Get_ProductInfo
1007: (
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2,
1013: p_cp_id IN NUMBER,
1028: --
1029: -- Standard IN Parameters:
1030: -- p_api_version IN NUMBER Required
1031: -- p_init_msg_list IN VARCHAR2 Optional
1032: -- Default = FND_API.G_FALSE
1033: --
1034: -- Standard OUT NOCOPY Parameters:
1035: -- x_return_status OUT NOCOPY VARCHAR2(1)
1036: -- x_msg_count OUT NOCOPY NUMBER
1053:
1054: PROCEDURE Split_Product
1055: (
1056: p_api_version IN NUMBER,
1057: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1054: PROCEDURE Split_Product
1055: (
1056: p_api_version IN NUMBER,
1057: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1062: p_cp_id IN NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1062: p_cp_id IN NUMBER,
1063: p_qty1 IN NUMBER,
1064: p_qty2 IN NUMBER,
1065: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1066: p_reason_code IN VARCHAR2,
1067: x_new_parent_cp_id OUT NOCOPY NUMBER
1068: ) ;
1069:
1079: --
1080: -- Standard IN Parameters:
1081: -- p_api_version IN NUMBER Required
1082: -- p_init_msg_list IN VARCHAR2 Optional
1083: -- Default = FND_API.G_FALSE
1084: --
1085: -- Standard OUT NOCOPY Parameters:
1086: -- x_return_status OUT NOCOPY VARCHAR2(1)
1087: -- x_msg_count OUT NOCOPY NUMBER
1102:
1103: PROCEDURE Split_Product
1104: (
1105: p_api_version IN NUMBER,
1106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1108: x_return_status OUT NOCOPY VARCHAR2,
1109: x_msg_count OUT NOCOPY NUMBER,
1110: x_msg_data OUT NOCOPY VARCHAR2,
1103: PROCEDURE Split_Product
1104: (
1105: p_api_version IN NUMBER,
1106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1108: x_return_status OUT NOCOPY VARCHAR2,
1109: x_msg_count OUT NOCOPY NUMBER,
1110: x_msg_data OUT NOCOPY VARCHAR2,
1111: p_cp_id IN NUMBER,
1109: x_msg_count OUT NOCOPY NUMBER,
1110: x_msg_data OUT NOCOPY VARCHAR2,
1111: p_cp_id IN NUMBER,
1112: p_reason_code IN VARCHAR2,
1113: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1114: );
1115:
1116:
1117: PROCEDURE Create_Product_Parameters
1116:
1117: PROCEDURE Create_Product_Parameters
1118: (
1119: p_api_version IN NUMBER,
1120: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1121: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1122: x_return_status OUT NOCOPY VARCHAR2,
1123: x_msg_count OUT NOCOPY NUMBER,
1124: x_msg_data OUT NOCOPY VARCHAR2,
1117: PROCEDURE Create_Product_Parameters
1118: (
1119: p_api_version IN NUMBER,
1120: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1121: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1122: x_return_status OUT NOCOPY VARCHAR2,
1123: x_msg_count OUT NOCOPY NUMBER,
1124: x_msg_data OUT NOCOPY VARCHAR2,
1125: p_cp_param_rec IN CP_Param_Rec_Type,
1130:
1131: PROCEDURE Update_Product_Parameters
1132: (
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1135: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1136: x_return_status OUT NOCOPY VARCHAR2,
1137: x_msg_count OUT NOCOPY NUMBER,
1138: x_msg_data OUT NOCOPY VARCHAR2,
1131: PROCEDURE Update_Product_Parameters
1132: (
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1135: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1136: x_return_status OUT NOCOPY VARCHAR2,
1137: x_msg_count OUT NOCOPY NUMBER,
1138: x_msg_data OUT NOCOPY VARCHAR2,
1139: p_cp_parameter_id IN NUMBER,
1145:
1146: PROCEDURE Delete_Product_Parameters
1147: (
1148: p_api_version IN NUMBER,
1149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1151: x_return_status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2,
1146: PROCEDURE Delete_Product_Parameters
1147: (
1148: p_api_version IN NUMBER,
1149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1151: x_return_status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2,
1154: p_cp_parameter_id IN NUMBER