APPS.AK_LOV_RELATIONS_PKG dependencies on AK_REGION_LOV_RELATIONS

Line 6: -- Used for the table AK_REGION_LOV_RELATIONS.

2: /* $Header: AKDRLOVB.pls 120.2 2005/09/29 14:00:03 tshort ship $ */
3:
4: -- This package is created for inserting, locking and deleting
5: -- rows in the LOV-Target Relationship form.
6: -- Used for the table AK_REGION_LOV_RELATIONS.
7:
8: procedure INSERT_ROW (
9: X_ROWID in out NOCOPY VARCHAR2,
10: X_REGION_APPLICATION_ID in NUMBER,

Line 34: cursor C is select ROWID from AK_REGION_LOV_RELATIONS

30:
31: l_base_region_appl_id number;
32: l_base_region_code varchar2(30);
33:
34: cursor C is select ROWID from AK_REGION_LOV_RELATIONS
35: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
36: and REGION_CODE = X_REGION_CODE
37: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
38: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 58: insert into AK_REGION_LOV_RELATIONS (

54: l_BASE_REGION_CODE := X_REGION_CODE;
55: else
56: l_BASE_REGION_CODE := X_BASE_REGION_CODE;
57: end if;
58: insert into AK_REGION_LOV_RELATIONS (
59: REGION_APPLICATION_ID,
60: REGION_CODE,
61: ATTRIBUTE_APPLICATION_ID,
62: ATTRIBUTE_CODE,

Line 125: delete from AK_REGION_LOV_RELATIONS

121: X_BASE_ATTRIBUTE_CODE in VARCHAR2,
122: X_DIRECTION_FLAG in VARCHAR2
123: ) is
124: begin
125: delete from AK_REGION_LOV_RELATIONS
126: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
127: and REGION_CODE = X_REGION_CODE
128: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
129: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 162: from AK_REGION_LOV_RELATIONS

158: X_REQUIRED_FLAG in VARCHAR2
159: ) is
160: cursor c is select
161: REQUIRED_FLAG
162: from AK_REGION_LOV_RELATIONS
163: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
164: and REGION_CODE = X_REGION_CODE
165: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
166: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 233: update ak_region_lov_relations set

229: l_BASE_REGION_CODE := X_REGION_CODE;
230: else
231: l_BASE_REGION_CODE := X_BASE_REGION_CODE;
232: end if;
233: update ak_region_lov_relations set
234: required_flag = X_REQUIRED_FLAG
235: where region_application_id = X_REGION_APPLICATION_ID
236: and region_code = X_REGION_CODE
237: and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID