eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_THRESHOLD_DTLS

Line 53: lr_dtl_record jai_rgm_threshold_dtls%rowtype;

49:
50: /*-------------------------------DECLARE SECTION OF GENERATE_CONSOLIDATED_DOC ---------------------------*/
51:
52: ln_reg_id number;
53: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
54: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
55: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
56:
57: ln_surcharge_doc_amt number;

Line 91: from jai_rgm_threshold_dtls dtls

87: ,nvl(dtls.manual_surcharge_amt,0) manual_surcharge_amt
88: ,nvl(dtls.system_surcharge_amt,0) system_surcharge_amt
89: ,nvl(dtls.system_surcharge_cess_amt,0) system_surcharge_cess_amt
90: ,nvl(dtls.system_surcharge_sh_cess_amt,0) system_surcharge_sh_cess_amt --Bgowrava for forward porting bug#5989740
91: from jai_rgm_threshold_dtls dtls
92: ,jai_rgm_thresholds hdr
93: where hdr.threshold_id = p_threshold_id
94: and dtls.threshold_id = hdr.threshold_id ;
95:

Line 154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type

150:
151: procedure calculate_tcs_doc_amount
152: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
153: , p_tcs_amt in number
154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
157: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
158: , p_surcharge_doc_amt out nocopy number

Line 155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type

151: procedure calculate_tcs_doc_amount
152: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
153: , p_tcs_amt in number
154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
157: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
158: , p_surcharge_doc_amt out nocopy number
159: , p_surcharge_doc_cess_amt out nocopy number

Line 156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type

152: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
153: , p_tcs_amt in number
154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
157: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
158: , p_surcharge_doc_amt out nocopy number
159: , p_surcharge_doc_cess_amt out nocopy number
160: , p_surcharge_doc_sh_cess_amt out nocopy number --Bgowrava for forward porting bug#5989740

Line 157: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740

153: , p_tcs_amt in number
154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
157: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
158: , p_surcharge_doc_amt out nocopy number
159: , p_surcharge_doc_cess_amt out nocopy number
160: , p_surcharge_doc_sh_cess_amt out nocopy number --Bgowrava for forward porting bug#5989740
161: , p_process_flag out nocopy varchar2

Line 644: update jai_rgm_threshold_dtls

640: -- This must be the last statement in the loop as update should happen only if all the above processing is completed successfully
641: */
642: <>
643: /** Update System surcharge/cess amouts */
644: update jai_rgm_threshold_dtls
645: set system_surcharge_amt = system_surcharge_amt + ln_surcharge_doc_amt
646: , system_surcharge_cess_amt = system_surcharge_cess_amt + ln_surcharge_doc_cess_amt
647: , system_surcharge_sh_cess_amt = system_surcharge_sh_cess_amt + ln_surcharge_doc_sh_cess_amt --Bgowrava for forward porting bug#5989740
648: , last_update_date = sysdate

Line 1396: cursor c_get_threshold_dtl ( cp_threshold_id jai_rgm_threshold_dtls.threshold_id%type

1392: and party_id = cp_party_id
1393: and party_type = cp_party_type
1394: and fin_year = cp_fin_year;
1395:
1396: cursor c_get_threshold_dtl ( cp_threshold_id jai_rgm_threshold_dtls.threshold_id%type
1397: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type
1398: )
1399: is
1400: select threshold_dtl_id

Line 1397: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type

1393: and party_type = cp_party_type
1394: and fin_year = cp_fin_year;
1395:
1396: cursor c_get_threshold_dtl ( cp_threshold_id jai_rgm_threshold_dtls.threshold_id%type
1397: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type
1398: )
1399: is
1400: select threshold_dtl_id
1401: , invoice_amt

Line 1411: from jai_rgm_threshold_dtls

1407: , manual_surcharge_amt
1408: , system_surcharge_amt
1409: , system_surcharge_cess_amt
1410: , system_surcharge_sh_cess_amt --Bgowrava for forward porting bug#5989740
1411: from jai_rgm_threshold_dtls
1412: where threshold_id = cp_threshold_id
1413: and item_classification = cp_item_classification;
1414:
1415: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

Line 1493: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;

1489:
1490:
1491:
1492: ln_threshold_id jai_rgm_thresholds.threshold_id%type;
1493: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;
1494: lr_hdr_record jai_rgm_thresholds%rowtype;
1495: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
1496: lx_row_id rowid;
1497: ln_ref_thhold_base_amt number;

Line 1495: lr_dtl_record jai_rgm_threshold_dtls%rowtype;

1491:
1492: ln_threshold_id jai_rgm_thresholds.threshold_id%type;
1493: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;
1494: lr_hdr_record jai_rgm_thresholds%rowtype;
1495: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
1496: lx_row_id rowid;
1497: ln_ref_thhold_base_amt number;
1498: /*
1499: ln_manual_surcharge_amt number;

Line 1633: ||Part -2 :- CREATE OR UPDATE TABLE JAI_RGM_THRESHOLD_DTLS

1629: end if; /** ln_threshold_id is null */
1630:
1631:
1632: /**************************************************************************************
1633: ||Part -2 :- CREATE OR UPDATE TABLE JAI_RGM_THRESHOLD_DTLS
1634: ***************************************************************************************/
1635: /**
1636: Assumption: When control comes here ln_threshold_id should NOT BE NULL.
1637: */

Line 1880: ,'Updating JAI_RGM_THRESHOLD_DTLS' || chr(10)

1876: else /** Threshold detils record already exists. Hence update the existing record to increment
1877: per item classificaton amounts */
1878:
1879: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1880: ,'Updating JAI_RGM_THRESHOLD_DTLS' || chr(10)
1881: ||'invoice_amt ='||lr_dtl_record.invoice_amt || chr(10)
1882: ||'cash_receipt_amt ='||lr_dtl_record.cash_receipt_amt || chr(10)
1883: ||'application_amt ='||lr_dtl_record.application_amt || chr(10)
1884: ||'unapplication_amt ='||lr_dtl_record.unapplication_amt || chr(10)

Line 1896: update jai_rgm_threshold_dtls

1892: ||'last_update_login ='||ln_login_id || chr(10)
1893: ||'last_update_login ='||ln_threshold_dtl_id
1894: ); */ --commented by bgowrava for bug#5631784
1895:
1896: update jai_rgm_threshold_dtls
1897: set invoice_amt = lr_dtl_record.invoice_amt
1898: , cash_receipt_amt = lr_dtl_record.cash_receipt_amt
1899: , application_amt = lr_dtl_record.application_amt
1900: , unapplication_amt = lr_dtl_record.unapplication_amt

Line 1992: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype

1988:
1989: end maintain_threshold;
1990:
1991: /*------------------------------------------------------------------------------------------------------------*/
1992: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype
1993: , p_threshold_dtl_id out nocopy jai_rgm_threshold_dtls.threshold_dtl_id%type
1994: , p_row_id out nocopy rowid
1995: )
1996: is

Line 1993: , p_threshold_dtl_id out nocopy jai_rgm_threshold_dtls.threshold_dtl_id%type

1989: end maintain_threshold;
1990:
1991: /*------------------------------------------------------------------------------------------------------------*/
1992: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype
1993: , p_threshold_dtl_id out nocopy jai_rgm_threshold_dtls.threshold_dtl_id%type
1994: , p_row_id out nocopy rowid
1995: )
1996: is
1997:

Line 2006: insert into jai_rgm_threshold_dtls

2002: into p_threshold_dtl_id
2003: from dual;
2004: end if;
2005: /** Threshold detail record does not exists */
2006: insert into jai_rgm_threshold_dtls
2007: ( threshold_dtl_id
2008: , threshold_id
2009: , item_classification
2010: , invoice_amt

Line 2139: from jai_rgm_threshold_dtls

2135: + nvl(reversal_amt ,0)
2136: ) total_threshold_amt
2137: ,sum ( nvl(threshold_base_amt ,0)
2138: ) total_threshold_base_amt
2139: from jai_rgm_threshold_dtls
2140: where threshold_id = p_threshold_id;
2141:
2142: cursor c_get_thhold_hdr_info
2143: is