APPS.WIP_REPETITIVE_ENTITY dependencies on WIP_ENTITIES

Line 12: from WIP_ENTITIES

8: temp VARCHAR2(1);
9:
10: cursor chck_discrete is
11: select 'x'
12: from WIP_ENTITIES
13: where organization_id = p_org_id
14: and wip_entity_name = p_entity_name
15: and entity_type <> WIP_CONSTANTS.REPETITIVE;
16:

Line 52: -- create new entry in wip_entities

48: open check_entity;
49: fetch check_entity into p_entity_id;
50:
51: if check_entity%NOTFOUND then
52: -- create new entry in wip_entities
53: select wip_entities_s.nextval
54: into p_entity_id
55: from dual;
56:

Line 53: select wip_entities_s.nextval

49: fetch check_entity into p_entity_id;
50:
51: if check_entity%NOTFOUND then
52: -- create new entry in wip_entities
53: select wip_entities_s.nextval
54: into p_entity_id
55: from dual;
56:
57: OPEN C4;

Line 65: insert into wip_entities

61: Raise NO_DATA_FOUND;
62: end if;
63: CLOSE C4;
64:
65: insert into wip_entities
66: (wip_entity_id, organization_id,
67: last_update_date, last_updated_by,
68: creation_date, created_by, last_update_login,
69: wip_entity_name, entity_type, description,

Line 280: -- check if wip_entity exists, if not insert in wip_entities

276:
277: --- check discrete
278: check_discrete(p_organization_id, p_wip_entity_name);
279:
280: -- check if wip_entity exists, if not insert in wip_entities
281: insert_entity(p_wip_entity_id, p_organization_id,
282: p_wip_entity_name, p_description,
283: p_primary_item_id, x_user_id, x_login_id);
284:

Line 349: -- delete from wip_entities if last record

345: if (SQL%NOTFOUND) then
346: raise NO_DATA_FOUND;
347: end if;
348:
349: -- delete from wip_entities if last record
350: open check_last_entity;
351: fetch check_last_entity into temp;
352: close check_last_entity;
353:

Line 355: delete from WIP_ENTITIES

351: fetch check_last_entity into temp;
352: close check_last_entity;
353:
354: if (temp = 0) then
355: delete from WIP_ENTITIES
356: where organization_id = p_org_id
357: and wip_entity_id = p_wip_entity_id;
358: end if;
359: end delete_entity;