APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_CONC_REQUESTS

Line 456: INSERT INTO jai_rgm_conc_requests(

452: OPEN c_request_date(ln_conc_request_id);
453: FETCH c_request_date INTO ln_conc_request_date;
454: CLOSE c_request_date;
455:
456: INSERT INTO jai_rgm_conc_requests(
457: batch_id,
458: request_id,
459: request_date,
460: regime_id,

Line 473: jai_rgm_conc_requests_s.nextval,

469: program_application_id,
470: program_id,
471: program_login_id
472: ) VALUES (
473: jai_rgm_conc_requests_s.nextval,
474: ln_conc_request_id,
475: ln_conc_request_date,
476: p_regime_id,
477: p_rgm_registration_num,

Line 1542: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;

1538: p_trace_switch IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
1539: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
1540: ) IS
1541:
1542: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;
1543: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;
1544: ld_trx_start_date DATE;
1545:
1546: lv_process_flag VARCHAR2(2);

Line 1543: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;

1539: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
1540: ) IS
1541:
1542: ln_batch_id JAI_RGM_CONC_REQUESTS.batch_id%TYPE;
1543: ln_request_id JAI_RGM_CONC_REQUESTS.request_id%TYPE;
1544: ld_trx_start_date DATE;
1545:
1546: lv_process_flag VARCHAR2(2);
1547: lv_process_message VARCHAR2(1000);

Line 1816: FROM jai_rgm_conc_requests

1812: lv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
1813:
1814: CURSOR c_previous_batch_dtls(cp_regime_id IN NUMBER, cp_registration_num IN VARCHAR2) IS
1815: SELECT trx_till_date+1
1816: FROM jai_rgm_conc_requests
1817: WHERE regime_id = cp_regime_id
1818: AND rgm_registration_num = cp_registration_num;
1819:
1820: /* Bug 4991017. Added by Lakshmi Gopalsami