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.0 2007/11/02 13:02:27 sgudupat noship $ */
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 586: AR_BPA_PRINT_TRX.build_where_clause(p_org_id

582: lc_select_stmt := ' SELECT ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE FROM '
583: ||' ( SELECT apsa.payment_schedule_id '|| build_from_clause ||
584: ' AND NVL(hcasa.language,' || '''' || lc_base_lang || ''') = ' || '''' || lc_userenv_lang || '''' ;
585:
586: AR_BPA_PRINT_TRX.build_where_clause(p_org_id
587: ,p_choice
588: ,p_cust_trx_class
589: ,p_trx_type_id
590: ,p_trx_number_low

Line 606: AR_BPA_PRINT_TRX.build_where_clause(p_org_id

602:
603: lc_sql_stmt := lc_insert_stmt || lc_select_stmt || lc_where1 || ')';
604:
605: IF ( ld_print_date_low IS NOT NULL OR ld_print_date_high IS NOT NULL ) THEN
606: AR_BPA_PRINT_TRX.build_where_clause(p_org_id
607: ,p_choice
608: ,p_cust_trx_class
609: ,p_trx_type_id
610: ,p_trx_number_low

Line 632: AR_BPA_PRINT_TRX.bind_variables(p_org_id

628: ------------------------------------------------
629:
630: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
631: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
632: AR_BPA_PRINT_TRX.bind_variables(p_org_id
633: ,p_choice
634: ,p_cust_trx_class
635: ,p_trx_type_id
636: ,p_trx_number_low

Line 650: AR_BPA_PRINT_TRX.bind_variables(p_org_id

646: ,'N'
647: ,ln_sql_stmt_c );
648:
649: IF ( ld_print_date_low IS NOT NULL OR ld_print_date_high IS NOT NULL ) THEN
650: AR_BPA_PRINT_TRX.bind_variables(p_org_id
651: ,p_choice
652: ,p_cust_trx_class
653: ,p_trx_type_id
654: ,p_trx_number_low

Line 701: ln_request_id := AR_BPA_PRINT_TRX.submit_print_request(

697: END LOOP;
698: COMMIT; -- commit the record here
699:
700: FOR no_of_workers IN 1 .. ln_divided_worker_counts LOOP
701: ln_request_id := AR_BPA_PRINT_TRX.submit_print_request(
702: ln_m_request_id
703: ,no_of_workers
704: ,p_template_id
705: ,'Y'

Line 763: END ar_bpa_print_trx;

759: COMMIT;
760: END IF;
761: END print_invoices;
762:
763: END ar_bpa_print_trx;