APPS.AMW_ORG_CERT_AGGR_PKG dependencies on AMW_FULL_ENTITY_HIER

Line 22: FROM amw_full_entity_hier

18: l_parent_id NUMBER;
19:
20: CURSOR row_exists_check(c_parent_id NUMBER) IS
21: SELECT 1
22: FROM amw_full_entity_hier
23: WHERE entity_type = 'BUSIPROC_CERTIFICATION'
24: AND entity_id = p_certification_id
25: AND object_type = 'SUBSIDIARY'
26: AND object_id = p_child_id

Line 54: INSERT INTO amw_full_entity_hier

50:
51: IF row_exists_check%NOTFOUND THEN
52: CLOSE row_exists_check;
53:
54: INSERT INTO amw_full_entity_hier
55: (entity_hierarchy_id, entity_type, entity_id, object_type, object_id,
56: parent_object_type, parent_object_id, level_id, creation_date,
57: created_by, last_update_date, last_updated_by, last_update_login,
58: object_version_number, delete_flag)

Line 59: VALUES(amw_full_entity_hier_s.nextval, 'BUSIPROC_CERTIFICATION',

55: (entity_hierarchy_id, entity_type, entity_id, object_type, object_id,
56: parent_object_type, parent_object_id, level_id, creation_date,
57: created_by, last_update_date, last_updated_by, last_update_login,
58: object_version_number, delete_flag)
59: VALUES(amw_full_entity_hier_s.nextval, 'BUSIPROC_CERTIFICATION',
60: p_certification_id, 'SUBSIDIARY', p_child_id, 'SUBSIDIARY',
61: l_parent_id, 1, sysdate, fnd_global.user_id, sysdate,
62: fnd_global.user_id, fnd_global.login_id, 1, 'N');
63:

Line 326: DELETE FROM amw_full_entity_hier

322:
323: fnd_file.put_line(fnd_file.LOG, 'Certification_Id:'||p_certification_id);
324:
325: -- First clear out the hierarchy
326: DELETE FROM amw_full_entity_hier
327: WHERE entity_id = p_certification_id;
328:
329: -- Loop through the flex values and create the hierarchy
330: FOR sub_info IN get_all_subs LOOP