5:
6: type WLTX_TRANSACTIONS_REC_TYPE is record
7: (
8: /* Transaction info */
9: TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10: TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11: TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
6: type WLTX_TRANSACTIONS_REC_TYPE is record
7: (
8: /* Transaction info */
9: TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10: TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11: TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14:
7: (
8: /* Transaction info */
9: TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10: TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11: TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14:
15: /*Added for MES*/
8: /* Transaction info */
9: TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10: TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11: TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14:
15: /*Added for MES*/
16: EMPLOYEE_ID WSM_SPLIT_MERGE_TRANSACTIONS.EMPLOYEE_ID%TYPE,
9: TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10: TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11: TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14:
15: /*Added for MES*/
16: EMPLOYEE_ID WSM_SPLIT_MERGE_TRANSACTIONS.EMPLOYEE_ID%TYPE,
17:
12: REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13: TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14:
15: /*Added for MES*/
16: EMPLOYEE_ID WSM_SPLIT_MERGE_TRANSACTIONS.EMPLOYEE_ID%TYPE,
17:
18: /* Org info */
19: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE,
20: ORGANIZATION_ID WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID%TYPE,
16: EMPLOYEE_ID WSM_SPLIT_MERGE_TRANSACTIONS.EMPLOYEE_ID%TYPE,
17:
18: /* Org info */
19: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE,
20: ORGANIZATION_ID WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID%TYPE,
21:
22: ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
18: /* Org info */
19: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE,
20: ORGANIZATION_ID WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID%TYPE,
21:
22: ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
20: ORGANIZATION_ID WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID%TYPE,
21:
22: ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
21:
22: ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
22: ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
23:
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
24: ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
25: ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
26: ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
27: ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
28: ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
29: ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
30: ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
31: ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39: ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
32: ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39: ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
40:
33: ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39: ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
40:
41: );
34: ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39: ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
40:
41: );
42:
35: ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36: ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37: ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38: ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39: ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
40:
41: );
42:
43: type WLTX_STARTING_JOBS_REC_TYPE is record