APPS.ASO_DEPENDENCY_UTIL dependencies on OE_AK_OBJ_ATTR_EXT

Line 450: FROM oe_ak_obj_attr_ext

446: RETURN NUMBER
447: IS
448: CURSOR get_min_attr_id IS
449: SELECT min(attribute_id)
450: FROM oe_ak_obj_attr_ext
451: WHERE database_object_name = p_database_object_name
452: AND attribute_application_id = G_APPLICATION_ID;
453:
454: l_min_attr_id NUMBER;

Line 508: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b

504: l_dep_attr_tbl Number_Tbl_Type;
505:
506: CURSOR c_trigger_attributes IS
507: SELECT DISTINCT a.trigger_attribute_id,b.attribute_code
508: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
509: WHERE a.trigger_attribute_id = b.attribute_id
510: AND a.database_object_name = p_database_object_name;
511:
512: CURSOR c_dependent_attributes(lc_trigger_attribute_id NUMBER) IS

Line 514: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b

510: AND a.database_object_name = p_database_object_name;
511:
512: CURSOR c_dependent_attributes(lc_trigger_attribute_id NUMBER) IS
513: SELECT a.dependent_attribute_id,b.attribute_code
514: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
515: WHERE a.dependent_attribute_id = b.attribute_id
516: AND a.trigger_attribute_id = lc_trigger_attribute_id
517: AND a.enabled_flag = 'Y';
518: BEGIN

Line 625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

621: l_dependent_code VARCHAR2(30);
622:
623: CURSOR c_trigger_attribute IS
624: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
626: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
627: AND a.attribute_application_id = G_APPLICATION_ID
628: AND a.database_object_name = p_database_object_name
629: AND b.enabled_flag = 'Y'

Line 636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

632: AND a.attribute_application_id = c.attribute_application_id;
633:
634: CURSOR c_all_trigger_attribute IS
635: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
637: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
638: AND a.attribute_application_id = G_APPLICATION_ID
639: AND a.database_object_name = p_database_object_name
640: AND a.database_object_name = c.database_object_name

Line 656: FROM oe_ak_obj_attr_ext

652: AND attribute_application_id = G_APPLICATION_ID;
653:
654: CURSOR c_attribute_code(lc_attribute_id NUMBER) IS
655: SELECT attribute_code
656: FROM oe_ak_obj_attr_ext
657: WHERE attribute_id = lc_attribute_id;
658:
659: CURSOR c_attribute_column_name(lc_attribute_code VARCHAR2) IS
660: SELECT column_name

Line 671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c

667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
672: WHERE a.attribute_application_id = G_APPLICATION_ID
673: AND a.database_object_name = p_database_object_name
674: AND a.database_object_name = b.database_object_name
675: AND a.attribute_application_id = b.attribute_application_id

Line 823: Text(' FROM oe_ak_obj_attr_ext', 1);

819: l_ac_cursor_name := 'c_attribute_code';
820: Text('CURSOR '||l_ac_cursor_name||' (lc_attribute_id NUMBER)', 1);
821: Text('IS', 1);
822: Text(' SELECT attribute_code', 1);
823: Text(' FROM oe_ak_obj_attr_ext', 1);
824: Text(' WHERE attribute_id = lc_attribute_id;', 1);
825: NEW_LINE;
826:
827: l_ck_cursor_name := 'c_ak_'||l_entity_name;

Line 1098: FROM oe_ak_obj_attr_ext

1094: CURSOR c_attribute_id (
1095: lc_attribute_code VARCHAR2
1096: ) IS
1097: SELECT attribute_id
1098: FROM oe_ak_obj_attr_ext
1099: WHERE attribute_code = lc_attribute_code
1100: AND database_object_name = p_database_object_name
1101: AND attribute_application_id = G_APPLICATION_ID;
1102: BEGIN