APPS.OKL_ACCOUNTING_PROCESS_PVT dependencies on OKL_AE_HEADERS

Line 536: l_ae_category OKL_AE_HEADERS.AE_CATEGORY%TYPE;

532: TYPE ref_cursor IS REF CURSOR;
533: trx_csr ref_cursor;
534:
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:

Line 636: FROM OKL_AE_HEADERS

632: WHERE aet_id = v_aet_id;
633:
634: CURSOR aeh_csr(v_aet_id NUMBER) IS
635: SELECT ae_header_id
636: FROM OKL_AE_HEADERS
637: WHERE accounting_event_id = v_aet_id;
638:
639: l_aetv_rec aetv_rec_type := p_aetv_rec;
640: l_ae_header_id NUMBER;

Line 823: OKL_AE_HEADERS AEH

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:
827: l_accounted_dr_total NUMBER := 0;

Line 1016: FROM okl_ae_headers ah

1012: --- Cursor to select the error Headers
1013:
1014: CURSOR ae_err_hdr_csr (p_request_id NUMBER) IS
1015: SELECT COUNT(*) err_ae_headers
1016: FROM okl_ae_headers ah
1017: WHERE ah.request_id = p_request_id AND
1018: ah.accounting_error_code IS NOT NULL;
1019:
1020:

Line 1046: okl_ae_headers aeh,

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
1050: AND aeh.accounting_error_code IS NULL

Line 1068: FROM okl_Ae_headers aeh,

1064: try.id try_id,
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

Line 1091: FROM okl_Ae_headers aeh,

1087: try.id try_id,
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

Line 1126: okl_ae_headers aeh

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
1130: ael.reference3 = p_try_id AND

Line 1147: okl_Ae_headers aeh,

1143: try.name try_name,
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

Line 1220: okl_ae_headers aeh

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
1224: ael.ae_header_id = aeh.ae_header_id ORDER BY ael.source_id;

Line 1241: okl_ae_headers aeh,

1237: DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
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

Line 1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||

1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
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 , ' ' ) ||