APPS.EGO_CHANGE_USER_ATTRS_PUB SQL Statements

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

Line: 91

    SELECT DISTINCT ORGANIZATION_ID
          ,CHANGE_NUMBER
      FROM ENG_CHG_USR_ATR_INTERFACE
     WHERE DATA_SET_ID = cp_data_set_id
       AND PROCESS_STATUS = G_PS_IN_PROCESS
       AND CHANGE_NUMBER IS NOT NULL
       AND CHANGE_ID IS NULL;

Line: 104

    SELECT DISTINCT ORGANIZATION_CODE
          ,ORGANIZATION_ID
          ,CHANGE_NUMBER
          ,CHANGE_ID
          ,CHANGE_MGMT_TYPE_CODE
          ,CHANGE_TYPE_ID
          ,ROW_IDENTIFIER
          ,CHANGE_LINE_ID
     FROM ENG_CHG_USR_ATR_INTERFACE
    WHERE DATA_SET_ID = cp_data_set_id
      AND PROCESS_STATUS = G_PS_ERROR;

Line: 121

    SELECT TRANSACTION_ID
          ,PROCESS_STATUS
          ,ORGANIZATION_CODE
          ,CHANGE_NUMBER
          ,CHANGE_MGMT_TYPE_CODE
          ,CHANGE_LINE_SEQUENCE_NUMBER
          ,ATTR_GROUP_INT_NAME
          ,ROW_IDENTIFIER
          ,ATTR_INT_NAME
          ,ATTR_VALUE_STR
          ,ATTR_VALUE_NUM
          ,ATTR_VALUE_DATE
          ,ATTR_DISP_VALUE
          ,TRANSACTION_TYPE
          ,ORGANIZATION_ID
          ,CHANGE_ID
          ,CHANGE_TYPE_ID
          ,ATTR_GROUP_ID
          ,CHANGE_LINE_ID
      FROM ENG_CHG_USR_ATR_INTERFACE
     WHERE DATA_SET_ID = cp_data_set_id
       AND CHANGE_LINE_ID is NULL
       AND PROCESS_STATUS = G_PS_IN_PROCESS
    ORDER BY ORGANIZATION_ID, CHANGE_ID,(DECODE (UPPER(TRANSACTION_TYPE),
                                                  'DELETE', 1,
                                                  'UPDATE', 2,
                                                  'SYNC', 3,
                                                  'CREATE', 4, 5)), ROW_IDENTIFIER;

Line: 153

    SELECT TRANSACTION_ID
          ,PROCESS_STATUS
          ,ORGANIZATION_CODE
          ,CHANGE_NUMBER
          ,CHANGE_MGMT_TYPE_CODE
          ,CHANGE_LINE_SEQUENCE_NUMBER
          ,ATTR_GROUP_INT_NAME
          ,ROW_IDENTIFIER
          ,ATTR_INT_NAME
          ,ATTR_VALUE_STR
          ,ATTR_VALUE_NUM
          ,ATTR_VALUE_DATE
          ,ATTR_DISP_VALUE
          ,TRANSACTION_TYPE
          ,ORGANIZATION_ID
          ,CHANGE_ID
          ,CHANGE_TYPE_ID
          ,ATTR_GROUP_ID
          ,CHANGE_LINE_ID
      FROM ENG_CHG_USR_ATR_INTERFACE
     WHERE DATA_SET_ID = cp_data_set_id
       AND CHANGE_LINE_ID is NOT NULL
       AND PROCESS_STATUS = G_PS_IN_PROCESS
    ORDER BY ORGANIZATION_ID, CHANGE_LINE_ID,(DECODE (UPPER(TRANSACTION_TYPE),
                                                  'DELETE', 1,
                                                  'UPDATE', 2,
                                                  'SYNC', 3,
                                                  'CREATE', 4, 5)), ROW_IDENTIFIER;

Line: 183

        SELECT status_type,
               approval_status_type
          FROM eng_engineering_changes
         WHERE change_id = l_change_id;

Line: 189

        SELECT status_code
          FROM eng_change_lines
         WHERE change_line_id = l_change_line_id;

Line: 200

      SELECT 'HZ_PARTY:'||TO_CHAR(PERSON_ID)
        INTO G_HZ_PARTY_ID
        FROM EGO_PEOPLE_V
       WHERE USER_NAME = G_USER_NAME;

Line: 245

    UPDATE ENG_CHG_USR_ATR_INTERFACE
       SET PROCESS_STATUS = G_PS_IN_PROCESS
          ,ORGANIZATION_ID = NULL
          ,CHANGE_TYPE_ID = NULL
          ,CHANGE_ID = NULL
          ,CHANGE_LINE_ID = NULL
          ,REQUEST_ID = G_REQUEST_ID
          ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
          ,PROGRAM_ID = G_PROGAM_ID
          ,PROGRAM_UPDATE_DATE = SYSDATE
          ,CREATED_BY = G_USER_ID
          ,LAST_UPDATED_BY = G_USER_ID
          ,LAST_UPDATE_LOGIN = G_LOGIN_ID
     WHERE DATA_SET_ID = p_data_set_id;

Line: 272

    UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
       SET UAI.ORGANIZATION_ID = (SELECT MP.ORGANIZATION_ID
                                    FROM MTL_PARAMETERS MP
                                   WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
     WHERE UAI.DATA_SET_ID = p_data_set_id
       AND UAI.ORGANIZATION_CODE IS NOT NULL
       AND EXISTS(SELECT MP2.ORGANIZATION_ID
                    FROM MTL_PARAMETERS MP2
                   WHERE MP2.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE);

Line: 295

     UPDATE ENG_CHG_USR_ATR_INTERFACE
     SET PROCESS_STATUS = G_PS_ERROR
     WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
                                FROM ENG_CHG_USR_ATR_INTERFACE
                                WHERE DATA_SET_ID = p_data_set_id
                                AND PROCESS_STATUS = G_PS_IN_PROCESS
                                AND ORGANIZATION_ID IS NULL)
     AND DATA_SET_ID = p_data_set_id;

Line: 314

     UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
       SET UAI.CHANGE_ID =
           (SELECT EEC.CHANGE_ID
              FROM ENG_ENGINEERING_CHANGES EEC
             WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
               AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
               AND EEC.CHANGE_MGMT_TYPE_CODE = UAI.CHANGE_MGMT_TYPE_CODE
               AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
     WHERE UAI.DATA_SET_ID = p_data_set_id
       AND PROCESS_STATUS = G_PS_IN_PROCESS
       AND EXISTS(SELECT EEC.CHANGE_ID
                    FROM ENG_ENGINEERING_CHANGES EEC
                   WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
                     AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
                     AND EEC.CHANGE_MGMT_TYPE_CODE = UAI.CHANGE_MGMT_TYPE_CODE
                     AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);

Line: 332

UPDATE ENG_CHG_USR_ATR_INTERFACE UAI SET
  UAI.CHANGE_LINE_ID=
   (SELECT ELV.CHANGE_LINE_ID
    FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC
    WHERE
      EEC.CHANGE_ID = ELV.CHANGE_ID
      AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
      AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
      AND ELV.SEQUENCE_NUMBER = UAI.CHANGE_LINE_SEQUENCE_NUMBER
    ),
  UAI.CHANGE_ID=
   (SELECT ELV.CHANGE_ID
    FROM ENG_CHANGE_LINES ELV, ENG_ENGINEERING_CHANGES EEC
    WHERE
      EEC.CHANGE_ID = ELV.CHANGE_ID
      AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
      AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
      AND ELV.SEQUENCE_NUMBER = UAI.CHANGE_LINE_SEQUENCE_NUMBER
   )
  WHERE
    UAI.DATA_SET_ID = p_data_set_id
    AND PROCESS_STATUS = G_PS_IN_PROCESS
    AND EXISTS
     (SELECT ELV.CHANGE_LINE_ID
      FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC
      WHERE
        EEC.CHANGE_ID = ELV.CHANGE_ID
        AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
        AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
        AND ELV.SEQUENCE_NUMBER = UAI.CHANGE_LINE_SEQUENCE_NUMBER
     );

Line: 378

     UPDATE ENG_CHG_USR_ATR_INTERFACE
     SET PROCESS_STATUS = G_PS_ERROR
     WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
                                FROM ENG_CHG_USR_ATR_INTERFACE
                                WHERE DATA_SET_ID = p_data_set_id
                                AND PROCESS_STATUS = G_PS_IN_PROCESS
                                AND CHANGE_ID IS NULL
                                AND CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
     AND DATA_SET_ID = p_data_set_id;

Line: 389

     UPDATE ENG_CHG_USR_ATR_INTERFACE
     SET PROCESS_STATUS = G_PS_ERROR
     WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
                                FROM ENG_CHG_USR_ATR_INTERFACE
                                WHERE DATA_SET_ID = p_data_set_id
                                AND PROCESS_STATUS = G_PS_IN_PROCESS
				AND CHANGE_LINE_ID IS NULL
                                AND CHANGE_LINE_SEQUENCE_NUMBER IS NOT NULL)
     AND DATA_SET_ID = p_data_set_id;

