APPS.EGO_COMMON_PVT SQL Statements

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

Line: 30

   SELECT STATUS
   INTO l_status
   FROM FND_PRODUCT_INSTALLATIONS
   WHERE APPLICATION_ID = '431';

Line: 77

* This procedure updates the profile value EGO_USER_ORGANIZATION_CONTEXT *
* for the current user. Returns S is successful.                         *
* If any other profile id is passed, this API returns U.                 *
* @param P_PROFILE_OPTION_ID: Profile Id                                 *
* @param P_PROFILE_OPTION_VALUE: Profile Value                           *
* @return X_RETURN_STATUS: Return Status. U- Unsuccessful. S- Success    *
* @return X_MSG_DATA: Message indicating wat went wrong incase of U      *
*------------------------------------------------------------------------*
*/
PROCEDURE SAVE_USR_ORG_CTX_PROF_VAL (
  P_PROFILE_OPTION_ID       IN NUMBER
 ,P_PROFILE_OPTION_VALUE    IN VARCHAR2
 ,P_MODE                    IN VARCHAR2
 ,X_RETURN_STATUS   OUT NOCOPY VARCHAR2
 ,X_MSG_DATA        OUT NOCOPY VARCHAR2
)
IS
  L_PROFILE_OPTION_NAME        VARCHAR2(80);

Line: 101

  SELECT PROFILE_OPTION_NAME INTO L_PROFILE_OPTION_NAME
    FROM FND_PROFILE_OPTIONS
   WHERE PROFILE_OPTION_ID = P_PROFILE_OPTION_ID;

Line: 106

  IF(P_MODE = 'delete') THEN
    X_RETURN_STATUS := 'U';

Line: 108

    FND_MESSAGE.SET_NAME('EGO', 'EGO_PROF_DELETE_NOT_SUP');

Line: 118

    IF(P_MODE = 'update') THEN
      FND_MESSAGE.SET_NAME('EGO', 'EGO_PROF_UPDATE_NOT_SUP');

Line: 123

    IF(P_MODE = 'insert') THEN
      FND_MESSAGE.SET_NAME('EGO', 'EGO_PROF_INSERT_NOT_SUP');

Line: 140

    FND_MESSAGE.SET_NAME('EGO', 'EGO_PROFILE_UPDATE_FAILED');

Line: 150

* associated with an item being deleted. It is called from               *
* BOM_DELETE_GROUPS_API.INVOKE_EVENTS.                                   *
* @param P_INVENTORY_ITEM_ID: Id of the item being deleted.              *
* @param P_ORGANIZATION_ID: Organization Id from which the item is being *
*                           deleted.Profile Value                        *
* @param P_ITEM_NUMBER: Item Number of the item being deleted.           *
*------------------------------------------------------------------------*
*/
  PROCEDURE CANCEL_NIR_FOR_DELETE_ITEM (
     P_INVENTORY_ITEM_ID IN NUMBER
    ,P_ORGANIZATION_ID   IN NUMBER
    ,P_ITEM_NUMBER       IN VARCHAR2
    )
  IS
    l_nir_cancel_status VARCHAR2(10);

Line: 170

      FND_MESSAGE.SET_NAME('EGO', 'EGO_CANCELLED_BY_DELETE');

Line: 196

  END CANCEL_NIR_FOR_DELETE_ITEM;

Line: 212

   SELECT OPTION_VALUE
   INTO RETURN_VALUE
   FROM EGO_DEFAULT_OPTIONS
   WHERE OPTION_CODE = OPTION_CODE_IN;