APPS.AR_BPA_PRINT_TRX dependencies on AR_BPA_PRINT_TRX

Line 1: PACKAGE BODY AR_BPA_PRINT_TRX AS

1: PACKAGE BODY AR_BPA_PRINT_TRX AS
2: /* $Header: arbpaptb.pls 120.6 2011/03/24 23:04:16 rravikir ship $ */
3: --*************************************************************************
4: -- Copyright (c) 2000 Oracle Product Development
5: -- All rights reserved

Line 15: -- This script creates the package body of AR_BPA_PRINT_TRX

11: -- PROGRAM NAME
12: -- arbpaptb.pls
13: --
14: -- DESCRIPTION
15: -- This script creates the package body of AR_BPA_PRINT_TRX
16: --
17: -- USAGE
18: -- To install sqlplus / @arbpaptb.pls
19: -- To execute sqlplus / AR_BPA_PRINT_TRX.

Line 19: -- To execute sqlplus / AR_BPA_PRINT_TRX.

15: -- This script creates the package body of AR_BPA_PRINT_TRX
16: --
17: -- USAGE
18: -- To install sqlplus / @arbpaptb.pls
19: -- To execute sqlplus / AR_BPA_PRINT_TRX.
20: --
21: -- PROGRAM LIST DESCRIPTION
22: --
23: -- PRINT_INVOICES This function is used to print the selected invoices

Line 617: AR_BPA_PRINT_TRX.build_where_clause(p_org_id

613: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE, customer_trx_id FROM '
614: ||' ( SELECT apsa.payment_schedule_id, rct.customer_trx_id '|| build_from_clause ||
615: ' AND NVL(hcasa.language,' || '''' || lc_base_lang || ''') = ' || '''' || lc_userenv_lang || '''' ;
616:
617: AR_BPA_PRINT_TRX.build_where_clause(p_org_id
618: ,p_choice
619: ,p_cust_trx_class
620: ,p_trx_type_id
621: ,p_trx_number_low

Line 637: AR_BPA_PRINT_TRX.build_where_clause(p_org_id

633:
634: lc_sql_stmt := lc_insert_stmt || lc_select_stmt || lc_where1 || ')';
635:
636: IF ( ld_print_date_low IS NOT NULL OR ld_print_date_high IS NOT NULL ) THEN
637: AR_BPA_PRINT_TRX.build_where_clause(p_org_id
638: ,p_choice
639: ,p_cust_trx_class
640: ,p_trx_type_id
641: ,p_trx_number_low

Line 663: AR_BPA_PRINT_TRX.bind_variables(p_org_id

659: ------------------------------------------------
660:
661: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
662: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
663: AR_BPA_PRINT_TRX.bind_variables(p_org_id
664: ,p_choice
665: ,p_cust_trx_class
666: ,p_trx_type_id
667: ,p_trx_number_low

Line 681: AR_BPA_PRINT_TRX.bind_variables(p_org_id

677: ,'N'
678: ,ln_sql_stmt_c );
679:
680: IF ( ld_print_date_low IS NOT NULL OR ld_print_date_high IS NOT NULL ) THEN
681: AR_BPA_PRINT_TRX.bind_variables(p_org_id
682: ,p_choice
683: ,p_cust_trx_class
684: ,p_trx_type_id
685: ,p_trx_number_low

Line 732: ln_request_id := AR_BPA_PRINT_TRX.submit_print_request(

728: END LOOP;
729: COMMIT; -- commit the record here
730:
731: FOR no_of_workers IN 1 .. ln_divided_worker_counts LOOP
732: ln_request_id := AR_BPA_PRINT_TRX.submit_print_request(
733: ln_m_request_id
734: ,no_of_workers
735: ,p_template_id
736: ,p_choice

Line 795: END ar_bpa_print_trx;

791: COMMIT;
792: END IF;
793: END print_invoices;
794:
795: END ar_bpa_print_trx;