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

APPS.IEX_IEA_PVT dependencies on OKC_API

Line 8: external_agency_id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- IEX_EXT_AGNCY_V Record Spec
7: TYPE ieav_rec_type IS RECORD (
8: external_agency_id NUMBER := OKC_API.G_MISS_NUM
9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM

Line 9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- IEX_EXT_AGNCY_V Record Spec
7: TYPE ieav_rec_type IS RECORD (
8: external_agency_id NUMBER := OKC_API.G_MISS_NUM
9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM

6: -- IEX_EXT_AGNCY_V Record Spec
7: TYPE ieav_rec_type IS RECORD (
8: external_agency_id NUMBER := OKC_API.G_MISS_NUM
9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE ieav_rec_type IS RECORD (
8: external_agency_id NUMBER := OKC_API.G_MISS_NUM
9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,rank NUMBER := OKC_API.G_MISS_NUM

8: external_agency_id NUMBER := OKC_API.G_MISS_NUM
9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE

9: ,external_agency_name IEX_EXT_AGNCY_V.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

11: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

12: ,rank NUMBER := OKC_API.G_MISS_NUM
13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

13: ,effective_start_date IEX_EXT_AGNCY_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

14: ,effective_end_date IEX_EXT_AGNCY_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

15: ,description IEX_EXT_AGNCY_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,org_id NUMBER := OKC_API.G_MISS_NUM

16: ,language IEX_EXT_AGNCY_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

17: ,source_lang IEX_EXT_AGNCY_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 IEX_EXT_AGNCY_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

18: ,sfwt_flag IEX_EXT_AGNCY_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 IEX_EXT_AGNCY_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 IEX_EXT_AGNCY_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 IEX_EXT_AGNCY_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 IEX_EXT_AGNCY_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 IEX_EXT_AGNCY_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

20: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,attribute_category IEX_EXT_AGNCY_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute1 IEX_EXT_AGNCY_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute2 IEX_EXT_AGNCY_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute3 IEX_EXT_AGNCY_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute4 IEX_EXT_AGNCY_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute5 IEX_EXT_AGNCY_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute6 IEX_EXT_AGNCY_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute7 IEX_EXT_AGNCY_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,attribute4 IEX_EXT_AGNCY_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

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

Line 26: ,attribute5 IEX_EXT_AGNCY_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

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

Line 27: ,attribute6 IEX_EXT_AGNCY_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

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

Line 28: ,attribute7 IEX_EXT_AGNCY_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

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

Line 29: ,attribute8 IEX_EXT_AGNCY_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

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

Line 30: ,attribute9 IEX_EXT_AGNCY_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

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

Line 31: ,attribute10 IEX_EXT_AGNCY_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

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

Line 32: ,attribute11 IEX_EXT_AGNCY_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

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

Line 33: ,attribute12 IEX_EXT_AGNCY_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

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

Line 34: ,attribute13 IEX_EXT_AGNCY_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

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

Line 35: ,attribute14 IEX_EXT_AGNCY_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

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

Line 36: ,attribute15 IEX_EXT_AGNCY_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

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

Line 37: ,created_by NUMBER := OKC_API.G_MISS_NUM

33: ,attribute12 IEX_EXT_AGNCY_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute13 IEX_EXT_AGNCY_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 IEX_EXT_AGNCY_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 IEX_EXT_AGNCY_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

34: ,attribute13 IEX_EXT_AGNCY_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute14 IEX_EXT_AGNCY_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 IEX_EXT_AGNCY_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: G_MISS_ieav_rec ieav_rec_type;

Line 39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

35: ,attribute14 IEX_EXT_AGNCY_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute15 IEX_EXT_AGNCY_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: G_MISS_ieav_rec ieav_rec_type;
43: TYPE ieav_tbl_type IS TABLE OF ieav_rec_type

Line 40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

36: ,attribute15 IEX_EXT_AGNCY_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: G_MISS_ieav_rec ieav_rec_type;
43: TYPE ieav_tbl_type IS TABLE OF ieav_rec_type
44: INDEX BY BINARY_INTEGER;

Line 41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,creation_date IEX_EXT_AGNCY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_date IEX_EXT_AGNCY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: G_MISS_ieav_rec ieav_rec_type;
43: TYPE ieav_tbl_type IS TABLE OF ieav_rec_type
44: INDEX BY BINARY_INTEGER;
45: -- IEX_EXT_AGNCY_B Record Spec

Line 47: external_agency_id NUMBER := OKC_API.G_MISS_NUM

43: TYPE ieav_tbl_type IS TABLE OF ieav_rec_type
44: INDEX BY BINARY_INTEGER;
45: -- IEX_EXT_AGNCY_B Record Spec
46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM

Line 48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR

44: INDEX BY BINARY_INTEGER;
45: -- IEX_EXT_AGNCY_B Record Spec
46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM

45: -- IEX_EXT_AGNCY_B Record Spec
46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM

46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 51: ,rank NUMBER := OKC_API.G_MISS_NUM

47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE

48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE

49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 55: ,org_id NUMBER := OKC_API.G_MISS_NUM

51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 72: ,created_by NUMBER := OKC_API.G_MISS_NUM

68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;

Line 74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;
78: TYPE iea_tbl_type IS TABLE OF iea_rec_type

Line 75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;
78: TYPE iea_tbl_type IS TABLE OF iea_rec_type
79: INDEX BY BINARY_INTEGER;

Line 76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;
78: TYPE iea_tbl_type IS TABLE OF iea_rec_type
79: INDEX BY BINARY_INTEGER;
80: -- IEX_EXT_AGNCY_TL Record Spec

Line 82: external_agency_id NUMBER := OKC_API.G_MISS_NUM

78: TYPE iea_tbl_type IS TABLE OF iea_rec_type
79: INDEX BY BINARY_INTEGER;
80: -- IEX_EXT_AGNCY_TL Record Spec
81: TYPE ieat_rec_type IS RECORD (
82: external_agency_id NUMBER := OKC_API.G_MISS_NUM
83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

79: INDEX BY BINARY_INTEGER;
80: -- IEX_EXT_AGNCY_TL Record Spec
81: TYPE ieat_rec_type IS RECORD (
82: external_agency_id NUMBER := OKC_API.G_MISS_NUM
83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

80: -- IEX_EXT_AGNCY_TL Record Spec
81: TYPE ieat_rec_type IS RECORD (
82: external_agency_id NUMBER := OKC_API.G_MISS_NUM
83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

81: TYPE ieat_rec_type IS RECORD (
82: external_agency_id NUMBER := OKC_API.G_MISS_NUM
83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

82: external_agency_id NUMBER := OKC_API.G_MISS_NUM
83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 87: ,created_by NUMBER := OKC_API.G_MISS_NUM

83: ,description IEX_EXT_AGNCY_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

84: ,language IEX_EXT_AGNCY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
92: G_MISS_ieat_rec ieat_rec_type;

Line 89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

85: ,source_lang IEX_EXT_AGNCY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
92: G_MISS_ieat_rec ieat_rec_type;
93: TYPE ieat_tbl_type IS TABLE OF ieat_rec_type

Line 90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

86: ,sfwt_flag IEX_EXT_AGNCY_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
92: G_MISS_ieat_rec ieat_rec_type;
93: TYPE ieat_tbl_type IS TABLE OF ieat_rec_type
94: INDEX BY BINARY_INTEGER;

Line 91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

87: ,created_by NUMBER := OKC_API.G_MISS_NUM
88: ,creation_date IEX_EXT_AGNCY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
90: ,last_update_date IEX_EXT_AGNCY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
92: G_MISS_ieat_rec ieat_rec_type;
93: TYPE ieat_tbl_type IS TABLE OF ieat_rec_type
94: INDEX BY BINARY_INTEGER;
95: ---------------------------------------------------------------------------

Line 98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

94: INDEX BY BINARY_INTEGER;
95: ---------------------------------------------------------------------------
96: -- GLOBAL MESSAGE CONSTANTS
97: ---------------------------------------------------------------------------
98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

95: ---------------------------------------------------------------------------
96: -- GLOBAL MESSAGE CONSTANTS
97: ---------------------------------------------------------------------------
98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

96: -- GLOBAL MESSAGE CONSTANTS
97: ---------------------------------------------------------------------------
98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

97: ---------------------------------------------------------------------------
98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

98: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

99: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

100: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
108: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

101: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
108: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
109: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

102: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
108: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
109: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
110: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

103: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
104: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
105: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
106: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
107: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
108: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
109: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
110: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
111:

Line 121: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

117: ---------------------------------------------------------------------------
118: -- GLOBAL VARIABLES
119: ---------------------------------------------------------------------------
120: G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_IEA_PVT';
121: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
122: -------------------------------------------------------------------------------
123: --Post change to TAPI code
124: -------------------------------------------------------------------------------
125: --G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

138: PROCEDURE api_copy;
139: PROCEDURE add_language;
140: PROCEDURE insert_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_ieav_rec IN ieav_rec_type,

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: p_ieav_rec IN ieav_rec_type,
147: x_ieav_rec OUT NOCOPY ieav_rec_type);
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_ieav_tbl IN ieav_tbl_type,

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155: x_ieav_tbl OUT NOCOPY ieav_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_ieav_tbl IN ieav_tbl_type,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

163: p_ieav_tbl IN ieav_tbl_type,
164: x_ieav_tbl OUT NOCOPY ieav_tbl_type);
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ieav_rec IN ieav_rec_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ieav_rec IN ieav_rec_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_ieav_tbl IN ieav_tbl_type,

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_ieav_tbl IN ieav_tbl_type,
179: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
180: PROCEDURE lock_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_ieav_tbl IN ieav_tbl_type);

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_ieav_tbl IN ieav_tbl_type);
187: PROCEDURE update_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_ieav_rec IN ieav_rec_type,

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

193: p_ieav_rec IN ieav_rec_type,
194: x_ieav_rec OUT NOCOPY ieav_rec_type);
195: PROCEDURE update_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_ieav_tbl IN ieav_tbl_type,

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: x_ieav_tbl OUT NOCOPY ieav_tbl_type,
203: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
204: PROCEDURE update_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_ieav_tbl IN ieav_tbl_type,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: p_ieav_tbl IN ieav_tbl_type,
211: x_ieav_tbl OUT NOCOPY ieav_tbl_type);
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_ieav_rec IN ieav_rec_type);

Line 221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_ieav_rec IN ieav_rec_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_ieav_tbl IN ieav_tbl_type,

Line 229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

225: p_ieav_tbl IN ieav_tbl_type,
226: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
227: PROCEDURE delete_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_ieav_tbl IN ieav_tbl_type);

Line 236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_ieav_tbl IN ieav_tbl_type);
234: PROCEDURE validate_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_ieav_rec IN ieav_rec_type);

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_ieav_rec IN ieav_rec_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_ieav_tbl IN ieav_tbl_type,

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247: p_ieav_tbl IN ieav_tbl_type,
248: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
249: PROCEDURE validate_row(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_ieav_tbl IN ieav_tbl_type);