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_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;

70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
75:
76: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
77: p_organization_id hr_all_organization_units.organization_id%Type,
78: p_location_id hr_locations.location_id%Type ,

Line 90: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,

86: -- AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
87: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,TRUNC(p_date)) ; --changed the sysdate default value to TRUNC(p_date) for bug#8667957
88:
89: CURSOR c_rgm_hdr_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
90: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,
91: p_date DATE
92: ) IS
93: SELECT rgm_document_seq_id
94: FROM jai_rgm_doc_seq_hdrs rhdr

Line 103: p_att_type_code jai_rgm_registrations.attribute_type_Code%TYPE , --rchandan for bug#4428980

99:
100: CURSOR c_rgm_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
101: p_organization_id hr_all_organization_units.organization_id%Type,
102: p_location_id hr_locations.location_id%Type,
103: p_att_type_code jai_rgm_registrations.attribute_type_Code%TYPE , --rchandan for bug#4428980
104: p_att_code jai_rgm_registrations.attribute_Code%TYPE --rchandan for bug#4428980
105: ) IS
106: select attribute_value
107: from JAI_RGM_ORG_REGNS_V

Line 104: p_att_code jai_rgm_registrations.attribute_Code%TYPE --rchandan for bug#4428980

100: CURSOR c_rgm_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
101: p_organization_id hr_all_organization_units.organization_id%Type,
102: p_location_id hr_locations.location_id%Type,
103: p_att_type_code jai_rgm_registrations.attribute_type_Code%TYPE , --rchandan for bug#4428980
104: p_att_code jai_rgm_registrations.attribute_Code%TYPE --rchandan for bug#4428980
105: ) IS
106: select attribute_value
107: from JAI_RGM_ORG_REGNS_V
108: where regime_id = p_regime_id