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 42: (p_threshold_id in jai_rgm_thresholds.threshold_id%type

38: lv_context := rtrim(lv_object_name || '.'||lv_member_name,'.');
39: end set_debug_context;
40: /*------------------------------------------END - PRIVATE MEMBERS DECLRATION --------------------------------*/
41: procedure generate_consolidated_doc
42: (p_threshold_id in jai_rgm_thresholds.threshold_id%type
43: ,p_transaction_id in jai_rgm_refs_all.transaction_id%type
44: ,p_org_id in jai_rgm_refs_all.org_id%type
45: ,p_process_flag out nocopy varchar2
46: ,p_process_message out nocopy varchar2

Line 54: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

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

Line 92: ,jai_rgm_thresholds hdr

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

Line 518: , p_table_name => jai_constants.jai_rgm_thresholds

514: , p_document_id => jai_constants.tcs_surcharge_id
515: , p_document_type => jai_constants.tcs_event_surcharge
516: , p_document_line_id => jai_constants.tcs_surcharge_id
517: , p_document_date => r_ref_dtls.source_document_date
518: , p_table_name => jai_constants.jai_rgm_thresholds
519: , p_line_amount => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt) --Bgowrava for forward porting bug#5989740
520: , p_document_amount => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt) --Bgowrava for forward porting bug#5989740
521: , p_org_id => r_ref_dtls.org_id
522: , p_organization_id => r_ref_dtls.organization_id

Line 675: p_regime_id - A valid regime_id from jai_rgm_thresholds.

671: /*---------------------------------------------PUBLIC SECTION-------------------------------------------------*/
672: /**
673: get_threshold_slab_id - returns identifier for current threshold slab as out parameter
674: IN
675: p_regime_id - A valid regime_id from jai_rgm_thresholds.
676: p_org_tan_no - Organiztion TAN as defined in the regime setup
677: p_organization_id - Inventory organization defined in the regime setup
678: p_party_type - Party type. Can be either CUSTOMER or VENDOR. Currently only CUSTOMER is valid.
679: p_party_id - Party identifier.

Line 694: p_regime_id in jai_rgm_thresholds.regime_id%type

690: */
691: /*------------------------------------------------------------------------------------------------------------*/
692: procedure get_threshold_slab_id
693: (
694: p_regime_id in jai_rgm_thresholds.regime_id%type
695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type

Line 697: , p_party_type in jai_rgm_thresholds.party_type%type

693: (
694: p_regime_id in jai_rgm_thresholds.regime_id%type
695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type
699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
700: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
701: , p_source_trx_date in date default null

Line 698: , p_party_id in jai_rgm_thresholds.party_id%type

694: p_regime_id in jai_rgm_thresholds.regime_id%type
695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type
699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
700: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
701: , p_source_trx_date in date default null
702: , p_called_from in varchar2 default null

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

695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type
699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
700: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
701: , p_source_trx_date in date default null
702: , p_called_from in varchar2 default null
703: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

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

699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
700: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
701: , p_source_trx_date in date default null
702: , p_called_from in varchar2 default null
703: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
704: , p_process_flag out nocopy varchar2
705: , p_process_message out nocopy varchar2
706: )
707: is

Line 710: ln_fin_year jai_rgm_thresholds.fin_year%type;

706: )
707: is
708: ln_reg_id number;
709: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;
710: ln_fin_year jai_rgm_thresholds.fin_year%type;
711: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;
712:
713: /** cursor will fetch org_tan_no from regime setup */
714: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type

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

730: /**
731: Following cursor will derrive threshold_slab_id for a given combination of
732: fin_year, org_tan_no, party_type and party_id form the threshold setup
733: */
734: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
736: , cp_party_type jai_rgm_thresholds.party_type%type
737: , cp_party_id jai_rgm_thresholds.party_id%type
738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type

Line 735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

731: Following cursor will derrive threshold_slab_id for a given combination of
732: fin_year, org_tan_no, party_type and party_id form the threshold setup
733: */
734: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
736: , cp_party_type jai_rgm_thresholds.party_type%type
737: , cp_party_id jai_rgm_thresholds.party_id%type
738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
739: )

Line 736: , cp_party_type jai_rgm_thresholds.party_type%type

732: fin_year, org_tan_no, party_type and party_id form the threshold setup
733: */
734: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
736: , cp_party_type jai_rgm_thresholds.party_type%type
737: , cp_party_id jai_rgm_thresholds.party_id%type
738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
739: )
740: is

Line 737: , cp_party_id jai_rgm_thresholds.party_id%type

