APPS.JAI_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_DEFINITIONS

Line 31: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

27: made code changes in the cursor c_rgm_dtl to make it work for unregistered RTV
28:
29: */
30: PROCEDURE Gen_Invoice_Number(
31: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
32: p_organization_id hr_all_organization_units.organization_id%Type,
33: p_location_id hr_locations.location_id%Type,
34: p_DATE DATE,
35: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,

Line 48: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%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 ,
51: p_date DATE
52: ) IS

Line 60: CURSOR c_rgm_hdr_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

56: AND rhdr.party_id = p_organization_id
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

Line 70: CURSOR c_rgm_regnum(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

66: WHERE rhdr.regime_id = p_regime_id
67: AND rhdr.registration_num = ln_regnum
68: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
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