DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_TRX_PKG

Line 1: PACKAGE BODY jai_ar_sup_trx_pkg AS

1: PACKAGE BODY jai_ar_sup_trx_pkg AS
2: /* $Header: jai_ar_sup_trx.plb 120.38.12020000.3 2013/04/05 10:34:23 mmurtuza ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 75: jai_ar_sup_trx_pkg.identify_invoices(p_batch_id);

71: -----------------------------------------------------------------------------------------*/
72:
73: PROCEDURE process_report_stpr(p_batch_id number) is
74: BEGIN
75: jai_ar_sup_trx_pkg.identify_invoices(p_batch_id);
76: jai_ar_sup_trx_pkg.process_invoices;
77:
78: END process_report_stpr;
79:

Line 76: jai_ar_sup_trx_pkg.process_invoices;

72:
73: PROCEDURE process_report_stpr(p_batch_id number) is
74: BEGIN
75: jai_ar_sup_trx_pkg.identify_invoices(p_batch_id);
76: jai_ar_sup_trx_pkg.process_invoices;
77:
78: END process_report_stpr;
79:
80: PROCEDURE identify_invoices(P_BATCH_ID NUMBER)

Line 94: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.identify_invoices';

90: ld_creation_date DATE;
91: ln_created_by NUMBER;
92:
93: /* Added by Ramananda for bug#4407165 */
94: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.identify_invoices';
95:
96: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
97: AND MAPPING_TYPE = M;
98:

Line 527: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.process_invoices';

523: PROCEDURE process_invoices
524: IS
525:
526: /* Added by Ramananda for bug#4407165 */
527: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.process_invoices';
528:
529: inv_no NUMBER;
530: v_assess_value NUMBER;
531: atax_amount NUMBER;

Line 804: CHANGE HISTORY: FILENAME: jai_ar_sup_trx_pkg.process_invoices.sql

800: BEGIN
801:
802:
803: /*----------------------------------------------------------------------------------------------------------------------------
804: CHANGE HISTORY: FILENAME: jai_ar_sup_trx_pkg.process_invoices.sql
805: S.No Date Author and Details
806: ------------------------------------------------------------------------------------------------------------------------------
807: 1 24/03/2001 Bhaskar,
808: changed a query to select price_list_id basing on Header_Id rather than basing on order_number.

Line 1655: jai_ar_sup_trx_pkg.calculate_tax('OE_LINES_UPDATE',ATAX_CATEGORY_ID,I.CUSTOMER_TRX_LINE_ID,

1651: pack_assess := passing_assessable*aquantity;
1652: v_statement_id := '68';
1653:
1654:
1655: jai_ar_sup_trx_pkg.calculate_tax('OE_LINES_UPDATE',ATAX_CATEGORY_ID,I.CUSTOMER_TRX_LINE_ID,
1656: pack_assess ,PASSING_AMOUNT,NVL(FETCH_INV.CONVERSION_RATE,1),
1657: I.Inventory_item_id,Aquantity, AUNIT_CODE,NULL,
1658: NULL, NULL, SYSDATE,fnd_global.user_id,fnd_global.user_id );
1659: END IF;

Line 1981: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.create_invoices';

1977: v_sales_rep_id number;
1978: v_term_id number;
1979:
1980: /* Added by Ramananda for bug#4407165 */
1981: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.create_invoices';
1982:
1983: Cursor GET_SUPP_INV IS
1984: SELECT A.customer_trx_id,
1985: A.chosen_for_process,

Line 2191: FILENAME: jai_ar_sup_trx_pkg.create_invoices.sql

2187:
2188: -- 2:56 PM 8/16/99
2189:
2190: /*------------------------------------------------------------------------------------------
2191: FILENAME: jai_ar_sup_trx_pkg.create_invoices.sql
2192:
2193: CHANGE HISTORY:
2194: S.No Date Author and Details
2195: 1 2001/04/10 Anuradha Parthasarathy

Line 2656: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.calculate_tax';

2652: counter NUMBER ;
2653: max_iter NUMBER := 10 ;
2654:
2655: /* Added by Ramananda for bug#4407165 */
2656: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.calculate_tax';
2657: ln_amount NUMBER; --Added by Shujuan for 10358786 on 28-Jan-2011
2658:
2659: /* Added by LGOPALSA. Bug 4210102.
2660: * Added Excise and CVD Education Cess

Line 2757: FILENAME: jai_ar_sup_trx_pkg.calculate_tax.sql

2753:
2754:
2755:
2756: /*------------------------------------------------------------------------------------------
2757: FILENAME: jai_ar_sup_trx_pkg.calculate_tax.sql
2758:
2759: CHANGE HISTORY:
2760: S.No Date Author and Details
2761: 1 2001/04/04 Anuradha Parthasarathy

Line 2789: jai_ar_sup_trx_pkg.calculate_tax

2785:
2786: ----------------------------------------------------------------------------------------------------------------------------------------------------
2787: Current Version Current Bug Dependent Files Version Author Date Remarks
2788: Of File On Bug/Patchset Dependent On
2789: jai_ar_sup_trx_pkg.calculate_tax
2790: ----------------------------------------------------------------------------------------------------------------------------------------------------
2791: 115.1 3659008 IN60105D2 None -- Aiyer 14/06/2004 Row introduces to start dependency tracking
2792:
2793: 115.2 4210102 IN60106 + 4146708 LGOPALSA 12/03/2005 Introduction of Cess dependency

Line 3946: END jai_ar_sup_trx_pkg;

3942: app_exception.raise_exception;
3943:
3944: END calculate_tax;
3945:
3946: END jai_ar_sup_trx_pkg;
3947: