DBA Data[Home] [Help]

APPS.OKL_OIN_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_OPEN_INT_V Record Spec
7: TYPE oinv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE

Line 9: ,party_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_OPEN_INT_V Record Spec
7: TYPE oinv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR

6: -- OKL_OPEN_INT_V Record Spec
7: TYPE oinv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR

Line 11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR

7: TYPE oinv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR

9: ,party_id NUMBER := OKC_API.G_MISS_NUM
10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR

10: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR

11: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR

12: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR

13: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR

14: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR

15: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR

16: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR

17: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR

18: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR

19: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR

20: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR

21: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR

22: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

23: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR

24: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

25: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR

Line 30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR

26: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

27: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

28: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR

Line 33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR

29: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR

30: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM

Line 35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR

31: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR

32: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM

Line 37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR

33: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 38: ,cas_id NUMBER := OKC_API.G_MISS_NUM

34: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

35: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 40: ,khr_id NUMBER := OKC_API.G_MISS_NUM

36: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM

Line 41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

37: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR

38: ,cas_id NUMBER := OKC_API.G_MISS_NUM
39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

39: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM

Line 44: ,original_amount NUMBER := OKC_API.G_MISS_NUM

40: ,khr_id NUMBER := OKC_API.G_MISS_NUM
41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM

Line 45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE

42: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 47: ,term_duration NUMBER := OKC_API.G_MISS_NUM

43: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM

Line 48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM

44: ,original_amount NUMBER := OKC_API.G_MISS_NUM
45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM

Line 49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

45: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR

Line 50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE

46: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM

47: ,term_duration NUMBER := OKC_API.G_MISS_NUM
48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM

48: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE

Line 53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR

49: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE

Line 54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE

50: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM

Line 55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE

51: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM

Line 56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE

52: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE

53: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR

Line 58: ,referral_number NUMBER := OKC_API.G_MISS_NUM

54: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,contact_id NUMBER := OKC_API.G_MISS_NUM

55: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR

56: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR

57: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR

58: ,referral_number NUMBER := OKC_API.G_MISS_NUM
59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

59: ,contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 64: ,org_id NUMBER := OKC_API.G_MISS_NUM

60: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 65: ,request_id NUMBER := OKC_API.G_MISS_NUM

61: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

62: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 67: ,program_id NUMBER := OKC_API.G_MISS_NUM

63: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

64: ,org_id NUMBER := OKC_API.G_MISS_NUM
65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

65: ,request_id NUMBER := OKC_API.G_MISS_NUM
66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

66: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

67: ,program_id NUMBER := OKC_API.G_MISS_NUM
68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

68: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

69: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

70: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

71: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

72: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

73: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

74: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

75: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

76: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

77: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

78: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

79: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

80: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 85: ,created_by NUMBER := OKC_API.G_MISS_NUM

81: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

82: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90: G_MISS_oinv_rec oinv_rec_type;

Line 87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

83: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90: G_MISS_oinv_rec oinv_rec_type;
91: TYPE oinv_tbl_type IS TABLE OF oinv_rec_type

Line 88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

84: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90: G_MISS_oinv_rec oinv_rec_type;
91: TYPE oinv_tbl_type IS TABLE OF oinv_rec_type
92: INDEX BY BINARY_INTEGER;

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

85: ,created_by NUMBER := OKC_API.G_MISS_NUM
86: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90: G_MISS_oinv_rec oinv_rec_type;
91: TYPE oinv_tbl_type IS TABLE OF oinv_rec_type
92: INDEX BY BINARY_INTEGER;
93: -- OKL_OPEN_INT Record Spec

Line 95: id NUMBER := OKC_API.G_MISS_NUM

91: TYPE oinv_tbl_type IS TABLE OF oinv_rec_type
92: INDEX BY BINARY_INTEGER;
93: -- OKL_OPEN_INT Record Spec
94: TYPE oin_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM
96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE

Line 96: ,party_id NUMBER := OKC_API.G_MISS_NUM

