APPS.AK_REGIONS2_PKG dependencies on AK_REGION_ITEMS

Line 26: from ak_region_items

22: where region_code = p_csr_code
23: and region_application_id = p_csr_id;
24: cursor ri_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
25: select *
26: from ak_region_items
27: where region_code = p_csr_code
28: and region_application_id = p_csr_id;
29: cursor rit_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
30: select *

Line 31: from ak_region_items_tl

27: where region_code = p_csr_code
28: and region_application_id = p_csr_id;
29: cursor rit_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
30: select *
31: from ak_region_items_tl
32: where region_code = p_csr_code
33: and region_application_id = p_csr_id;
34: cursor rlr_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
35: select *

Line 202: insert into AK_REGION_ITEMS (

198: -- Put new code and id into record and insert into appropriate table
199: ri_rec.region_code := p_n_code;
200: ri_rec.region_application_id := p_n_id;
201:
202: insert into AK_REGION_ITEMS (
203: REGION_APPLICATION_ID,
204: REGION_CODE,
205: ATTRIBUTE_APPLICATION_ID,
206: ATTRIBUTE_CODE,

Line 390: insert into AK_REGION_ITEMS_TL (

386: -- Put new code and id into record and insert into appropriate table
387: rit_rec.region_code := p_n_code;
388: rit_rec.region_application_id := p_n_id;
389:
390: insert into AK_REGION_ITEMS_TL (
391: REGION_APPLICATION_ID,
392: REGION_CODE,
393: ATTRIBUTE_APPLICATION_ID,
394: ATTRIBUTE_CODE,