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_ACCOUNTING_PROCESS_PVT dependencies on OKL_AE_LINES

Line 15: source_table okl_ae_lines.source_table%TYPE,

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);
19:

Line 17: source_id okl_ae_lines.source_id%TYPE,

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);
19:
20: TYPE trx_err_tbl_type IS TABLE OF trx_err_rec_type
21: INDEX BY BINARY_INTEGER;

Line 643: l_error_code OKL_AE_LINES.accounting_error_code%TYPE;

639: l_aetv_rec aetv_rec_type := p_aetv_rec;
640: l_ae_header_id NUMBER;
641: l_aelv_tbl_in aelv_tbl_type;
642: l_aelv_tbl_out aelv_tbl_type;
643: l_error_code OKL_AE_LINES.accounting_error_code%TYPE;
644: l_line_number NUMBER := 0;
645: l_ccid_valid VARCHAR2(1) := Okl_Api.G_TRUE;
646: i NUMBER := 0;
647: l_description OKL_AE_LINES.Description%TYPE;

Line 647: l_description OKL_AE_LINES.Description%TYPE;

643: l_error_code OKL_AE_LINES.accounting_error_code%TYPE;
644: l_line_number NUMBER := 0;
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;

Line 822: FROM OKL_AE_LINES AEL,

818:
819: CURSOR sum_csr(v_event_id NUMBER) IS
820: SELECT ael.Accounted_Dr Accounted_Dr,
821: ael.Accounted_Cr Accounted_Cr
822: FROM OKL_AE_LINES AEL,
823: OKL_AE_HEADERS AEH
824: WHERE AEH.accounting_event_ID = v_event_id
825: AND AEL.ae_header_id = AEH.ae_header_id ;
826:

Line 1023: FROM okl_ae_lines ael

1019:
1020:
1021: CURSOR ae_err_line_csr (p_request_id NUMBER) IS
1022: SELECT COUNT(*) err_ae_lines
1023: FROM okl_ae_lines ael
1024: WHERE ael.request_id = p_request_id AND
1025: ael.accounting_error_code IS NOT NULL;
1026:
1027:

Line 1045: FROM okl_ae_lines ael,

1041: DECODE(ael.accounted_dr,NULL,ael.accounted_cr, ael.accounted_dr) accounted_amount,
1042: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1043: ael.currency_code currency_code,
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

Line 1069: okl_ae_lines ael,

1065: try.name try_name,
1066: aeh.ae_category ae_category,
1067: ael.currency_code
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

Line 1092: okl_ae_lines ael,

1088: try.name try_name,
1089: aeh.ae_category ae_category,
1090: ael.currency_code
1091: FROM okl_Ae_headers aeh,
1092: okl_ae_lines ael,
1093: okl_trx_types_v try,
1094: okl_trx_assets tas,
1095: okl_txl_assets_b tal
1096: WHERE aeh.ae_header_id=ael.ae_header_id

Line 1125: okl_ae_lines ael,

1121: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1122: ael.currency_code,
1123: aeh.ae_category
1124: FROM
1125: okl_ae_lines ael,
1126: okl_ae_headers aeh
1127: WHERE
1128: ael.request_id = p_request_id AND
1129: ael.currency_code = p_currency_code AND

Line 1148: okl_ae_lines ael,

1144: aeh.ae_category ae_category,
1145: ael.currency_code
1146: FROM
1147: okl_Ae_headers aeh,
1148: okl_ae_lines ael,
1149: okl_trx_types_v try
1150: WHERE
1151: aeh.request_id = p_request_id AND
1152: aeh.accounting_error_code IS NULL AND

Line 1219: okl_ae_lines ael,

1215: DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
1216: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1217: ael.currency_code
1218: FROM
1219: okl_ae_lines ael,
1220: okl_ae_headers aeh
1221: WHERE
1222: ael.request_id = l_request_id AND
1223: ael.accounting_error_code = 'INVALID_ACCOUNT' AND

Line 1242: okl_ae_lines ael

1238: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1239: ael.currency_code currency_code
1240: FROM
1241: okl_ae_headers aeh,
1242: okl_ae_lines ael
1243: WHERE
1244: aeh.request_id = l_request_id AND
1245: aeh.accounting_error_code = 'DEBIT_NOT_EQUAL_TO_CREDIT' AND
1246: aeh.ae_header_id = ael.ae_header_id ORDER BY ael.source_id;

Line 1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));

1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));
1299: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length, '-' ));
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||
1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||
1302: LPAD(l_total_headers, 20 , ' ' ) || LPAD(l_total_lines, 20 , ' ' ));