6: TYPE tcl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id NUMBER := OKC_API.G_MISS_NUM,
9: kle_id NUMBER := OKC_API.G_MISS_NUM,
10: before_transfer_yn OKL_TXL_CNTRCT_LNS.BEFORE_TRANSFER_YN%TYPE := OKC_API.G_MISS_CHAR,
11: tcn_id NUMBER := OKC_API.G_MISS_NUM,
12: rct_id NUMBER := OKC_API.G_MISS_NUM,
13: btc_id NUMBER := OKC_API.G_MISS_NUM,
14: sty_id NUMBER := OKC_API.G_MISS_NUM,
12: rct_id NUMBER := OKC_API.G_MISS_NUM,
13: btc_id NUMBER := OKC_API.G_MISS_NUM,
14: sty_id NUMBER := OKC_API.G_MISS_NUM,
15: line_number NUMBER := OKC_API.G_MISS_NUM,
16: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: line_number NUMBER := OKC_API.G_MISS_NUM,
16: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: org_id NUMBER := OKC_API.G_MISS_NUM,
23: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: org_id NUMBER := OKC_API.G_MISS_NUM,
23: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: program_id NUMBER := OKC_API.G_MISS_NUM,
25: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: org_id NUMBER := OKC_API.G_MISS_NUM,
23: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: program_id NUMBER := OKC_API.G_MISS_NUM,
25: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
26: amount NUMBER := OKC_API.G_MISS_NUM,
27: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: org_id NUMBER := OKC_API.G_MISS_NUM,
23: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24: program_id NUMBER := OKC_API.G_MISS_NUM,
25: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
26: amount NUMBER := OKC_API.G_MISS_NUM,
27: program_application_id NUMBER := OKC_API.G_MISS_NUM,
28: -- redwin 07/20/2001 changed from currency to currency_code
29: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
26: amount NUMBER := OKC_API.G_MISS_NUM,
27: program_application_id NUMBER := OKC_API.G_MISS_NUM,
28: -- redwin 07/20/2001 changed from currency to currency_code
29: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
30: request_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: program_application_id NUMBER := OKC_API.G_MISS_NUM,
28: -- redwin 07/20/2001 changed from currency to currency_code
29: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
30: request_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: -- redwin 07/20/2001 changed from currency to currency_code
29: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
30: request_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
30: request_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: request_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
41: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49: avl_id NUMBER := OKC_API.G_MISS_NUM,
42: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49: avl_id NUMBER := OKC_API.G_MISS_NUM,
50: bkt_id OKL_BUCKETS_V.ID%TYPE := OKC_API.G_MISS_NUM,
43: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49: avl_id NUMBER := OKC_API.G_MISS_NUM,
50: bkt_id OKL_BUCKETS_V.ID%TYPE := OKC_API.G_MISS_NUM,
51: -- Added by Santonyr May 20th, 2002 Bug 2305542
51: -- Added by Santonyr May 20th, 2002 Bug 2305542
52: kle_id_new NUMBER := OKC_API.G_MISS_NUM,
53: percentage NUMBER := OKC_API.G_MISS_NUM,
54: -- Added by Hkpatel Sep 17th, 2003
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
53: percentage NUMBER := OKC_API.G_MISS_NUM,
54: -- Added by Hkpatel Sep 17th, 2003
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
54: -- Added by Hkpatel Sep 17th, 2003
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
56: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
57: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
58: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
59: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
60: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
61: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
62: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
68: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
69: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
63: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
68: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
69: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
70: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
71: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: -- Added by DJANASWA 02-Feb-2007 for SLA project
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
68: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
69: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
70: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
71: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
72: );
65: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
66: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
68: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
69: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
70: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
71: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
72: );
73:
67: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
68: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
69: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
70: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
71: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
72: );
73:
74: g_miss_tcl_rec tcl_rec_type;
75:
83: btc_id NUMBER := OKC_API.G_MISS_NUM,
84: tcn_id NUMBER := OKC_API.G_MISS_NUM,
85: khr_id NUMBER := OKC_API.G_MISS_NUM,
86: kle_id NUMBER := OKC_API.G_MISS_NUM,
87: before_transfer_yn OKL_TXL_CNTRCT_LNS.BEFORE_TRANSFER_YN%TYPE := OKC_API.G_MISS_CHAR,
88: line_number NUMBER := OKC_API.G_MISS_NUM,
89: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: amount NUMBER := OKC_API.G_MISS_NUM,
91: -- redwin 07/20/2001 changed from currency to currency_code
85: khr_id NUMBER := OKC_API.G_MISS_NUM,
86: kle_id NUMBER := OKC_API.G_MISS_NUM,
87: before_transfer_yn OKL_TXL_CNTRCT_LNS.BEFORE_TRANSFER_YN%TYPE := OKC_API.G_MISS_CHAR,
88: line_number NUMBER := OKC_API.G_MISS_NUM,
89: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: amount NUMBER := OKC_API.G_MISS_NUM,
91: -- redwin 07/20/2001 changed from currency to currency_code
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
88: line_number NUMBER := OKC_API.G_MISS_NUM,
89: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: amount NUMBER := OKC_API.G_MISS_NUM,
91: -- redwin 07/20/2001 changed from currency to currency_code
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
89: description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: amount NUMBER := OKC_API.G_MISS_NUM,
91: -- redwin 07/20/2001 changed from currency to currency_code
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
90: amount NUMBER := OKC_API.G_MISS_NUM,
91: -- redwin 07/20/2001 changed from currency to currency_code
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
91: -- redwin 07/20/2001 changed from currency to currency_code
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
92: currency_code OKL_TXL_CNTRCT_LNS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
93: gl_reversal_yn OKL_TXL_CNTRCT_LNS.GL_REVERSAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
94: attribute_category OKL_TXL_CNTRCT_LNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
95: attribute1 OKL_TXL_CNTRCT_LNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
96: attribute2 OKL_TXL_CNTRCT_LNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
97: attribute3 OKL_TXL_CNTRCT_LNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
98: attribute4 OKL_TXL_CNTRCT_LNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
99: attribute5 OKL_TXL_CNTRCT_LNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
100: attribute6 OKL_TXL_CNTRCT_LNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
101: attribute7 OKL_TXL_CNTRCT_LNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
102: attribute8 OKL_TXL_CNTRCT_LNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
103: attribute9 OKL_TXL_CNTRCT_LNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
104: attribute10 OKL_TXL_CNTRCT_LNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
112: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
105: attribute11 OKL_TXL_CNTRCT_LNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
112: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
106: attribute12 OKL_TXL_CNTRCT_LNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute13 OKL_TXL_CNTRCT_LNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
112: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
114: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
108: attribute14 OKL_TXL_CNTRCT_LNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute15 OKL_TXL_CNTRCT_LNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
112: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
114: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
115: org_id NUMBER := OKC_API.G_MISS_NUM,
116: program_id NUMBER := OKC_API.G_MISS_NUM,
110: tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: created_by NUMBER := OKC_API.G_MISS_NUM,
112: creation_date OKL_TXL_CNTRCT_LNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
114: last_update_date OKL_TXL_CNTRCT_LNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
115: org_id NUMBER := OKC_API.G_MISS_NUM,
116: program_id NUMBER := OKC_API.G_MISS_NUM,
117: program_application_id NUMBER := OKC_API.G_MISS_NUM,
118: request_id NUMBER := OKC_API.G_MISS_NUM,
115: org_id NUMBER := OKC_API.G_MISS_NUM,
116: program_id NUMBER := OKC_API.G_MISS_NUM,
117: program_application_id NUMBER := OKC_API.G_MISS_NUM,
118: request_id NUMBER := OKC_API.G_MISS_NUM,
119: program_update_date OKL_TXL_CNTRCT_LNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_update_login NUMBER := OKC_API.G_MISS_NUM,
121: avl_id NUMBER := OKC_API.G_MISS_NUM,
122: bkt_id NUMBER := OKC_API.G_MISS_NUM,
123: -- Added by Santonyr May 20th, 2002 Bug 2305542
123: -- Added by Santonyr May 20th, 2002 Bug 2305542
124: kle_id_new NUMBER := OKC_API.G_MISS_NUM,
125: percentage NUMBER := OKC_API.G_MISS_NUM,
126: -- Added by Hkpatel Sep 17th, 2003
127: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
128: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
125: percentage NUMBER := OKC_API.G_MISS_NUM,
126: -- Added by Hkpatel Sep 17th, 2003
127: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
128: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
126: -- Added by Hkpatel Sep 17th, 2003
127: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
128: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
127: accrual_rule_yn OKL_TXL_CNTRCT_LNS.ACCRUAL_RULE_YN%TYPE := OKC_API.G_MISS_CHAR,
128: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
128: -- Added by PAGARG 21-Oct-2004 Bug# 3964726
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
129: source_column_1 OKL_TXL_CNTRCT_LNS.source_column_1%TYPE := OKC_API.G_MISS_CHAR,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
130: source_value_1 OKL_TXL_CNTRCT_LNS.source_value_1%TYPE := OKC_API.G_MISS_NUM,
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
131: source_column_2 OKL_TXL_CNTRCT_LNS.source_column_2%TYPE := OKC_API.G_MISS_CHAR,
132: source_value_2 OKL_TXL_CNTRCT_LNS.source_value_2%TYPE := OKC_API.G_MISS_NUM,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
133: source_column_3 OKL_TXL_CNTRCT_LNS.source_column_3%TYPE := OKC_API.G_MISS_CHAR,
134: source_value_3 OKL_TXL_CNTRCT_LNS.source_value_3%TYPE := OKC_API.G_MISS_NUM,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
140: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
141: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
135: canceled_date OKL_TXL_CNTRCT_LNS.canceled_date%TYPE := OKC_API.G_MISS_DATE,
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
140: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
141: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
142: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
143: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
136: -- Added by DJANASWA 02-Feb-2007 for SLA project
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
140: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
141: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
142: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
143: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
144: );
137: tax_line_id OKL_TXL_CNTRCT_LNS.tax_line_id%TYPE := OKC_API.G_MISS_NUM,
138: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
140: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
141: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
142: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
143: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
144: );
145:
139: stream_type_code OKL_TXL_CNTRCT_LNS.stream_type_code%TYPE := OKC_API.G_MISS_CHAR,
140: stream_type_purpose OKL_TXL_CNTRCT_LNS.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
141: asset_book_type_name OKL_TXL_CNTRCT_LNS.asset_book_type_name%TYPE := OKC_API.G_MISS_CHAR,
142: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
143: UPGRADE_STATUS_FLAG OKL_TXL_CNTRCT_LNS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR
144: );
145:
146: g_miss_tclv_rec tclv_rec_type;
147: TYPE tclv_tbl_type IS TABLE OF tclv_rec_type