APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_BATCH_RANGES

Line 1871: l_range_id OTA_BATCH_RANGES.range_id%TYPE;

1867: PROCEDURE create_enrollments_multi(p_conc_reqId IN NUMBER) IS
1868:
1869: l_start_person_action_id number DEFAULT 0;
1870: l_end_person_action_id number DEFAULT 0;
1871: l_range_id OTA_BATCH_RANGES.range_id%TYPE;
1872:
1873: CURSOR csr_get_request_members(l_conc_reqID NUMBER) IS
1874: SELECT
1875: reqmembers.MANDATORY_ENR_REQUEST_ID,

Line 1910: FROM OTA_BATCH_RANGES ran

1906: CURSOR c_range_thread IS
1907: SELECT ran.range_id
1908: ,ran.starting_person_action_id
1909: ,ran.ending_person_action_id
1910: FROM OTA_BATCH_RANGES ran
1911: WHERE ran.range_status_cd = 'U'
1912: AND ran.batch_source_cd = 'ME'
1913: AND ran.BATCH_ACTION_ID = p_conc_reqId
1914: AND rownum < 2

Line 1960: UPDATE OTA_BATCH_RANGES ran

1956: END IF;
1957:
1958: CLOSE c_range_thread;
1959:
1960: UPDATE OTA_BATCH_RANGES ran
1961: SET ran.range_status_cd = 'P'
1962: WHERE ran.range_id = l_range_id;
1963:
1964: COMMIT;

Line 3094: l_range_id OTA_BATCH_RANGES.range_id%TYPE;

3090: PROCEDURE create_cert_subscriptions(p_conc_reqId IN NUMBER) IS
3091:
3092: l_start_person_action_id number DEFAULT 0;
3093: l_end_person_action_id number DEFAULT 0;
3094: l_range_id OTA_BATCH_RANGES.range_id%TYPE;
3095:
3096: CURSOR csr_get_request_members(l_conc_reqID NUMBER) IS
3097: SELECT
3098: reqmembers.MANDATORY_ENR_REQUEST_ID,

Line 3122: FROM OTA_BATCH_RANGES ran

3118: CURSOR c_range_thread IS
3119: SELECT ran.range_id
3120: ,ran.starting_person_action_id
3121: ,ran.ending_person_action_id
3122: FROM OTA_BATCH_RANGES ran
3123: WHERE ran.range_status_cd = 'U'
3124: AND ran.batch_source_cd = 'AS'
3125: AND ran.BATCH_ACTION_ID = p_conc_reqId
3126: AND rownum < 2

Line 3160: UPDATE OTA_BATCH_RANGES ran

3156: END IF;
3157:
3158: CLOSE c_range_thread;
3159:
3160: UPDATE OTA_BATCH_RANGES ran
3161: SET ran.range_status_cd = 'P'
3162: WHERE ran.range_id = l_range_id;
3163:
3164: COMMIT;

Line 3336: delete from ota_batch_ranges

3332: if sql%rowcount > 0 then
3333: commit;
3334: end if;
3335:
3336: delete from ota_batch_ranges
3337: where BATCH_ACTION_ID = mand_enr_req_rec(l_conc_req).conc_req_id
3338: and BATCH_SOURCE_CD <> 'EP';
3339:
3340: if sql%rowcount > 0 then