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_THRESHOLDS

Line 131: (p_threshold_id in jai_rgm_thresholds.threshold_id%type

127:
128: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
129:
130: procedure generate_consolidated_doc
131: (p_threshold_id in jai_rgm_thresholds.threshold_id%type
132: ,p_transaction_id in jai_rgm_refs_all.transaction_id%type
133: ,p_org_id in jai_rgm_refs_all.org_id%type
134: ,p_process_flag out nocopy varchar2
135: ,p_process_message out nocopy varchar2

Line 143: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

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;
147: ln_surcharge_doc_cess_amt number;

Line 181: ,jai_rgm_thresholds hdr

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:
185: cursor c_curr_code (cp_org_id jai_rgm_refs_all.org_id%type)

Line 607: , p_table_name => jai_constants.jai_rgm_thresholds

603: , p_document_id => jai_constants.tcs_surcharge_id
604: , p_document_type => jai_constants.tcs_event_surcharge
605: , p_document_line_id => jai_constants.tcs_surcharge_id
606: , p_document_date => r_ref_dtls.source_document_date
607: , p_table_name => jai_constants.jai_rgm_thresholds
608: , p_line_amount => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt) --Bgowrava for forward porting bug#5989740
609: , p_document_amount => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt) --Bgowrava for forward porting bug#5989740
610: , p_org_id => r_ref_dtls.org_id
611: , p_organization_id => r_ref_dtls.organization_id

Line 764: p_regime_id - A valid regime_id from jai_rgm_thresholds.

760: /*---------------------------------------------PUBLIC SECTION-------------------------------------------------*/
761: /**
762: get_threshold_slab_id - returns identifier for current threshold slab as out parameter
763: IN
764: p_regime_id - A valid regime_id from jai_rgm_thresholds.
765: p_org_tan_no - Organiztion TAN as defined in the regime setup
766: p_organization_id - Inventory organization defined in the regime setup
767: p_party_type - Party type. Can be either CUSTOMER or VENDOR. Currently only CUSTOMER is valid.
768: p_party_id - Party identifier.

Line 783: p_regime_id in jai_rgm_thresholds.regime_id%type

779: */
780: /*------------------------------------------------------------------------------------------------------------*/
781: procedure get_threshold_slab_id
782: (
783: p_regime_id in jai_rgm_thresholds.regime_id%type
784: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
785: , p_organization_id in hr_organization_units.organization_id%type default null
786: , p_party_type in jai_rgm_thresholds.party_type%type
787: , p_party_id in jai_rgm_thresholds.party_id%type

Line 786: , p_party_type in jai_rgm_thresholds.party_type%type

782: (
783: p_regime_id in jai_rgm_thresholds.regime_id%type
784: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
785: , p_organization_id in hr_organization_units.organization_id%type default null
786: , p_party_type in jai_rgm_thresholds.party_type%type
787: , p_party_id in jai_rgm_thresholds.party_id%type
788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
790: , p_source_trx_date in date default null

Line 787: , p_party_id in jai_rgm_thresholds.party_id%type

783: p_regime_id in jai_rgm_thresholds.regime_id%type
784: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
785: , p_organization_id in hr_organization_units.organization_id%type default null
786: , p_party_type in jai_rgm_thresholds.party_type%type
787: , p_party_id in jai_rgm_thresholds.party_id%type
788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
790: , p_source_trx_date in date default null
791: , p_called_from in varchar2 default null

Line 788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null

784: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
785: , p_organization_id in hr_organization_units.organization_id%type default null
786: , p_party_type in jai_rgm_thresholds.party_type%type
787: , p_party_id in jai_rgm_thresholds.party_id%type
788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
790: , p_source_trx_date in date default null
791: , p_called_from in varchar2 default null
792: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

Line 792: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
790: , p_source_trx_date in date default null
791: , p_called_from in varchar2 default null
792: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
793: , p_process_flag out nocopy varchar2
794: , p_process_message out nocopy varchar2
795: )
796: is

Line 799: ln_fin_year jai_rgm_thresholds.fin_year%type;

795: )
796: is
797: ln_reg_id number;
798: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;
799: ln_fin_year jai_rgm_thresholds.fin_year%type;
800: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;
801:
802: /** cursor will fetch org_tan_no from regime setup */
803: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type

Line 823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type

819: /**
820: Following cursor will derrive threshold_slab_id for a given combination of
821: fin_year, org_tan_no, party_type and party_id form the threshold setup
822: */
823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
825: , cp_party_type jai_rgm_thresholds.party_type%type
826: , cp_party_id jai_rgm_thresholds.party_id%type
827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type

Line 824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

820: Following cursor will derrive threshold_slab_id for a given combination of
821: fin_year, org_tan_no, party_type and party_id form the threshold setup
822: */
823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
825: , cp_party_type jai_rgm_thresholds.party_type%type
826: , cp_party_id jai_rgm_thresholds.party_id%type
827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
828: )

