APPS.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_RGM_TERM_ASSIGNS

Line 365: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,

361: ***************************************************/
362:
363: PROCEDURE get_term_id
364: (
365: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
366: p_item_id IN NUMBER ,
367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,

Line 367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,

363: PROCEDURE get_term_id
364: (
365: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
366: p_item_id IN NUMBER ,
367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
370: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
371: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,

364: (
365: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
366: p_item_id IN NUMBER ,
367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
370: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
371: p_process_flag OUT NOCOPY VARCHAR2 ,
372: p_process_msg OUT NOCOPY VARCHAR2

Line 369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,

365: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
366: p_item_id IN NUMBER ,
367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
370: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
371: p_process_flag OUT NOCOPY VARCHAR2 ,
372: p_process_msg OUT NOCOPY VARCHAR2
373: )

Line 370: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,

366: p_item_id IN NUMBER ,
367: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
368: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
369: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
370: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
371: p_process_flag OUT NOCOPY VARCHAR2 ,
372: p_process_msg OUT NOCOPY VARCHAR2
373: )
374: IS

Line 410: FROM JAI_RGM_TERM_ASSIGNS

406: p_loc_id NUMBER
407: )
408: IS
409: SELECT term_id
410: FROM JAI_RGM_TERM_ASSIGNS
411: WHERE NVL ( location_id , p_loc_id ) = p_loc_id
412: AND NVL ( organization_type , p_party_type ) = p_party_type
413: AND NVL ( organization_id , p_org_id ) = p_org_id
414: AND NVL ( regime_regno , p_reg_regno ) = p_reg_regno

Line 419: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;

415: AND NVL ( regime_item_class , p_reg_item_class ) = p_reg_item_class
416: AND regime_id = p_reg_id ;
417:
418:
419: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;
420: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;
421: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE %TYPE ;
422: lv_process_flag VARCHAR2(3) ;
423: lv_process_msg VARCHAR2(1000);

Line 420: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;

416: AND regime_id = p_reg_id ;
417:
418:
419: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;
420: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;
421: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE %TYPE ;
422: lv_process_flag VARCHAR2(3) ;
423: lv_process_msg VARCHAR2(1000);
424: