eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LOSS_PROV_PVT dependencies on OKL_TRX_CONTRACTS

Line 105: FROM OKL_TRX_CONTRACTS

101:
102: /* cursor to get the total reserve amount */
103: CURSOR rsrv_amt_csr(p_khr_id NUMBER) IS
104: SELECT SUM(NVL(AMOUNT,0)) tot_res_amt
105: FROM OKL_TRX_CONTRACTS
106: WHERE KHR_ID = p_khr_id
107: AND tcn_type = 'PSP'
108: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
109: AND tsu_code = 'PROCESSED'

Line 374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

370: l_loss_date DATE := TRUNC(sysdate);
371: l_period_start_date DATE;
372: l_period_end_date DATE;
373: l_period_name VARCHAR2(2000);
374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

Line 375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

371: l_period_start_date DATE;
372: l_period_end_date DATE;
373: l_period_name VARCHAR2(2000);
374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

Line 642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

638: p_contract_id IN OKL_K_HEADERS_FULL_V.ID%TYPE,
639: p_contract_number IN OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
640: p_fact_synd_code IN VARCHAR2,
641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
644: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
645: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type) IS
646:

Line 643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

639: p_contract_number IN OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
640: p_fact_synd_code IN VARCHAR2,
641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
644: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
645: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type) IS
646:
647: --local variables

Line 644: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

640: p_fact_synd_code IN VARCHAR2,
641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
644: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
645: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type) IS
646:
647: --local variables
648: l_api_name VARCHAR2(20) := 'CREATE_GEN_LOSS_TRX';

Line 645: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type) IS

641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
644: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
645: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type) IS
646:
647: --local variables
648: l_api_name VARCHAR2(20) := 'CREATE_GEN_LOSS_TRX';
649: l_api_version CONSTANT NUMBER := 1.0;

Line 686: Okl_Trx_Contracts_Pub.create_trx_contracts

682: RAISE Okl_Api.G_EXCEPTION_ERROR;
683: END IF;
684:
685: -- Call Transaction Public API to insert transaction header and line records
686: Okl_Trx_Contracts_Pub.create_trx_contracts
687: (p_api_version => p_api_version
688: ,p_init_msg_list => p_init_msg_list
689: ,x_return_status => x_return_status
690: ,x_msg_count => x_msg_count

Line 1003: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PGL';

999: -- constants
1000: l_api_name CONSTANT VARCHAR2(40) := 'GENERAL_LOSS_PROVISION';
1001: l_api_version CONSTANT NUMBER := 1.0;
1002: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'General Loss Provision';
1003: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PGL';
1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';
1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';

Line 1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

1002: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'General Loss Provision';
1003: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PGL';
1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';
1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';
1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';
1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';

Line 1016: l_product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE := to_number(p_product_id);

1012: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1013: l_sob_name VARCHAR2(2000);
1014: l_org_id NUMBER;
1015: l_org_name VARCHAR2(2000);
1016: l_product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE := to_number(p_product_id);
1017: l_product_name OKL_PRODUCTS_V.NAME%TYPE;
1018: l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE := to_number(p_bucket_id);
1019: l_entry_date DATE := FND_DATE.CANONICAL_TO_DATE(p_entry_date);
1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;

Line 1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1022: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;

Line 1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

1022: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
1030: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;

Line 1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
1030: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
1031: l_error_cnt NUMBER :=1;

Line 1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
1030: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
1031: l_error_cnt NUMBER :=1;
1032: l_period_start_date DATE;

Line 1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;

1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
1029: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
1030: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
1031: l_error_cnt NUMBER :=1;
1032: l_period_start_date DATE;
1033: l_period_end_date DATE;

Line 1085: CURSOR okl_pdt_cntrcts_csr (p_pdt_id OKL_TRX_CONTRACTS.PDT_ID%TYPE) IS

1081: -- 13-DEC-02 sgiyer added where clause to select lease contracts only
1082: -- changed where clause for performance
1083: -- and added multi-currency columns in select criteria
1084: -- bug 3448020. removing under revision status
1085: CURSOR okl_pdt_cntrcts_csr (p_pdt_id OKL_TRX_CONTRACTS.PDT_ID%TYPE) IS
1086: SELECT chr.id
1087: ,chr.contract_number
1088: ,khr.deal_type
1089: ,chr.currency_code

Line 1103: CURSOR investor_cntrcts_csr (p_pdt_id OKL_TRX_CONTRACTS.PDT_ID%TYPE) IS

1099: AND chr.scs_code = 'LEASE';
1100:
1101:
1102: -- cursor for getting a contract belonging to a Investor product
1103: CURSOR investor_cntrcts_csr (p_pdt_id OKL_TRX_CONTRACTS.PDT_ID%TYPE) IS
1104: SELECT chr.id
1105: ,chr.contract_number
1106: ,khr.deal_type
1107: ,chr.currency_code

Line 1184: FROM OKL_TRX_CONTRACTS

1180:
1181: -- cursor to check whether the contract has a specific loss
1182: CURSOR sp_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1183: SELECT 'Y'
1184: FROM OKL_TRX_CONTRACTS
1185: WHERE khr_id = p_khr_id
1186: AND tcn_type = 'PSP'
1187: AND tsu_code = l_tsu_code
1188: AND representation_type = 'PRIMARY'; -- SGIYER MGAAP Changes Bug 7263041

Line 1193: FROM OKL_TRX_CONTRACTS

1189:
1190: -- cursor to check whether the contract has a general loss
1191: CURSOR gen_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1192: SELECT 'Y'
1193: FROM OKL_TRX_CONTRACTS
1194: WHERE khr_id = p_khr_id
1195: AND tcn_type = 'PGL'
1196: AND tsu_code = l_tsu_code
1197: AND representation_type = 'PRIMARY'; -- SGIYER MGAAP Changes Bug 7263041

Line 1529: l_trx_header_total OKL_TRX_CONTRACTS.AMOUNT%TYPE := 0;

1525: l_no_of_days NUMBER;
1526: l_due_amt NUMBER;
1527: l_inv_loss_amt NUMBER :=0;
1528: l_loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1529: l_trx_header_total OKL_TRX_CONTRACTS.AMOUNT%TYPE := 0;
1530: l_converted_net_book_value NUMBER;
1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);
1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1533:

