APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 76: cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR

72: | cp_rgm_code IN varchar2 YES TDS / TCS |
73: | cp_trx_date IN DATE YES transaction date |
74: ---------------------------------------------------------------------------------------------------------------------------------*/
75: FUNCTION get_tcs_fin_year(
76: cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
77: , cp_rgm_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
78: , cp_trx_date DATE
79: ) RETURN VARCHAR2
80: IS

Line 86: JAI_RGM_REGISTRATIONS jrr

82: cursor c_get_tcs_rgm_atrbt
83: is
84: SELECT jrr.ATTRIBUTE_VALUE
85: FROM JAI_RGM_DEFINITIONS jrd,
86: JAI_RGM_REGISTRATIONS jrr
87: WHERE jrd.REGIME_ID = jrr.REGIME_ID
88: AND jrr.ATTRIBUTE_CODE = cp_attr_code
89: AND jrd.REGIME_CODE = cp_rgm_code;
90:

Line 784: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null

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
788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null

Line 798: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;

794: , p_process_message out nocopy varchar2
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 */

Line 804: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%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
804: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%type
805: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_code%type
806: , cp_organization_id jai_rgm_parties.organization_id%type
807: )
808: is

Line 805: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_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
804: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%type
805: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_code%type
806: , cp_organization_id jai_rgm_parties.organization_id%type
807: )
808: is
809: select