[Home] [Help]
56:
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,
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 ,
79: p_date DATE
80: ) IS
81: SELECT RGM_DOCUMENT_SEQ_ID
97: -- AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
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