92: INDEX BY BINARY_INTEGER;
93: -- OKL_OPEN_INT Record Spec
94: TYPE oin_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM
96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR

Line 97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR

93: -- OKL_OPEN_INT Record Spec
94: TYPE oin_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM
96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR

Line 98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR

94: TYPE oin_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM
96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE

95: id NUMBER := OKC_API.G_MISS_NUM
96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR

96: ,party_id NUMBER := OKC_API.G_MISS_NUM
97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR

Line 101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR

97: ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR

Line 102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR

98: ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR

Line 103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR

99: ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR

Line 104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR

100: ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR

Line 105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR

101: ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR

102: ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR

Line 107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR

103: ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR

Line 108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR

104: ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR

Line 109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR

105: ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR

106: ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR

107: ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR

Line 112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR

108: ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR

109: ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR

Line 114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

110: ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR

111: ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

112: ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR

Line 117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR

113: ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR

Line 118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

114: ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR

Line 119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

115: ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR

Line 120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR

116: ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR

117: ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM

Line 122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR

118: ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR

119: ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM

Line 124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR

120: ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 125: ,cas_id NUMBER := OKC_API.G_MISS_NUM

121: ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

122: ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 127: ,khr_id NUMBER := OKC_API.G_MISS_NUM

123: ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM

Line 128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

124: ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR

125: ,cas_id NUMBER := OKC_API.G_MISS_NUM
126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

126: ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM

Line 131: ,original_amount NUMBER := OKC_API.G_MISS_NUM

127: ,khr_id NUMBER := OKC_API.G_MISS_NUM
128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM

Line 132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE

128: ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE

129: ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 134: ,term_duration NUMBER := OKC_API.G_MISS_NUM

130: ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM

Line 135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM

131: ,original_amount NUMBER := OKC_API.G_MISS_NUM
132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM

Line 136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

132: ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR

Line 137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE

133: ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM

134: ,term_duration NUMBER := OKC_API.G_MISS_NUM
135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM

135: ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE

Line 140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR

136: ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE

Line 141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE

137: ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM

Line 142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE

138: ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM

Line 143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE

139: ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE

140: ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR

Line 145: ,referral_number NUMBER := OKC_API.G_MISS_NUM

141: ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR

Line 146: ,contact_id NUMBER := OKC_API.G_MISS_NUM

142: ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR

143: ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR

144: ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR

145: ,referral_number NUMBER := OKC_API.G_MISS_NUM
146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

146: ,contact_id NUMBER := OKC_API.G_MISS_NUM
147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 151: ,org_id NUMBER := OKC_API.G_MISS_NUM

147: ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 152: ,request_id NUMBER := OKC_API.G_MISS_NUM

148: ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

149: ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 154: ,program_id NUMBER := OKC_API.G_MISS_NUM

150: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

151: ,org_id NUMBER := OKC_API.G_MISS_NUM
152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

152: ,request_id NUMBER := OKC_API.G_MISS_NUM
153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

153: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

154: ,program_id NUMBER := OKC_API.G_MISS_NUM
155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

155: ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

156: ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

157: ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

158: ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

159: ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

160: ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

161: ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

162: ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

163: ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

164: ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

165: ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

166: ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

167: ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 172: ,created_by NUMBER := OKC_API.G_MISS_NUM

168: ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

169: ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
177: G_MISS_oin_rec oin_rec_type;

Line 174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

170: ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
177: G_MISS_oin_rec oin_rec_type;
178: TYPE oin_tbl_type IS TABLE OF oin_rec_type

Line 175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

171: ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
177: G_MISS_oin_rec oin_rec_type;
178: TYPE oin_tbl_type IS TABLE OF oin_rec_type
179: INDEX BY BINARY_INTEGER;

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

172: ,created_by NUMBER := OKC_API.G_MISS_NUM
173: ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175: ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
177: G_MISS_oin_rec oin_rec_type;
178: TYPE oin_tbl_type IS TABLE OF oin_rec_type
179: INDEX BY BINARY_INTEGER;
180: ---------------------------------------------------------------------------

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

