APPS.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_RGM_TERM_ASSIGNS

Line 588: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,

584: ***************************************************/
585:
586: PROCEDURE get_term_id
587: (
588: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
589: p_item_id IN NUMBER ,
590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,

Line 590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,

586: PROCEDURE get_term_id
587: (
588: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
589: p_item_id IN NUMBER ,
590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
593: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
594: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,

587: (
588: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
589: p_item_id IN NUMBER ,
590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
593: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
594: p_process_flag OUT NOCOPY VARCHAR2 ,
595: p_process_msg OUT NOCOPY VARCHAR2

Line 592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,

588: p_regime_id IN JAI_RGM_TERM_ASSIGNS.REGIME_ID %TYPE ,
589: p_item_id IN NUMBER ,
590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
593: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
594: p_process_flag OUT NOCOPY VARCHAR2 ,
595: p_process_msg OUT NOCOPY VARCHAR2
596: )

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

589: p_item_id IN NUMBER ,
590: p_organization_id IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID %TYPE ,
591: p_party_type IN JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE ,
592: p_location_id IN JAI_RGM_TERM_ASSIGNS.LOCATION_ID %TYPE ,
593: p_term_id OUT NOCOPY JAI_RGM_TERM_ASSIGNS.TERM_ID %TYPE ,
594: p_process_flag OUT NOCOPY VARCHAR2 ,
595: p_process_msg OUT NOCOPY VARCHAR2
596: )
597: IS

Line 633: FROM JAI_RGM_TERM_ASSIGNS

629: p_loc_id NUMBER
630: )
631: IS
632: SELECT term_id
633: FROM JAI_RGM_TERM_ASSIGNS
634: WHERE NVL ( location_id , p_loc_id ) = p_loc_id
635: AND NVL ( organization_type , p_party_type ) = p_party_type
636: AND NVL ( organization_id , p_org_id ) = p_org_id
637: AND NVL ( regime_regno , p_reg_regno ) = p_reg_regno

Line 642: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;

638: AND NVL ( regime_item_class , p_reg_item_class ) = p_reg_item_class
639: AND regime_id = p_reg_id ;
640:
641:
642: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;
643: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;
644: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE %TYPE ;
645: lv_process_flag VARCHAR2(3) ;
646: lv_process_msg VARCHAR2(1000);

Line 643: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;

639: AND regime_id = p_reg_id ;
640:
641:
642: lv_reg_item_class JAI_RGM_TERM_ASSIGNS.REGIME_ITEM_CLASS%TYPE ;
643: lv_regime_regno JAI_RGM_TERM_ASSIGNS.REGIME_REGNO %TYPE ;
644: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE %TYPE ;
645: lv_process_flag VARCHAR2(3) ;
646: lv_process_msg VARCHAR2(1000);
647: