4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE iti_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE iti_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
6: ---------------------------------------------------------------------------
7: TYPE iti_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
7: TYPE iti_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
11: tal_id NUMBER := OKC_API.G_MISS_NUM,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
12: kle_id NUMBER := OKC_API.G_MISS_NUM,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
13: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
14: line_number NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
15: instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
16: object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
17: object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
18: jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
19: object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
36: attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
40: attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
42: attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
51: selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
51: selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: asd_id NUMBER := OKC_API.G_MISS_NUM);
46: last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
51: selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: asd_id NUMBER := OKC_API.G_MISS_NUM);
53: g_miss_iti_rec iti_rec_type;
54: TYPE iti_tbl_type IS TABLE OF iti_rec_type
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
51: selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: asd_id NUMBER := OKC_API.G_MISS_NUM);
53: g_miss_iti_rec iti_rec_type;
54: TYPE iti_tbl_type IS TABLE OF iti_rec_type
55: INDEX BY BINARY_INTEGER;
48: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49: --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50: instance_id NUMBER := OKC_API.G_MISS_NUM,
51: selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: asd_id NUMBER := OKC_API.G_MISS_NUM);
53: g_miss_iti_rec iti_rec_type;
54: TYPE iti_tbl_type IS TABLE OF iti_rec_type
55: INDEX BY BINARY_INTEGER;
56: TYPE itiv_rec_type IS RECORD (
53: g_miss_iti_rec iti_rec_type;
54: TYPE iti_tbl_type IS TABLE OF iti_rec_type
55: INDEX BY BINARY_INTEGER;
56: TYPE itiv_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
54: TYPE iti_tbl_type IS TABLE OF iti_rec_type
55: INDEX BY BINARY_INTEGER;
56: TYPE itiv_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: INDEX BY BINARY_INTEGER;
56: TYPE itiv_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
56: TYPE itiv_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
57: id NUMBER := OKC_API.G_MISS_NUM,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
58: object_version_number NUMBER := OKC_API.G_MISS_NUM,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
59: tas_id NUMBER := OKC_API.G_MISS_NUM,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
60: tal_id NUMBER := OKC_API.G_MISS_NUM,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
61: kle_id NUMBER := OKC_API.G_MISS_NUM,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
62: tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
63: line_number NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
64: instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
65: object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
66: object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
67: jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
68: object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
69: object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
70: jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
71: inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
72: serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
73: mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
74: inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
75: inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
76: attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
77: attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
78: attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
79: attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
80: attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
81: attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
82: attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
83: attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
84: attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
85: attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
86: attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
87: attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
88: attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
89: attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
90: attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
91: attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
92: created_by NUMBER := OKC_API.G_MISS_NUM,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
100: selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93: creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
100: selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
101: asd_id NUMBER := OKC_API.G_MISS_NUM);
95: last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
100: selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
101: asd_id NUMBER := OKC_API.G_MISS_NUM);
102: g_miss_itiv_rec itiv_rec_type;
103: TYPE itiv_tbl_type IS TABLE OF itiv_rec_type
96: last_update_login NUMBER := OKC_API.G_MISS_NUM,
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
100: selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
101: asd_id NUMBER := OKC_API.G_MISS_NUM);
102: g_miss_itiv_rec itiv_rec_type;
103: TYPE itiv_tbl_type IS TABLE OF itiv_rec_type
104: INDEX BY BINARY_INTEGER;
97: dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98: --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99: instance_id NUMBER := OKC_API.G_MISS_NUM,
100: selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
101: asd_id NUMBER := OKC_API.G_MISS_NUM);
102: g_miss_itiv_rec itiv_rec_type;
103: TYPE itiv_tbl_type IS TABLE OF itiv_rec_type
104: INDEX BY BINARY_INTEGER;
105: ---------------------------------------------------------------------------
104: INDEX BY BINARY_INTEGER;
105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
108: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
118: ---------------------------------------------------------------------------
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
118: ---------------------------------------------------------------------------
119: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ITI_PVT';
126: PROCEDURE change_version;
127: PROCEDURE api_copy;
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_itiv_rec IN itiv_rec_type,
135: x_itiv_rec OUT NOCOPY itiv_rec_type);
136:
137: PROCEDURE insert_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_itiv_tbl IN itiv_tbl_type,
144: x_itiv_tbl OUT NOCOPY itiv_tbl_type);
145:
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_itiv_rec IN itiv_rec_type);
152: p_itiv_rec IN itiv_rec_type);
153:
154: PROCEDURE lock_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_itiv_tbl IN itiv_tbl_type);
160: p_itiv_tbl IN itiv_tbl_type);
161:
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_itiv_rec IN itiv_rec_type,
169: x_itiv_rec OUT NOCOPY itiv_rec_type);
170:
171: PROCEDURE update_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_itiv_tbl IN itiv_tbl_type,
178: x_itiv_tbl OUT NOCOPY itiv_tbl_type);
179:
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_itiv_rec IN itiv_rec_type);
186: p_itiv_rec IN itiv_rec_type);
187:
188: PROCEDURE delete_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_itiv_tbl IN itiv_tbl_type);
194: p_itiv_tbl IN itiv_tbl_type);
195:
196: PROCEDURE validate_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_itiv_rec IN itiv_rec_type);
202: p_itiv_rec IN itiv_rec_type);
203:
204: PROCEDURE validate_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_itiv_tbl IN itiv_tbl_type);