APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 97: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,

93: lv_process_message VARCHAR2(4000);
94:
95: /*csahoo for bug#5879769...end*/
96:
97: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
98: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
99: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
100: p_error_flag OUT NOCOPY VARCHAR2 ,
101: p_error_message OUT NOCOPY VARCHAR2

Line 99: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

95: /*csahoo for bug#5879769...end*/
96:
97: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
98: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
99: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
100: p_error_flag OUT NOCOPY VARCHAR2 ,
101: p_error_message OUT NOCOPY VARCHAR2
102: )
103: IS

Line 114: JAI_RGM_DEFINITIONS

110: IS
111: SELECT
112: regime_id
113: FROM
114: JAI_RGM_DEFINITIONS
115: WHERE
116: regime_code = p_regime_code;
117: /*
118: ||Get the meaning for a corresponding lookup_type and lookup_code

Line 138: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE

134: || Check whether a tax type exists in the regime registrations table for the
135: || tax types attached to a invoice tax line.
136: */
137: CURSOR c_chk_service_tax ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
138: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE
139: )
140: IS
141: SELECT
142: 1

Line 151: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

147: upper(registration_type) = upper(jai_constants.regn_type_tax_types) AND
148: upper(attribute_code) = upper(cp_tax_type);
149:
150: lv_exists VARCHAR2(2) ;
151: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
152: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
153: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
154:
155: BEGIN

Line 446: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

442: END get_ar_tax_disc_accnt ;
443:
444:
445:
446: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
447: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
448: p_from_date IN DATE ,
449: p_to_date IN DATE ,
450: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 659: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

655: ROLLBACK to before_ref_inv_cm;
656:
657: END populate_inv_cm_references;
658:
659: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
660: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
661: p_from_date IN DATE ,
662: p_to_date IN DATE ,
663: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 1129: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

1125: END delete_non_existant_cm;
1126:
1127:
1128:
1129: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1130: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1131: p_from_date IN DATE ,
1132: p_to_date IN DATE ,
1133: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 1847: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

1843: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
1844: END populate_cm_app;
1845:
1846:
1847: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1848: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1849: p_from_date IN DATE ,
1850: p_to_date IN DATE ,
1851: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 2339: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

2335:
2336:
2337:
2338:
2339: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
2340: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2341: p_from_date IN DATE ,
2342: p_to_date IN DATE ,
2343: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,