Line 1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:
1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1547: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;

Line 1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:
1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1547: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
1548: l_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;

Line 1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1541:
1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1547: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
1548: l_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
1549:

Line 1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1545: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1546: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1547: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
1548: l_error_msg_tbl Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
1549:
1550: -- Begin a new PL/SQL block to trap errors related to a praticular contract and to move on to the next contract

Line 2297: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PSP';

2293:
2294: -- constants
2295: l_api_name CONSTANT VARCHAR2(40) := 'SPECIFIC_LOSS_PROVISION';
2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PSP';
2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';
2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';
2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';
2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';
2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
2303:
2304: --variables
2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
2303:
2304: --variables
2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;

Line 2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
2303:
2304: --variables
2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;

Line 2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

2303:
2304: --variables
2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;

Line 2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

2304: --variables
2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;
2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;

Line 2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;

2305: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2306: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;
2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
2313: l_sysdate DATE := SYSDATE;

Line 2324: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2320: l_inv_acct_code VARCHAR2(2000);
2321: l_scs_code VARCHAR2(2000);
2322:
2323: -- record and table structure variables
2324: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;

Line 2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2321: l_scs_code VARCHAR2(2000);
2322:
2323: -- record and table structure variables
2324: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

Line 2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2322:
2323: -- record and table structure variables
2324: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

Line 2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2323: -- record and table structure variables
2324: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

Line 2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl

2363:
2364: -- Cursor to verify if the stream type selected is the same as used earlier
2365: -- CURSOR sty_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2366: -- SELECT DISTINCT sty.id id
2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl
2368: -- WHERE trx.khr_id = p_ctr_id
2369: -- AND trx.tcn_type = 'PSP'
2370: -- AND trx.tsu_code = l_tsu_code
2371: -- AND trx.id = txl.tcn_id

Line 2377: FROM OKL_TRX_CONTRACTS

2373:
2374: -- cursor to check whether the contract has a general loss
2375: CURSOR gen_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2376: SELECT 'Y'
2377: FROM OKL_TRX_CONTRACTS
2378: WHERE khr_id = p_ctr_id
2379: AND tcn_type = 'PGL'
2380: AND tsu_code = l_tsu_code
2381: AND representation_type='PRIMARY';

Line 2386: FROM OKL_TRX_CONTRACTS

2382:
2383: -- cursor to check whether the contract has a specific loss
2384: CURSOR spec_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2385: SELECT 'Y'
2386: FROM OKL_TRX_CONTRACTS
2387: WHERE khr_id = p_ctr_id
2388: AND tcn_type = 'PSP'
2389: AND tsu_code = l_tsu_code
2390: AND representation_type='PRIMARY';

Line 2775: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

2771: l_tclv_tbl(1).tcl_type := l_tcl_type;
2772: l_tclv_tbl(1).sty_id := p_slpv_rec.sty_id;
2773:
2774: -- create transaction and transaction lines
2775: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
2776: p_api_version => p_api_version
2777: ,p_init_msg_list => p_init_msg_list
2778: ,x_return_status => l_return_status
2779: ,x_msg_count => x_msg_count