APPS.WIP_REPETITIVE_ENTITY dependencies on WIP_REPETITIVE_ITEMS

Line 38: from WIP_REPETITIVE_ITEMS

34:
35:
36: cursor check_entity is
37: select wip_entity_id
38: from WIP_REPETITIVE_ITEMS
39: where organization_id = p_org_id
40: and primary_item_id = p_primary_id;
41:
42: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;

Line 88: from WIP_REPETITIVE_ITEMS

84:
85: temp NUMBER;
86: cursor C is
87: select count(primary_line_flag)
88: from WIP_REPETITIVE_ITEMS
89: where wip_entity_id = nvl(p_entity_id, -1)
90: and organization_id = p_org_id
91: and primary_line_flag = 1
92: and line_id <> p_line_id;

Line 142: FROM WIP_REPETITIVE_ITEMS

138: p_user_id NUMBER,
139: p_login_id NUMBER) is
140: CURSOR C IS
141: SELECT rowid
142: FROM WIP_REPETITIVE_ITEMS
143: WHERE WIP_ENTITY_ID = p_wip_entity_id
144: AND organization_id = p_organization_id
145: AND line_id = p_line_id;
146:

Line 150: INSERT INTO WIP_REPETITIVE_ITEMS (

146:
147:
148: begin
149:
150: INSERT INTO WIP_REPETITIVE_ITEMS (
151: Wip_Entity_id,
152: Line_Id,
153: Organization_Id,
154: Creation_Date,

Line 336: from WIP_REPETITIVE_ITEMS

332:
333: temp NUMBER;
334: cursor check_last_entity is
335: select count(wip_entity_id)
336: from WIP_REPETITIVE_ITEMS
337: where organization_id = p_org_id
338: and wip_entity_id = p_wip_entity_id;
339:
340: begin

Line 341: -- delete from wip_repetitive_items

337: where organization_id = p_org_id
338: and wip_entity_id = p_wip_entity_id;
339:
340: begin
341: -- delete from wip_repetitive_items
342: delete from WIP_REPETITIVE_ITEMS
343: where rowid = p_rowid;
344:
345: if (SQL%NOTFOUND) then

Line 342: delete from WIP_REPETITIVE_ITEMS

338: and wip_entity_id = p_wip_entity_id;
339:
340: begin
341: -- delete from wip_repetitive_items
342: delete from WIP_REPETITIVE_ITEMS
343: where rowid = p_rowid;
344:
345: if (SQL%NOTFOUND) then
346: raise NO_DATA_FOUND;

Line 407: UPDATE WIP_REPETITIVE_ITEMS

403: validate_primary_line(p_wip_entity_id, p_line_id,
404: p_organization_id);
405: end if;
406:
407: UPDATE WIP_REPETITIVE_ITEMS
408: SET
409: organization_id = p_organization_id,
410: last_update_date = SYSDATE,
411: last_updated_by = x_userid,