eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_HEADERS_VL_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_LIST_HEADER_ID in NUMBER,
  X_PURPOSE_CODE in VARCHAR2,
  X_NO_OF_ROWS_FATIGUED in NUMBER,
  X_NO_OF_ROWS_SUPPRESSED in NUMBER,
  X_QUERY_TEMPLATE_ID in NUMBER,
  X_MIGRATION_DATE in DATE,
  X_TCA_FAILED_RECORDS in NUMBER,
  X_USER_STATUS_ID in NUMBER,
  X_QUANTUM in NUMBER,
  X_RELEASE_CONTROL_ALG_ID in NUMBER,
  X_DIALING_METHOD in VARCHAR2,
  X_CALLING_CALENDAR_ID in NUMBER,
  X_RELEASE_STRATEGY in VARCHAR2,
  X_CUSTOM_SETUP_ID in NUMBER,
  X_COUNTRY in NUMBER,
  X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
  X_CALL_CENTER_READY_FLAG in VARCHAR2,
  X_PURGE_FLAG in VARCHAR2,
  X_QUOTA in NUMBER,
  X_QUOTA_RESET in NUMBER,
  X_RECYCLING_ALG_ID in NUMBER,
  X_PUBLIC_FLAG in VARCHAR2,
  X_LIST_CATEGORY in VARCHAR2,
  X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
  X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
  X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
  X_NO_OF_ROWS_RANDOM in NUMBER,
  X_MAIN_GEN_START_TIME in DATE,
  X_MAIN_GEN_END_TIME in DATE,
  X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
  X_RESULT_TEXT in VARCHAR2,
  X_KEYWORDS in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LIST_PRIORITY in NUMBER,
  X_ASSIGN_PERSON_ID in NUMBER,
  X_LIST_SOURCE in VARCHAR2,
  X_LIST_SOURCE_TYPE in VARCHAR2,
  X_LIST_ONLINE_FLAG in VARCHAR2,
  X_RANDOM_LIST_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_ASSIGNED_TO in NUMBER,
  X_QUERY_ID in NUMBER,
  X_OWNER_PERSON_ID in NUMBER,
  X_ARCHIVED_BY in NUMBER,
  X_ARCHIVED_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_TIMEZONE_ID in NUMBER,
  X_USER_ENTERED_START_TIME in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LIST_USED_BY_ID in NUMBER,
  X_ARC_LIST_USED_BY in VARCHAR2,
  X_LIST_TYPE in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_STATUS_DATE in DATE,
  X_GENERATION_TYPE in VARCHAR2,
  X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
  X_ROW_SELECTION_TYPE in VARCHAR2,
  X_OWNER_USER_ID in NUMBER,
  X_ACCESS_LEVEL in VARCHAR2,
  X_ENABLE_LOG_FLAG in VARCHAR2,
  X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
  X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
  X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
  X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
  X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
  X_FORECASTED_START_DATE in DATE,
  X_FORECASTED_END_DATE in DATE,
  X_ACTUAL_END_DATE in DATE,
  X_SENT_OUT_DATE in DATE,
  X_DEDUPE_START_DATE in DATE,
  X_LAST_DEDUPE_DATE in DATE,
  X_LAST_DEDUPED_BY_USER_ID in NUMBER,
  X_WORKFLOW_ITEM_KEY in NUMBER,
  X_NO_OF_ROWS_DUPLICATES in NUMBER,
  X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
  X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
  X_NO_OF_ROWS_IN_LIST in NUMBER,
  X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
  X_NO_OF_ROWS_ACTIVE in NUMBER,
  X_NO_OF_ROWS_INACTIVE in NUMBER,
  X_APPLY_TRAFFIC_COP in VARCHAR2,
  X_LIST_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_ID NUMBER,
  X_PROGRAM_APPLICATION_ID NUMBER,
  X_PROGRAM_UPDATE_DATE date,
  X_ORG_ID NUMBER,
  X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
  X_PARENT_LIST_HEADER_ID NUMBER,
  X_SPLIT_TYPE VARCHAR,
  X_SPLIT_VALUE NUMBER,
   X_CTRL_CONF_LEVEL NUMBER,
        X_CTRL_REQ_RESP_RATE NUMBER,
        X_CTRL_LIMIT_OF_ERROR NUMBER,
        X_STATUS_CODE_OLD VARCHAR2,
        X_CTRL_CONC_JOB_ID NUMBER,
        X_CTRL_STATUS_CODE VARCHAR2,
        X_CTRL_GEN_MODE VARCHAR2,
	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206


) is
  cursor C is select ROWID from AMS_LIST_HEADERS_ALL
    where LIST_HEADER_ID = X_LIST_HEADER_ID
    ;

