DBA Data[Home] [Help]

APPS.FLM_KANBAN_SUMMARY_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(X_rowid                  IN OUT NOCOPY VARCHAR2,
		     X_summary_id	      IN OUT NOCOPY NUMBER,
                     X_organization_id      	     	    NUMBER,
                     X_summary_type                         NUMBER,
                     X_summary_code                         VARCHAR2,
                     X_kanban_plan_id			    NUMBER,
                     X_node_type			    NUMBER,
                     X_source_organization_id               NUMBER,
                     X_supplier_id                          NUMBER,
                     X_supplier_site_id                     NUMBER,
                     X_subinventory_name                    VARCHAR2,
                     X_locator_id                           NUMBER,
                     X_wip_line_id                          NUMBER,
                     X_x		                    NUMBER,
                     X_y                                    NUMBER) IS

   CURSOR C1 IS SELECT rowid FROM FLM_KANBAN_SUMMARY
             WHERE summary_id = X_summary_id;
Line: 22

   CURSOR C2 IS SELECT flm_kanban_summary_s.nextval FROM sys.dual;
Line: 30

   INSERT INTO FLM_KANBAN_SUMMARY(
	   SUMMARY_ID
	  ,ORGANIZATION_ID
	  ,SUMMARY_TYPE
	  ,SUMMARY_CODE
	  ,KANBAN_PLAN_ID
	  ,CREATED_BY
	  ,CREATION_DATE
	  ,LAST_UPDATED_BY
	  ,LAST_UPDATE_DATE
	  ,LAST_UPDATE_LOGIN
	  ,NODE_TYPE
	  ,SOURCE_ORGANIZATION_ID
	  ,SUPPLIER_ID
	  ,SUPPLIER_SITE_ID
	  ,SUBINVENTORY_NAME
	  ,LOCATOR_ID
	  ,WIP_LINE_ID
	  ,X_COORDINATE
	  ,Y_COORDINATE
         ) VALUES (
	   X_SUMMARY_ID
	  ,X_ORGANIZATION_ID
	  ,X_SUMMARY_TYPE
	  ,X_SUMMARY_CODE
	  ,X_KANBAN_PLAN_ID
	  ,FND_GLOBAL.USER_ID
	  ,SYSDATE
	  ,FND_GLOBAL.USER_ID
	  ,SYSDATE
	  ,FND_GLOBAL.LOGIN_ID
	  ,X_NODE_TYPE
	  ,X_SOURCE_ORGANIZATION_ID
	  ,X_SUPPLIER_ID
	  ,X_SUPPLIER_SITE_ID
	  ,X_SUBINVENTORY_NAME
	  ,X_LOCATOR_ID
	  ,X_WIP_LINE_ID
	  ,X_X
	  ,X_Y
	 );
Line: 79

END Insert_Row;
Line: 99

      SELECT *
      FROM FLM_KANBAN_SUMMARY
      WHERE rowid = X_rowid
      FOR UPDATE of summary_id NOWAIT;
Line: 109

    FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
Line: 166

PROCEDURE Update_Row(X_rowid                                VARCHAR2,
		     X_summary_id			    NUMBER,
                     X_organization_id      	     	    NUMBER,
                     X_summary_type                         NUMBER,
                     X_summary_code                         VARCHAR2,
                     X_kanban_plan_id			    NUMBER,
                     X_node_type			    NUMBER,
                     X_source_organization_id               NUMBER,
                     X_supplier_id                          NUMBER,
                     X_supplier_site_id                     NUMBER,
                     X_subinventory_name                    VARCHAR2,
                     X_locator_id                           NUMBER,
                     X_wip_line_id                          NUMBER,
                     X_x		                    NUMBER,
                     X_y                                    NUMBER) IS

BEGIN
  UPDATE FLM_KANBAN_SUMMARY
  SET
    summary_id			=    X_summary_id,
    organization_id		=    X_organization_id,
    summary_type		=    X_summary_type,
    summary_code		=    X_summary_code,
    kanban_plan_id		=    X_kanban_plan_id,
    LAST_UPDATED_BY         	=    FND_GLOBAL.USER_ID,
    LAST_UPDATE_DATE           	=    SYSDATE,
    LAST_UPDATE_LOGIN		=    FND_GLOBAL.LOGIN_ID,
    node_type			=    X_node_type,
    source_organization_id	=    X_source_organization_id,
    supplier_id			=    X_supplier_id,
    supplier_site_id		=    X_supplier_site_id,
    subinventory_name		=    X_subinventory_name,
    locator_id			=    X_locator_id,
    wip_line_id			=    X_wip_line_id,
    x_coordinate		=    X_x,
    y_coordinate		=    X_y
  WHERE rowid = X_rowid;
Line: 208

END Update_Row;
Line: 212

PROCEDURE Delete_Row(X_rowid VARCHAR2) IS

BEGIN
  DELETE FROM FLM_KANBAN_SUMMARY
  WHERE  rowid = X_Rowid;
Line: 221

END Delete_Row;