[Home] [Help]
1: PACKAGE BODY jai_ar_sup_trx_pkg AS
2: /* $Header: jai_ar_sup_trx.plb 120.20 2008/01/21 11:25:48 ssumaith ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
59: -----------------------------------------------------------------------------------------*/
60:
61: PROCEDURE process_report_stpr(p_batch_id number) is
62: BEGIN
63: jai_ar_sup_trx_pkg.identify_invoices(p_batch_id);
64: jai_ar_sup_trx_pkg.process_invoices;
65:
66: END process_report_stpr;
67:
60:
61: PROCEDURE process_report_stpr(p_batch_id number) is
62: BEGIN
63: jai_ar_sup_trx_pkg.identify_invoices(p_batch_id);
64: jai_ar_sup_trx_pkg.process_invoices;
65:
66: END process_report_stpr;
67:
68: PROCEDURE identify_invoices(P_BATCH_ID NUMBER)
78: ld_creation_date DATE;
79: ln_created_by NUMBER;
80:
81: /* Added by Ramananda for bug#4407165 */
82: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.identify_invoices';
83:
84: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
85: AND MAPPING_TYPE = M;
86:
453: PROCEDURE process_invoices
454: IS
455:
456: /* Added by Ramananda for bug#4407165 */
457: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.process_invoices';
458:
459: inv_no NUMBER;
460: v_assess_value NUMBER;
461: atax_amount NUMBER;
728: BEGIN
729:
730:
731: /*----------------------------------------------------------------------------------------------------------------------------
732: CHANGE HISTORY: FILENAME: jai_ar_sup_trx_pkg.process_invoices.sql
733: S.No Date Author and Details
734: ------------------------------------------------------------------------------------------------------------------------------
735: 1 24/03/2001 Bhaskar,
736: changed a query to select price_list_id basing on Header_Id rather than basing on order_number.
1526: pack_assess := passing_assessable*aquantity;
1527: v_statement_id := '68';
1528:
1529:
1530: jai_ar_sup_trx_pkg.calculate_tax('OE_LINES_UPDATE',ATAX_CATEGORY_ID,I.CUSTOMER_TRX_LINE_ID,
1531: pack_assess ,PASSING_AMOUNT,NVL(FETCH_INV.CONVERSION_RATE,1),
1532: I.Inventory_item_id,Aquantity, AUNIT_CODE,NULL,
1533: NULL, NULL, SYSDATE,fnd_global.user_id,fnd_global.user_id );
1534: END IF;
1849: v_sales_rep_id number;
1850: v_term_id number;
1851:
1852: /* Added by Ramananda for bug#4407165 */
1853: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.create_invoices';
1854:
1855: Cursor GET_SUPP_INV IS
1856: SELECT A.customer_trx_id,
1857: A.chosen_for_process,
2058:
2059: -- 2:56 PM 8/16/99
2060:
2061: /*------------------------------------------------------------------------------------------
2062: FILENAME: jai_ar_sup_trx_pkg.create_invoices.sql
2063:
2064: CHANGE HISTORY:
2065: S.No Date Author and Details
2066: 1 2001/04/10 Anuradha Parthasarathy
2509: counter NUMBER ;
2510: max_iter NUMBER := 10 ;
2511:
2512: /* Added by Ramananda for bug#4407165 */
2513: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.calculate_tax';
2514:
2515:
2516: /* Added by LGOPALSA. Bug 4210102.
2517: * Added Excise and CVD Education Cess
2610:
2611:
2612:
2613: /*------------------------------------------------------------------------------------------
2614: FILENAME: jai_ar_sup_trx_pkg.calculate_tax.sql
2615:
2616: CHANGE HISTORY:
2617: S.No Date Author and Details
2618: 1 2001/04/04 Anuradha Parthasarathy
2642:
2643: ----------------------------------------------------------------------------------------------------------------------------------------------------
2644: Current Version Current Bug Dependent Files Version Author Date Remarks
2645: Of File On Bug/Patchset Dependent On
2646: jai_ar_sup_trx_pkg.calculate_tax
2647: ----------------------------------------------------------------------------------------------------------------------------------------------------
2648: 115.1 3659008 IN60105D2 None -- Aiyer 14/06/2004 Row introduces to start dependency tracking
2649:
2650: 115.2 4210102 IN60106 + 4146708 LGOPALSA 12/03/2005 Introduction of Cess dependency
3294: app_exception.raise_exception;
3295:
3296: END calculate_tax;
3297:
3298: END jai_ar_sup_trx_pkg;