[Home] [Help]
10:
11: -- Added by Santonyr on 28-Jan-2003 for reporting purpose
12:
13: TYPE trx_err_rec_type IS RECORD (
14: trx_number okl_trx_contracts.trx_number%TYPE,
15: source_table okl_ae_lines.source_table%TYPE,
16: period_name VARCHAR2(30),
17: source_id okl_ae_lines.source_id%TYPE,
18: gl_date DATE);
175: CURSOR trx_csr(v_source_id NUMBER) IS
176: SELECT tcn.trx_number,
177: try.trx_type_class
178: FROM OKL_TXL_CNTRCT_LNS tcl,
179: OKL_TRX_CONTRACTS tcn,
180: OKL_TRX_TYPES_V try
181: WHERE tcl.id = v_source_id
182: AND tcl.tcn_id = tcn.id
183: AND tcn.try_id = try.id;
211: i NUMBER := 0;
212: l_event_number NUMBER := 0;
213: l_api_version NUMBER := 1.0;
214: l_total_events NUMBER := 0;
215: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE;
216:
217: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
218: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
219:
535: l_trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE;
536: l_ae_category OKL_AE_HEADERS.AE_CATEGORY%TYPE;
537: l_template_id NUMBER;
538: l_try_id NUMBER;
539: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := p_trx_number;
540:
541:
542: BEGIN
543:
645: l_ccid_valid VARCHAR2(1) := Okl_Api.G_TRUE;
646: i NUMBER := 0;
647: l_description OKL_AE_LINES.Description%TYPE;
648: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
649: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := p_trx_number;
650: l_total_lines NUMBER;
651: l_contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE;
652:
653: -- Added by Santonyr Bug 3925719
656: SELECT
657: tcn.try_id
658: FROM
659: okl_txl_cntrct_lns txl,
660: okl_trx_contracts tcn
661: WHERE
662: txl.id = p_source_id AND
663: txl.tcn_id = tcn.id;
664:
1044: aeh.ae_category ae_category
1045: FROM okl_ae_lines ael,
1046: okl_ae_headers aeh,
1047: okl_txl_cntrct_lns tcl,
1048: okl_trx_contracts tcn
1049: WHERE aeh.ae_header_id = ael.ae_header_id
1050: AND aeh.accounting_error_code IS NULL
1051: AND ael.accounting_error_code IS NULL
1052: AND ael.request_id = p_request_id
1068: FROM okl_Ae_headers aeh,
1069: okl_ae_lines ael,
1070: okl_trx_types_v try,
1071: okl_txl_cntrct_lns tcl,
1072: okl_trx_contracts tcn
1073: WHERE aeh.ae_header_id=ael.ae_header_id
1074: AND aeh.accounting_error_code IS NULL
1075: AND ael.accounting_error_code IS NULL
1076: AND aeh.request_id = p_request_id
1170: tcl.amount amount,
1171: tcn.date_transaction_occurred transaction_date
1172: FROM
1173: okl_txl_cntrct_lns tcl,
1174: okl_trx_contracts tcn,
1175: okl_trx_types_v try,
1176: okc_k_headers_b khr
1177: WHERE
1178: tcl.id = p_source_id AND