Line 825: , cp_party_type jai_rgm_thresholds.party_type%type

821: fin_year, org_tan_no, party_type and party_id form the threshold setup
822: */
823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
825: , cp_party_type jai_rgm_thresholds.party_type%type
826: , cp_party_id jai_rgm_thresholds.party_id%type
827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
828: )
829: is

Line 826: , cp_party_id jai_rgm_thresholds.party_id%type

822: */
823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
825: , cp_party_type jai_rgm_thresholds.party_type%type
826: , cp_party_id jai_rgm_thresholds.party_id%type
827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
828: )
829: is
830: select

Line 836: ,jai_rgm_thresholds rgmths

832: from
833: jai_ap_tds_thhold_slabs thslbs
834: ,jai_ap_tds_thhold_types thtyps
835: ,jai_ap_tds_thhold_hdrs thhdrs
836: ,jai_rgm_thresholds rgmths
837: where
838: thslbs.threshold_type_id = thtyps.threshold_type_id
839: and thtyps.threshold_hdr_id = thhdrs.threshold_hdr_id
840: and thhdrs.regime_id = rgmths.regime_id

Line 855: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type

851: /*Added nvl caluse by mmurtuza for bug 13505267*/
852:
853:
854:
855: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
856: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
857: , cp_party_type jai_rgm_thresholds.party_type%type
858: , cp_party_id jai_rgm_thresholds.party_id%type
859: )

Line 856: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

852:
853:
854:
855: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
856: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
857: , cp_party_type jai_rgm_thresholds.party_type%type
858: , cp_party_id jai_rgm_thresholds.party_id%type
859: )
860: is

Line 857: , cp_party_type jai_rgm_thresholds.party_type%type

853:
854:
855: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
856: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
857: , cp_party_type jai_rgm_thresholds.party_type%type
858: , cp_party_id jai_rgm_thresholds.party_id%type
859: )
860: is
861: select threshold_slab_id

Line 858: , cp_party_id jai_rgm_thresholds.party_id%type

854:
855: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
856: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
857: , cp_party_type jai_rgm_thresholds.party_type%type
858: , cp_party_id jai_rgm_thresholds.party_id%type
859: )
860: is
861: select threshold_slab_id
862: from jai_rgm_thresholds

Line 862: from jai_rgm_thresholds

858: , cp_party_id jai_rgm_thresholds.party_id%type
859: )
860: is
861: select threshold_slab_id
862: from jai_rgm_thresholds
863: where fin_year = cp_fin_year
864: and org_tan_no = cp_org_tan_no
865: and party_type = cp_party_type
866: and party_id = cp_party_id

Line 978: /** This is an internal call. Hence fetch the applicable slab id for amount updated in the jai_rgm_thresholds */

974: ); */ -- */ --commented by bgowrava for bug#5631784
975:
976: if p_called_from is not null
977: and p_called_from = jai_constants.tcs_event_surcharge then
978: /** This is an internal call. Hence fetch the applicable slab id for amount updated in the jai_rgm_thresholds */
979:
980: /**
981: Assumption: To fetch slab from the setup transaction date is mandatory
982: */

Line 1018: else /** p_called_from is null means the call is from outside. So, fetch the threshold slab from jai_rgm_thresholds and return */

1014: );
1015: fetch c_get_threshold_slab into p_threshold_slab_id;
1016: close c_get_threshold_slab ;
1017:
1018: else /** p_called_from is null means the call is from outside. So, fetch the threshold slab from jai_rgm_thresholds and return */
1019:
1020: open c_get_thhold_hdr_slab ( cp_fin_year => ln_fin_year
1021: , cp_org_tan_no => ln_org_tan_no
1022: , cp_party_type => jai_constants.party_type_customer

Line 1067: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type

1063: */
1064: /*------------------------------------------------------------------------------------------------------------*/
1065: procedure get_threshold_tax_cat_id
1066: (
1067: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
1068: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
1069: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
1070: , p_process_flag out nocopy varchar2
1071: , p_process_message out nocopy varchar2

Line 1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type

1475: , source_document_type
1476: , source_document_date
1477: , org_id;
1478:
1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1481: , cp_party_type jai_rgm_thresholds.party_type%type
1482: , cp_party_id jai_rgm_thresholds.party_id%type
1483: , cp_fin_year jai_rgm_thresholds.fin_year%type

Line 1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

1476: , source_document_date
1477: , org_id;
1478:
1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1481: , cp_party_type jai_rgm_thresholds.party_type%type
1482: , cp_party_id jai_rgm_thresholds.party_id%type
1483: , cp_fin_year jai_rgm_thresholds.fin_year%type
1484: )

Line 1481: , cp_party_type jai_rgm_thresholds.party_type%type

1477: , org_id;
1478:
1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1481: , cp_party_type jai_rgm_thresholds.party_type%type
1482: , cp_party_id jai_rgm_thresholds.party_id%type
1483: , cp_fin_year jai_rgm_thresholds.fin_year%type
1484: )
1485: is

