DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_DEFINITIONS

Line 82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,

78: p_process_flag OUT NOCOPY VARCHAR2 ,
79: p_process_message OUT NOCOPY VARCHAR2
80: );
81:
82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,

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

200: WHERE
201: jtyi.legal_entity_id = cp_org_id
202: AND trunc(cp_trx_date) BETWEEN trunc(jtyi.start_date) and trunc(nvl(jtyi.end_date,sysdate)); --Added trunc by JMEENA for bug#9538920
203:
204: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
205: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
206: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE
207: )
208: IS