733: */
734: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
736: , cp_party_type jai_rgm_thresholds.party_type%type
737: , cp_party_id jai_rgm_thresholds.party_id%type
738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
739: )
740: is
741: select

Line 747: ,jai_rgm_thresholds rgmths

743: from
744: jai_ap_tds_thhold_slabs thslbs
745: ,jai_ap_tds_thhold_types thtyps
746: ,jai_ap_tds_thhold_hdrs thhdrs
747: ,jai_rgm_thresholds rgmths
748: where
749: thslbs.threshold_type_id = thtyps.threshold_type_id
750: and thtyps.threshold_hdr_id = thhdrs.threshold_hdr_id
751: and thhdrs.regime_id = rgmths.regime_id

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

759: and nvl(thtyps.to_date, trunc(p_source_trx_date))
760: and rgmths.total_threshold_amt between thslbs.from_amount
761: and nvl(thslbs.to_amount,rgmths.total_threshold_amt);
762:
763: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
764: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
765: , cp_party_type jai_rgm_thresholds.party_type%type
766: , cp_party_id jai_rgm_thresholds.party_id%type
767: )

Line 764: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

760: and rgmths.total_threshold_amt between thslbs.from_amount
761: and nvl(thslbs.to_amount,rgmths.total_threshold_amt);
762:
763: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
764: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
765: , cp_party_type jai_rgm_thresholds.party_type%type
766: , cp_party_id jai_rgm_thresholds.party_id%type
767: )
768: is

Line 765: , cp_party_type jai_rgm_thresholds.party_type%type

761: and nvl(thslbs.to_amount,rgmths.total_threshold_amt);
762:
763: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
764: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
765: , cp_party_type jai_rgm_thresholds.party_type%type
766: , cp_party_id jai_rgm_thresholds.party_id%type
767: )
768: is
769: select threshold_slab_id

Line 766: , cp_party_id jai_rgm_thresholds.party_id%type

762:
763: cursor c_get_thhold_hdr_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
764: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
765: , cp_party_type jai_rgm_thresholds.party_type%type
766: , cp_party_id jai_rgm_thresholds.party_id%type
767: )
768: is
769: select threshold_slab_id
770: from jai_rgm_thresholds

Line 770: from jai_rgm_thresholds

766: , cp_party_id jai_rgm_thresholds.party_id%type
767: )
768: is
769: select threshold_slab_id
770: from jai_rgm_thresholds
771: where fin_year = cp_fin_year
772: and org_tan_no = cp_org_tan_no
773: and party_type = cp_party_type
774: and party_id = cp_party_id

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

879: ); */ -- */ --commented by bgowrava for bug#5631784
880:
881: if p_called_from is not null
882: and p_called_from = jai_constants.tcs_event_surcharge then
883: /** This is an internal call. Hence fetch the applicable slab id for amount updated in the jai_rgm_thresholds */
884:
885: /**
886: Assumption: To fetch slab from the setup transaction date is mandatory
887: */

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

919: );
920: fetch c_get_threshold_slab into p_threshold_slab_id;
921: close c_get_threshold_slab ;
922:
923: else /** p_called_from is null means the call is from outside. So, fetch the threshold slab from jai_rgm_thresholds and return */
924:
925: open c_get_thhold_hdr_slab ( cp_fin_year => ln_fin_year
926: , cp_org_tan_no => ln_org_tan_no
927: , cp_party_type => jai_constants.party_type_customer

Line 972: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type

968: */
969: /*------------------------------------------------------------------------------------------------------------*/
970: procedure get_threshold_tax_cat_id
971: (
972: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
973: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
974: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
975: , p_process_flag out nocopy varchar2
976: , p_process_message out nocopy varchar2

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

1376: , source_document_type
1377: , source_document_date
1378: , org_id;
1379:
1380: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1382: , cp_party_type jai_rgm_thresholds.party_type%type
1383: , cp_party_id jai_rgm_thresholds.party_id%type
1384: , cp_fin_year jai_rgm_thresholds.fin_year%type

Line 1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type

1377: , source_document_date
1378: , org_id;
1379:
1380: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1382: , cp_party_type jai_rgm_thresholds.party_type%type
1383: , cp_party_id jai_rgm_thresholds.party_id%type
1384: , cp_fin_year jai_rgm_thresholds.fin_year%type
1385: )

Line 1382: , cp_party_type jai_rgm_thresholds.party_type%type

1378: , org_id;
1379:
1380: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1382: , cp_party_type jai_rgm_thresholds.party_type%type
1383: , cp_party_id jai_rgm_thresholds.party_id%type
1384: , cp_fin_year jai_rgm_thresholds.fin_year%type
1385: )
1386: is

