APPS.GMO_INSTRUCTION_GRP SQL Statements

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

Line: 17

    P_MODE                  IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
    P_CONTEXT_PARAMETERS    IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
    X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER

) IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 114

    P_MODE                  IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
    P_CONTEXT_PARAMETERS    IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
    X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER
)
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 225

PROCEDURE DELETE_ENTITY_FOR_PROCESS
(
       P_API_VERSION           IN NUMBER,
       P_INIT_MSG_LIST         IN VARCHAR2 DEFAULT FND_API.G_FALSE,
       P_VALIDATION_LEVEL      IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
       X_RETURN_STATUS         OUT NOCOPY VARCHAR2,
       X_MSG_COUNT             OUT NOCOPY NUMBER,
       X_MSG_DATA              OUT NOCOPY VARCHAR2,

       P_CURR_INSTR_PROCESS_ID   IN NUMBER,
       P_ENTITY_NAME             IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
       P_ENTITY_KEY              IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
       X_INSTRUCTION_PROCESS_ID  OUT NOCOPY NUMBER

)IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 240

    l_api_name      CONSTANT VARCHAR2(30)   := 'DELETE_ENTITY_FOR_PROCESS';

Line: 260

        GMO_INSTRUCTION_PVT.DELETE_ENTITY_FOR_PROCESS
        (
            P_CURR_INSTR_PROCESS_ID => P_CURR_INSTR_PROCESS_ID,
            P_ENTITY_NAME => P_ENTITY_NAME,
            P_ENTITY_KEY => P_ENTITY_KEY,
            X_INSTRUCTION_PROCESS_ID => X_INSTRUCTION_PROCESS_ID,
            X_RETURN_STATUS => X_RETURN_STATUS,
            X_MSG_COUNT => X_MSG_COUNT,
            X_MSG_DATA => X_MSG_DATA
        );

Line: 289

                        FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_instruction_grp.delete_entity_for_process', FALSE);

Line: 298

                        FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instruction_grp.delete_entity_for_process', FALSE);

Line: 311

                        FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instruction_grp.delete_entity_for_process', FALSE);

Line: 313

END DELETE_ENTITY_FOR_PROCESS;

Line: 330

    P_MODE                  IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
    P_CONTEXT_PARAMETERS    IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
    X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER

) IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 857

   SELECT ATTRIBUTE_VALUE INTO X_DEFINITION_STATUS
   FROM GMO_INSTR_ATTRIBUTES_T
   WHERE ATTRIBUTE_NAME  = 'DEFINITION_STATUS'
   AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;