4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- IEX_EXCLUSION_HIST_V Record Spec
7: TYPE iehv_rec_type IS RECORD (
8: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- IEX_EXCLUSION_HIST_V Record Spec
7: TYPE iehv_rec_type IS RECORD (
8: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
6: -- IEX_EXCLUSION_HIST_V Record Spec
7: TYPE iehv_rec_type IS RECORD (
8: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
7: TYPE iehv_rec_type IS RECORD (
8: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
8: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
10: ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
11: ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
12: ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
13: ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
14: ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
16: ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
17: ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
18: ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
19: ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
20: ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
21: ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
23: ,org_id NUMBER := OKC_API.G_MISS_NUM
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_iehv_rec iehv_rec_type;
38: ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_iehv_rec iehv_rec_type;
46: TYPE iehv_tbl_type IS TABLE OF iehv_rec_type
39: ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_iehv_rec iehv_rec_type;
46: TYPE iehv_tbl_type IS TABLE OF iehv_rec_type
47: INDEX BY BINARY_INTEGER;
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_iehv_rec iehv_rec_type;
46: TYPE iehv_tbl_type IS TABLE OF iehv_rec_type
47: INDEX BY BINARY_INTEGER;
48: -- IEX_EXCLUSION_HIST_TL Record Spec
46: TYPE iehv_tbl_type IS TABLE OF iehv_rec_type
47: INDEX BY BINARY_INTEGER;
48: -- IEX_EXCLUSION_HIST_TL Record Spec
49: TYPE ieht_rec_type IS RECORD (
50: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
47: INDEX BY BINARY_INTEGER;
48: -- IEX_EXCLUSION_HIST_TL Record Spec
49: TYPE ieht_rec_type IS RECORD (
50: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
48: -- IEX_EXCLUSION_HIST_TL Record Spec
49: TYPE ieht_rec_type IS RECORD (
50: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
49: TYPE ieht_rec_type IS RECORD (
50: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
50: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
51: ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
53: ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: G_MISS_ieht_rec ieht_rec_type;
54: ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: G_MISS_ieht_rec ieht_rec_type;
62: TYPE ieht_tbl_type IS TABLE OF ieht_rec_type
55: ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: G_MISS_ieht_rec ieht_rec_type;
62: TYPE ieht_tbl_type IS TABLE OF ieht_rec_type
63: INDEX BY BINARY_INTEGER;
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: G_MISS_ieht_rec ieht_rec_type;
62: TYPE ieht_tbl_type IS TABLE OF ieht_rec_type
63: INDEX BY BINARY_INTEGER;
64: -- IEX_EXCLUSION_HIST_B Record Spec
62: TYPE ieht_tbl_type IS TABLE OF ieht_rec_type
63: INDEX BY BINARY_INTEGER;
64: -- IEX_EXCLUSION_HIST_B Record Spec
65: TYPE ieh_rec_type IS RECORD (
66: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
63: INDEX BY BINARY_INTEGER;
64: -- IEX_EXCLUSION_HIST_B Record Spec
65: TYPE ieh_rec_type IS RECORD (
66: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
64: -- IEX_EXCLUSION_HIST_B Record Spec
65: TYPE ieh_rec_type IS RECORD (
66: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
65: TYPE ieh_rec_type IS RECORD (
66: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
66: exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
69: ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,org_id NUMBER := OKC_API.G_MISS_NUM
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90: ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: G_MISS_ieh_rec ieh_rec_type;
91: ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: G_MISS_ieh_rec ieh_rec_type;
99: TYPE ieh_tbl_type IS TABLE OF ieh_rec_type
92: ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: G_MISS_ieh_rec ieh_rec_type;
99: TYPE ieh_tbl_type IS TABLE OF ieh_rec_type
100: INDEX BY BINARY_INTEGER;
93: ,created_by NUMBER := OKC_API.G_MISS_NUM
94: ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96: ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: G_MISS_ieh_rec ieh_rec_type;
99: TYPE ieh_tbl_type IS TABLE OF ieh_rec_type
100: INDEX BY BINARY_INTEGER;
101: ---------------------------------------------------------------------------
100: INDEX BY BINARY_INTEGER;
101: ---------------------------------------------------------------------------
102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
101: ---------------------------------------------------------------------------
102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
114: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
114: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
115: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
114: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
115: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
116: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
114: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
115: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
116: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
117:
123: ---------------------------------------------------------------------------
124: -- GLOBAL VARIABLES
125: ---------------------------------------------------------------------------
126: G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_IEH_PVT';
127: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
128:
129: -------------------------------------------------------------------------------
130: --Post change to TAPI code
131: -------------------------------------------------------------------------------
145: PROCEDURE api_copy;
146: PROCEDURE add_language;
147: PROCEDURE insert_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_iehv_rec IN iehv_rec_type,
153: p_iehv_rec IN iehv_rec_type,
154: x_iehv_rec OUT NOCOPY iehv_rec_type);
155: PROCEDURE insert_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_iehv_tbl IN iehv_tbl_type,
162: x_iehv_tbl OUT NOCOPY iehv_tbl_type,
163: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
164: PROCEDURE insert_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_iehv_tbl IN iehv_tbl_type,
170: p_iehv_tbl IN iehv_tbl_type,
171: x_iehv_tbl OUT NOCOPY iehv_tbl_type);
172: PROCEDURE lock_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_iehv_rec IN iehv_rec_type);
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_iehv_rec IN iehv_rec_type);
179: PROCEDURE lock_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_iehv_tbl IN iehv_tbl_type,
185: p_iehv_tbl IN iehv_tbl_type,
186: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
187: PROCEDURE lock_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_iehv_tbl IN iehv_tbl_type);
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_iehv_tbl IN iehv_tbl_type);
194: PROCEDURE update_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_iehv_rec IN iehv_rec_type,
200: p_iehv_rec IN iehv_rec_type,
201: x_iehv_rec OUT NOCOPY iehv_rec_type);
202: PROCEDURE update_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_iehv_tbl IN iehv_tbl_type,
209: x_iehv_tbl OUT NOCOPY iehv_tbl_type,
210: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
211: PROCEDURE update_row(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_iehv_tbl IN iehv_tbl_type,
217: p_iehv_tbl IN iehv_tbl_type,
218: x_iehv_tbl OUT NOCOPY iehv_tbl_type);
219: PROCEDURE delete_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_iehv_rec IN iehv_rec_type);
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_iehv_rec IN iehv_rec_type);
226: PROCEDURE delete_row(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_iehv_tbl IN iehv_tbl_type,
232: p_iehv_tbl IN iehv_tbl_type,
233: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
234: PROCEDURE delete_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_iehv_tbl IN iehv_tbl_type);
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_iehv_tbl IN iehv_tbl_type);
241: PROCEDURE validate_row(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_iehv_rec IN iehv_rec_type);
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_iehv_rec IN iehv_rec_type);
248: PROCEDURE validate_row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_iehv_tbl IN iehv_tbl_type,
254: p_iehv_tbl IN iehv_tbl_type,
255: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
256: PROCEDURE validate_row(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_iehv_tbl IN iehv_tbl_type);