eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TQL_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 10: qlt_code OKL_TXL_QUOTE_LINES_B.QLT_CODE%TYPE := OKC_API.G_MISS_CHAR,

6: TYPE tql_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sty_id NUMBER := OKC_API.G_MISS_NUM,
9: kle_id NUMBER := OKC_API.G_MISS_NUM,
10: qlt_code OKL_TXL_QUOTE_LINES_B.QLT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: qte_id NUMBER := OKC_API.G_MISS_NUM,
12: line_number NUMBER := OKC_API.G_MISS_NUM,
13: amount NUMBER := OKC_API.G_MISS_NUM,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 15: modified_yn OKL_TXL_QUOTE_LINES_B.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,

11: qte_id NUMBER := OKC_API.G_MISS_NUM,
12: line_number NUMBER := OKC_API.G_MISS_NUM,
13: amount NUMBER := OKC_API.G_MISS_NUM,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: modified_yn OKL_TXL_QUOTE_LINES_B.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxed_yn OKL_TXL_QUOTE_LINES_B.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,
17: defaulted_yn OKL_TXL_QUOTE_LINES_B.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: request_id NUMBER := OKC_API.G_MISS_NUM,

Line 16: taxed_yn OKL_TXL_QUOTE_LINES_B.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,

12: line_number NUMBER := OKC_API.G_MISS_NUM,
13: amount NUMBER := OKC_API.G_MISS_NUM,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: modified_yn OKL_TXL_QUOTE_LINES_B.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxed_yn OKL_TXL_QUOTE_LINES_B.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,
17: defaulted_yn OKL_TXL_QUOTE_LINES_B.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: request_id NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,

Line 17: defaulted_yn OKL_TXL_QUOTE_LINES_B.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,

13: amount NUMBER := OKC_API.G_MISS_NUM,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: modified_yn OKL_TXL_QUOTE_LINES_B.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxed_yn OKL_TXL_QUOTE_LINES_B.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,
17: defaulted_yn OKL_TXL_QUOTE_LINES_B.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: request_id NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,

Line 22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: request_id NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

19: request_id NUMBER := OKC_API.G_MISS_NUM,
20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

20: program_application_id NUMBER := OKC_API.G_MISS_NUM,
21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

21: program_id NUMBER := OKC_API.G_MISS_NUM,
22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

22: program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

23: attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

24: attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

25: attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

26: attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

27: attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

28: attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

29: attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

30: attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

31: attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

32: attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

33: attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

34: attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

36: attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM,
44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

38: attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM,
44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,

Line 44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,

40: creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM,
44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

Line 45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM,
44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
49: yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

43: last_update_login NUMBER := OKC_API.G_MISS_NUM,
44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
49: yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
50: yield_value NUMBER := OKC_API.G_MISS_NUM,
51: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,

Line 48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

44: start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
49: yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
50: yield_value NUMBER := OKC_API.G_MISS_NUM,
51: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
52: asset_value NUMBER := OKC_API.G_MISS_NUM,

Line 49: yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

45: period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46: number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47: lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48: advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
49: yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
50: yield_value NUMBER := OKC_API.G_MISS_NUM,
51: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
52: asset_value NUMBER := OKC_API.G_MISS_NUM,
53: residual_value NUMBER := OKC_API.G_MISS_NUM,

Line 58: split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312

54: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
55: asset_quantity NUMBER := OKC_API.G_MISS_NUM,
56: quote_quantity NUMBER := OKC_API.G_MISS_NUM,
57: split_kle_id NUMBER := OKC_API.G_MISS_NUM,
58: split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
59: -- BAKUCHIB 2667636 Start
60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

56: quote_quantity NUMBER := OKC_API.G_MISS_NUM,
57: split_kle_id NUMBER := OKC_API.G_MISS_NUM,
58: split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
59: -- BAKUCHIB 2667636 Start
60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

57: split_kle_id NUMBER := OKC_API.G_MISS_NUM,
58: split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
59: -- BAKUCHIB 2667636 Start
60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End

Line 62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

58: split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
59: -- BAKUCHIB 2667636 Start
60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End
66: -- PAGARG 15-Feb-05 Bug 4161133 Start

Line 63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,

59: -- BAKUCHIB 2667636 Start
60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End
66: -- PAGARG 15-Feb-05 Bug 4161133 Start
67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B

Line 64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

60: currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End
66: -- PAGARG 15-Feb-05 Bug 4161133 Start
67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
68: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,

Line 67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B

63: currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End
66: -- PAGARG 15-Feb-05 Bug 4161133 Start
67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
68: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
69: -- PAGARG 15-Feb-05 Bug 4161133 End
70: --rmunjulu 23-May-05 Sales_Tax_Enhancements
71: try_id OKL_TXL_QUOTE_LINES_B.TRY_ID%TYPE := OKL_API.G_MISS_NUM);

Line 68: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,

64: currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: -- BAKUCHIB 2667636 End
66: -- PAGARG 15-Feb-05 Bug 4161133 Start
67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
68: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
69: -- PAGARG 15-Feb-05 Bug 4161133 End
70: --rmunjulu 23-May-05 Sales_Tax_Enhancements
71: try_id OKL_TXL_QUOTE_LINES_B.TRY_ID%TYPE := OKL_API.G_MISS_NUM);
72: g_miss_tql_rec tql_rec_type;

Line 71: try_id OKL_TXL_QUOTE_LINES_B.TRY_ID%TYPE := OKL_API.G_MISS_NUM);

67: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
68: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
69: -- PAGARG 15-Feb-05 Bug 4161133 End
70: --rmunjulu 23-May-05 Sales_Tax_Enhancements
71: try_id OKL_TXL_QUOTE_LINES_B.TRY_ID%TYPE := OKL_API.G_MISS_NUM);
72: g_miss_tql_rec tql_rec_type;
73: TYPE tql_tbl_type IS TABLE OF tql_rec_type
74: INDEX BY BINARY_INTEGER;
75: TYPE OklTxlQuoteLinesTlRecType IS RECORD (

Line 152: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B

148: currency_conversion_rate OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
149: currency_conversion_date OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
150: -- BAKUCHIB 2667636 End
151: -- PAGARG 15-Feb-05 Bug 4161133 Start
152: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
153: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
154: -- PAGARG 15-Feb-05 Bug 4161133 End
155: --rmunjulu 23-May-05 Sales_Tax_Enhancements
156: try_id OKL_TXL_QUOTE_LINES_V.TRY_ID%TYPE := OKL_API.G_MISS_NUM);

Line 153: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,

149: currency_conversion_date OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
150: -- BAKUCHIB 2667636 End
151: -- PAGARG 15-Feb-05 Bug 4161133 Start
152: -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
153: due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
154: -- PAGARG 15-Feb-05 Bug 4161133 End
155: --rmunjulu 23-May-05 Sales_Tax_Enhancements
156: try_id OKL_TXL_QUOTE_LINES_V.TRY_ID%TYPE := OKL_API.G_MISS_NUM);
157: g_miss_tqlv_rec tqlv_rec_type;