Line: 136


  insert into AMS_LIST_HEADERS_ALL (
    PURPOSE_CODE,
    NO_OF_ROWS_FATIGUED,
    NO_OF_ROWS_SUPPRESSED,
    QUERY_TEMPLATE_ID,
    MIGRATION_DATE,
    TCA_FAILED_RECORDS,
    USER_STATUS_ID,
    QUANTUM,
    RELEASE_CONTROL_ALG_ID,
    DIALING_METHOD,
    CALLING_CALENDAR_ID,
    RELEASE_STRATEGY,
    CUSTOM_SETUP_ID,
    COUNTRY,
    CALLBACK_PRIORITY_FLAG,
    CALL_CENTER_READY_FLAG,
    PURGE_FLAG,
    QUOTA,
    QUOTA_RESET,
    RECYCLING_ALG_ID,
    PUBLIC_FLAG,
    LIST_CATEGORY,
    NO_OF_ROWS_MANUALLY_ENTERED,
    NO_OF_ROWS_DO_NOT_CALL,
    NO_OF_ROWS_DO_NOT_MAIL,
    NO_OF_ROWS_RANDOM,
    MAIN_GEN_START_TIME,
    MAIN_GEN_END_TIME,
    MAIN_RANDOM_NTH_ROW_SELECTION,
    MAIN_RANDOM_PCT_ROW_SELECTION,
    CTRL_RANDOM_NTH_ROW_SELECTION,
    CTRL_RANDOM_PCT_ROW_SELECTION,
    REPEAT_SOURCE_LIST_HEADER_ID,
    RESULT_TEXT,
    KEYWORDS,
    DESCRIPTION,
    LIST_PRIORITY,
    ASSIGN_PERSON_ID,
    LIST_SOURCE,
    LIST_SOURCE_TYPE,
    LIST_ONLINE_FLAG,
    RANDOM_LIST_ID,
    ENABLED_FLAG,
    ASSIGNED_TO,
    QUERY_ID,
    OWNER_PERSON_ID,
    ARCHIVED_BY,
    ARCHIVED_DATE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    TIMEZONE_ID,
    USER_ENTERED_START_TIME,
    LIST_HEADER_ID,
    OBJECT_VERSION_NUMBER,
    REQUEST_ID,
    VIEW_APPLICATION_ID,
    LIST_USED_BY_ID,
    ARC_LIST_USED_BY,
    LIST_TYPE,
    STATUS_CODE,
    STATUS_DATE,
    GENERATION_TYPE,
    REPEAT_EXCLUDE_TYPE,
    ROW_SELECTION_TYPE,
    OWNER_USER_ID,
    ACCESS_LEVEL,
    ENABLE_LOG_FLAG,
    ENABLE_WORD_REPLACEMENT_FLAG,
    ENABLE_PARALLEL_DML_FLAG,
    DEDUPE_DURING_GENERATION_FLAG,
    GENERATE_CONTROL_GROUP_FLAG,
    LAST_GENERATION_SUCCESS_FLAG,
    FORECASTED_START_DATE,
    FORECASTED_END_DATE,
    ACTUAL_END_DATE,
    SENT_OUT_DATE,
    DEDUPE_START_DATE,
    LAST_DEDUPE_DATE,
    LAST_DEDUPED_BY_USER_ID,
    WORKFLOW_ITEM_KEY,
    NO_OF_ROWS_DUPLICATES,
    NO_OF_ROWS_MIN_REQUESTED,
    NO_OF_ROWS_MAX_REQUESTED,
    NO_OF_ROWS_IN_LIST,
    NO_OF_ROWS_IN_CTRL_GROUP,
    NO_OF_ROWS_ACTIVE,
    NO_OF_ROWS_INACTIVE,
    APPLY_TRAFFIC_COP,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PROGRAM_ID ,
    PROGRAM_APPLICATION_ID ,
    PROGRAM_UPDATE_DATE,
    ORG_ID,
    NO_OF_ROWS_PREV_CONTACTED,
    PARENT_LIST_HEADER_ID,
    SPLIT_TYPE,
    SPLIT_VALUE,
         CTRL_CONF_LEVEL,
        CTRL_REQ_RESP_RATE,
        CTRL_LIMIT_OF_ERROR,
        STATUS_CODE_OLD,
        CTRL_CONC_JOB_ID,
        CTRL_STATUS_CODE,
        CTRL_GEN_MODE,
	APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206

  ) values (
    X_PURPOSE_CODE,
    X_NO_OF_ROWS_FATIGUED,
    X_NO_OF_ROWS_SUPPRESSED,
    X_QUERY_TEMPLATE_ID,
    X_MIGRATION_DATE,
    X_TCA_FAILED_RECORDS,
    X_USER_STATUS_ID,
    X_QUANTUM,
    X_RELEASE_CONTROL_ALG_ID,
    X_DIALING_METHOD,
    X_CALLING_CALENDAR_ID,
    X_RELEASE_STRATEGY,
    X_CUSTOM_SETUP_ID,
    X_COUNTRY,
    X_CALLBACK_PRIORITY_FLAG,
    X_CALL_CENTER_READY_FLAG,
    X_PURGE_FLAG,
    X_QUOTA,
    X_QUOTA_RESET,
    X_RECYCLING_ALG_ID,
    X_PUBLIC_FLAG,
    X_LIST_CATEGORY,
    X_NO_OF_ROWS_MANUALLY_ENTERED,
    X_NO_OF_ROWS_DO_NOT_CALL,
    X_NO_OF_ROWS_DO_NOT_MAIL,
    X_NO_OF_ROWS_RANDOM,
    X_MAIN_GEN_START_TIME,
    X_MAIN_GEN_END_TIME,
    X_MAIN_RANDOM_NTH_ROW_SELECTIO,
    X_MAIN_RANDOM_PCT_ROW_SELECTIO,
    X_CTRL_RANDOM_NTH_ROW_SELECTIO,
    X_CTRL_RANDOM_PCT_ROW_SELECTIO,
    X_REPEAT_SOURCE_LIST_HEADER_ID,
    X_RESULT_TEXT,
    X_KEYWORDS,
    X_DESCRIPTION,
    X_LIST_PRIORITY,
    X_ASSIGN_PERSON_ID,
    X_LIST_SOURCE,
    X_LIST_SOURCE_TYPE,
    X_LIST_ONLINE_FLAG,
    X_RANDOM_LIST_ID,
    X_ENABLED_FLAG,
    X_ASSIGNED_TO,
    X_QUERY_ID,
    X_OWNER_PERSON_ID,
    X_ARCHIVED_BY,
    X_ARCHIVED_DATE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_TIMEZONE_ID,
    X_USER_ENTERED_START_TIME,
    X_LIST_HEADER_ID,
    X_OBJECT_VERSION_NUMBER,
    X_REQUEST_ID,
    X_VIEW_APPLICATION_ID,
    X_LIST_USED_BY_ID,
    X_ARC_LIST_USED_BY,
    X_LIST_TYPE,
    X_STATUS_CODE,
    X_STATUS_DATE,
    X_GENERATION_TYPE,
    X_REPEAT_EXCLUDE_TYPE,
    X_ROW_SELECTION_TYPE,
    X_OWNER_USER_ID,
    X_ACCESS_LEVEL,
    X_ENABLE_LOG_FLAG,
    X_ENABLE_WORD_REPLACEMENT_FLAG,
    X_ENABLE_PARALLEL_DML_FLAG,
    X_DEDUPE_DURING_GENERATION_FLA,
    X_GENERATE_CONTROL_GROUP_FLAG,
    X_LAST_GENERATION_SUCCESS_FLAG,
    X_FORECASTED_START_DATE,
    X_FORECASTED_END_DATE,
    X_ACTUAL_END_DATE,
    X_SENT_OUT_DATE,
    X_DEDUPE_START_DATE,
    X_LAST_DEDUPE_DATE,
    X_LAST_DEDUPED_BY_USER_ID,
    X_WORKFLOW_ITEM_KEY,
    X_NO_OF_ROWS_DUPLICATES,
    X_NO_OF_ROWS_MIN_REQUESTED,
    X_NO_OF_ROWS_MAX_REQUESTED,
    X_NO_OF_ROWS_IN_LIST,
    X_NO_OF_ROWS_IN_CTRL_GROUP,
    X_NO_OF_ROWS_ACTIVE,
    X_NO_OF_ROWS_INACTIVE,
    X_APPLY_TRAFFIC_COP,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_PROGRAM_ID ,
    X_PROGRAM_APPLICATION_ID ,
    X_PROGRAM_UPDATE_DATE,
    X_ORG_ID,
    X_NO_OF_ROWS_PREV_CONTACTED,
    X_PARENT_LIST_HEADER_ID,
    X_SPLIT_TYPE,
    X_SPLIT_VALUE,
         X_CTRL_CONF_LEVEL,
        X_CTRL_REQ_RESP_RATE,
        X_CTRL_LIMIT_OF_ERROR,
        X_STATUS_CODE_OLD,
        X_CTRL_CONC_JOB_ID,
        X_CTRL_STATUS_CODE,
        X_CTRL_GEN_MODE,
	X_APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206
  );

