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_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 314: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

310: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
311:
312: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
313: select to_date(attribute_value, 'DD/MM/YYYY')
314: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
315: where jrr.regime_id = jrd.regime_id
316: AND jrd.regime_code = jai_constants.service_regime
317: and jrr.organization_id = p_organization_id
318: and jrr.location_id = p_location_id

Line 324: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

320: AND jrr.attribute_type_code = 'OTHERS'
321: AND jrr.registration_type = 'OTHERS'
322: AND (NOT EXISTS
323: (select '1'
324: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
325: where jrr.regime_id = jrd.regime_id
326: AND jrd.regime_code = jai_constants.service_regime
327: and jrr.attribute_code IN 'INV_ORG_CLASSIFICATION'
328: and jrr.attribute_value <> 'ORGANIZATION'

Line 334: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

330: and jrr.location_id = p_location_id)
331: OR
332: NOT EXISTS
333: (select '1'
334: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
335: where jrr.regime_id = jrd.regime_id
336: AND jrd.regime_code = jai_constants.service_regime
337: and jrr.attribute_code IN 'SERVICE TYPE'
338: and jrr.attribute_value <> 'OTHER'

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

395: END IF;
396: END is_accrual_basis;
397:
398:
399: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
400: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
401: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
402: p_error_flag OUT NOCOPY VARCHAR2 ,
403: p_error_message OUT NOCOPY VARCHAR2

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

397:
398:
399: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
400: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
401: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
402: p_error_flag OUT NOCOPY VARCHAR2 ,
403: p_error_message OUT NOCOPY VARCHAR2
404: )
405: IS

Line 416: JAI_RGM_DEFINITIONS

412: IS
413: SELECT
414: regime_id
415: FROM
416: JAI_RGM_DEFINITIONS
417: WHERE
418: regime_code = p_regime_code;
419: /*
420: ||Get the meaning for a corresponding lookup_type and lookup_code

Line 440: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE

436: || Check whether a tax type exists in the regime registrations table for the
437: || tax types attached to a invoice tax line.
438: */
439: CURSOR c_chk_service_tax ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
440: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE
441: )
442: IS
443: SELECT
444: 1

Line 453: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

449: upper(registration_type) = upper(jai_constants.regn_type_tax_types) AND
450: upper(attribute_code) = upper(cp_tax_type);
451:
452: lv_exists VARCHAR2(2) ;
453: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
454: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
455: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
456:
457: BEGIN

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

744: END get_ar_tax_disc_accnt ;
745:
746:
747:
748: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
749: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
750: p_from_date IN DATE ,
751: p_to_date IN DATE ,
752: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

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

1179: ROLLBACK to before_ref_inv_cm;
1180:
1181: END populate_inv_cm_references;
1182:
1183: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1184: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1185: p_from_date IN DATE ,
1186: p_to_date IN DATE ,
1187: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

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

1678: END delete_non_existant_cm;
1679:
1680:
1681:
1682: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1683: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1684: p_from_date IN DATE ,
1685: p_to_date IN DATE ,
1686: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

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

2548: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
2549: END populate_cm_app;
2550:
2551:
2552: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
2553: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2554: p_from_date IN DATE ,
2555: p_to_date IN DATE ,
2556: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 3383: PROCEDURE populate_repository (p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

3379: END populate_receipt_records;
3380:
3381: /*Bug 11821537 - Start*/
3382:
3383: PROCEDURE populate_repository (p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
3384: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
3385: p_from_date IN DATE ,
3386: p_to_date IN DATE ,
3387: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

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

4622: ----------------------------------------------------------------------------------------------
4623: --Add by Xiao for POT Phase III changes, reg bug#12895841 on 1-Aug-2011, end
4624:
4625:
4626: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
4627: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
4628: p_from_date IN DATE ,
4629: p_to_date IN DATE ,
4630: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

Line 4649: from JAI_RGM_DEFINITIONS

4645: IS
4646: SELECT to_date(attribute_value, 'DD/MM/YYYY')
4647: FROM jai_rgm_registrations
4648: WHERE regime_id = (select regime_id
4649: from JAI_RGM_DEFINITIONS
4650: where regime_code = jai_constants.service_regime)
4651: AND attribute_code = 'EFF_DATE_ST_PT'
4652: AND attribute_type_code = 'OTHERS'
4653: AND registration_type = 'OTHERS';

Line 5105: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,

5101: AND jrttv.regime_code = jai_constants.service_regime
5102: AND nvl(jtc.INCLUSIVE_TAX_FLAG,'N') = cp_inclusive_tax_flag
5103: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash;
5104:
5105: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
5106: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
5107: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE ,
5108: cp_location_id JAI_RGM_PARTIES.LOCATION_ID%TYPE
5109: )

Line 5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

5183:
5184: lv_member_name VARCHAR2(80);
5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;