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 HR_LOCATIONS

Line 61: p_location_id hr_locations.location_id%Type,

57: */
58: PROCEDURE Gen_Invoice_Number(
59: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
60: p_organization_id hr_all_organization_units.organization_id%Type,
61: p_location_id hr_locations.location_id%Type,
62: p_DATE DATE,
63: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,
64: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,
65: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/

Line 78: p_location_id hr_locations.location_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 ,
79: p_date DATE
80: ) IS
81: SELECT RGM_DOCUMENT_SEQ_ID
82: FROM jai_rgm_doc_seq_hdrs rhdr

Line 102: p_location_id hr_locations.location_id%Type,

98: 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
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