Line 1482: , cp_party_id jai_rgm_thresholds.party_id%type

1478:
1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1481: , cp_party_type jai_rgm_thresholds.party_type%type
1482: , cp_party_id jai_rgm_thresholds.party_id%type
1483: , cp_fin_year jai_rgm_thresholds.fin_year%type
1484: )
1485: is
1486: select threshold_id

Line 1483: , cp_fin_year jai_rgm_thresholds.fin_year%type

1479: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1480: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1481: , cp_party_type jai_rgm_thresholds.party_type%type
1482: , cp_party_id jai_rgm_thresholds.party_id%type
1483: , cp_fin_year jai_rgm_thresholds.fin_year%type
1484: )
1485: is
1486: select threshold_id
1487: , threshold_slab_id

Line 1488: from jai_rgm_thresholds

1484: )
1485: is
1486: select threshold_id
1487: , threshold_slab_id
1488: from jai_rgm_thresholds
1489: where regime_id = cp_regime_id
1490: and org_tan_no = cp_org_tan_no
1491: and party_id = cp_party_id
1492: and party_type = cp_party_type

Line 1591: ln_threshold_id jai_rgm_thresholds.threshold_id%type;

1587: -- end Bgowrava for forward porting bug#5989740
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;

Line 1593: lr_hdr_record jai_rgm_thresholds%rowtype;

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;
1597: /*

Line 1606: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

1602: ln_surcharge_amt number;
1603: ln_surcharge_cess_amt number;
1604: ln_surcharge_sh_cess_amt number; --Bgowrava for forward porting bug#5989740
1605: lv_thhold_slab_change_flag varchar2(2);
1606: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
1607: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1608:
1609:
1610: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

Line 1637: /** Check for combination of ORG_TAN_NO, PARTY_ID, FIN_YEAR a record exists in the jai_rgm_thresholds table */

1633:
1634: for r_trx_lines in c_get_trx_details
1635: loop
1636:
1637: /** Check for combination of ORG_TAN_NO, PARTY_ID, FIN_YEAR a record exists in the jai_rgm_thresholds table */
1638: open c_get_threshold_id
1639: ( cp_regime_id => r_trx_lines.regime_id
1640: , cp_org_tan_no => r_trx_lines.org_tan_no
1641: , cp_party_type => jai_constants.party_type_customer

Line 1655: ||Part -1 :- FIRST TIME HEADER CREATION IN TABLE JAI_RGM_THRESHOLDS

1651: , jai_cmn_debug_contexts_pkg.detail
1652: );*/ --commented by bgowrava for bug#5631784
1653:
1654: /**************************************************************************************
1655: ||Part -1 :- FIRST TIME HEADER CREATION IN TABLE JAI_RGM_THRESHOLDS
1656: ***************************************************************************************/
1657:
1658: if ln_threshold_id is null then
1659:

Line 1705: , 'Before insert into jai_rgm_thresholds' || chr(10)

1701: lr_hdr_record.last_update_login := ln_login_id ;
1702:
1703:
1704: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1705: , 'Before insert into jai_rgm_thresholds' || chr(10)
1706: ||'lr_hdr_record.threshold_id ='||lr_hdr_record.threshold_id || chr(10)
1707: ||'lr_hdr_record.regime_id ='||lr_hdr_record.regime_id || chr(10)
1708: ||'lr_hdr_record.org_tan_no ='||lr_hdr_record.org_tan_no || chr(10)
1709: ||'lr_hdr_record.party_id ='||lr_hdr_record.party_id || chr(10)

Line 1739: p_process_message := 'Cannot create threshold header record in jai_rgm_thresholds';

1735: Assumption: When control comes here ln_threshold_id should NOT BE NULL.
1736: */
1737: if ln_threshold_id is null then
1738: p_process_flag := jai_constants.expected_error;
1739: p_process_message := 'Cannot create threshold header record in jai_rgm_thresholds';
1740: return;
1741: end if;
1742:
1743: /** Initialize record */

Line 2100: select jai_rgm_thresholds_s.nextval

2096:
2097: begin
2098:
2099: if p_record.threshold_dtl_id is null then
2100: select jai_rgm_thresholds_s.nextval
2101: into p_threshold_dtl_id
2102: from dual;
2103: end if;
2104: /** Threshold detail record does not exists */

Line 2158: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype

2154: raise;
2155:
2156: end insert_threshold_dtl;
2157: /*------------------------------------------------------------------------------------------------------------*/
2158: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype
2159: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
2160: , p_row_id out nocopy rowid
2161: )
2162: is