Line 1383: , cp_party_id jai_rgm_thresholds.party_id%type

1379:
1380: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1382: , cp_party_type jai_rgm_thresholds.party_type%type
1383: , cp_party_id jai_rgm_thresholds.party_id%type
1384: , cp_fin_year jai_rgm_thresholds.fin_year%type
1385: )
1386: is
1387: select threshold_id

Line 1384: , cp_fin_year jai_rgm_thresholds.fin_year%type

1380: cursor c_get_threshold_id ( cp_regime_id jai_rgm_thresholds.regime_id%type
1381: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
1382: , cp_party_type jai_rgm_thresholds.party_type%type
1383: , cp_party_id jai_rgm_thresholds.party_id%type
1384: , cp_fin_year jai_rgm_thresholds.fin_year%type
1385: )
1386: is
1387: select threshold_id
1388: , threshold_slab_id

Line 1389: from jai_rgm_thresholds

1385: )
1386: is
1387: select threshold_id
1388: , threshold_slab_id
1389: from jai_rgm_thresholds
1390: where regime_id = cp_regime_id
1391: and org_tan_no = cp_org_tan_no
1392: and party_id = cp_party_id
1393: and party_type = cp_party_type

Line 1492: ln_threshold_id jai_rgm_thresholds.threshold_id%type;

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

Line 1494: lr_hdr_record jai_rgm_thresholds%rowtype;

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

Line 1507: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

1503: ln_surcharge_amt number;
1504: ln_surcharge_cess_amt number;
1505: ln_surcharge_sh_cess_amt number; --Bgowrava for forward porting bug#5989740
1506: lv_thhold_slab_change_flag varchar2(2);
1507: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
1508: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1509:
1510:
1511: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

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

1534:
1535: for r_trx_lines in c_get_trx_details
1536: loop
1537:
1538: /** Check for combination of ORG_TAN_NO, PARTY_ID, FIN_YEAR a record exists in the jai_rgm_thresholds table */
1539: open c_get_threshold_id
1540: ( cp_regime_id => r_trx_lines.regime_id
1541: , cp_org_tan_no => r_trx_lines.org_tan_no
1542: , cp_party_type => jai_constants.party_type_customer

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

1552: , jai_cmn_debug_contexts_pkg.detail
1553: );*/ --commented by bgowrava for bug#5631784
1554:
1555: /**************************************************************************************
1556: ||Part -1 :- FIRST TIME HEADER CREATION IN TABLE JAI_RGM_THRESHOLDS
1557: ***************************************************************************************/
1558:
1559: if ln_threshold_id is null then
1560:

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

1602: lr_hdr_record.last_update_login := ln_login_id ;
1603:
1604:
1605: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1606: , 'Before insert into jai_rgm_thresholds' || chr(10)
1607: ||'lr_hdr_record.threshold_id ='||lr_hdr_record.threshold_id || chr(10)
1608: ||'lr_hdr_record.regime_id ='||lr_hdr_record.regime_id || chr(10)
1609: ||'lr_hdr_record.org_tan_no ='||lr_hdr_record.org_tan_no || chr(10)
1610: ||'lr_hdr_record.party_id ='||lr_hdr_record.party_id || chr(10)

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

1636: Assumption: When control comes here ln_threshold_id should NOT BE NULL.
1637: */
1638: if ln_threshold_id is null then
1639: p_process_flag := jai_constants.expected_error;
1640: p_process_message := 'Cannot create threshold header record in jai_rgm_thresholds';
1641: return;
1642: end if;
1643:
1644: /** Initialize record */

Line 2001: select jai_rgm_thresholds_s.nextval

1997:
1998: begin
1999:
2000: if p_record.threshold_dtl_id is null then
2001: select jai_rgm_thresholds_s.nextval
2002: into p_threshold_dtl_id
2003: from dual;
2004: end if;
2005: /** Threshold detail record does not exists */

Line 2059: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype

2055: raise;
2056:
2057: end insert_threshold_dtl;
2058: /*------------------------------------------------------------------------------------------------------------*/
2059: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype
2060: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
2061: , p_row_id out nocopy rowid
2062: )
2063: is

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

2056:
2057: end insert_threshold_dtl;
2058: /*------------------------------------------------------------------------------------------------------------*/
2059: procedure insert_threshold_hdr ( p_record in jai_rgm_thresholds%rowtype
2060: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
2061: , p_row_id out nocopy rowid
2062: )
2063: is
2064: begin

Line 2067: select jai_rgm_thresholds_s.nextval

