[Home] [Help]
16: represents alias to ap_liability_balance.
17: p_org_where_ael - Multi ORG WHERE condition for cross org reporting
18: represents alias to ap_ae_lines_all.
19: p_org_where_asp - Multi ORG WHERE condition for cross org reporting
20: represents alias to ap_system_parameters_all.
21: p_neg_bal_only - Report on Negative Balances only parameter.
22: p_debug_switch - Debug Switch.
23:
24: This function returns TRUE on successful completion and FALSE on any error.
418: || ' FROM ap_ae_lines_all ael, '
419: || ' ap_ae_headers_all aeh, '
420: || ' ap_invoice_payments_all aip, '
421: || ' ap_invoices_all ai, '
422: || ' ap_system_parameters_all asp '
423: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
424: || ' AND ael.ae_header_id = aeh.ae_header_id '
425: || ' AND aeh.gl_transfer_flag = ''Y'' '
426: || ' AND trunc(aeh.accounting_date) <= '
463: || ' FROM ax_ap_ae_lines_all_v ael, '
464: || ' ax_ap_ae_headers_all_v aeh, '
465: || ' ap_invoice_payments_all aip, '
466: || ' ap_invoices_all ai, '
467: || ' ap_system_parameters_all asp '
468: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
469: || ' AND ael.set_of_books_id = aeh.set_of_books_id '
470: || ' AND ael.journal_sequence_id = aeh.journal_sequence_id '
471: || ' AND ael.ae_header_id = aeh.ae_header_id '
565: || ' FROM ap_ae_lines_all ael, '
566: || ' ap_ae_headers_all aeh, '
567: || ' ap_invoice_payments_all aip, '
568: || ' ap_invoices_all ai, '
569: || ' ap_system_parameters_all asp '
570: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
571: || ' AND ai.invoice_date >= to_date('''||p_from_date||''',''YYYY/MM/DD'') '
572: || ' AND ael.ae_header_id = aeh.ae_header_id '
573: || ' AND aeh.gl_transfer_flag = ''Y'' '
611: || ' FROM ax_ap_ae_lines_all_v ael, '
612: || ' ax_ap_ae_headers_all_v aeh, '
613: || ' ap_invoice_payments_all aip, '
614: || ' ap_invoices_all ai, '
615: || ' ap_system_parameters_all asp '
616: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
617: || ' AND ai.invoice_date >= to_date('''||p_from_date||''',''YYYY/MM/DD'') '
618: || ' AND ael.set_of_books_id = aeh.set_of_books_id '
619: || ' AND ael.journal_sequence_id = aeh.journal_sequence_id '
720:
721: /*=============================================================================
722: Use_Future_Dated function is used to verify for the given org or set of orgs
723: if there exists atleast one ORG has future_dated_pmt_liab_relief vlaue set to
724: MATURITY in ap_system_parameters_all. If so we should call the Insert Future
725: Dated payments function. The function will return TRUE if there exists atleast
726: one org that satisfies the requirement, else will return FALSE.
727:
728: =============================================================================*/
738:
739: BEGIN
740:
741: l_sql_stmt := 'SELECT COUNT(*) '
742: || 'FROM ap_system_parameters_all asp '
743: || 'WHERE asp.future_dated_pmt_liab_relief = ''MATURITY'' '
744: || p_org_where_asp;
745:
746: IF (p_debug_switch IN ('y','Y')) THEN
1036: FUNCTION Get_Base_Currency_Code (
1037: p_set_of_books_id IN NUMBER)
1038: RETURN VARCHAR2 IS
1039:
1040: l_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1041:
1042: BEGIN
1043:
1044: SELECT base_currency_code
1042: BEGIN
1043:
1044: SELECT base_currency_code
1045: INTO l_currency_code
1046: FROM ap_system_parameters_all
1047: WHERE set_of_books_id = p_set_of_books_id;
1048:
1049: RETURN l_currency_code;
1050:
1116:
1117: l_invoice_amount NUMBER;
1118: l_table_name VARCHAR2(30) := 'AP_INVOICES';
1119: l_req_info VARCHAR2(30) := 'BASE_AMOUNT';
1120: l_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1121:
1122: BEGIN
1123:
1124: IF Is_Reporting_Books(p_set_of_books_id) = TRUE THEN