DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_DEFINITIONS

Line 88: , cp_rgm_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --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
92:

Line 96: FROM JAI_RGM_DEFINITIONS jrd,

92:
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;

Line 1419: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

1415: AND jrct.customer_trx_id = jrctl.customer_trx_id;
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 ;

Line 4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,

4001: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4002: END process_unapp_rcpt_rev ;
4003:
4004:
4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,

Line 4039: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

4035: ||Get the primary key
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) ;

Line 4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%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) ;

Line 5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

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 ;
5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;