DBA Data[Home] [Help]

APPS.AK_REGIONS2_PKG dependencies on AK_REGION_LOV_RELATIONS

Line 36: from ak_region_lov_relations

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 *
36: from ak_region_lov_relations
37: where region_code = p_csr_code
38: and region_application_id = p_csr_id;
39:
40: -- Misc variables to be used

Line 426: insert into AK_REGION_LOV_RELATIONS (

422: -- Put new code and id into record and insert into appropriate table
423: rlr_rec.region_code := p_n_code;
424: rlr_rec.region_application_id := p_n_id;
425:
426: insert into AK_REGION_LOV_RELATIONS (
427: REGION_APPLICATION_ID,
428: REGION_CODE,
429: ATTRIBUTE_APPLICATION_ID,
430: ATTRIBUTE_CODE,