APPS.JAI_CMN_RGM_SETUP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

		 SELECT RGM_DOCUMENT_SEQ_ID
		         FROM jai_rgm_doc_seq_hdrs rhdr
		         WHERE rhdr.regime_id            = p_regime_id
		         AND   rhdr.party_id             = p_organization_id
		         AND   rhdr.party_site_id        = p_location_id
		         AND   TRUNC(p_date)  between TRUNC(rhdr.effective_from) and
		 NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line: 81

        SELECT RGM_DOCUMENT_SEQ_ID
        FROM jai_rgm_doc_seq_hdrs rhdr
        WHERE rhdr.regime_id            = p_regime_id
        AND   rhdr.party_id             = p_organization_id
        AND   rhdr.party_site_id        = p_location_id
       -- AND   TRUNC(p_date)  between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line: 93

        SELECT rgm_document_seq_id
        FROM jai_rgm_doc_seq_hdrs rhdr
        WHERE rhdr.regime_id            = p_regime_id
        AND   rhdr.registration_num     = ln_regnum
     --   AND   TRUNC(p_date)  between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line: 106

                select attribute_value
                from   JAI_RGM_ORG_REGNS_V
                where  regime_id = p_regime_id
                and    organization_id = p_organization_id
                and    location_id = p_location_id
                and    attribute_type_Code =  p_att_type_code
                and    attribute_code = p_att_code  ;

Line: 119

        SELECT rgm_document_seq_dtl_id
        FROM jai_rgm_doc_seq_dtls   rdtl
        WHERE rdtl.rgm_document_seq_id          = ln_seq_id
        AND   rdtl.document_class               = p_doc_class
        AND   rdtl.document_class_type_id       =   decode(p_doc_class, 'R', -8888,	  'UR', -8888, --csahoo bug 5233925
                                      p_doc_type_id) ;

Line: 128

        SELECT rgm_document_seq_dtl_id
        FROM jai_rgm_doc_seq_dtls
        WHERE rgm_document_seq_id = ln_seq_id
        AND    document_class      = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);

Line: 136

        SELECT prefix,current_number,end_number
        FROM jai_rgm_doc_seq_dtls
        WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id
	FOR UPDATE of current_number ;   /* Added 'FOR UPDATE OF current_number' by ssawant for bug#5603661 */

Line: 143

       SELECT regime_code
       FROM jai_rgm_definitions
       WHERE regime_id = ln_regime_id;

Line: 182

                        UPDATE jai_rgm_doc_seq_dtls
                        SET  current_number = ln_current
                        WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 218

                                UPDATE jai_rgm_doc_seq_dtls
                                SET  current_number = ln_current
                                WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 286

                              UPDATE jai_rgm_doc_seq_dtls
                              SET  current_number = ln_current
                              WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 320

                              UPDATE jai_rgm_doc_seq_dtls
                              SET  current_number = ln_current
                              WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;