APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_CONC_REQUESTS

Line 219: INSERT INTO jai_rgm_conc_requests(

215: OPEN c_request_date(ln_conc_request_id);
216: FETCH c_request_date INTO ln_conc_request_date;
217: CLOSE c_request_date;
218:
219: INSERT INTO jai_rgm_conc_requests(
220: batch_id,
221: request_id,
222: request_date,
223: regime_id,

Line 236: jai_rgm_conc_requests_s.nextval,

232: program_application_id,
233: program_id,
234: program_login_id
235: ) VALUES (
236: jai_rgm_conc_requests_s.nextval,
237: ln_conc_request_id,
238: ln_conc_request_date,
239: p_regime_id,
240: p_rgm_registration_num,

Line 659: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;

655: p_trace_switch IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
656: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
657: ) IS
658:
659: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;
660: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;
661: ld_trx_start_date DATE;
662:
663: lv_process_flag VARCHAR2(2);

Line 660: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;

656: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
657: ) IS
658:
659: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;
660: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;
661: ld_trx_start_date DATE;
662:
663: lv_process_flag VARCHAR2(2);
664: lv_process_message VARCHAR2(1000);

Line 839: FROM jai_rgm_conc_requests

835: lv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
836:
837: CURSOR c_previous_batch_dtls(cp_regime_id IN NUMBER, cp_registration_num IN VARCHAR2) IS
838: SELECT trx_till_date+1
839: FROM jai_rgm_conc_requests
840: WHERE regime_id = cp_regime_id
841: AND rgm_registration_num = cp_registration_num;
842:
843: /* Bug 4991017. Added by Lakshmi Gopalsami