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 46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;

42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
47:
48: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
49: p_organization_id hr_all_organization_units.organization_id%Type,
50: p_location_id hr_locations.location_id%Type ,

Line 61: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,

57: AND rhdr.party_site_id = p_location_id
58: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
59:
60: CURSOR c_rgm_hdr_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
61: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,
62: p_date DATE
63: ) IS
64: SELECT rgm_document_seq_id
65: FROM jai_rgm_doc_seq_hdrs rhdr

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

69:
70: CURSOR c_rgm_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
71: p_organization_id hr_all_organization_units.organization_id%Type,
72: p_location_id hr_locations.location_id%Type,
73: p_att_type_code jai_rgm_registrations.attribute_type_Code%TYPE , --rchandan for bug#4428980
74: p_att_code jai_rgm_registrations.attribute_Code%TYPE --rchandan for bug#4428980
75: ) IS
76: select attribute_value
77: from JAI_RGM_ORG_REGNS_V

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

70: CURSOR c_rgm_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
71: p_organization_id hr_all_organization_units.organization_id%Type,
72: p_location_id hr_locations.location_id%Type,
73: p_att_type_code jai_rgm_registrations.attribute_type_Code%TYPE , --rchandan for bug#4428980
74: p_att_code jai_rgm_registrations.attribute_Code%TYPE --rchandan for bug#4428980
75: ) IS
76: select attribute_value
77: from JAI_RGM_ORG_REGNS_V
78: where regime_id = p_regime_id