APPS.GMO_DISPENSE_SETUP_PVT SQL Statements

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

Line: 16

  SELECT
    CONCATENATED_SEGMENTS
  FROM
    MTL_SYSTEM_ITEMS_VL
  WHERE
    INVENTORY_ITEM_ID = P_ITEM_ID;

Line: 73

  SELECT
    DESCRIPTION
  FROM
    MTL_SYSTEM_ITEMS_VL
  WHERE
    INVENTORY_ITEM_ID = P_ITEM_ID;

Line: 239

PROCEDURE UPDATE_CONTEXT_PARAMS
(
  P_INSTRUCTION_PROCESS_ID     IN  NUMBER,
  P_ENTITY_NAME                IN  VARCHAR2,
  P_ENTITY_KEY                 IN  VARCHAR2,
  P_ENTITY_DISPLAYNAME         IN  VARCHAR2,
  P_INSTRUCTION_TYPE           IN  FND_TABLE_OF_VARCHAR2_255,
  P_CONTEXT_PARAMETER_NAMES    IN  FND_TABLE_OF_VARCHAR2_255,
  P_CONTEXT_PARAMETER_VALUES   IN  FND_TABLE_OF_VARCHAR2_255
)

IS

L_ENTITY_NAME        FND_TABLE_OF_VARCHAR2_255;

Line: 270

UPDATE_ERROR EXCEPTION;

Line: 310

    P_MODE                   => GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
    P_CONTEXT_PARAMETERS     => L_CONTEXT_PARAMETERS,
    X_INSTRUCTION_PROCESS_ID => L_INSTRUCTION_PROCESS_ID,
    X_RETURN_STATUS          => L_RETURN_STATUS,
    X_MSG_COUNT              => L_MSG_COUNT,
    X_MSG_DATA               => L_MSG_DATA
  );

Line: 320

    RAISE UPDATE_ERROR;

Line: 324

  WHEN UPDATE_ERROR THEN
    FND_MESSAGE.SET_ENCODED(L_MSG_DATA);

Line: 329

                      'edr.plsql.GMO_DISPENSE_SETUP_PVT.UPDATE_CONTEXT_PARAMS',
                      FALSE
                     );

Line: 344

                      'edr.plsql.GMO_DISPENSE_SETUP_PVT.UPDATE_CONTEXT_PARAMS',
                      FALSE
                     );

Line: 351

END UPDATE_CONTEXT_PARAMS;

Line: 456

  SELECT LOOKUP_CODE
  FROM FND_LOOKUPS
  WHERE LOOKUP_TYPE = 'GMO_INSTR_' || P_ENTITY_NAME;

Line: 582

    SELECT * INTO X_DISPENSE_CONFIG
    FROM  GMO_DISPENSE_CONFIG
    WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND   ORGANIZATION_ID = P_ORGANIZATION_ID
    AND   RECIPE_ID = P_RECIPE_ID
    AND   DISPENSE_REQUIRED_FLAG = 'Y'
    AND   SYSDATE BETWEEN START_DATE AND NVL(END_DATE,START_DATE);

Line: 607

    SELECT * INTO X_DISPENSE_CONFIG
    FROM  GMO_DISPENSE_CONFIG
    WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND   ORGANIZATION_ID=P_ORGANIZATION_ID
    AND   DISPENSE_REQUIRED_FLAG = 'Y'
    AND   RECIPE_ID IS NULL
    AND   SYSDATE BETWEEN START_DATE AND NVL(END_DATE,START_DATE);

Line: 631

    SELECT * INTO X_DISPENSE_CONFIG
    FROM  GMO_DISPENSE_CONFIG
    WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND   DISPENSE_REQUIRED_FLAG = 'Y'
    AND   ORGANIZATION_ID IS NULL
    AND   RECIPE_ID IS NULL
    AND   SYSDATE BETWEEN START_DATE AND NVL(END_DATE,START_DATE);

Line: 710

  SELECT PRIMARY_UOM_CODE INTO L_ITEM_UOM
  FROM   MTL_SYSTEM_ITEMS
  WHERE  INVENTORY_ITEM_ID = P_ITEM_ID
  AND    ORGANIZATION_ID = NVL(P_ORGANIZATION_ID, ORGANIZATION_ID)
  AND    ROWNUM =1;

Line: 767

    SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
    INTO   X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
    FROM GMO_DISPENSE_CONFIG
    WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND ORGANIZATION_ID=P_ORGANIZATION_ID
    AND RECIPE_ID=P_RECIPE_ID
    AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line: 788

    SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
    INTO   X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
    FROM GMO_DISPENSE_CONFIG
    WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND ORGANIZATION_ID=P_ORGANIZATION_ID
    AND RECIPE_ID IS NULL
    AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line: 809

    SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
    INTO   X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
    FROM   GMO_DISPENSE_CONFIG
    WHERE  INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
    AND    ORGANIZATION_ID IS NULL
    AND    RECIPE_ID IS NULL
    AND    SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line: 846

  SELECT DISPENSE_CONFIG_ID INTO L_DISPENSE_CONFIG_ID
  FROM   GMO_DISPENSE_CONFIG_INST
  WHERE  ENTITY_NAME = P_ENTITY_NAME
  AND    ENTITY_KEY  = P_ENTITY_KEY;

Line: 852

    SELECT * INTO X_DISPENSE_CONFIG FROM GMO_DISPENSE_CONFIG
    WHERE  CONFIG_ID = L_DISPENSE_CONFIG_ID;

Line: 911

    SELECT COUNT(*) INTO L_COUNT
    FROM   GMO_DISPENSE_CONFIG
    WHERE  CONFIG_ID = P_DISPENSE_CONFIG_ID;

Line: 916

      INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,
                                           DISPENSE_CONFIG_ID,
	   				   ENTITY_NAME,
					   ENTITY_KEY,
                                           CREATION_DATE,
                                           CREATED_BY,
					   LAST_UPDATE_DATE,
					   LAST_UPDATED_BY,
					   LAST_UPDATE_LOGIN)

      VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,
              P_DISPENSE_CONFIG_ID,
	      P_ENTITY_NAME,
	      P_ENTITY_KEY,
	      SYSDATE,
	      FND_GLOBAL.USER_ID(),
	      SYSDATE,
	      FND_GLOBAL.LOGIN_ID(),
	      FND_GLOBAL.LOGIN_ID());

Line: 1028

  SELECT COUNT(*) INTO L_COUNT
  FROM   GMO_DISPENSE_CONFIG
  WHERE  CONFIG_ID = P_DISPENSE_CONFIG_ID;

Line: 1033

    INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,
                                         DISPENSE_CONFIG_ID,
					 ENTITY_NAME,
					 ENTITY_KEY,
                                         CREATION_DATE,
                                         CREATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATED_BY,
					 LAST_UPDATE_LOGIN)

     VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,
             P_DISPENSE_CONFIG_ID,
	     P_ENTITY_NAME,
	     P_ENTITY_KEY,
	     SYSDATE,
	     FND_GLOBAL.USER_ID(),
	     SYSDATE,
	     FND_GLOBAL.LOGIN_ID(),
	     FND_GLOBAL.LOGIN_ID());