179: INDEX BY BINARY_INTEGER;
180: ---------------------------------------------------------------------------
181: -- GLOBAL MESSAGE CONSTANTS
182: ---------------------------------------------------------------------------
183: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

180: ---------------------------------------------------------------------------
181: -- GLOBAL MESSAGE CONSTANTS
182: ---------------------------------------------------------------------------
183: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

181: -- GLOBAL MESSAGE CONSTANTS
182: ---------------------------------------------------------------------------
183: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

182: ---------------------------------------------------------------------------
183: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

183: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

184: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

185: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
193: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

186: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
193: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
194: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

187: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
193: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
194: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
195: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

188: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
193: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
194: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
195: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
196:

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

202: ---------------------------------------------------------------------------
203: -- GLOBAL VARIABLES
204: ---------------------------------------------------------------------------
205: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OIN_PVT';
206: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
207: -------------------------------------------------------------------------------
208: --Post change to TAPI code
209: -------------------------------------------------------------------------------
210: --G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

221: PROCEDURE change_version;
222: PROCEDURE api_copy;
223: PROCEDURE insert_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_oinv_rec IN oinv_rec_type,

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229: p_oinv_rec IN oinv_rec_type,
230: x_oinv_rec OUT NOCOPY oinv_rec_type);
231: PROCEDURE insert_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_oinv_tbl IN oinv_tbl_type,

Line 242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

238: x_oinv_tbl OUT NOCOPY oinv_tbl_type,
239: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
240: PROCEDURE insert_row(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_oinv_tbl IN oinv_tbl_type,

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246: p_oinv_tbl IN oinv_tbl_type,
247: x_oinv_tbl OUT NOCOPY oinv_tbl_type);
248: PROCEDURE lock_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_oinv_rec IN oinv_rec_type);

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_oinv_rec IN oinv_rec_type);
255: PROCEDURE lock_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_oinv_tbl IN oinv_tbl_type,

Line 265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

261: p_oinv_tbl IN oinv_tbl_type,
262: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
263: PROCEDURE lock_row(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_oinv_tbl IN oinv_tbl_type);

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_oinv_tbl IN oinv_tbl_type);
270: PROCEDURE update_row(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_oinv_rec IN oinv_rec_type,

Line 280: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

276: p_oinv_rec IN oinv_rec_type,
277: x_oinv_rec OUT NOCOPY oinv_rec_type);
278: PROCEDURE update_row(
279: p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_oinv_tbl IN oinv_tbl_type,

Line 289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

285: x_oinv_tbl OUT NOCOPY oinv_tbl_type,
286: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
287: PROCEDURE update_row(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_oinv_tbl IN oinv_tbl_type,

Line 297: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

293: p_oinv_tbl IN oinv_tbl_type,
294: x_oinv_tbl OUT NOCOPY oinv_tbl_type);
295: PROCEDURE delete_row(
296: p_api_version IN NUMBER,
297: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2,
301: p_oinv_rec IN oinv_rec_type);

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

300: x_msg_data OUT NOCOPY VARCHAR2,
301: p_oinv_rec IN oinv_rec_type);
302: PROCEDURE delete_row(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_oinv_tbl IN oinv_tbl_type,

Line 312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

308: p_oinv_tbl IN oinv_tbl_type,
309: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
310: PROCEDURE delete_row(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_oinv_tbl IN oinv_tbl_type);

Line 319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_oinv_tbl IN oinv_tbl_type);
317: PROCEDURE validate_row(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_oinv_rec IN oinv_rec_type);

Line 326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_oinv_rec IN oinv_rec_type);
324: PROCEDURE validate_row(
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: p_oinv_tbl IN oinv_tbl_type,

Line 334: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

330: p_oinv_tbl IN oinv_tbl_type,
331: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
332: PROCEDURE validate_row(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2,
338: p_oinv_tbl IN oinv_tbl_type);