Line: 387


  insert into AMS_LIST_HEADERS_ALL_TL (
    LIST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATE_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LIST_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LIST_HEADER_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LIST_NAME,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AMS_LIST_HEADERS_ALL_TL T
    where T.LIST_HEADER_ID = X_LIST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 425


end INSERT_ROW;

Line: 457


  X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
  X_RESULT_TEXT in VARCHAR2,
  X_KEYWORDS in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LIST_PRIORITY in NUMBER,
  X_ASSIGN_PERSON_ID in NUMBER,
  X_LIST_SOURCE in VARCHAR2,
  X_LIST_SOURCE_TYPE in VARCHAR2,
  X_LIST_ONLINE_FLAG in VARCHAR2,
  X_RANDOM_LIST_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_ASSIGNED_TO in NUMBER,
  X_QUERY_ID in NUMBER,
  X_OWNER_PERSON_ID in NUMBER,
  X_ARCHIVED_BY in NUMBER,
  X_ARCHIVED_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_TIMEZONE_ID in NUMBER,
  X_USER_ENTERED_START_TIME in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LIST_USED_BY_ID in NUMBER,
  X_ARC_LIST_USED_BY in VARCHAR2,
  X_LIST_TYPE in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_STATUS_DATE in DATE,
  X_GENERATION_TYPE in VARCHAR2,
  X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
  X_ROW_SELECTION_TYPE in VARCHAR2,
  X_OWNER_USER_ID in NUMBER,
  X_ACCESS_LEVEL in VARCHAR2,
  X_ENABLE_LOG_FLAG in VARCHAR2,
  X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
  X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
  X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
  X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
  X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
  X_FORECASTED_START_DATE in DATE,
  X_FORECASTED_END_DATE in DATE,
  X_ACTUAL_END_DATE in DATE,
  X_SENT_OUT_DATE in DATE,
  X_DEDUPE_START_DATE in DATE,
  X_LAST_DEDUPE_DATE in DATE,
  X_LAST_DEDUPED_BY_USER_ID in NUMBER,
  X_WORKFLOW_ITEM_KEY in NUMBER,
  X_NO_OF_ROWS_DUPLICATES in NUMBER,
  X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
  X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
  X_NO_OF_ROWS_IN_LIST in NUMBER,
  X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
  X_NO_OF_ROWS_ACTIVE in NUMBER,
  X_NO_OF_ROWS_INACTIVE in NUMBER,
  X_APPLY_TRAFFIC_COP in VARCHAR2,
  X_LIST_NAME in VARCHAR2,
  X_PROGRAM_ID NUMBER,
  X_PROGRAM_APPLICATION_ID NUMBER,
  X_PROGRAM_UPDATE_DATE DATE,
  X_ORG_ID NUMBER,
  X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
  X_PARENT_LIST_HEADER_ID NUMBER,
  X_SPLIT_TYPE VARCHAR,
  X_SPLIT_VALUE NUMBER,
  X_CTRL_CONF_LEVEL NUMBER,
        X_CTRL_REQ_RESP_RATE NUMBER,
        X_CTRL_LIMIT_OF_ERROR NUMBER,
        X_STATUS_CODE_OLD VARCHAR2,
        X_CTRL_CONC_JOB_ID NUMBER,
        X_CTRL_STATUS_CODE VARCHAR2,
        X_CTRL_GEN_MODE VARCHAR2,
	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206


) is
  cursor c is select
      PURPOSE_CODE,
      NO_OF_ROWS_FATIGUED,
      NO_OF_ROWS_SUPPRESSED,
      QUERY_TEMPLATE_ID,
      MIGRATION_DATE,
      TCA_FAILED_RECORDS,
      USER_STATUS_ID,
      QUANTUM,
      RELEASE_CONTROL_ALG_ID,
      DIALING_METHOD,
      CALLING_CALENDAR_ID,
      RELEASE_STRATEGY,
      CUSTOM_SETUP_ID,
      COUNTRY,
      CALLBACK_PRIORITY_FLAG,
      CALL_CENTER_READY_FLAG,
      PURGE_FLAG,
      QUOTA,
      QUOTA_RESET,
      RECYCLING_ALG_ID,
      PUBLIC_FLAG,
      LIST_CATEGORY,
      NO_OF_ROWS_MANUALLY_ENTERED,
      NO_OF_ROWS_DO_NOT_CALL,
      NO_OF_ROWS_DO_NOT_MAIL,
      NO_OF_ROWS_RANDOM,
      MAIN_GEN_START_TIME,
      MAIN_GEN_END_TIME,
      MAIN_RANDOM_NTH_ROW_SELECTION,
      MAIN_RANDOM_PCT_ROW_SELECTION,
      CTRL_RANDOM_NTH_ROW_SELECTION,
      CTRL_RANDOM_PCT_ROW_SELECTION,
      REPEAT_SOURCE_LIST_HEADER_ID,
      RESULT_TEXT,
      KEYWORDS,
      DESCRIPTION,
      LIST_PRIORITY,
      ASSIGN_PERSON_ID,
      LIST_SOURCE,
      LIST_SOURCE_TYPE,
      LIST_ONLINE_FLAG,
      RANDOM_LIST_ID,
      ENABLED_FLAG,
      ASSIGNED_TO,
      QUERY_ID,
      OWNER_PERSON_ID,
      ARCHIVED_BY,
      ARCHIVED_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      TIMEZONE_ID,
      USER_ENTERED_START_TIME,
      OBJECT_VERSION_NUMBER,
      REQUEST_ID,
      VIEW_APPLICATION_ID,
      LIST_USED_BY_ID,
      ARC_LIST_USED_BY,
      LIST_TYPE,
      STATUS_CODE,
      STATUS_DATE,
      GENERATION_TYPE,
      REPEAT_EXCLUDE_TYPE,
      ROW_SELECTION_TYPE,
      OWNER_USER_ID,
      ACCESS_LEVEL,
      ENABLE_LOG_FLAG,
      ENABLE_WORD_REPLACEMENT_FLAG,
      ENABLE_PARALLEL_DML_FLAG,
      DEDUPE_DURING_GENERATION_FLAG,
      GENERATE_CONTROL_GROUP_FLAG,
      LAST_GENERATION_SUCCESS_FLAG,
      FORECASTED_START_DATE,
      FORECASTED_END_DATE,
      ACTUAL_END_DATE,
      SENT_OUT_DATE,
      DEDUPE_START_DATE,
      LAST_DEDUPE_DATE,
      LAST_DEDUPED_BY_USER_ID,
      WORKFLOW_ITEM_KEY,
      NO_OF_ROWS_DUPLICATES,
      NO_OF_ROWS_MIN_REQUESTED,
      NO_OF_ROWS_MAX_REQUESTED,
      NO_OF_ROWS_IN_LIST,
      NO_OF_ROWS_IN_CTRL_GROUP,
      NO_OF_ROWS_ACTIVE,
      NO_OF_ROWS_INACTIVE,
      APPLY_TRAFFIC_COP,
      NO_OF_ROWS_PREV_CONTACTED,
      PARENT_LIST_HEADER_ID,
      SPLIT_TYPE,
      SPLIT_VALUE,
      CTRL_CONF_LEVEL,
        CTRL_REQ_RESP_RATE,
        CTRL_LIMIT_OF_ERROR,
        STATUS_CODE_OLD,
        CTRL_CONC_JOB_ID,
        CTRL_STATUS_CODE,
        CTRL_GEN_MODE,
	APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206



    from AMS_LIST_HEADERS_ALL
    where LIST_HEADER_ID = X_LIST_HEADER_ID
    for update of LIST_HEADER_ID nowait;