2063: is
2064: begin
2065:
2066: if p_record.threshold_id is null then
2067: select jai_rgm_thresholds_s.nextval
2068: into p_threshold_id
2069: from dual;
2070: end if;
2071:

Line 2072: insert into jai_rgm_thresholds

2068: into p_threshold_id
2069: from dual;
2070: end if;
2071:
2072: insert into jai_rgm_thresholds
2073: ( threshold_id
2074: , regime_id
2075: , org_tan_no
2076: , party_id

Line 2119: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type

2115: end insert_threshold_hdr;
2116:
2117: /*------------------------------------------------------------------------------------------------------------*/
2118: procedure sync_threshold_header
2119: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
2120: , p_source_trx_date in date
2121: , p_thhold_slab_change_flag out nocopy varchar2
2122: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
2123: , p_process_flag out nocopy varchar2

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

2118: procedure sync_threshold_header
2119: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
2120: , p_source_trx_date in date
2121: , p_thhold_slab_change_flag out nocopy varchar2
2122: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
2123: , p_process_flag out nocopy varchar2
2124: , p_process_message out nocopy varchar2
2125: )
2126:

Line 2150: from jai_rgm_thresholds

2146: ,party_type
2147: ,party_id
2148: ,fin_year
2149: ,threshold_slab_id
2150: from jai_rgm_thresholds
2151: where threshold_id = p_threshold_id;
2152:
2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;

Line 2153: ln_regime_id jai_rgm_thresholds.regime_id%type;

2149: ,threshold_slab_id
2150: from jai_rgm_thresholds
2151: where threshold_id = p_threshold_id;
2152:
2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;

Line 2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;

2150: from jai_rgm_thresholds
2151: where threshold_id = p_threshold_id;
2152:
2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:

Line 2155: lv_party_type jai_rgm_thresholds.party_type%type;

2151: where threshold_id = p_threshold_id;
2152:
2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

Line 2156: ln_party_id jai_rgm_thresholds.party_id%type;

2152:
2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

Line 2157: ln_fin_year jai_rgm_thresholds.fin_year%type;

2153: ln_regime_id jai_rgm_thresholds.regime_id%type;
2154: lv_org_tan_no jai_rgm_thresholds.org_tan_no%type;
2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2161:

Line 2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

2155: lv_party_type jai_rgm_thresholds.party_type%type;
2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2161:
2162: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2163: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;

Line 2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;

2156: ln_party_id jai_rgm_thresholds.party_id%type;
2157: ln_fin_year jai_rgm_thresholds.fin_year%type;
2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2161:
2162: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2163: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2164:

Line 2162: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;

2158:
2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2161:
2162: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2163: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2164:
2165: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
2166: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

Line 2163: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;

2159: ln_curr_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2160: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
2161:
2162: ln_total_thhold_amt jai_rgm_thresholds.total_threshold_amt%type;
2163: ln_total_thhold_base_amt jai_rgm_thresholds.total_threshold_base_amt%type;
2164:
2165: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
2166: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
2167:

Line 2196: update jai_rgm_thresholds

2192:
2193: ln_total_thhold_amt := nvl(ln_total_thhold_amt ,0);
2194: ln_total_thhold_base_amt := nvl(ln_total_thhold_base_amt ,0);
2195:
2196: update jai_rgm_thresholds
2197: set total_threshold_amt = ln_total_thhold_amt
2198: ,total_threshold_base_amt = ln_total_thhold_base_amt
2199: ,last_updated_by = ln_user_id
2200: ,last_update_date = sysdate

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

2238:
2239: p_new_thhold_slab_id := ln_new_thhold_slab_id;
2240:
2241: if nvl(ln_new_thhold_slab_id,-9999) <> nvl(ln_curr_thhold_slab_id,-9999) then
2242: /** Slab is changed. Hence update threshold slab in the jai_rgm_thresholds */
2243: update jai_rgm_thresholds
2244: set threshold_slab_id = ln_new_thhold_slab_id
2245: ,last_update_date = sysdate
2246: ,last_updated_by = ln_user_id

Line 2243: update jai_rgm_thresholds

2239: p_new_thhold_slab_id := ln_new_thhold_slab_id;
2240:
2241: if nvl(ln_new_thhold_slab_id,-9999) <> nvl(ln_curr_thhold_slab_id,-9999) then
2242: /** Slab is changed. Hence update threshold slab in the jai_rgm_thresholds */
2243: update jai_rgm_thresholds
2244: set threshold_slab_id = ln_new_thhold_slab_id
2245: ,last_update_date = sysdate
2246: ,last_updated_by = ln_user_id
2247: ,last_update_login = ln_login_id