[Home] [Help]
17: G_SOB_NAME_REP VARCHAR2(2000);
18: G_ORG_ID NUMBER;
19: G_ORG_NAME VARCHAR2(2000);
20: G_ACCRUAL_REVERSAL_DAYS OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
21: G_FUNC_CURRENCY_CODE_REP OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
22: G_ACCRUAL_DATE DATE;
23:
24: TYPE trx_rec_type IS RECORD (
25: old_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
21: G_FUNC_CURRENCY_CODE_REP OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
22: G_ACCRUAL_DATE DATE;
23:
24: TYPE trx_rec_type IS RECORD (
25: old_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
26: new_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
27: ID okl_trx_contracts_all.ID%TYPE := OKL_API.G_MISS_NUM
28: );
29:
22: G_ACCRUAL_DATE DATE;
23:
24: TYPE trx_rec_type IS RECORD (
25: old_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
26: new_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
27: ID okl_trx_contracts_all.ID%TYPE := OKL_API.G_MISS_NUM
28: );
29:
30: TYPE trx_tbl_type IS TABLE OF trx_rec_type INDEX BY BINARY_INTEGER;
23:
24: TYPE trx_rec_type IS RECORD (
25: old_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
26: new_trx_number okl_trx_contracts_all.trx_number%TYPE := OKL_API.G_MISS_CHAR,
27: ID okl_trx_contracts_all.ID%TYPE := OKL_API.G_MISS_NUM
28: );
29:
30: TYPE trx_tbl_type IS TABLE OF trx_rec_type INDEX BY BINARY_INTEGER;
31: G_trx_number_tbl trx_tbl_type;
52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
67: batch_name VARCHAR2(2000),
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
67: batch_name VARCHAR2(2000),
68: sob_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
67: batch_name VARCHAR2(2000),
68: sob_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
69: accrual_date DATE,
70: period_end_date DATE,
71: period_start_date DATE,
72: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
68: sob_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
69: accrual_date DATE,
70: period_end_date DATE,
71: period_start_date DATE,
72: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
73: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
74: submission_mode VARCHAR2(2000),
75: rev_rec_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE);
76:
69: accrual_date DATE,
70: period_end_date DATE,
71: period_start_date DATE,
72: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
73: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
74: submission_mode VARCHAR2(2000),
75: rev_rec_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE);
76:
77: --Added by kthiruva on 02-Mar-2006 for logging purposes
408:
409: --Bug 5036337
410: CURSOR check_actual_trx(p_khr_id NUMBER) IS
411: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
412: FROM OKL_TRX_CONTRACTS trx,
413: OKL_TRX_TYPES_V try,
414: OKL_TXL_CNTRCT_LNS txl,
415: OKL_STRM_TYPE_V sty
416: WHERE trx.khr_id = p_khr_id
1165: x_sob_name OUT NOCOPY VARCHAR2,
1166: x_org_id OUT NOCOPY OKL_SYS_ACCT_OPTS.org_id%TYPE,
1167: x_org_name OUT NOCOPY VARCHAR2,
1168: x_accrual_reversal_days OUT NOCOPY NUMBER,
1169: x_func_currency_code OUT NOCOPY OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
1170: x_return_status OUT NOCOPY VARCHAR2
1171: ) IS
1172:
1173: l_period_name VARCHAR2(2000);
1176: l_period_status VARCHAR2(2000);
1177: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
1178: l_sob_name VARCHAR2(2000);
1179: l_try_id OKL_TRX_TYPES_V.id%TYPE;
1180: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1181: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;
1182: l_org_name VARCHAR2(2000);
1183: l_accrual_reversal_days NUMBER;
1184:
1383: p_init_msg_list IN VARCHAR2,
1384: x_return_status OUT NOCOPY VARCHAR2,
1385: x_msg_count OUT NOCOPY NUMBER,
1386: x_msg_data OUT NOCOPY VARCHAR2,
1387: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1388: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1389: p_accrual_rec IN accrual_rec_type,
1390: p_stream_tbl IN stream_tbl_type,
1391: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
1384: x_return_status OUT NOCOPY VARCHAR2,
1385: x_msg_count OUT NOCOPY NUMBER,
1386: x_msg_data OUT NOCOPY VARCHAR2,
1387: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1388: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1389: p_accrual_rec IN accrual_rec_type,
1390: p_stream_tbl IN stream_tbl_type,
1391: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
1392:
1479: WHERE kle.id = p_kle_id;
1480:
1481:
1482: --local variables
1483: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1480:
1481:
1482: --local variables
1483: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1489: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1490: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1491: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1492: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1489: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1490: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1491: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1492: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1493: --START: change by nikshah, for SLA Uptake Bug 5705866
1532:
1533: -- MGAAP 7263041
1534: CURSOR primary_rep_trx_id_csr(p_trx_number IN VARCHAR2) IS
1535: SELECT ID
1536: FROM OKL_TRX_CONTRACTS
1537: WHERE TRX_NUMBER = p_trx_number
1538: AND REPRESENTATION_TYPE = 'PRIMARY';
1539:
1540: l_primary_rep_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
1536: FROM OKL_TRX_CONTRACTS
1537: WHERE TRX_NUMBER = p_trx_number
1538: AND REPRESENTATION_TYPE = 'PRIMARY';
1539:
1540: l_primary_rep_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
1541:
1542: BEGIN
1543: -- Set save point
1544:
1677: l_tclv_tbl(i).attribute15 := get_line_dff_rec.attribute15;
1678: END LOOP;
1679: END LOOP;
1680:
1681: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
1682: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
1683: WRITE_TO_LOG('===========================================================');
1684: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
1685: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);
1722: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
1723: END LOOP;
1724:
1725: -- Call Transaction Public API to insert transaction header and line records
1726: Okl_Trx_Contracts_Pub.create_trx_contracts
1727: (p_api_version => p_api_version
1728: ,p_init_msg_list => p_init_msg_list
1729: ,x_return_status => x_return_status
1730: ,x_msg_count => x_msg_count
2217: l_try_id NUMBER;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2754: x_msg_count OUT NOCOPY NUMBER,
2755: x_msg_data OUT NOCOPY VARCHAR2,
2756: p_acceleration_rec IN acceleration_rec_type,
2757: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY', --MGAAP 7263041
2758: x_trx_number OUT NOCOPY OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE) IS --MGAAP 7263041
2759:
2760: -- local collections
2761: TYPE accelerate_ref_cursor IS REF CURSOR;
2762: TYPE stream_rec IS RECORD
2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2797: acceleration_streams_csr accelerate_ref_cursor;
2798: l_stream_rec stream_rec;
2799: l_counter NUMBER := 1;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2797: acceleration_streams_csr accelerate_ref_cursor;
2798: l_stream_rec stream_rec;
2799: l_counter NUMBER := 1;
2800:
3316: p_reverse_rec IN accrual_rec_type,
3317: x_return_status OUT NOCOPY VARCHAR2,
3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3317: x_return_status OUT NOCOPY VARCHAR2,
3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:
3327: -- local variables
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3325: ) IS
3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;
3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3335: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3333: l_api_version CONSTANT NUMBER := 1.0;
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3335: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3335: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3335: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3356: -- removed to_date function in between statement as parameters are already of date datatype.
3357: CURSOR reverse_trx_csr(p_khr_id NUMBER, p_reversal_date_to DATE, p_reversal_date_from DATE) IS
3358: SELECT id, transaction_date,
3359: trx_number -- MGAAP 7263041
3360: FROM OKL_TRX_CONTRACTS
3361: WHERE khr_id = p_khr_id
3362: AND TRUNC(date_transaction_occurred) BETWEEN TRUNC(p_reversal_date_to) AND TRUNC(p_reversal_date_from)
3363: AND tsu_code = l_tsu_code_ent
3364: AND tcn_type = l_tcn_type
3469: RAISE OKL_API.G_EXCEPTION_ERROR;
3470: END IF;
3471: END IF;
3472:
3473: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3474: --Call the transaction public api for update
3475: Okl_Trx_Contracts_Pub.update_trx_contracts
3476: (p_api_version => p_api_version,
3477: p_init_msg_list => p_init_msg_list,
3471: END IF;
3472:
3473: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3474: --Call the transaction public api for update
3475: Okl_Trx_Contracts_Pub.update_trx_contracts
3476: (p_api_version => p_api_version,
3477: p_init_msg_list => p_init_msg_list,
3478: x_return_status => x_return_status,
3479: x_msg_count => x_msg_count,
3479: x_msg_count => x_msg_count,
3480: x_msg_data => x_msg_data,
3481: p_tcnv_tbl => l_tcnv_tbl,
3482: x_tcnv_tbl => x_rev_tcnv_tbl);
3483: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
3484:
3485: -- store the highest degree of error
3486: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3487: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3642: p_reverse_rec IN accrual_rec_type,
3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_count OUT NOCOPY NUMBER,
3645: x_msg_data OUT NOCOPY VARCHAR2,
3646: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_count OUT NOCOPY NUMBER,
3645: x_msg_data OUT NOCOPY VARCHAR2,
3646: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3652: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3653:
3654: BEGIN
3655:
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3652: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3653:
3654: BEGIN
3655:
3656: REVERSE_ACCRUALS (
3685: -- local variables
3686: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ACCRUALS';
3687: l_api_version CONSTANT NUMBER := 1.0;
3688: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3689: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3686: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ACCRUALS';
3687: l_api_version CONSTANT NUMBER := 1.0;
3688: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3689: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3687: l_api_version CONSTANT NUMBER := 1.0;
3688: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3689: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3696: l_contract_number VARCHAR2(2000);
3697: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3698: l_count1 NUMBER := 1;
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3696: l_contract_number VARCHAR2(2000);
3697: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3698: l_count1 NUMBER := 1;
3699: l_count2 NUMBER := 1;
3706:
3707: -- Cursor to select accrual transactions for cancellation using specified tcn_type
3708: CURSOR reverse_trx_csr IS
3709: SELECT trx.id,trx.transaction_date
3710: FROM OKL_TRX_CONTRACTS trx, okl_trx_types_v typ
3711: WHERE trx.khr_id = p_khr_id
3712: AND trx.tsu_code = l_tsu_code_ent
3713: AND trx.tcn_type = NVL(p_tcn_type,trx.tcn_type)
3714: AND trx.try_id = typ.id
3826: END IF;
3827: END IF;
3828:
3829: --Call the transaction public api for update
3830: Okl_Trx_Contracts_Pub.update_trx_contracts
3831: (p_api_version => p_api_version,
3832: p_init_msg_list => p_init_msg_list,
3833: x_return_status => x_return_status,
3834: x_msg_count => x_msg_count,
3919:
3920: -- local variables
3921: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ALL_ACCRUALS';
3922: l_api_version CONSTANT NUMBER := 1.0;
3923: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3924: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3925: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3922: l_api_version CONSTANT NUMBER := 1.0;
3923: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3924: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3925: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3923: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3924: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3925: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3924: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3925: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3933: l_count NUMBER := 1;
3934: l_count2 NUMBER := 1;
3935: l_contract_number VARCHAR2(2000);
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3933: l_count NUMBER := 1;
3934: l_count2 NUMBER := 1;
3935: l_contract_number VARCHAR2(2000);
3936:
3942:
3943: -- Cursor to select accrual transactions for cancellation
3944: CURSOR reverse_trx_csr(p_khr_id NUMBER) IS
3945: SELECT id, transaction_date
3946: FROM OKL_TRX_CONTRACTS
3947: WHERE khr_id = p_khr_id
3948: AND tsu_code = l_tsu_code_ent
3949: AND tcn_type = l_tcn_type;
3950: --AND representation_type = 'PRIMARY'; --MGAAP 7263041
4042: END IF;
4043: END IF;
4044:
4045: --Call the transaction public api for update
4046: Okl_Trx_Contracts_Pub.update_trx_contracts
4047: (p_api_version => p_api_version,
4048: p_init_msg_list => p_init_msg_list,
4049: x_return_status => x_return_status,
4050: x_msg_count => x_msg_count,
4128: p_catchup_rec IN accrual_rec_type,
4129: x_return_status OUT NOCOPY VARCHAR2,
4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4129: x_return_status OUT NOCOPY VARCHAR2,
4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:
4139: -- local variables
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4137: ) IS
4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4159: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4159: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4160: l_api_name VARCHAR2(20) := 'CATCHUP_ACCRUALS';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4159: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4160: l_api_name VARCHAR2(20) := 'CATCHUP_ACCRUALS';
4161: l_api_version CONSTANT NUMBER := 1.0;
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4159: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4160: l_api_name VARCHAR2(20) := 'CATCHUP_ACCRUALS';
4161: l_api_version CONSTANT NUMBER := 1.0;
4162: l_accrual_rec accrual_rec_type;
4167: -- Cursor to select transaction headers for accrual catchup
4168: CURSOR catchup_trx_csr(p_khr_id NUMBER) IS
4169: SELECT id, transaction_date,
4170: trx_number -- MGAAP 7263041
4171: FROM OKL_TRX_CONTRACTS
4172: WHERE khr_id = p_khr_id
4173: AND tcn_type = l_tcn_type
4174: AND tsu_code = l_tsu_code_ent
4175: AND accrual_activity = l_non_accrual_activity
4276: RAISE OKL_API.G_EXCEPTION_ERROR;
4277: END IF;
4278: END IF;
4279:
4280: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4281: --Call the transaction public api for update
4282: Okl_Trx_Contracts_Pub.update_trx_contracts
4283: (p_api_version => p_api_version,
4284: p_init_msg_list => p_init_msg_list,
4278: END IF;
4279:
4280: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4281: --Call the transaction public api for update
4282: Okl_Trx_Contracts_Pub.update_trx_contracts
4283: (p_api_version => p_api_version,
4284: p_init_msg_list => p_init_msg_list,
4285: x_return_status => x_return_status,
4286: x_msg_count => x_msg_count,
4286: x_msg_count => x_msg_count,
4287: x_msg_data => x_msg_data,
4288: p_tcnv_tbl => l_tcnv_tbl,
4289: x_tcnv_tbl => x_rev_tcnv_tbl);
4290: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
4291:
4292: -- store the highest degree of error
4293: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4294: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4450: p_catchup_rec IN accrual_rec_type,
4451: x_return_status OUT NOCOPY VARCHAR2,
4452: x_msg_count OUT NOCOPY NUMBER,
4453: x_msg_data OUT NOCOPY VARCHAR2,
4454: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4451: x_return_status OUT NOCOPY VARCHAR2,
4452: x_msg_count OUT NOCOPY NUMBER,
4453: x_msg_data OUT NOCOPY VARCHAR2,
4454: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4460: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4461:
4462: BEGIN
4463:
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4460: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4461:
4462: BEGIN
4463:
4464: CATCHUP_ACCRUALS (
4481: p_init_msg_list IN VARCHAR2,
4482: x_return_status OUT NOCOPY VARCHAR2,
4483: x_msg_count OUT NOCOPY NUMBER,
4484: x_msg_data OUT NOCOPY VARCHAR2,
4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4487: p_accrual_rec IN accrual_rec_type,
4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4489: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4482: x_return_status OUT NOCOPY VARCHAR2,
4483: x_msg_count OUT NOCOPY NUMBER,
4484: x_msg_data OUT NOCOPY VARCHAR2,
4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4487: p_accrual_rec IN accrual_rec_type,
4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4489: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4490:
4512: FROM okl_k_headers khr
4513: WHERE khr.id = p_khr_id;
4514:
4515: --local variables
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4513: WHERE khr.id = p_khr_id;
4514:
4515: --local variables
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4730: l_tclv_tbl(i).currency_code := p_accrual_rec.currency_code;
4731: l_tclv_tbl(i).accrual_rule_yn := p_accrual_rec.accrual_rule_yn;
4732: END LOOP;
4733:
4734: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
4735: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
4736: WRITE_TO_LOG('===========================================================');
4737: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
4738: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);
4775: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
4776: END LOOP;
4777:
4778: -- Call Transaction Public API to insert transaction header and line records
4779: Okl_Trx_Contracts_Pub.create_trx_contracts
4780: (p_api_version => p_api_version
4781: ,p_init_msg_list => p_init_msg_list
4782: ,x_return_status => x_return_status
4783: ,x_msg_count => x_msg_count
4951: l_tcnv_rec.amount := l_trx_header_amt;
4952:
4953:
4954: -- update the transaction header and line records with amounts
4955: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4956: Okl_Trx_Contracts_Pub.update_trx_contracts
4957: (p_api_version => p_api_version
4958: ,p_init_msg_list => p_init_msg_list
4959: ,x_return_status => x_return_status
4952:
4953:
4954: -- update the transaction header and line records with amounts
4955: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4956: Okl_Trx_Contracts_Pub.update_trx_contracts
4957: (p_api_version => p_api_version
4958: ,p_init_msg_list => p_init_msg_list
4959: ,x_return_status => x_return_status
4960: ,x_msg_count => x_msg_count
4962: ,p_tcnv_rec => l_tcnv_rec
4963: ,p_tclv_tbl => l_tclv_tbl
4964: ,x_tcnv_rec => x_tcnv_rec
4965: ,x_tclv_tbl => x_tclv_tbl );
4966: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);
4967: -- store the highest degree of error
4968: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4970: -- need to leave
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5226: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5226: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5227: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5226: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5227: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
5228: l_batch_name OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := p_process_accrual_rec.batch_name;
5229: l_reverse_date_to DATE;
5230: l_sob_name VARCHAR2(2000);
5223: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5226: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5227: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
5228: l_batch_name OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := p_process_accrual_rec.batch_name;
5229: l_reverse_date_to DATE;
5230: l_sob_name VARCHAR2(2000);
5231: l_sysdate DATE := SYSDATE;
5224: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
5225: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5226: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5227: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
5228: l_batch_name OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := p_process_accrual_rec.batch_name;
5229: l_reverse_date_to DATE;
5230: l_sob_name VARCHAR2(2000);
5231: l_sysdate DATE := SYSDATE;
5232: l_api_version CONSTANT NUMBER := 1.0;
5243: l_accrual_date DATE;
5244: l_rule_info_cat VARCHAR2(2000) := 'LAINTP';
5245: l_period_status VARCHAR2(1);
5246:
5247: l_previous_accrual_status OKL_TRX_CONTRACTS.accrual_status_yn%TYPE;
5248: l_previous_override_status OKL_TRX_CONTRACTS.update_status_yn%TYPE;
5249: l_last_interest_calc_date DATE;
5250: -- bug 2490346
5251: -- changed l_interest_fixed to l_variable_rate
5244: l_rule_info_cat VARCHAR2(2000) := 'LAINTP';
5245: l_period_status VARCHAR2(1);
5246:
5247: l_previous_accrual_status OKL_TRX_CONTRACTS.accrual_status_yn%TYPE;
5248: l_previous_override_status OKL_TRX_CONTRACTS.update_status_yn%TYPE;
5249: l_last_interest_calc_date DATE;
5250: -- bug 2490346
5251: -- changed l_interest_fixed to l_variable_rate
5252: --l_variable_rate VARCHAR2(2000);
5257: l_rule_result VARCHAR2(1);
5258: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5258: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5268: l_reverse_rec accrual_rec_type;
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5268: l_reverse_rec accrual_rec_type;
5269: l_catchup_rec accrual_rec_type;
5289: -- AND rule_information_category = l_rule_info_cat;
5290:
5291:
5292: -- Cursor to select the previous accrual and override statuses
5293: -- bug 2474969, modified subquery from okl_trx_contracts to okl_trx_contracts_v
5294: -- bug 2870449, 25-Mar-03, SGIYER, added khr_id = p_khr_id to outer query.
5295: CURSOR last_status_csr(p_khr_id NUMBER) IS
5296: SELECT accrual_status_yn, update_status_yn
5297: FROM OKL_TRX_CONTRACTS
5293: -- bug 2474969, modified subquery from okl_trx_contracts to okl_trx_contracts_v
5294: -- bug 2870449, 25-Mar-03, SGIYER, added khr_id = p_khr_id to outer query.
5295: CURSOR last_status_csr(p_khr_id NUMBER) IS
5296: SELECT accrual_status_yn, update_status_yn
5297: FROM OKL_TRX_CONTRACTS
5298: WHERE date_transaction_occurred = (SELECT MAX(date_transaction_occurred)
5299: FROM OKL_TRX_CONTRACTS
5300: WHERE khr_id = p_khr_id
5301: AND tcn_type = l_tcn_type
5295: CURSOR last_status_csr(p_khr_id NUMBER) IS
5296: SELECT accrual_status_yn, update_status_yn
5297: FROM OKL_TRX_CONTRACTS
5298: WHERE date_transaction_occurred = (SELECT MAX(date_transaction_occurred)
5299: FROM OKL_TRX_CONTRACTS
5300: WHERE khr_id = p_khr_id
5301: AND tcn_type = l_tcn_type
5302: AND tsu_code = l_tsu_code_ent
5303: AND representation_type = 'PRIMARY') -- MGAAP 7263041
5310: -- bug# 2474969
5311: -- bug# 2852781. Added tsu_code check for rebook error.
5312: CURSOR check_agn_csr(p_khr_id NUMBER) IS
5313: SELECT 'Y'
5314: FROM OKL_TRX_CONTRACTS
5315: WHERE tcn_type = l_tcn_type
5316: AND khr_id = p_khr_id
5317: AND tsu_code = l_tsu_code_ent
5318: AND representation_type = 'PRIMARY'; -- MGAAP 7263041
5351: -- cursor to check for accrual trx for a given period for variable rate contracts
5352: -- 12/5/05. Bug 4862620. Check for trx with variable interest income only
5353: CURSOR check_variable_trx(p_khr_id NUMBER, p_date DATE) IS
5354: SELECT 'Y'
5355: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty
5356: WHERE trx.khr_id = p_khr_id
5357: AND trx.try_id = try.id
5358: AND try.name = 'Accrual'
5359: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5368: -- CURSOR check_actual_trx(p_khr_id NUMBER, p_date DATE) IS
5369: -- SELECT 'Y'
5370: CURSOR check_actual_trx(p_khr_id NUMBER) IS
5371: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
5372: FROM OKL_TRX_CONTRACTS trx,
5373: OKL_TRX_TYPES_V try,
5374: OKL_TXL_CNTRCT_LNS txl,
5375: OKL_STRM_TYPE_V sty
5376: WHERE trx.khr_id = p_khr_id
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
8972: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
8973: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
8972: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
8973: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
8974: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
8972: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
8973: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
8974: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
8975: l_reverse_date_to DATE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
8972: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
8973: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
8974: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
8975: l_reverse_date_to DATE;
8976: l_sob_name VARCHAR2(2000);
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
8972: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
8973: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
8974: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
8975: l_reverse_date_to DATE;
8976: l_sob_name VARCHAR2(2000);
8977: l_api_version CONSTANT NUMBER := 1.0;
8990: l_contract_error_count NUMBER := 1;
8991: l_period_status VARCHAR2(1);
8992: l_counter NUMBER := 1;
8993: l_contract_counter NUMBER := 0;
8994: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
8995: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
8996:
8997: l_reqid FND_CONCURRENT_REQUESTS.request_id%TYPE;
8998: req_data VARCHAR2(10);
8991: l_period_status VARCHAR2(1);
8992: l_counter NUMBER := 1;
8993: l_contract_counter NUMBER := 0;
8994: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
8995: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
8996:
8997: l_reqid FND_CONCURRENT_REQUESTS.request_id%TYPE;
8998: req_data VARCHAR2(10);
8999: i NUMBER;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9643: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9643: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
9644: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9643: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
9644: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
9645: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
9646: l_reverse_date_to DATE;
9647: l_sob_name VARCHAR2(2000);
9648: l_sysdate DATE := SYSDATE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9643: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
9644: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
9645: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
9646: l_reverse_date_to DATE;
9647: l_sob_name VARCHAR2(2000);
9648: l_sysdate DATE := SYSDATE;
9649: l_api_version CONSTANT NUMBER := 1.0;
9664: l_rule_info_cat VARCHAR2(2000) := 'LAINTP';
9665: l_period_status VARCHAR2(1);
9666: l_counter NUMBER := 1;
9667: l_contract_counter NUMBER := 0;
9668: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
9669: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
9670: l_lower_limit NUMBER := 1;
9671: l_upper_limit NUMBER;
9672: l_process_records NUMBER := 30;
9665: l_period_status VARCHAR2(1);
9666: l_counter NUMBER := 1;
9667: l_contract_counter NUMBER := 0;
9668: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
9669: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
9670: l_lower_limit NUMBER := 1;
9671: l_upper_limit NUMBER;
9672: l_process_records NUMBER := 30;
9673: l_total_records NUMBER;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10035: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10035: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
10036: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10035: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
10036: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
10037: l_reverse_date_to DATE;
10038: l_sob_name VARCHAR2(2000);
10031: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10035: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
10036: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
10037: l_reverse_date_to DATE;
10038: l_sob_name VARCHAR2(2000);
10039: l_api_version CONSTANT NUMBER := 1.0;