3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tcn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tcn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE tcn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
6: TYPE tcn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
8: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
9: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
10: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
13: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
14: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
15: qte_id NUMBER := Okc_Api.G_MISS_NUM,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
16: aes_id NUMBER := Okc_Api.G_MISS_NUM,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
17: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
18: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
19: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
20: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
21: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
23: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
24: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
25: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
26: created_by NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
27: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
28: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
29: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
30: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
32: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33: org_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
34: khr_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
35: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
36: := Okc_Api.G_MISS_CHAR,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
37: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
38: := Okc_Api.G_MISS_CHAR,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
39: amount NUMBER := Okc_Api.G_MISS_NUM,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
40: request_id NUMBER := Okc_Api.G_MISS_NUM,
41: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
42: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
43: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
44: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
45: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
46: := Okc_Api.G_MISS_DATE,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
47: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
48: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
49: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
50: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
51: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
52: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
56: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
57: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
59: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
61: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
62: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
63: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64: try_id NUMBER := Okc_Api.G_MISS_NUM,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
65: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73: := Okc_Api.G_MISS_CHAR,
66: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73: := Okc_Api.G_MISS_CHAR,
74: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
67: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73: := Okc_Api.G_MISS_CHAR,
74: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
75: := Okc_Api.G_MISS_CHAR,
69: := Okc_Api.G_MISS_DATE,
70: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73: := Okc_Api.G_MISS_CHAR,
74: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
75: := Okc_Api.G_MISS_CHAR,
76: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77: := Okc_Api.G_MISS_CHAR,
71: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73: := Okc_Api.G_MISS_CHAR,
74: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
75: := Okc_Api.G_MISS_CHAR,
76: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77: := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
73: := Okc_Api.G_MISS_CHAR,
74: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
75: := Okc_Api.G_MISS_CHAR,
76: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77: := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
75: := Okc_Api.G_MISS_CHAR,
76: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77: := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
76: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77: := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
77: := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
79: := Okc_Api.G_MISS_CHAR,
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87:
80: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87:
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
81: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87:
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89:
82: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87:
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89:
90: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
86: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87:
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89:
90: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
91: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
92: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
93: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94:
87:
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89:
90: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
91: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
92: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
93: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94:
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
88: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89:
90: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
91: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
92: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
93: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94:
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96:
89:
90: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
91: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
92: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
93: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94:
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96:
97: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
93: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94:
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96:
97: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
98: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
99: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
100:
101: -- Added by Keerthi
94:
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96:
97: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
98: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
99: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
100:
101: -- Added by Keerthi
102: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
95: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96:
97: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
98: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
99: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
100:
101: -- Added by Keerthi
102: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
103:
98: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
99: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
100:
101: -- Added by Keerthi
102: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
103:
104: -- Added by Keerthi
105: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
106: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
101: -- Added by Keerthi
102: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
103:
104: -- Added by Keerthi
105: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
106: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
107:
108: -- Added by kmotepal
109: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
102: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
103:
104: -- Added by Keerthi
105: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
106: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
107:
108: -- Added by kmotepal
109: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
110: --Added by dpsingh for LE Uptake
105: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
106: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
107:
108: -- Added by kmotepal
109: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
110: --Added by dpsingh for LE Uptake
111: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM,
112: --Added by dpsingh for SLA Uptake (Bug 5707866)
113: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
111: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM,
112: --Added by dpsingh for SLA Uptake (Bug 5707866)
113: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
114: -- Added by DJANASWA for SLA project
115: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
116: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
114: -- Added by DJANASWA for SLA project
115: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
116: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
114: -- Added by DJANASWA for SLA project
115: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
116: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
115: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
116: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
116: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
124: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
117: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
124: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
125: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
118: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
124: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
125: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
126: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
124: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
125: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
126: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
127: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
128: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
124: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
125: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
126: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
127: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
128: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
129: REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
130: -- sosharma added column for Income accrual recon-report
131: TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
132: );
125: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
126: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
127: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
128: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
129: REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
130: -- sosharma added column for Income accrual recon-report
131: TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
132: );
133:
135: g_miss_tcn_rec tcn_rec_type;
136: TYPE tcn_tbl_type IS TABLE OF tcn_rec_type
137: INDEX BY BINARY_INTEGER;
138: TYPE tcnv_rec_type IS RECORD (
139: id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
136: TYPE tcn_tbl_type IS TABLE OF tcn_rec_type
137: INDEX BY BINARY_INTEGER;
138: TYPE tcnv_rec_type IS RECORD (
139: id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
137: INDEX BY BINARY_INTEGER;
138: TYPE tcnv_rec_type IS RECORD (
139: id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
138: TYPE tcnv_rec_type IS RECORD (
139: id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
139: id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
140: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
141: rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
142: rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
143: rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
144: trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
145: khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
146: pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147: pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154: := Okc_Api.G_MISS_CHAR,
148: qte_id NUMBER := Okc_Api.G_MISS_NUM,
149: aes_id NUMBER := Okc_Api.G_MISS_NUM,
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
150: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
151: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152: := Okc_Api.G_MISS_CHAR,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
153: tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
154: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
155: date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
156: accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157: := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
158: update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
159: amount NUMBER := Okc_Api.G_MISS_NUM,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
160: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
161: attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
162: := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
163: attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
164: attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
165: attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
166: attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
167: attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
168: attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
169: attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
170: attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
171: attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
172: attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
173: attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
174: attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
175: attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
176: attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
177: attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
178: tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
179: rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
180: party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
181: party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
182: party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
183: party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
184: complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
185: org_id NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
186: khr_id NUMBER := Okc_Api.G_MISS_NUM,
187: request_id NUMBER := Okc_Api.G_MISS_NUM,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
188: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
189: khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
190: program_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
191: program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
192: := Okc_Api.G_MISS_DATE,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
193: created_by NUMBER := Okc_Api.G_MISS_NUM,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
194: creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
195: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
196: last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
197: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198: try_id NUMBER := Okc_Api.G_MISS_NUM,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
199: tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207: := Okc_Api.G_MISS_CHAR,
200: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207: := Okc_Api.G_MISS_CHAR,
208: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
201: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202: date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207: := Okc_Api.G_MISS_CHAR,
208: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
209: := Okc_Api.G_MISS_CHAR,
203: := Okc_Api.G_MISS_DATE,
204: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207: := Okc_Api.G_MISS_CHAR,
208: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
209: := Okc_Api.G_MISS_CHAR,
210: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211: := Okc_Api.G_MISS_CHAR,
205: tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206: tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207: := Okc_Api.G_MISS_CHAR,
208: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
209: := Okc_Api.G_MISS_CHAR,
210: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211: := Okc_Api.G_MISS_CHAR,
212: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213: := Okc_Api.G_MISS_CHAR,
207: := Okc_Api.G_MISS_CHAR,
208: tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
209: := Okc_Api.G_MISS_CHAR,
210: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211: := Okc_Api.G_MISS_CHAR,
212: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
209: := Okc_Api.G_MISS_CHAR,
210: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211: := Okc_Api.G_MISS_CHAR,
212: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
210: tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211: := Okc_Api.G_MISS_CHAR,
212: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
211: := Okc_Api.G_MISS_CHAR,
212: tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
213: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221: := Okc_Api.G_MISS_CHAR,
214: tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221: := Okc_Api.G_MISS_CHAR,
222: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
215: tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216: tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221: := Okc_Api.G_MISS_CHAR,
222: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
223:
217: := Okc_Api.G_MISS_CHAR,
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221: := Okc_Api.G_MISS_CHAR,
222: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
223:
224: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225:
218: tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219: tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220: tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221: := Okc_Api.G_MISS_CHAR,
222: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
223:
224: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225:
226: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
222: accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
223:
224: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225:
226: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
227: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
228: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
229: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230:
223:
224: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225:
226: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
227: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
228: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
229: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
224: -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225:
226: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
227: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
228: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
229: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232:
225:
226: tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
227: tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
228: tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
229: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232:
233: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
229: tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232:
233: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
234: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
235: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
236:
237: -- Added by Keerthi
230:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232:
233: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
234: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
235: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
236:
237: -- Added by Keerthi
238:
231: -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232:
233: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
234: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
235: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
236:
237: -- Added by Keerthi
238:
239: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
235: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
236:
237: -- Added by Keerthi
238:
239: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
240:
241: -- Added by Keerthi
242: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
243: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
238:
239: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
240:
241: -- Added by Keerthi
242: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
243: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
244:
245: -- Added by kmotepal
246: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
239: chr_id NUMBER := Okc_Api.G_MISS_NUM ,
240:
241: -- Added by Keerthi
242: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
243: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
244:
245: -- Added by kmotepal
246: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
247:
242: source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
243: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
244:
245: -- Added by kmotepal
246: canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
247:
248: --Added by dpsingh for LE Uptake
249: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM,
250:
251: --Added by dpsingh for SLA Uptake (Bug 5707866)
252: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
253:
254: -- Added by DJANASWA for SLA project
255: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
256: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
253:
254: -- Added by DJANASWA for SLA project
255: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
256: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
254: -- Added by DJANASWA for SLA project
255: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
256: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
255: accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
256: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
256: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
264: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
257: product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
264: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
265: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
258: book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259: tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
264: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
265: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
266: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
260: tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261: representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262: representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263: -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
264: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
265: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
266: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
267: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
268: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
264: UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
265: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
266: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
267: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
268: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
269: REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
270: -- sosharma added column for Income accrual recon-report
271: TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
272: );
265: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
266: TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
267: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
268: primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
269: REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
270: -- sosharma added column for Income accrual recon-report
271: TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
272: );
273:
277: INDEX BY BINARY_INTEGER;
278: ---------------------------------------------------------------------------
279: -- GLOBAL MESSAGE CONSTANTS
280: ---------------------------------------------------------------------------
281: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
278: ---------------------------------------------------------------------------
279: -- GLOBAL MESSAGE CONSTANTS
280: ---------------------------------------------------------------------------
281: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
279: -- GLOBAL MESSAGE CONSTANTS
280: ---------------------------------------------------------------------------
281: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
280: ---------------------------------------------------------------------------
281: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
281: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
282: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
283: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
291: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
284: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
291: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
292: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
285: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
291: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
292: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
293: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
286: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
291: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
292: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
293: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
294: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_NO_PARENT_RECORD';
302: ---------------------------------------------------------------------------
303: -- GLOBAL VARIABLES
304: ---------------------------------------------------------------------------
305: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TCN_PVT';
306: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
307: ---------------------------------------------------------------------------
308: -- Procedures and Functions
309: ---------------------------------------------------------------------------
310:
312: PROCEDURE change_version;
313: PROCEDURE api_copy;
314: PROCEDURE insert_row(
315: p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_tcnv_rec IN tcnv_rec_type,
321: x_tcnv_rec OUT NOCOPY tcnv_rec_type);
322:
323: PROCEDURE insert_row(
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_tcnv_tbl IN tcnv_tbl_type,
330: x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
331:
332: PROCEDURE lock_row(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2,
338: p_tcnv_rec IN tcnv_rec_type);
338: p_tcnv_rec IN tcnv_rec_type);
339:
340: PROCEDURE lock_row(
341: p_api_version IN NUMBER,
342: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
343: x_return_status OUT NOCOPY VARCHAR2,
344: x_msg_count OUT NOCOPY NUMBER,
345: x_msg_data OUT NOCOPY VARCHAR2,
346: p_tcnv_tbl IN tcnv_tbl_type);
346: p_tcnv_tbl IN tcnv_tbl_type);
347:
348: PROCEDURE update_row(
349: p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_tcnv_rec IN tcnv_rec_type,
355: x_tcnv_rec OUT NOCOPY tcnv_rec_type);
356:
357: PROCEDURE update_row(
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_tcnv_tbl IN tcnv_tbl_type,
364: x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
365:
366: PROCEDURE delete_row(
367: p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,
372: p_tcnv_rec IN tcnv_rec_type);
372: p_tcnv_rec IN tcnv_rec_type);
373:
374: PROCEDURE delete_row(
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
380: p_tcnv_tbl IN tcnv_tbl_type);
380: p_tcnv_tbl IN tcnv_tbl_type);
381:
382: PROCEDURE validate_row(
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_tcnv_rec IN tcnv_rec_type);
388: p_tcnv_rec IN tcnv_rec_type);
389:
390: PROCEDURE validate_row(
391: p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
393: x_return_status OUT NOCOPY VARCHAR2,
394: x_msg_count OUT NOCOPY NUMBER,
395: x_msg_data OUT NOCOPY VARCHAR2,
396: p_tcnv_tbl IN tcnv_tbl_type);