10: lsm_id NUMBER := Okl_Api.G_MISS_NUM,
11: til_id NUMBER := Okl_Api.G_MISS_NUM,
12: xsi_id_details NUMBER := Okl_Api.G_MISS_NUM,
13: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
14: line_type OKL_XTL_SELL_INVS_B.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
15: amount NUMBER := Okl_Api.G_MISS_NUM,
16: quantity NUMBER := Okl_Api.G_MISS_NUM,
17: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
18: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
18: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
19: request_id NUMBER := Okl_Api.G_MISS_NUM,
20: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
21: program_id NUMBER := Okl_Api.G_MISS_NUM,
22: program_update_date OKL_XTL_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
23: org_id NUMBER := Okl_Api.G_MISS_NUM,
24: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
25: isl_id NUMBER := Okl_Api.G_MISS_NUM,
26: sel_id NUMBER := Okl_Api.G_MISS_NUM,
26: sel_id NUMBER := Okl_Api.G_MISS_NUM,
27: -- Start changes on remarketing by fmiao on 10/18/04 --
28: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
29: -- End changes on remarketing by fmiao on 10/18/04 --
30: attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
27: -- Start changes on remarketing by fmiao on 10/18/04 --
28: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
29: -- End changes on remarketing by fmiao on 10/18/04 --
30: attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
28: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
29: -- End changes on remarketing by fmiao on 10/18/04 --
30: attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
29: -- End changes on remarketing by fmiao on 10/18/04 --
30: attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
39: attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
47: creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
40: attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
47: creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
48: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
41: attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
47: creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
48: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
49: last_update_date OKL_XTL_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
43: attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
47: creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
48: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
49: last_update_date OKL_XTL_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
50: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
51: g_miss_xls_rec xls_rec_type;
45: attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46: created_by NUMBER := Okl_Api.G_MISS_NUM,
47: creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
48: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
49: last_update_date OKL_XTL_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
50: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
51: g_miss_xls_rec xls_rec_type;
52: TYPE xls_tbl_type IS TABLE OF xls_rec_type
53: INDEX BY BINARY_INTEGER;