Line: 404

    UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
       SET UAI.CHANGE_TYPE_ID =
           (SELECT EEC.CHANGE_ORDER_TYPE_ID
              FROM ENG_ENGINEERING_CHANGES EEC
             WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
               AND EEC.CHANGE_ID = UAI.CHANGE_ID
               AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
     WHERE UAI.DATA_SET_ID = p_data_set_id
       AND PROCESS_STATUS = G_PS_IN_PROCESS
       AND EXISTS(SELECT EEC.CHANGE_ORDER_TYPE_ID
                    FROM ENG_ENGINEERING_CHANGES EEC
                   WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
                     AND EEC.CHANGE_ID = UAI.CHANGE_ID
                     AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);

Line: 420

      UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
       SET UAI.CHANGE_TYPE_ID =
           (SELECT EEC.CHANGE_TYPE_ID
              FROM ENG_CHANGE_LINES_VL EEC
             WHERE
               EEC.CHANGE_LINE_ID = UAI.CHANGE_LINE_ID
               )
     WHERE UAI.DATA_SET_ID = p_data_set_id
       AND PROCESS_STATUS = G_PS_IN_PROCESS
       AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NOT NULL;

Line: 444

     UPDATE ENG_CHG_USR_ATR_INTERFACE
     SET PROCESS_STATUS = G_PS_ERROR
     WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
                                FROM ENG_CHG_USR_ATR_INTERFACE
                                WHERE DATA_SET_ID = p_data_set_id
                                AND PROCESS_STATUS = G_PS_IN_PROCESS
                                AND CHANGE_TYPE_ID IS NULL )
     AND DATA_SET_ID = p_data_set_id;

Line: 609

          UPDATE ENG_CHG_USR_ATR_INTERFACE
             SET PROCESS_STATUS = G_PS_ERROR
           WHERE DATA_SET_ID = p_data_set_id
             AND ORGANIZATION_ID = attr_rec.ORGANIZATION_ID
             AND CHANGE_ID = attr_rec.CHANGE_ID;

Line: 724

          p_attributes_row_table.DELETE;

Line: 725

          p_attributes_data_table.DELETE;

Line: 906

          UPDATE ENG_CHG_USR_ATR_INTERFACE
             SET PROCESS_STATUS = G_PS_ERROR
           WHERE DATA_SET_ID = p_data_set_id
             AND ORGANIZATION_ID = attr_rec.ORGANIZATION_ID
             AND CHANGE_LINE_ID = attr_rec.CHANGE_LINE_ID;

Line: 1033

          p_line_attributes_row_table.DELETE;

Line: 1034

          p_line_attributes_data_table.DELETE;

Line: 1172

      l_dynamic_sql := 'UPDATE ENG_CHG_USR_ATR_INTERFACE'||
                         ' SET PROCESS_STATUS = '|| G_PS_ERROR ||
                       ' WHERE DATA_SET_ID = :1'||
                         ' AND ROW_IDENTIFIER IN ('|| l_failed_row_id_list || ')';

Line: 1186

      DELETE FROM ENG_CHG_USR_ATR_INTERFACE
       WHERE DATA_SET_ID = p_data_set_id
         AND PROCESS_STATUS = G_PS_IN_PROCESS;

Line: 1194

      UPDATE ENG_CHG_USR_ATR_INTERFACE
         SET PROCESS_STATUS = G_PS_SUCCESS
       WHERE DATA_SET_ID = p_data_set_id
         AND PROCESS_STATUS = G_PS_IN_PROCESS;

Line: 1269

    SELECT EGO_IUA_DATA_SET_ID_S.CURRVAL INTO l_curr_data_set_id FROM DUAL;

