6: -- * ------------------------------------------------------------------+
7:
8: TYPE INVOICE_CHANGES_ALL_REC_TYPE IS RECORD
9: (
10: INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
7:
8: TYPE INVOICE_CHANGES_ALL_REC_TYPE IS RECORD
9: (
10: INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
8: TYPE INVOICE_CHANGES_ALL_REC_TYPE IS RECORD
9: (
10: INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: (
10: INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
10: INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
39: COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
39: COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
40: );
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
39: COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
40: );
41:
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
39: COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
40: );
41:
42: G_MISS_INVOICE_CHANGES_ALL_REC INVOICE_CHANGES_ALL_REC_TYPE;
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38: ORG_ID NUMBER := FND_API.G_MISS_NUM,
39: COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
40: );
41:
42: G_MISS_INVOICE_CHANGES_ALL_REC INVOICE_CHANGES_ALL_REC_TYPE;
43: