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 142: lr_dtl_record jai_rgm_threshold_dtls%rowtype;

138:
139: /*-------------------------------DECLARE SECTION OF GENERATE_CONSOLIDATED_DOC ---------------------------*/
140:
141: ln_reg_id number;
142: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
143: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
144: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
145:
146: ln_surcharge_doc_amt number;

Line 180: from jai_rgm_threshold_dtls dtls

176: ,nvl(dtls.manual_surcharge_amt,0) manual_surcharge_amt
177: ,nvl(dtls.system_surcharge_amt,0) system_surcharge_amt
178: ,nvl(dtls.system_surcharge_cess_amt,0) system_surcharge_cess_amt
179: ,nvl(dtls.system_surcharge_sh_cess_amt,0) system_surcharge_sh_cess_amt --Bgowrava for forward porting bug#5989740
180: from jai_rgm_threshold_dtls dtls
181: ,jai_rgm_thresholds hdr
182: where hdr.threshold_id = p_threshold_id
183: and dtls.threshold_id = hdr.threshold_id ;
184:

Line 243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type

239:
240: procedure calculate_tcs_doc_amount
241: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
242: , p_tcs_amt in number
243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
246: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
247: , p_surcharge_doc_amt out nocopy number

Line 244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type

240: procedure calculate_tcs_doc_amount
241: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
242: , p_tcs_amt in number
243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
246: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
247: , p_surcharge_doc_amt out nocopy number
248: , p_surcharge_doc_cess_amt out nocopy number

Line 245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type

241: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
242: , p_tcs_amt in number
243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
246: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
247: , p_surcharge_doc_amt out nocopy number
248: , p_surcharge_doc_cess_amt out nocopy number
249: , p_surcharge_doc_sh_cess_amt out nocopy number --Bgowrava for forward porting bug#5989740

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

242: , p_tcs_amt in number
243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
246: , p_system_surcharge_sh_cess_amt in jai_rgm_threshold_dtls.system_surcharge_sh_cess_amt%type --Bgowrava for forward porting bug#5989740
247: , p_surcharge_doc_amt out nocopy number
248: , p_surcharge_doc_cess_amt out nocopy number
249: , p_surcharge_doc_sh_cess_amt out nocopy number --Bgowrava for forward porting bug#5989740
250: , p_process_flag out nocopy varchar2

Line 733: update jai_rgm_threshold_dtls

729: -- This must be the last statement in the loop as update should happen only if all the above processing is completed successfully
730: */
731: <>
732: /** Update System surcharge/cess amouts */
733: update jai_rgm_threshold_dtls
734: set system_surcharge_amt = system_surcharge_amt + ln_surcharge_doc_amt
735: , system_surcharge_cess_amt = system_surcharge_cess_amt + ln_surcharge_doc_cess_amt
736: , system_surcharge_sh_cess_amt = system_surcharge_sh_cess_amt + ln_surcharge_doc_sh_cess_amt --Bgowrava for forward porting bug#5989740
737: , last_update_date = sysdate

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

1491: and party_id = cp_party_id
1492: and party_type = cp_party_type
1493: and fin_year = cp_fin_year;
1494:
1495: cursor c_get_threshold_dtl ( cp_threshold_id jai_rgm_threshold_dtls.threshold_id%type
1496: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type
1497: )
1498: is
1499: select threshold_dtl_id

Line 1496: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type

1492: and party_type = cp_party_type
1493: and fin_year = cp_fin_year;
1494:
1495: cursor c_get_threshold_dtl ( cp_threshold_id jai_rgm_threshold_dtls.threshold_id%type
1496: , cp_item_classification jai_rgm_threshold_dtls.item_classification%type
1497: )
1498: is
1499: select threshold_dtl_id
1500: , invoice_amt

Line 1510: from jai_rgm_threshold_dtls

1506: , manual_surcharge_amt
1507: , system_surcharge_amt
1508: , system_surcharge_cess_amt
1509: , system_surcharge_sh_cess_amt --Bgowrava for forward porting bug#5989740
1510: from jai_rgm_threshold_dtls
1511: where threshold_id = cp_threshold_id
1512: and item_classification = cp_item_classification;
1513:
1514: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

Line 1592: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;

1588:
1589:
1590:
1591: ln_threshold_id jai_rgm_thresholds.threshold_id%type;
1592: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;
1593: lr_hdr_record jai_rgm_thresholds%rowtype;
1594: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
1595: lx_row_id rowid;
1596: ln_ref_thhold_base_amt number;

Line 1594: lr_dtl_record jai_rgm_threshold_dtls%rowtype;

1590:
1591: ln_threshold_id jai_rgm_thresholds.threshold_id%type;
1592: ln_threshold_dtl_id jai_rgm_threshold_dtls.threshold_dtl_id%type;
1593: lr_hdr_record jai_rgm_thresholds%rowtype;
1594: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
1595: lx_row_id rowid;
1596: ln_ref_thhold_base_amt number;
1597: /*
1598: ln_manual_surcharge_amt number;

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

1728: end if; /** ln_threshold_id is null */
1729:
1730:
1731: /**************************************************************************************
1732: ||Part -2 :- CREATE OR UPDATE TABLE JAI_RGM_THRESHOLD_DTLS
1733: ***************************************************************************************/
1734: /**
1735: Assumption: When control comes here ln_threshold_id should NOT BE NULL.
1736: */

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

1975: else /** Threshold detils record already exists. Hence update the existing record to increment
1976: per item classificaton amounts */
1977:
1978: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1979: ,'Updating JAI_RGM_THRESHOLD_DTLS' || chr(10)
1980: ||'invoice_amt ='||lr_dtl_record.invoice_amt || chr(10)
1981: ||'cash_receipt_amt ='||lr_dtl_record.cash_receipt_amt || chr(10)
1982: ||'application_amt ='||lr_dtl_record.application_amt || chr(10)
1983: ||'unapplication_amt ='||lr_dtl_record.unapplication_amt || chr(10)

Line 1995: update jai_rgm_threshold_dtls

1991: ||'last_update_login ='||ln_login_id || chr(10)
1992: ||'last_update_login ='||ln_threshold_dtl_id
1993: ); */ --commented by bgowrava for bug#5631784
1994:
1995: update jai_rgm_threshold_dtls
1996: set invoice_amt = lr_dtl_record.invoice_amt
1997: , cash_receipt_amt = lr_dtl_record.cash_receipt_amt
1998: , application_amt = lr_dtl_record.application_amt
1999: , unapplication_amt = lr_dtl_record.unapplication_amt

Line 2091: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype

2087:
2088: end maintain_threshold;
2089:
2090: /*------------------------------------------------------------------------------------------------------------*/
2091: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype
2092: , p_threshold_dtl_id out nocopy jai_rgm_threshold_dtls.threshold_dtl_id%type
2093: , p_row_id out nocopy rowid
2094: )
2095: is

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

2088: end maintain_threshold;
2089:
2090: /*------------------------------------------------------------------------------------------------------------*/
2091: procedure insert_threshold_dtl ( p_record in jai_rgm_threshold_dtls%rowtype
2092: , p_threshold_dtl_id out nocopy jai_rgm_threshold_dtls.threshold_dtl_id%type
2093: , p_row_id out nocopy rowid
2094: )
2095: is
2096:

Line 2105: insert into jai_rgm_threshold_dtls

2101: into p_threshold_dtl_id
2102: from dual;
2103: end if;
2104: /** Threshold detail record does not exists */
2105: insert into jai_rgm_threshold_dtls
2106: ( threshold_dtl_id
2107: , threshold_id
2108: , item_classification
2109: , invoice_amt

Line 2238: from jai_rgm_threshold_dtls

2234: + nvl(reversal_amt ,0)
2235: ) total_threshold_amt
2236: ,sum ( nvl(threshold_base_amt ,0)
2237: ) total_threshold_base_amt
2238: from jai_rgm_threshold_dtls
2239: where threshold_id = p_threshold_id;
2240:
2241: cursor c_get_thhold_hdr_info
2242: is