3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE art_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE art_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE art_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE art_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: kle_id NUMBER := OKC_API.G_MISS_NUM,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
9: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
10: iso_id NUMBER := OKC_API.G_MISS_NUM,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
11: rna_id NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: rmr_id NUMBER := OKC_API.G_MISS_NUM,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
13: ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
14: imr_id NUMBER := OKC_API.G_MISS_NUM,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
15: art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
16: date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
17: date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
18: relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
19: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
20: voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
21: commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
22: date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
23: date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: request_id NUMBER := OKC_API.G_MISS_NUM,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: program_application_id NUMBER := OKC_API.G_MISS_NUM,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: program_id NUMBER := OKC_API.G_MISS_NUM,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
41: attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
45: attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
46: attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
47: attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55:
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55:
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
49: creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55:
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55:
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
53: floor_price NUMBER := OKC_API.G_MISS_NUM,
54: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55:
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
55:
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
56: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
57: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
58:
59: new_item_price NUMBER := OKC_API.G_MISS_NUM,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: --RABHUPAT - 2667636 - End
62: like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: --RABHUPAT - 2667636 - End
70: -- RRAVIKIR - Legal Entity Changes
63: -- RABHUPAT - 2667636 - Start
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: --RABHUPAT - 2667636 - End
70: -- RRAVIKIR - Legal Entity Changes
71: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
64: currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65: currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: --RABHUPAT - 2667636 - End
70: -- RRAVIKIR - Legal Entity Changes
71: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
72: -- Legal Entity Changes End
67: currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68: currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: --RABHUPAT - 2667636 - End
70: -- RRAVIKIR - Legal Entity Changes
71: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
72: -- Legal Entity Changes End
73: -- DJANASWA Loan Repossession proj start
74: ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_B.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
75: -- Loan Repossession proj end
70: -- RRAVIKIR - Legal Entity Changes
71: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
72: -- Legal Entity Changes End
73: -- DJANASWA Loan Repossession proj start
74: ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_B.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
75: -- Loan Repossession proj end
76: g_miss_art_rec art_rec_type;
77: TYPE art_tbl_type IS TABLE OF art_rec_type
78: INDEX BY BINARY_INTEGER;
76: g_miss_art_rec art_rec_type;
77: TYPE art_tbl_type IS TABLE OF art_rec_type
78: INDEX BY BINARY_INTEGER;
79: TYPE okl_asset_returns_tl_rec_type IS RECORD (
80: id NUMBER := OKC_API.G_MISS_NUM,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: TYPE art_tbl_type IS TABLE OF art_rec_type
78: INDEX BY BINARY_INTEGER;
79: TYPE okl_asset_returns_tl_rec_type IS RECORD (
80: id NUMBER := OKC_API.G_MISS_NUM,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
78: INDEX BY BINARY_INTEGER;
79: TYPE okl_asset_returns_tl_rec_type IS RECORD (
80: id NUMBER := OKC_API.G_MISS_NUM,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: TYPE okl_asset_returns_tl_rec_type IS RECORD (
80: id NUMBER := OKC_API.G_MISS_NUM,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: id NUMBER := OKC_API.G_MISS_NUM,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
90: new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
83: sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
90: new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
91: GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
84: comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
90: new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
91: GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
92: TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
85: created_by NUMBER := OKC_API.G_MISS_NUM,
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
90: new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
91: GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
92: TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
93: INDEX BY BINARY_INTEGER;
86: creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88: last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89: last_update_login NUMBER := OKC_API.G_MISS_NUM,
90: new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
91: GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
92: TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
93: INDEX BY BINARY_INTEGER;
94: TYPE artv_rec_type IS RECORD (
91: GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
92: TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
93: INDEX BY BINARY_INTEGER;
94: TYPE artv_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
92: TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
93: INDEX BY BINARY_INTEGER;
94: TYPE artv_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
93: INDEX BY BINARY_INTEGER;
94: TYPE artv_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
94: TYPE artv_rec_type IS RECORD (
95: id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
95: id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
96: object_version_number NUMBER := OKC_API.G_MISS_NUM,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
97: sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: rmr_id NUMBER := OKC_API.G_MISS_NUM,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
99: imr_id NUMBER := OKC_API.G_MISS_NUM,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
100: rna_id NUMBER := OKC_API.G_MISS_NUM,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
101: kle_id NUMBER := OKC_API.G_MISS_NUM,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
102: iso_id NUMBER := OKC_API.G_MISS_NUM,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
103: security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
104: ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
105: art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
106: date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
107: date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
108: date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
109: date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
110: relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
111: voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
112: date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
113: date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
114: date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
115: commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
116: comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
117: attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
118: attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
119: attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
120: attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
121: attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
122: attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
123: attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
124: attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
125: attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
126: attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
127: attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
128: attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
129: attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
130: attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
131: attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
132: attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
133: org_id NUMBER := OKC_API.G_MISS_NUM,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
134: request_id NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
135: program_application_id NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
136: program_id NUMBER := OKC_API.G_MISS_NUM,
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
137: program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
138: created_by NUMBER := OKC_API.G_MISS_NUM,
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
139: creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141: last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
142: last_update_login NUMBER := OKC_API.G_MISS_NUM,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
143: floor_price NUMBER := OKC_API.G_MISS_NUM,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
144: -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
145:
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
146: -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
148: new_item_price NUMBER := OKC_API.G_MISS_NUM,
149: asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
150: new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
151: repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159: -- RABHUPAT - 2667636 - End
152: like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159: -- RABHUPAT - 2667636 - End
160: -- RRAVIKIR - Legal Entity Changes
153: -- RABHUPAT - 2667636 - Start
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159: -- RABHUPAT - 2667636 - End
160: -- RRAVIKIR - Legal Entity Changes
161: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
154: currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155: currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156: currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159: -- RABHUPAT - 2667636 - End
160: -- RRAVIKIR - Legal Entity Changes
161: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
162: -- Legal Entity Changes End
157: currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158: currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159: -- RABHUPAT - 2667636 - End
160: -- RRAVIKIR - Legal Entity Changes
161: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
162: -- Legal Entity Changes End
163: -- DJANASWA Loan Repossession proj start
164: ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_V.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
165: -- Loan Repossession proj end
160: -- RRAVIKIR - Legal Entity Changes
161: legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
162: -- Legal Entity Changes End
163: -- DJANASWA Loan Repossession proj start
164: ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_V.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
165: -- Loan Repossession proj end
166:
167: g_miss_artv_rec artv_rec_type;
168: TYPE artv_tbl_type IS TABLE OF artv_rec_type
169: INDEX BY BINARY_INTEGER;
170: ---------------------------------------------------------------------------
171: -- GLOBAL MESSAGE CONSTANTS
172: ---------------------------------------------------------------------------
173: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
170: ---------------------------------------------------------------------------
171: -- GLOBAL MESSAGE CONSTANTS
172: ---------------------------------------------------------------------------
173: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
171: -- GLOBAL MESSAGE CONSTANTS
172: ---------------------------------------------------------------------------
173: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
172: ---------------------------------------------------------------------------
173: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
173: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
174: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
175: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
183: ---------------------------------------------------------------------------
176: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
183: ---------------------------------------------------------------------------
184: -- GLOBAL VARIABLES
177: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
183: ---------------------------------------------------------------------------
184: -- GLOBAL VARIABLES
185: ---------------------------------------------------------------------------
178: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
183: ---------------------------------------------------------------------------
184: -- GLOBAL VARIABLES
185: ---------------------------------------------------------------------------
186: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ART_PVT';
183: ---------------------------------------------------------------------------
184: -- GLOBAL VARIABLES
185: ---------------------------------------------------------------------------
186: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ART_PVT';
187: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
188: ---------------------------------------------------------------------------
189: -- Procedures and Functions
190: ---------------------------------------------------------------------------
191:
194: PROCEDURE api_copy;
195: PROCEDURE add_language;
196: PROCEDURE insert_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_artv_rec IN artv_rec_type,
203: x_artv_rec OUT NOCOPY artv_rec_type);
204:
205: PROCEDURE insert_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_artv_tbl IN artv_tbl_type,
212: x_artv_tbl OUT NOCOPY artv_tbl_type);
213:
214: PROCEDURE lock_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_artv_rec IN artv_rec_type);
220: p_artv_rec IN artv_rec_type);
221:
222: PROCEDURE lock_row(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_artv_tbl IN artv_tbl_type);
228: p_artv_tbl IN artv_tbl_type);
229:
230: PROCEDURE update_row(
231: p_api_version IN NUMBER,
232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_artv_rec IN artv_rec_type,
237: x_artv_rec OUT NOCOPY artv_rec_type);
238:
239: PROCEDURE update_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_artv_tbl IN artv_tbl_type,
246: x_artv_tbl OUT NOCOPY artv_tbl_type);
247:
248: PROCEDURE delete_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_artv_rec IN artv_rec_type);
254: p_artv_rec IN artv_rec_type);
255:
256: PROCEDURE delete_row(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_artv_tbl IN artv_tbl_type);
262: p_artv_tbl IN artv_tbl_type);
263:
264: PROCEDURE validate_row(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_artv_rec IN artv_rec_type);
270: p_artv_rec IN artv_rec_type);
271:
272: PROCEDURE validate_row(
273: p_api_version IN NUMBER,
274: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_artv_tbl IN artv_tbl_type);