Line: 672


  cursor c1 is select
      LIST_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMS_LIST_HEADERS_ALL_TL
    where LIST_HEADER_ID = X_LIST_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of LIST_HEADER_ID nowait;

Line: 684


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 744


      AND ((recinfo.MAIN_RANDOM_NTH_ROW_SELECTION = X_MAIN_RANDOM_NTH_ROW_SELECTIO)
           OR ((recinfo.MAIN_RANDOM_NTH_ROW_SELECTION is null) AND (X_MAIN_RANDOM_NTH_ROW_SELECTIO is null)))
      AND ((recinfo.MAIN_RANDOM_PCT_ROW_SELECTION = X_MAIN_RANDOM_PCT_ROW_SELECTIO)
           OR ((recinfo.MAIN_RANDOM_PCT_ROW_SELECTION is null) AND (X_MAIN_RANDOM_PCT_ROW_SELECTIO is null)))
      AND ((recinfo.CTRL_RANDOM_NTH_ROW_SELECTION = X_CTRL_RANDOM_NTH_ROW_SELECTIO)
           OR ((recinfo.CTRL_RANDOM_NTH_ROW_SELECTION is null) AND (X_CTRL_RANDOM_NTH_ROW_SELECTIO is null)))
      AND ((recinfo.CTRL_RANDOM_PCT_ROW_SELECTION = X_CTRL_RANDOM_PCT_ROW_SELECTIO)
           OR ((recinfo.CTRL_RANDOM_PCT_ROW_SELECTION is null) AND (X_CTRL_RANDOM_PCT_ROW_SELECTIO is null)))
      AND ((recinfo.REPEAT_SOURCE_LIST_HEADER_ID = X_REPEAT_SOURCE_LIST_HEADER_ID)
           OR ((recinfo.REPEAT_SOURCE_LIST_HEADER_ID is null) AND (X_REPEAT_SOURCE_LIST_HEADER_ID is null)))
      AND ((recinfo.RESULT_TEXT = X_RESULT_TEXT)
           OR ((recinfo.RESULT_TEXT is null) AND (X_RESULT_TEXT is null)))
      AND ((recinfo.KEYWORDS = X_KEYWORDS)
           OR ((recinfo.KEYWORDS is null) AND (X_KEYWORDS is null)))
      AND ((recinfo.DESCRIPTION = X_DESCRIPTION)
           OR ((recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
      AND ((recinfo.LIST_PRIORITY = X_LIST_PRIORITY)
           OR ((recinfo.LIST_PRIORITY is null) AND (X_LIST_PRIORITY is null)))
      AND ((recinfo.ASSIGN_PERSON_ID = X_ASSIGN_PERSON_ID)
           OR ((recinfo.ASSIGN_PERSON_ID is null) AND (X_ASSIGN_PERSON_ID is null)))
      AND ((recinfo.LIST_SOURCE = X_LIST_SOURCE)
           OR ((recinfo.LIST_SOURCE is null) AND (X_LIST_SOURCE is null)))
      AND ((recinfo.LIST_SOURCE_TYPE = X_LIST_SOURCE_TYPE)
           OR ((recinfo.LIST_SOURCE_TYPE is null) AND (X_LIST_SOURCE_TYPE is null)))
      AND ((recinfo.LIST_ONLINE_FLAG = X_LIST_ONLINE_FLAG)
           OR ((recinfo.LIST_ONLINE_FLAG is null) AND (X_LIST_ONLINE_FLAG is null)))
      AND ((recinfo.RANDOM_LIST_ID = X_RANDOM_LIST_ID)
           OR ((recinfo.RANDOM_LIST_ID is null) AND (X_RANDOM_LIST_ID is null)))
      AND ((recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
           OR ((recinfo.ENABLED_FLAG is null) AND (X_ENABLED_FLAG is null)))
      AND ((recinfo.ASSIGNED_TO = X_ASSIGNED_TO)
           OR ((recinfo.ASSIGNED_TO is null) AND (X_ASSIGNED_TO is null)))
      AND ((recinfo.QUERY_ID = X_QUERY_ID)
           OR ((recinfo.QUERY_ID is null) AND (X_QUERY_ID is null)))
      AND ((recinfo.OWNER_PERSON_ID = X_OWNER_PERSON_ID)
           OR ((recinfo.OWNER_PERSON_ID is null) AND (X_OWNER_PERSON_ID is null)))
      AND ((recinfo.ARCHIVED_BY = X_ARCHIVED_BY)
           OR ((recinfo.ARCHIVED_BY is null) AND (X_ARCHIVED_BY is null)))
      AND ((recinfo.ARCHIVED_DATE = X_ARCHIVED_DATE)
           OR ((recinfo.ARCHIVED_DATE is null) AND (X_ARCHIVED_DATE is null)))
      AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
           OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
      AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
      AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
      AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
           OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
      AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
           OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
      AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
           OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
      AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
           OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
      AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
           OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
      AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
           OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
      AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
           OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
      AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
           OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
      AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
           OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
      AND ((recinfo.TIMEZONE_ID = X_TIMEZONE_ID)
           OR ((recinfo.TIMEZONE_ID is null) AND (X_TIMEZONE_ID is null)))
      AND ((recinfo.USER_ENTERED_START_TIME = X_USER_ENTERED_START_TIME)
           OR ((recinfo.USER_ENTERED_START_TIME is null) AND (X_USER_ENTERED_START_TIME is null)))
      AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
           OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
      AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
           OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
      AND ((recinfo.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID)
           OR ((recinfo.VIEW_APPLICATION_ID is null) AND (X_VIEW_APPLICATION_ID is null)))
      AND (recinfo.LIST_USED_BY_ID = X_LIST_USED_BY_ID)
      AND (recinfo.ARC_LIST_USED_BY = X_ARC_LIST_USED_BY)
      AND (recinfo.LIST_TYPE = X_LIST_TYPE)
      AND (recinfo.STATUS_CODE = X_STATUS_CODE)
      AND (recinfo.STATUS_DATE = X_STATUS_DATE)
      AND (recinfo.GENERATION_TYPE = X_GENERATION_TYPE)
      AND ((recinfo.REPEAT_EXCLUDE_TYPE = X_REPEAT_EXCLUDE_TYPE)
           OR ((recinfo.REPEAT_EXCLUDE_TYPE is null) AND (X_REPEAT_EXCLUDE_TYPE is null)))
      AND (recinfo.ROW_SELECTION_TYPE = X_ROW_SELECTION_TYPE)
      AND (recinfo.OWNER_USER_ID = X_OWNER_USER_ID)
      AND (recinfo.ACCESS_LEVEL = X_ACCESS_LEVEL)
      AND (recinfo.ENABLE_LOG_FLAG = X_ENABLE_LOG_FLAG)
      AND (recinfo.ENABLE_WORD_REPLACEMENT_FLAG = X_ENABLE_WORD_REPLACEMENT_FLAG)
      AND (recinfo.ENABLE_PARALLEL_DML_FLAG = X_ENABLE_PARALLEL_DML_FLAG)
      AND (recinfo.DEDUPE_DURING_GENERATION_FLAG = X_DEDUPE_DURING_GENERATION_FLA)
      AND (recinfo.GENERATE_CONTROL_GROUP_FLAG = X_GENERATE_CONTROL_GROUP_FLAG)
      AND (recinfo.LAST_GENERATION_SUCCESS_FLAG = X_LAST_GENERATION_SUCCESS_FLAG)
      AND (recinfo.FORECASTED_START_DATE = X_FORECASTED_START_DATE)
      AND ((recinfo.FORECASTED_END_DATE = X_FORECASTED_END_DATE)
           OR ((recinfo.FORECASTED_END_DATE is null) AND (X_FORECASTED_END_DATE is null)))
      AND ((recinfo.ACTUAL_END_DATE = X_ACTUAL_END_DATE)
           OR ((recinfo.ACTUAL_END_DATE is null) AND (X_ACTUAL_END_DATE is null)))
      AND ((recinfo.SENT_OUT_DATE = X_SENT_OUT_DATE)
           OR ((recinfo.SENT_OUT_DATE is null) AND (X_SENT_OUT_DATE is null)))
      AND ((recinfo.DEDUPE_START_DATE = X_DEDUPE_START_DATE)
           OR ((recinfo.DEDUPE_START_DATE is null) AND (X_DEDUPE_START_DATE is null)))
      AND ((recinfo.LAST_DEDUPE_DATE = X_LAST_DEDUPE_DATE)
           OR ((recinfo.LAST_DEDUPE_DATE is null) AND (X_LAST_DEDUPE_DATE is null)))
      AND ((recinfo.LAST_DEDUPED_BY_USER_ID = X_LAST_DEDUPED_BY_USER_ID)
           OR ((recinfo.LAST_DEDUPED_BY_USER_ID is null) AND (X_LAST_DEDUPED_BY_USER_ID is null)))
      AND ((recinfo.WORKFLOW_ITEM_KEY = X_WORKFLOW_ITEM_KEY)
           OR ((recinfo.WORKFLOW_ITEM_KEY is null) AND (X_WORKFLOW_ITEM_KEY is null)))
      AND ((recinfo.NO_OF_ROWS_DUPLICATES = X_NO_OF_ROWS_DUPLICATES)
           OR ((recinfo.NO_OF_ROWS_DUPLICATES is null) AND (X_NO_OF_ROWS_DUPLICATES is null)))
      AND ((recinfo.NO_OF_ROWS_MIN_REQUESTED = X_NO_OF_ROWS_MIN_REQUESTED)
           OR ((recinfo.NO_OF_ROWS_MIN_REQUESTED is null) AND (X_NO_OF_ROWS_MIN_REQUESTED is null)))
      AND ((recinfo.NO_OF_ROWS_MAX_REQUESTED = X_NO_OF_ROWS_MAX_REQUESTED)
           OR ((recinfo.NO_OF_ROWS_MAX_REQUESTED is null) AND (X_NO_OF_ROWS_MAX_REQUESTED is null)))
      AND ((recinfo.NO_OF_ROWS_IN_LIST = X_NO_OF_ROWS_IN_LIST)
           OR ((recinfo.NO_OF_ROWS_IN_LIST is null) AND (X_NO_OF_ROWS_IN_LIST is null)))
      AND ((recinfo.NO_OF_ROWS_IN_CTRL_GROUP = X_NO_OF_ROWS_IN_CTRL_GROUP)
           OR ((recinfo.NO_OF_ROWS_IN_CTRL_GROUP is null) AND (X_NO_OF_ROWS_IN_CTRL_GROUP is null)))
      AND ((recinfo.NO_OF_ROWS_ACTIVE = X_NO_OF_ROWS_ACTIVE)
           OR ((recinfo.NO_OF_ROWS_ACTIVE is null) AND (X_NO_OF_ROWS_ACTIVE is null)))
      AND ((recinfo.NO_OF_ROWS_INACTIVE = X_NO_OF_ROWS_INACTIVE)
           OR ((recinfo.NO_OF_ROWS_INACTIVE is null) AND (X_NO_OF_ROWS_INACTIVE is null)))
      AND ((recinfo.APPLY_TRAFFIC_COP = X_APPLY_TRAFFIC_COP)
           OR ((recinfo.APPLY_TRAFFIC_COP is null) AND (X_APPLY_TRAFFIC_COP is null)))*/
             ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
           OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
    --rmbhanda   bug#4609206 start
     AND ((recinfo.APPLY_SUPPRESSION_FLAG = X_APPLY_SUPPRESSION_FLAG)
           OR ((recinfo.APPLY_SUPPRESSION_FLAG is null) AND (X_APPLY_SUPPRESSION_FLAG is null)))
    --rmbhanda   bug#4609206   end
  ) then
    null;

Line: 901


procedure UPDATE_ROW (
  X_LIST_HEADER_ID in NUMBER,
  X_PURPOSE_CODE in VARCHAR2,
  X_NO_OF_ROWS_FATIGUED in NUMBER,
  X_NO_OF_ROWS_SUPPRESSED in NUMBER,
  X_QUERY_TEMPLATE_ID in NUMBER,
  X_MIGRATION_DATE in DATE,
  X_TCA_FAILED_RECORDS in NUMBER,
  X_USER_STATUS_ID in NUMBER,
  X_QUANTUM in NUMBER,
  X_RELEASE_CONTROL_ALG_ID in NUMBER,
  X_DIALING_METHOD in VARCHAR2,
  X_CALLING_CALENDAR_ID in NUMBER,
  X_RELEASE_STRATEGY in VARCHAR2,
  X_CUSTOM_SETUP_ID in NUMBER,
  X_COUNTRY in NUMBER,
  X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
  X_CALL_CENTER_READY_FLAG in VARCHAR2,
  X_PURGE_FLAG in VARCHAR2,
  X_QUOTA in NUMBER,
  X_QUOTA_RESET in NUMBER,
  X_RECYCLING_ALG_ID in NUMBER,
  X_PUBLIC_FLAG in VARCHAR2,
  X_LIST_CATEGORY in VARCHAR2,
  X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
  X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
  X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
  X_NO_OF_ROWS_RANDOM in NUMBER,
  X_MAIN_GEN_START_TIME in DATE,
  X_MAIN_GEN_END_TIME in DATE,
  X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
  X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
  X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
  X_RESULT_TEXT in VARCHAR2,
  X_KEYWORDS in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LIST_PRIORITY in NUMBER,
  X_ASSIGN_PERSON_ID in NUMBER,
  X_LIST_SOURCE in VARCHAR2,
  X_LIST_SOURCE_TYPE in VARCHAR2,
  X_LIST_ONLINE_FLAG in VARCHAR2,
  X_RANDOM_LIST_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_ASSIGNED_TO in NUMBER,
  X_QUERY_ID in NUMBER,
  X_OWNER_PERSON_ID in NUMBER,
  X_ARCHIVED_BY in NUMBER,
  X_ARCHIVED_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_TIMEZONE_ID in NUMBER,
  X_USER_ENTERED_START_TIME in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LIST_USED_BY_ID in NUMBER,
  X_ARC_LIST_USED_BY in VARCHAR2,
  X_LIST_TYPE in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_STATUS_DATE in DATE,
  X_GENERATION_TYPE in VARCHAR2,
  X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
  X_ROW_SELECTION_TYPE in VARCHAR2,
  X_OWNER_USER_ID in NUMBER,
  X_ACCESS_LEVEL in VARCHAR2,
  X_ENABLE_LOG_FLAG in VARCHAR2,
  X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
  X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
  X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
  X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
  X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
  X_FORECASTED_START_DATE in DATE,
  X_FORECASTED_END_DATE in DATE,
  X_ACTUAL_END_DATE in DATE,
  X_SENT_OUT_DATE in DATE,
  X_DEDUPE_START_DATE in DATE,
  X_LAST_DEDUPE_DATE in DATE,
  X_LAST_DEDUPED_BY_USER_ID in NUMBER,
  X_WORKFLOW_ITEM_KEY in NUMBER,
  X_NO_OF_ROWS_DUPLICATES in NUMBER,
  X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
  X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
  X_NO_OF_ROWS_IN_LIST in NUMBER,
  X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
  X_NO_OF_ROWS_ACTIVE in NUMBER,
  X_NO_OF_ROWS_INACTIVE in NUMBER,
  X_APPLY_TRAFFIC_COP in VARCHAR2,
  X_LIST_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_ID NUMBER,
  X_PROGRAM_APPLICATION_ID NUMBER,
  X_PROGRAM_UPDATE_DATE DATE,
  X_ORG_ID NUMBER,
  X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
  X_PARENT_LIST_HEADER_ID NUMBER,
  X_SPLIT_TYPE VARCHAR,
  X_SPLIT_VALUE NUMBER,
    X_CTRL_CONF_LEVEL NUMBER,
        X_CTRL_REQ_RESP_RATE NUMBER,
        X_CTRL_LIMIT_OF_ERROR NUMBER,
        X_STATUS_CODE_OLD VARCHAR2,
        X_CTRL_CONC_JOB_ID NUMBER,
        X_CTRL_STATUS_CODE VARCHAR2,
        X_CTRL_GEN_MODE VARCHAR2,
	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206


) is
begin
  update AMS_LIST_HEADERS_ALL set
    PURPOSE_CODE = X_PURPOSE_CODE,
    NO_OF_ROWS_FATIGUED = X_NO_OF_ROWS_FATIGUED,
    NO_OF_ROWS_SUPPRESSED = X_NO_OF_ROWS_SUPPRESSED,
    QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
    MIGRATION_DATE = X_MIGRATION_DATE,
    TCA_FAILED_RECORDS = X_TCA_FAILED_RECORDS,
    USER_STATUS_ID = X_USER_STATUS_ID,
    QUANTUM = X_QUANTUM,
    RELEASE_CONTROL_ALG_ID = X_RELEASE_CONTROL_ALG_ID,
    DIALING_METHOD = X_DIALING_METHOD,
    CALLING_CALENDAR_ID = X_CALLING_CALENDAR_ID,
    RELEASE_STRATEGY = X_RELEASE_STRATEGY,
    CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID,
    COUNTRY = X_COUNTRY,
    CALLBACK_PRIORITY_FLAG = X_CALLBACK_PRIORITY_FLAG,
    CALL_CENTER_READY_FLAG = X_CALL_CENTER_READY_FLAG,
    PURGE_FLAG = X_PURGE_FLAG,
    QUOTA = X_QUOTA,
    QUOTA_RESET = X_QUOTA_RESET,
    RECYCLING_ALG_ID = X_RECYCLING_ALG_ID,
    PUBLIC_FLAG = X_PUBLIC_FLAG,
    LIST_CATEGORY = X_LIST_CATEGORY,
    NO_OF_ROWS_MANUALLY_ENTERED = X_NO_OF_ROWS_MANUALLY_ENTERED,
    NO_OF_ROWS_DO_NOT_CALL = X_NO_OF_ROWS_DO_NOT_CALL,
    NO_OF_ROWS_DO_NOT_MAIL = X_NO_OF_ROWS_DO_NOT_MAIL,
    NO_OF_ROWS_RANDOM = X_NO_OF_ROWS_RANDOM,
    MAIN_GEN_START_TIME = X_MAIN_GEN_START_TIME,
    MAIN_GEN_END_TIME = X_MAIN_GEN_END_TIME,
    MAIN_RANDOM_NTH_ROW_SELECTION = X_MAIN_RANDOM_NTH_ROW_SELECTIO,
    MAIN_RANDOM_PCT_ROW_SELECTION = X_MAIN_RANDOM_PCT_ROW_SELECTIO,
    CTRL_RANDOM_NTH_ROW_SELECTION = X_CTRL_RANDOM_NTH_ROW_SELECTIO,
    CTRL_RANDOM_PCT_ROW_SELECTION = X_CTRL_RANDOM_PCT_ROW_SELECTIO,
    REPEAT_SOURCE_LIST_HEADER_ID = X_REPEAT_SOURCE_LIST_HEADER_ID,
    RESULT_TEXT = X_RESULT_TEXT,
    KEYWORDS = X_KEYWORDS,
    DESCRIPTION = X_DESCRIPTION,
    LIST_PRIORITY = X_LIST_PRIORITY,
    ASSIGN_PERSON_ID = X_ASSIGN_PERSON_ID,
    LIST_SOURCE = X_LIST_SOURCE,
    LIST_SOURCE_TYPE = X_LIST_SOURCE_TYPE,
    LIST_ONLINE_FLAG = X_LIST_ONLINE_FLAG,
    RANDOM_LIST_ID = X_RANDOM_LIST_ID,
    ENABLED_FLAG = X_ENABLED_FLAG,
    ASSIGNED_TO = X_ASSIGNED_TO,
    QUERY_ID = X_QUERY_ID,
    OWNER_PERSON_ID = X_OWNER_PERSON_ID,
    ARCHIVED_BY = X_ARCHIVED_BY,
    ARCHIVED_DATE = X_ARCHIVED_DATE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    TIMEZONE_ID = X_TIMEZONE_ID,
    USER_ENTERED_START_TIME = X_USER_ENTERED_START_TIME,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    REQUEST_ID = X_REQUEST_ID,
    VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID,
    LIST_USED_BY_ID = X_LIST_USED_BY_ID,
    ARC_LIST_USED_BY = X_ARC_LIST_USED_BY,
    LIST_TYPE = X_LIST_TYPE,
    STATUS_CODE = X_STATUS_CODE,
    STATUS_DATE = X_STATUS_DATE,
    GENERATION_TYPE = X_GENERATION_TYPE,
    REPEAT_EXCLUDE_TYPE = X_REPEAT_EXCLUDE_TYPE,
    ROW_SELECTION_TYPE = X_ROW_SELECTION_TYPE,
    OWNER_USER_ID = X_OWNER_USER_ID,
    ACCESS_LEVEL = X_ACCESS_LEVEL,
    ENABLE_LOG_FLAG = X_ENABLE_LOG_FLAG,
    ENABLE_WORD_REPLACEMENT_FLAG = X_ENABLE_WORD_REPLACEMENT_FLAG,
    ENABLE_PARALLEL_DML_FLAG = X_ENABLE_PARALLEL_DML_FLAG,
    DEDUPE_DURING_GENERATION_FLAG = X_DEDUPE_DURING_GENERATION_FLA,
    GENERATE_CONTROL_GROUP_FLAG = X_GENERATE_CONTROL_GROUP_FLAG,
    LAST_GENERATION_SUCCESS_FLAG = X_LAST_GENERATION_SUCCESS_FLAG,
    FORECASTED_START_DATE = X_FORECASTED_START_DATE,
    FORECASTED_END_DATE = X_FORECASTED_END_DATE,
    ACTUAL_END_DATE = X_ACTUAL_END_DATE,
    SENT_OUT_DATE = X_SENT_OUT_DATE,
    DEDUPE_START_DATE = X_DEDUPE_START_DATE,
    LAST_DEDUPE_DATE = X_LAST_DEDUPE_DATE,
    LAST_DEDUPED_BY_USER_ID = X_LAST_DEDUPED_BY_USER_ID,
    WORKFLOW_ITEM_KEY = X_WORKFLOW_ITEM_KEY,
    NO_OF_ROWS_DUPLICATES = X_NO_OF_ROWS_DUPLICATES,
    NO_OF_ROWS_MIN_REQUESTED = X_NO_OF_ROWS_MIN_REQUESTED,
    NO_OF_ROWS_MAX_REQUESTED = X_NO_OF_ROWS_MAX_REQUESTED,
    NO_OF_ROWS_IN_LIST = X_NO_OF_ROWS_IN_LIST,
    NO_OF_ROWS_IN_CTRL_GROUP = X_NO_OF_ROWS_IN_CTRL_GROUP,
    NO_OF_ROWS_ACTIVE = X_NO_OF_ROWS_ACTIVE,
    NO_OF_ROWS_INACTIVE = X_NO_OF_ROWS_INACTIVE,
    APPLY_TRAFFIC_COP = X_APPLY_TRAFFIC_COP,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    PROGRAM_ID = X_PROGRAM_ID ,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID ,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE ,
    ORG_ID = X_ORG_ID,
    NO_OF_ROWS_PREV_CONTACTED = X_NO_OF_ROWS_PREV_CONTACTED,
    PARENT_LIST_HEADER_ID = X_PARENT_LIST_HEADER_ID,
    SPLIT_TYPE = X_SPLIT_TYPE,
    SPLIT_VALUE = X_SPLIT_VALUE,
     CTRL_CONF_LEVEL = X_CTRL_CONF_LEVEL,
        CTRL_REQ_RESP_RATE = X_CTRL_REQ_RESP_RATE,
        CTRL_LIMIT_OF_ERROR = X_CTRL_LIMIT_OF_ERROR,
        STATUS_CODE_OLD = X_STATUS_CODE_OLD,
        CTRL_CONC_JOB_ID = X_CTRL_CONC_JOB_ID,
        CTRL_STATUS_CODE = X_CTRL_STATUS_CODE,
        CTRL_GEN_MODE = X_CTRL_GEN_MODE,
	APPLY_SUPPRESSION_FLAG=X_APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206


  where LIST_HEADER_ID = X_LIST_HEADER_ID;

Line: 1157


  update AMS_LIST_HEADERS_ALL_TL set
    LIST_NAME = X_LIST_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATE_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where LIST_HEADER_ID = X_LIST_HEADER_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 1170


end UPDATE_ROW;

Line: 1172


procedure DELETE_ROW (
  X_LIST_HEADER_ID in NUMBER
) is
begin
  delete from AMS_LIST_HEADERS_ALL_TL
  where LIST_HEADER_ID = X_LIST_HEADER_ID;

Line: 1183


  delete from AMS_LIST_HEADERS_ALL
  where LIST_HEADER_ID = X_LIST_HEADER_ID;

Line: 1189


end DELETE_ROW;

Line: 1194


  delete from AMS_LIST_HEADERS_ALL_TL T
  where not exists
    (select NULL
    from AMS_LIST_HEADERS_ALL B
    where B.LIST_HEADER_ID = T.LIST_HEADER_ID
    );

Line: 1201


  update AMS_LIST_HEADERS_ALL_TL T set (
      LIST_NAME
    ) = (select
      B.LIST_NAME
    from AMS_LIST_HEADERS_ALL_TL B
    where B.LIST_HEADER_ID = T.LIST_HEADER_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.LIST_HEADER_ID,
      T.LANGUAGE
  ) in (select
      SUBT.LIST_HEADER_ID,
      SUBT.LANGUAGE
    from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT
    where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.LIST_NAME <> SUBT.LIST_NAME
  ));

Line: 1220


  insert into AMS_LIST_HEADERS_ALL_TL (
    LIST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATE_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LIST_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LIST_HEADER_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.LIST_NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AMS_LIST_HEADERS_ALL_TL T
    where T.LIST_HEADER_ID = B.LIST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);