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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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;
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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;
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
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;
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: ---------------------------------------------------------------------------
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;
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;
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;
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;
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;
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;
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';
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';
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';
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:
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;
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,
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,
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,
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);
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,
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);
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,
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,
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,
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);
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,
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);
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);
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,
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);