APPS.WIP_REPETITIVE_ENTITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

select 'x'
from WIP_ENTITIES
where organization_id = p_org_id
and wip_entity_name = p_entity_name
and entity_type <> WIP_CONSTANTS.REPETITIVE;

Line: 27

procedure insert_entity (p_entity_id	IN OUT NOCOPY NUMBER,
			p_org_id		NUMBER,
			p_entity_name		VARCHAR2,
			p_description		VARCHAR2,
			p_primary_id		NUMBER,
			p_user_id		NUMBER,
			p_login_id		NUMBER) is


cursor check_entity is
select wip_entity_id
from WIP_REPETITIVE_ITEMS
where organization_id = p_org_id
and primary_item_id = p_primary_id;

Line: 42

CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;

Line: 53

		select wip_entities_s.nextval
		into p_entity_id
		from dual;

Line: 65

		insert into wip_entities
			(wip_entity_id, organization_id,
			last_update_date, last_updated_by,
			creation_date, created_by, last_update_login,
			wip_entity_name, entity_type, description,
			primary_item_id, gen_object_id)
     		values
			(p_entity_id, p_org_id,
			SYSDATE, p_user_id, SYSDATE, p_user_id, p_login_id,
			substr(p_entity_name, 1, 240),
			WIP_CONSTANTS.REPETITIVE,
			p_description, p_primary_id, X_Gen_Object_Id);

Line: 79

end insert_entity;

Line: 87

select count(primary_line_flag)
from WIP_REPETITIVE_ITEMS
where wip_entity_id = nvl(p_entity_id, -1)
and organization_id = p_org_id
and primary_line_flag = 1
and line_id <> p_line_id;

Line: 106

procedure insert_rep_item(p_rowid			IN OUT NOCOPY VARCHAR2,
                     p_wip_entity_id			NUMBER,
                     p_line_Id				NUMBER,
                     p_organization_id			NUMBER,
                     p_primary_item_id			NUMBER,
                     p_alternate_bom_designator		VARCHAR2,
                     p_alternate_routing_designator	VARCHAR2,
                     p_class_code			VARCHAR2,
                     p_wip_supply_type			NUMBER,
                     p_completion_subinventory		VARCHAR2,
                     p_completion_locator_id		NUMBER,
                     p_load_distribution_priority	NUMBER,
                     p_primary_line_flag		NUMBER,
                     p_production_line_rate		NUMBER,
		     p_overcompletion_toleran_type	NUMBER,
		     p_overcompletion_toleran_value	NUMBER,
                     p_attribute_category		VARCHAR2,
                     p_attribute1			VARCHAR2,
                     p_attribute2			VARCHAR2,
                     p_attribute3			VARCHAR2,
                     p_attribute4			VARCHAR2,
                     p_attribute5			VARCHAR2,
                     p_attribute6			VARCHAR2,
                     p_attribute7			VARCHAR2,
                     p_attribute8			VARCHAR2,
                     p_attribute9			VARCHAR2,
                     p_attribute10			VARCHAR2,
                     p_attribute11			VARCHAR2,
                     p_attribute12			VARCHAR2,
                     p_attribute13			VARCHAR2,
                     p_attribute14			VARCHAR2,
                     p_attribute15			VARCHAR2,
		     p_user_id				NUMBER,
		     p_login_id				NUMBER) is
   CURSOR C IS
     SELECT rowid
     FROM   WIP_REPETITIVE_ITEMS
     WHERE  WIP_ENTITY_ID = p_wip_entity_id
     AND    organization_id = p_organization_id
     AND    line_id = p_line_id;

Line: 150

  INSERT INTO WIP_REPETITIVE_ITEMS (
          Wip_Entity_id,
          Line_Id,
          Organization_Id,
          Creation_Date,
          Created_By,
	  Last_Update_Date,
	  Last_Updated_By,
	  Last_Update_Login,
          Primary_Item_Id,
          Alternate_Bom_Designator,
          Alternate_Routing_Designator,
          Class_Code,
          Wip_Supply_Type,
          Completion_Subinventory,
          Completion_Locator_Id,
          Load_Distribution_Priority,
          Primary_Line_Flag,
          Production_Line_Rate,
	  Overcompletion_Tolerance_Type,
	  Overcompletion_Tolerance_Value,
          Attribute_Category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
	  attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15
         ) VALUES (  p_wip_Entity_Id,
                     p_line_Id,
                     p_organization_Id,
		     SYSDATE,
	 	     p_user_id,
                     SYSDATE,
                     p_user_id,
		     p_login_id,
                     p_primary_item_Id,
                     p_alternate_bom_designator,
                     p_alternate_routing_designator,
                     p_class_code,
                     p_wip_supply_type,
                     p_completion_subinventory,
                     p_completion_locator_id,
                     p_load_distribution_priority,
                     p_primary_line_flag,
                     p_production_line_rate,
		     p_overcompletion_toleran_type,
		     p_overcompletion_toleran_value,
                     p_attribute_category,
                     p_attribute1,
                     p_attribute2,
                     p_attribute3,
                     p_attribute4,
                     p_attribute5,
                     p_attribute6,
                     p_attribute7,
                     p_attribute8,
                     p_attribute9,
                     p_attribute10,
                     p_attribute11,
                     p_attribute12,
                     p_attribute13,
                     p_attribute14,
                     p_attribute15);

Line: 231

end insert_rep_item;

