APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_REGISTRATIONS

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

83: | cp_rgm_code IN varchar2 YES TDS / TCS |
84: | cp_trx_date IN DATE YES transaction date |
85: ---------------------------------------------------------------------------------------------------------------------------------*/
86: FUNCTION get_tcs_fin_year(
87: cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
88: , cp_rgm_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
89: , cp_trx_date DATE
90: ) RETURN VARCHAR2
91: IS

Line 97: JAI_RGM_REGISTRATIONS jrr

93: cursor c_get_tcs_rgm_atrbt
94: is
95: SELECT jrr.ATTRIBUTE_VALUE
96: FROM JAI_RGM_DEFINITIONS jrd,
97: JAI_RGM_REGISTRATIONS jrr
98: WHERE jrd.REGIME_ID = jrr.REGIME_ID
99: AND jrr.ATTRIBUTE_CODE = cp_attr_code
100: AND jrd.REGIME_CODE = cp_rgm_code;
101:

Line 1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

1416:
1417: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
1418: lv_doc_type VARCHAR2(100) ;
1419: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
1422: ln_exists NUMBER(2) ;
1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

Line 4040: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

4036: || for the table jai_rgm_refs_all
4037: *****/
4038: ln_reg_id NUMBER;
4039: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4040: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4041: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4042: lv_process_flag VARCHAR2(2) ;
4043: lv_process_message VARCHAR2(2000) ;
4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

Line 4796: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

4792: ln_apportion_ratio NUMBER ;
4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4796: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4797: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4798: lv_process_flag VARCHAR2(2) ;
4799: lv_process_message VARCHAR2(4000) ;
4800: BEGIN

Line 5250: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

5246: where org_id = cp_org_id;
5247: lv_salesrep_flag VARCHAR2(1);
5248: --bug#8214204,end*/
5249:
5250: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;

Line 5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

5247: lv_salesrep_flag VARCHAR2(1);
5248: --bug#8214204,end*/
5249:
5250: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;

Line 5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

5249:
5250: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
5257: ln_ccid_tax_type_tcs NUMBER ;