APPS.JAI_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_DEFINITIONS

Line 59: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

55:
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 ,

Line 76: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%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 ,
79: p_date DATE
80: ) IS

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

85: AND rhdr.party_site_id = p_location_id
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

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

96: AND rhdr.registration_num = ln_regnum
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

Line 141: CURSOR c_get_regime_code(ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE)

137: FROM jai_rgm_doc_seq_dtls
138: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id
139: FOR UPDATE of current_number ; /* Added 'FOR UPDATE OF current_number' by ssawant for bug#5603661 */
140:
141: CURSOR c_get_regime_code(ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE)
142: IS
143: SELECT regime_code
144: FROM jai_rgm_definitions
145: WHERE regime_id = ln_regime_id;

Line 144: FROM jai_rgm_definitions

140:
141: CURSOR c_get_regime_code(ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE)
142: IS
143: SELECT regime_code
144: FROM jai_rgm_definitions
145: WHERE regime_id = ln_regime_id;
146: lv_regime_code jai_rgm_definitions.REGIMe_code%TYPE;
147:
148: BEGIN

Line 146: lv_regime_code jai_rgm_definitions.REGIMe_code%TYPE;

142: IS
143: SELECT regime_code
144: FROM jai_rgm_definitions
145: WHERE regime_id = ln_regime_id;
146: lv_regime_code jai_rgm_definitions.REGIMe_code%TYPE;
147:
148: BEGIN
149: OPEN c_rgm_hdr(p_regime_id, p_organization_id, p_location_id, p_date) ;
150: FETCH c_rgm_hdr into ln_seq_id ;