Line: 281

	insert_entity(p_wip_entity_id, p_organization_id,
			p_wip_entity_name, p_description,
			p_primary_item_id, x_user_id, x_login_id);

Line: 292

	insert_rep_item(p_rowid,
                     p_wip_entity_id,
                     p_line_id,
                     p_organization_id,
                     p_primary_item_id,
                     p_alternate_bom_designator,
                     p_alternate_routing_designator,
                     p_class_code,
                     p_wip_supply_type,
                     p_completion_subinventory,
                     p_completion_locator_id,
                     p_load_distribution_priority,
                     p_primary_line_flag,
                     p_production_line_rate,
		     p_overcompletion_toleran_type,
		     p_overcompletion_toleran_value,
                     p_attribute_category,
                     p_attribute1,
                     p_attribute2,
                     p_attribute3,
                     p_attribute4,
                     p_attribute5,
                     p_attribute6,
                     p_attribute7,
                     p_attribute8,
                     p_attribute9,
                     p_attribute10,
                     p_attribute11,
                     p_attribute12,
                     p_attribute13,
                     p_attribute14,
                     p_attribute15,
                     x_user_id,
                     x_login_id);

Line: 329

procedure delete_entity(p_wip_entity_id	IN OUT NOCOPY NUMBER,
		    p_org_id		NUMBER,
		    p_rowid		VARCHAR2) is

temp NUMBER;

Line: 335

select count(wip_entity_id)
from WIP_REPETITIVE_ITEMS
where organization_id = p_org_id
and wip_entity_id = p_wip_entity_id;

Line: 341

	-- delete from wip_repetitive_items
  	delete from WIP_REPETITIVE_ITEMS
  	where  rowid = p_rowid;

Line: 349

	-- delete from wip_entities if last record
	open check_last_entity;

Line: 355

		delete from WIP_ENTITIES
		where organization_id = p_org_id
		and wip_entity_id = p_wip_entity_id;

Line: 359

end delete_entity;

Line: 361

procedure update_entity(p_rowid                          VARCHAR2,
                 	p_wip_entity_id                  NUMBER,
                 	p_line_Id                        NUMBER,
                	p_organization_id                NUMBER,
	                p_primary_item_id                NUMBER,
       		        p_alternate_bom_designator       VARCHAR2,
                 	p_alternate_routing_designator   VARCHAR2,
                 	p_class_code                     VARCHAR2,
                 	p_wip_supply_type                NUMBER,
                 	p_completion_subinventory        VARCHAR2,
                 	p_completion_locator_id          NUMBER,
                 	p_load_distribution_priority     NUMBER,
                 	p_primary_line_flag              NUMBER,
                 	p_production_line_rate           NUMBER,
		 	p_overcompletion_toleran_type	  NUMBER,
		 	p_overcompletion_toleran_value	  NUMBER,
                 	p_attribute_category             VARCHAR2,
                 	p_attribute1                     VARCHAR2,
                 	p_attribute2                     VARCHAR2,
                 	p_attribute3                     VARCHAR2,
                 	p_attribute4                     VARCHAR2,
                 	p_attribute5                     VARCHAR2,
                 	p_attribute6                     VARCHAR2,
                 	p_attribute7                     VARCHAR2,
                 	p_attribute8                     VARCHAR2,
                 	p_attribute9                     VARCHAR2,
                 	p_attribute10                    VARCHAR2,
                 	p_attribute11                    VARCHAR2,
                 	p_attribute12                    VARCHAR2,
                 	p_attribute13                    VARCHAR2,
                 	p_attribute14                    VARCHAR2,
                 	p_attribute15                    VARCHAR2) is

x_userid NUMBER;

Line: 407

  UPDATE WIP_REPETITIVE_ITEMS
  SET
	  organization_id 		=	p_organization_id,
          last_update_date 		=	SYSDATE,
          last_updated_by		=	x_userid,
          last_update_login		=	x_loginid,
          primary_item_id		=	p_primary_item_id,
          alternate_bom_designator	=	p_alternate_bom_designator,
          alternate_routing_designator  =	p_alternate_routing_designator,
          class_code			= 	p_class_code,
          wip_supply_type		=	p_wip_supply_type,
          completion_subinventory	=	p_completion_subinventory,
          completion_locator_id		=	p_completion_locator_id,
          load_distribution_priority	=	p_load_distribution_priority,
          primary_line_flag		=	p_primary_line_flag,
          production_line_rate		=	p_production_line_rate,
	  overcompletion_tolerance_type =	p_overcompletion_toleran_type,
	  overcompletion_tolerance_value=	p_overcompletion_toleran_value,
	  attribute_category		=    	p_attribute_category,
    	  attribute1  			=    	p_attribute1,
    	  attribute2 			=    	p_attribute2,
    	  attribute3 			=    	p_attribute3,
    	  attribute4 			=    	p_attribute4,
    	  attribute5			=    	p_attribute5,
    	  attribute6  			=    	p_attribute6,
    	  attribute7 			=    	p_attribute7,
    	  attribute8 			=    	p_attribute8,
    	  attribute9 			=    	p_attribute9,
    	  attribute10 			=    	p_attribute10,
    	  attribute11			=    	p_attribute11,
    	  attribute12 			=    	p_attribute12,
    	  attribute13			=    	p_attribute13,
    	  attribute14 			=    	p_attribute14,
    	  attribute15			=   	p_attribute15
	WHERE rowid = p_rowid;

Line: 447

end update_entity;