3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tao_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tao_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE tao_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE tao_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
8: try_id NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
9: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
10: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
11: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
12: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
13: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
14: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
15: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
17: org_id NUMBER := Okc_Api.G_MISS_NUM,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
31: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
32: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
40: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
33: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
40: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
41: /* Changes Ends */
34: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
40: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
41: /* Changes Ends */
42:
36: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
40: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
41: /* Changes Ends */
42:
43: g_miss_tao_rec tao_rec_type;
44: TYPE tao_tbl_type IS TABLE OF tao_rec_type
43: g_miss_tao_rec tao_rec_type;
44: TYPE tao_tbl_type IS TABLE OF tao_rec_type
45: INDEX BY BINARY_INTEGER;
46: TYPE taov_rec_type IS RECORD (
47: id NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
44: TYPE tao_tbl_type IS TABLE OF tao_rec_type
45: INDEX BY BINARY_INTEGER;
46: TYPE taov_rec_type IS RECORD (
47: id NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
45: INDEX BY BINARY_INTEGER;
46: TYPE taov_rec_type IS RECORD (
47: id NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
46: TYPE taov_rec_type IS RECORD (
47: id NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: id NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: try_id NUMBER := Okc_Api.G_MISS_NUM,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
50: unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
51: rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
52: freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
53: rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
54: clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
55: tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
56: unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
66: attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
67: attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
68: attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
69: attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
70: attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
71: attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
72: attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
80: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
80: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
81: /* Changes Ends */
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
80: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
81: /* Changes Ends */
82:
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79: /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
80: post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
81: /* Changes Ends */
82:
83:
84: g_miss_taov_rec taov_rec_type;
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
94: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
95:
96: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
94: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
95:
96: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
95:
96: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
95:
96: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
96: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
97: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
98: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
106: ---------------------------------------------------------------------------
99: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
106: ---------------------------------------------------------------------------
107: -- GLOBAL VARIABLES
100: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
106: ---------------------------------------------------------------------------
107: -- GLOBAL VARIABLES
108: ---------------------------------------------------------------------------
101: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
106: ---------------------------------------------------------------------------
107: -- GLOBAL VARIABLES
108: ---------------------------------------------------------------------------
109: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAO_PVT';
106: ---------------------------------------------------------------------------
107: -- GLOBAL VARIABLES
108: ---------------------------------------------------------------------------
109: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAO_PVT';
110: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
111: ---------------------------------------------------------------------------
112: -- Procedures and Functions
113: ---------------------------------------------------------------------------
114:
116: PROCEDURE change_version;
117: PROCEDURE api_copy;
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_taov_rec IN taov_rec_type,
125: x_taov_rec OUT NOCOPY taov_rec_type);
126:
127: PROCEDURE insert_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_taov_tbl IN taov_tbl_type,
134: x_taov_tbl OUT NOCOPY taov_tbl_type);
135:
136: PROCEDURE lock_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_taov_rec IN taov_rec_type);
142: p_taov_rec IN taov_rec_type);
143:
144: PROCEDURE lock_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_taov_tbl IN taov_tbl_type);
150: p_taov_tbl IN taov_tbl_type);
151:
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_taov_rec IN taov_rec_type,
159: x_taov_rec OUT NOCOPY taov_rec_type);
160:
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_taov_tbl IN taov_tbl_type,
168: x_taov_tbl OUT NOCOPY taov_tbl_type);
169:
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_taov_rec IN taov_rec_type);
176: p_taov_rec IN taov_rec_type);
177:
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_taov_tbl IN taov_tbl_type);
184: p_taov_tbl IN taov_tbl_type);
185:
186: PROCEDURE validate_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_taov_rec IN taov_rec_type);
192: p_taov_rec IN taov_rec_type);
193:
194: PROCEDURE validate_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_taov_tbl IN taov_tbl_type);