Line 2159: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type

2155:
2156: end insert_threshold_dtl;
2157: /*------------------------------------------------------------------------------------------------------------*/
2158: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype
2159: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
2160: , p_row_id out nocopy rowid
2161: )
2162: is
2163: begin

Line 2166: select jai_rgm_thresholds_s.nextval

2162: is
2163: begin
2164:
2165: if p_record.threshold_id is null then
2166: select jai_rgm_thresholds_s.nextval
2167: into p_threshold_id
2168: from dual;
2169: end if;
2170:

Line 2171: insert into jai_rgm_thresholds

2167: into p_threshold_id
2168: from dual;
2169: end if;
2170:
2171: insert into jai_rgm_thresholds
2172: ( threshold_id
2173: , regime_id
2174: , org_tan_no
2175: , party_id

Line 2218: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type

2214: end insert_threshold_hdr;
2215:
2216: /*------------------------------------------------------------------------------------------------------------*/
2217: procedure sync_threshold_header
2218: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
2219: , p_source_trx_date in date
2220: , p_thhold_slab_change_flag out nocopy varchar2
2221: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
2222: , p_process_flag out nocopy varchar2

Line 2221: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

2217: procedure sync_threshold_header
2218: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
2219: , p_source_trx_date in date
2220: , p_thhold_slab_change_flag out nocopy varchar2
2221: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
2222: , p_process_flag out nocopy varchar2
2223: , p_process_message out nocopy varchar2
2224: )
2225:

Line 2249: from jai_rgm_thresholds

2245: ,party_type
2246: ,party_id
2247: ,fin_year
2248: ,threshold_slab_id
2249: from jai_rgm_thresholds
2250: where threshold_id = p_threshold_id;
2251:
2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;

Line 2252: ln_regime_id jai_rgm_thresholds.regime_id%type;

2248: ,threshold_slab_id
2249: from jai_rgm_thresholds
2250: where threshold_id = p_threshold_id;
2251:
2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;

Line 2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;

2249: from jai_rgm_thresholds
2250: where threshold_id = p_threshold_id;
2251:
2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:

Line 2254: lv_party_type jai_rgm_thresholds.party_type%type;

2250: where threshold_id = p_threshold_id;
2251:
2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

Line 2255: ln_party_id jai_rgm_thresholds.party_id%type;

2251:
2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

Line 2256: ln_fin_year jai_rgm_thresholds.fin_year%type;

2252: ln_regime_id jai_rgm_thresholds.regime_id%type;
2253: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2260:

Line 2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

2254: lv_party_type jai_rgm_thresholds.party_type%type;
2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2260:
2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;

Line 2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

2255: ln_party_id jai_rgm_thresholds.party_id%type;
2256: ln_fin_year jai_rgm_thresholds.fin_year%type;
2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2260:
2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2263:

Line 2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;

2257:
2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2260:
2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2263:
2264: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
2265: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

Line 2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;

2258: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2259: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2260:
2261: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2262: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2263:
2264: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
2265: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
2266:

Line 2295: update jai_rgm_thresholds

2291:
2292: ln_total_thhold_amt := nvl(ln_total_thhold_amt ,0);
2293: ln_total_thhold_base_amt := nvl(ln_total_thhold_base_amt ,0);
2294:
2295: update jai_rgm_thresholds
2296: set total_threshold_amt = ln_total_thhold_amt
2297: ,total_threshold_base_amt = ln_total_thhold_base_amt
2298: ,last_updated_by = ln_user_id
2299: ,last_update_date = sysdate

Line 2341: /** Slab is changed. Hence update threshold slab in the jai_rgm_thresholds */

2337:
2338: p_new_thhold_slab_id := ln_new_thhold_slab_id;
2339:
2340: if nvl(ln_new_thhold_slab_id,-9999) <> nvl(ln_curr_thhold_slab_id,-9999) then
2341: /** Slab is changed. Hence update threshold slab in the jai_rgm_thresholds */
2342: update jai_rgm_thresholds
2343: set threshold_slab_id = ln_new_thhold_slab_id
2344: ,last_update_date = sysdate
2345: ,last_updated_by = ln_user_id

Line 2342: update jai_rgm_thresholds

2338: p_new_thhold_slab_id := ln_new_thhold_slab_id;
2339:
2340: if nvl(ln_new_thhold_slab_id,-9999) <> nvl(ln_curr_thhold_slab_id,-9999) then
2341: /** Slab is changed. Hence update threshold slab in the jai_rgm_thresholds */
2342: update jai_rgm_thresholds
2343: set threshold_slab_id = ln_new_thhold_slab_id
2344: ,last_update_date = sysdate
2345: ,last_updated_by = ln_user_id
2346: ,last_update_login = ln_login_id