Line: 1275

      SELECT ENG_CUA_DATA_SET_ID_S.NEXTVAL INTO l_curr_data_set_id FROM DUAL;

Line: 1315

         select EEC.CHANGE_ID,EEC.CHANGE_ORDER_TYPE_ID
         from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
         where EEC.CHANGE_MGMT_TYPE_CODE = p_change_mgmt_type_code
         AND EEC.CHANGE_NOTICE = p_change_number
         AND MP.ORGANIZATION_CODE = p_Organization_Code
         AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID;

Line: 1329

      SELECT 'HZ_PARTY:'||TO_CHAR(PERSON_ID)
        INTO G_HZ_PARTY_ID
        FROM EGO_PEOPLE_V
       WHERE USER_NAME = G_USER_NAME;

Line: 1456

         select EEV.CHANGE_LINE_ID,EEV.CHANGE_TYPE_ID
         from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
         where EEC.CHANGE_ID = EEV.CHANGE_ID
         AND EEC.CHANGE_NOTICE = p_change_number
         AND MP.ORGANIZATION_CODE = p_Organization_Code
         AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID
         AND EEV.SEQUENCE_NUMBER = p_change_line_sequence_number;

Line: 1470

      SELECT 'HZ_PARTY:'||TO_CHAR(PERSON_ID)
        INTO G_HZ_PARTY_ID
        FROM EGO_PEOPLE_V
       WHERE USER_NAME = G_USER_NAME;

Line: 1565

PROCEDURE Check_Delete_Associations
(
    p_api_version                   IN      NUMBER
   ,p_association_id                IN      NUMBER
	 ,p_classification_code           IN      VARCHAR2
	 ,p_data_level                    IN      VARCHAR2
	 ,p_attr_group_id                 IN      NUMBER
	 ,p_application_id                IN      NUMBER
	 ,p_attr_group_type               IN      VARCHAR2
	 ,p_attr_group_name               IN      VARCHAR2
	 ,p_enabled_code                  IN      VARCHAR2
	 ,p_init_msg_list				          IN      VARCHAR2   := fnd_api.g_FALSE
	 ,x_ok_to_delete                  OUT     NOCOPY VARCHAR2
	 ,x_return_status           			OUT     NOCOPY VARCHAR2
	 ,x_errorcode               			OUT     NOCOPY NUMBER
	 ,x_msg_count               			OUT     NOCOPY NUMBER
   ,x_msg_data 			                OUT     NOCOPY VARCHAR2
)
IS

   l_api_version  					CONSTANT NUMBER           := 1.0;

Line: 1587

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

Line: 1604

    SELECT
    	attr_group_disp_name INTO l_attr_display_name
    FROM
    	ego_obj_attr_grp_assocs_v
    WHERE association_id =  p_association_id;

Line: 1611

    SELECT
      COUNT(*) INTO l_count
    FROM
      EGO_PAGE_ENTRIES_V
    WHERE
      ASSOCIATION_ID = p_association_id;

Line: 1620

      x_ok_to_delete := FND_API.G_FALSE;

Line: 1633

		 l_dynamic_sql := ' SELECT COUNT(*) ' ||
		   							  ' FROM ' ||
										  ' AK_CRITERIA cols, ' ||
   									  ' EGO_CRITERIA_TEMPLATES_V criterions ' ||
										  ' WHERE cols.customization_code = criterions.customization_code ' ||
										  ' AND criterions.classification1 = :1 ' ||
										  ' AND   cols.attribute_code LIKE :2'  ;

Line: 1644

		   x_ok_to_delete := FND_API.G_FALSE;

Line: 1653

		   l_dynamic_sql := ' SELECT COUNT(*) ' ||
		   								  ' FROM ' ||
										    ' EGO_RESULTS_FORMAT_COLUMNS_V cols, ' ||
   									    ' EGO_RESULTS_FORMAT_V resultFormat ' ||
										    ' WHERE cols.customization_code = resultFormat.customization_code ' ||
										    ' AND   resultFormat.classification1 = :1' ||
										    ' AND   cols.attribute_code LIKE :2' ;

Line: 1666

		     x_ok_to_delete := FND_API.G_FALSE;

Line: 1683

		  x_ok_to_delete := FND_API.G_TRUE;

Line: 1687

      x_ok_to_delete := FND_API.G_FALSE;

Line: 1696

END Check_Delete_Associations;