The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in OUT NOCOPY VARCHAR2,
X_LIST_HEADER_ID in NUMBER,
X_COUNTRY 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_CALLBACK_PRIORITY_FLAG in VARCHAR2,
X_CALL_CENTER_READY_FLAG in VARCHAR2,
X_CUSTOM_SETUP_ID in NUMBER,
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_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_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_LIST_NAME in VARCHAR2,
X_DESCRIPTION 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_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
X_APPLY_TRAFFIC_COP in VARCHAR2
) is
cursor C is select ROWID from AMS_LIST_HEADERS_ALL
where LIST_HEADER_ID = X_LIST_HEADER_ID
;
insert into AMS_LIST_HEADERS_ALL (
COUNTRY,
USER_STATUS_ID,
QUANTUM,
RELEASE_CONTROL_ALG_ID,
DIALING_METHOD,
CALLING_CALENDAR_ID,
RELEASE_STRATEGY,
CALLBACK_PRIORITY_FLAG,
CALL_CENTER_READY_FLAG,
CUSTOM_SETUP_ID,
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,
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,
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,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
NO_OF_ROWS_PREV_CONTACTED ,
APPLY_TRAFFIC_COP
) values (
X_COUNTRY,
X_USER_STATUS_ID,
X_QUANTUM,
X_RELEASE_CONTROL_ALG_ID,
X_DIALING_METHOD,
X_CALLING_CALENDAR_ID,
X_RELEASE_STRATEGY,
X_CALLBACK_PRIORITY_FLAG,
X_CALL_CENTER_READY_FLAG,
X_CUSTOM_SETUP_ID,
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_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_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_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_NO_OF_ROWS_PREV_CONTACTED,
X_APPLY_TRAFFIC_COP
);
insert into AMS_LIST_HEADERS_ALL_TL (
LIST_NAME,
DESCRIPTION,
LAST_UPDATE_LOGIN,
LIST_HEADER_ID,
LAST_UPDATE_DATE,
LAST_UPDATE_BY,
CREATION_DATE,
CREATED_BY,
LANGUAGE,
SOURCE_LANG
) select
X_LIST_NAME,
X_DESCRIPTION,
X_LAST_UPDATE_LOGIN,
X_LIST_HEADER_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_CREATION_DATE,
X_CREATED_BY,
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);
end INSERT_ROW;
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_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_LIST_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
X_APPLY_TRAFFIC_COP in VARCHAR2
) is
cursor c is select
COUNTRY,
USER_STATUS_ID,
QUANTUM,
RELEASE_CONTROL_ALG_ID,
DIALING_METHOD,
CALLING_CALENDAR_ID,
RELEASE_STRATEGY,
CALLBACK_PRIORITY_FLAG,
CALL_CENTER_READY_FLAG,
CUSTOM_SETUP_ID,
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,
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,
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,
NO_OF_ROWS_PREV_CONTACTED ,
APPLY_TRAFFIC_COP
from AMS_LIST_HEADERS_ALL
where LIST_HEADER_ID = X_LIST_HEADER_ID
for update of LIST_HEADER_ID nowait;
cursor c1 is select
LIST_NAME,
DESCRIPTION,
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;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
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.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.NO_OF_ROWS_prev_contacted = X_NO_OF_ROWS_prev_contacted )
OR ((recinfo.NO_OF_ROWS_prev_contacted is null) AND (X_NO_OF_ROWS_prev_contacted 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)))
) then
null;
procedure UPDATE_ROW (
X_LIST_HEADER_ID in NUMBER,
X_COUNTRY 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_CALLBACK_PRIORITY_FLAG in VARCHAR2,
X_CALL_CENTER_READY_FLAG in VARCHAR2,
X_CUSTOM_SETUP_ID in NUMBER,
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_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_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_LIST_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
X_APPLY_TRAFFIC_COP in VARCHAR2
) is
begin
update AMS_LIST_HEADERS_ALL set
COUNTRY = X_COUNTRY,
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,
CALLBACK_PRIORITY_FLAG = X_CALLBACK_PRIORITY_FLAG,
CALL_CENTER_READY_FLAG = X_CALL_CENTER_READY_FLAG,
CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID,
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,
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,
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,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
NO_OF_ROWS_PREV_CONTACTED = X_NO_OF_ROWS_PREV_CONTACTED,
APPLY_TRAFFIC_COP = X_APPLY_TRAFFIC_COP
where LIST_HEADER_ID = X_LIST_HEADER_ID;
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);
end UPDATE_ROW;
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;
delete from AMS_LIST_HEADERS_ALL
where LIST_HEADER_ID = X_LIST_HEADER_ID;
end DELETE_ROW;
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
);
update AMS_LIST_HEADERS_ALL_TL T set (
LIST_NAME,
DESCRIPTION
) = (select
B.LIST_NAME,
B.DESCRIPTION
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
or (SUBB.LIST_NAME is null and SUBT.LIST_NAME is not null)
or (SUBB.LIST_NAME is not null and SUBT.LIST_NAME is null)
or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
));
insert into AMS_LIST_HEADERS_ALL_TL (
LIST_NAME,
DESCRIPTION,
LAST_UPDATE_LOGIN,
LIST_HEADER_ID,
LAST_UPDATE_DATE,
LAST_UPDATE_BY,
CREATION_DATE,
CREATED_BY,
LANGUAGE,
SOURCE_LANG
) select /*+ ORDERED */
B.LIST_NAME,
B.DESCRIPTION,
B.LAST_UPDATE_LOGIN,
B.LIST_HEADER_ID,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_BY,
B.CREATION_DATE,
B.CREATED_BY,
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);
P_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
P_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
P_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
P_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
P_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
P_RESULT_TEXT in VARCHAR2,
P_KEYWORDS in VARCHAR2,
P_LIST_PRIORITY in NUMBER,
P_ASSIGN_PERSON_ID in NUMBER,
P_LIST_SOURCE in VARCHAR2,
P_LIST_SOURCE_TYPE in VARCHAR2,
P_LIST_ONLINE_FLAG in VARCHAR2,
P_RANDOM_LIST_ID in NUMBER,
P_ENABLED_FLAG in VARCHAR2,
P_ASSIGNED_TO in NUMBER,
P_QUERY_ID in NUMBER,
P_OWNER_PERSON_ID in NUMBER,
P_ARCHIVED_BY in NUMBER,
P_ARCHIVED_DATE in DATE,
P_ATTRIBUTE_CATEGORY in VARCHAR2,
P_ATTRIBUTE1 in VARCHAR2,
P_ATTRIBUTE2 in VARCHAR2,
P_ATTRIBUTE3 in VARCHAR2,
P_ATTRIBUTE4 in VARCHAR2,
P_ATTRIBUTE5 in VARCHAR2,
P_ATTRIBUTE6 in VARCHAR2,
P_ATTRIBUTE7 in VARCHAR2,
P_ATTRIBUTE8 in VARCHAR2,
P_ATTRIBUTE9 in VARCHAR2,
P_ATTRIBUTE10 in VARCHAR2,
P_ATTRIBUTE11 in VARCHAR2,
P_ATTRIBUTE12 in VARCHAR2,
P_ATTRIBUTE13 in VARCHAR2,
P_ATTRIBUTE14 in VARCHAR2,
P_ATTRIBUTE15 in VARCHAR2,
P_TIMEZONE_ID in NUMBER,
P_USER_ENTERED_START_TIME in DATE,
P_OBJECT_VERSION_NUMBER in NUMBER,
P_REQUEST_ID in NUMBER,
P_VIEW_APPLICATION_ID in NUMBER,
P_LIST_USED_BY_ID in NUMBER,
P_ARC_LIST_USED_BY in VARCHAR2,
P_LIST_TYPE in VARCHAR2,
P_STATUS_CODE in VARCHAR2,
P_STATUS_DATE in DATE,
P_GENERATION_TYPE in VARCHAR2,
P_REPEAT_EXCLUDE_TYPE in VARCHAR2,
P_ROW_SELECTION_TYPE in VARCHAR2,
P_LIST_NAME in VARCHAR2,
P_DESCRIPTION in VARCHAR2,
P_CREATION_DATE in DATE,
P_CREATED_BY in NUMBER,
P_LAST_UPDATE_DATE in DATE,
P_LAST_UPDATED_BY in NUMBER,
P_LAST_UPDATE_LOGIN in NUMBER,
P_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
P_APPLY_TRAFFIC_COP in VARCHAR2,
p_custom_mode in VARCHAR2
) is
l_user_id number := 0;
select 'x'
from ams_list_headers_all
where list_header_id = p_list_header_id;
SELECT object_version_number, last_updated_by
FROM ams_list_headers_all
where list_header_id = p_list_header_id;
l_last_updated_by number;
AMS_LIST_HEADERS_ALL_PKG.INSERT_ROW(
X_ROWID => l_row_id ,
X_LIST_HEADER_ID => P_LIST_HEADER_ID ,
X_COUNTRY => P_COUNTRY ,
X_USER_STATUS_ID => P_USER_STATUS_ID ,
X_QUANTUM => P_QUANTUM ,
X_RELEASE_CONTROL_ALG_ID => P_RELEASE_CONTROL_ALG_ID ,
X_DIALING_METHOD => P_DIALING_METHOD ,
X_CALLING_CALENDAR_ID => P_CALLING_CALENDAR_ID ,
X_RELEASE_STRATEGY => P_RELEASE_STRATEGY ,
X_CALLBACK_PRIORITY_FLAG => P_CALLBACK_PRIORITY_FLAG ,
X_CALL_CENTER_READY_FLAG => P_CALL_CENTER_READY_FLAG ,
X_CUSTOM_SETUP_ID => P_CUSTOM_SETUP_ID ,
X_OWNER_USER_ID => P_OWNER_USER_ID ,
X_ACCESS_LEVEL => P_ACCESS_LEVEL ,
X_ENABLE_LOG_FLAG => P_ENABLE_LOG_FLAG ,
X_ENABLE_WORD_REPLACEMENT_FLAG => P_ENABLE_WORD_REPLACEMENT_FLAG ,
X_ENABLE_PARALLEL_DML_FLAG => P_ENABLE_PARALLEL_DML_FLAG ,
X_DEDUPE_DURING_GENERATION_FLA => P_DEDUPE_DURING_GENERATION_FLA ,
X_GENERATE_CONTROL_GROUP_FLAG => P_GENERATE_CONTROL_GROUP_FLAG ,
X_LAST_GENERATION_SUCCESS_FLAG => P_LAST_GENERATION_SUCCESS_FLAG ,
X_FORECASTED_START_DATE => P_FORECASTED_START_DATE ,
X_FORECASTED_END_DATE => P_FORECASTED_END_DATE ,
X_ACTUAL_END_DATE => P_ACTUAL_END_DATE ,
X_SENT_OUT_DATE => P_SENT_OUT_DATE ,
X_DEDUPE_START_DATE => P_DEDUPE_START_DATE ,
X_LAST_DEDUPE_DATE => P_LAST_DEDUPE_DATE ,
X_LAST_DEDUPED_BY_USER_ID => P_LAST_DEDUPED_BY_USER_ID ,
X_WORKFLOW_ITEM_KEY => P_WORKFLOW_ITEM_KEY ,
X_NO_OF_ROWS_DUPLICATES => P_NO_OF_ROWS_DUPLICATES ,
X_NO_OF_ROWS_MIN_REQUESTED => P_NO_OF_ROWS_MIN_REQUESTED ,
X_NO_OF_ROWS_MAX_REQUESTED => P_NO_OF_ROWS_MAX_REQUESTED ,
X_NO_OF_ROWS_IN_LIST => P_NO_OF_ROWS_IN_LIST ,
X_NO_OF_ROWS_IN_CTRL_GROUP => P_NO_OF_ROWS_IN_CTRL_GROUP ,
X_NO_OF_ROWS_ACTIVE => P_NO_OF_ROWS_ACTIVE ,
X_NO_OF_ROWS_INACTIVE => P_NO_OF_ROWS_INACTIVE ,
X_NO_OF_ROWS_MANUALLY_ENTERED => P_NO_OF_ROWS_MANUALLY_ENTERED ,
X_NO_OF_ROWS_DO_NOT_CALL => P_NO_OF_ROWS_DO_NOT_CALL ,
X_NO_OF_ROWS_DO_NOT_MAIL => P_NO_OF_ROWS_DO_NOT_MAIL ,
X_NO_OF_ROWS_RANDOM => P_NO_OF_ROWS_RANDOM ,
X_MAIN_GEN_START_TIME => P_MAIN_GEN_START_TIME ,
X_MAIN_GEN_END_TIME => P_MAIN_GEN_END_TIME ,
X_MAIN_RANDOM_NTH_ROW_SELECTIO => P_MAIN_RANDOM_NTH_ROW_SELECTIO ,
X_MAIN_RANDOM_PCT_ROW_SELECTIO => P_MAIN_RANDOM_PCT_ROW_SELECTIO ,
X_CTRL_RANDOM_NTH_ROW_SELECTIO => P_CTRL_RANDOM_NTH_ROW_SELECTIO ,
X_CTRL_RANDOM_PCT_ROW_SELECTIO => P_CTRL_RANDOM_PCT_ROW_SELECTIO ,
X_REPEAT_SOURCE_LIST_HEADER_ID => P_REPEAT_SOURCE_LIST_HEADER_ID ,
X_RESULT_TEXT => P_RESULT_TEXT ,
X_KEYWORDS => P_KEYWORDS ,
X_LIST_PRIORITY => P_LIST_PRIORITY ,
X_ASSIGN_PERSON_ID => P_ASSIGN_PERSON_ID ,
X_LIST_SOURCE => P_LIST_SOURCE ,
X_LIST_SOURCE_TYPE => P_LIST_SOURCE_TYPE ,
X_LIST_ONLINE_FLAG => P_LIST_ONLINE_FLAG ,
X_RANDOM_LIST_ID => P_RANDOM_LIST_ID ,
X_ENABLED_FLAG => P_ENABLED_FLAG ,
X_ASSIGNED_TO => P_ASSIGNED_TO ,
X_QUERY_ID => P_QUERY_ID ,
X_OWNER_PERSON_ID => P_OWNER_PERSON_ID ,
X_ARCHIVED_BY => P_ARCHIVED_BY ,
X_ARCHIVED_DATE => P_ARCHIVED_DATE ,
X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 => P_ATTRIBUTE1 ,
X_ATTRIBUTE2 => P_ATTRIBUTE2 ,
X_ATTRIBUTE3 => P_ATTRIBUTE3 ,
X_ATTRIBUTE4 => P_ATTRIBUTE4 ,
X_ATTRIBUTE5 => P_ATTRIBUTE5 ,
X_ATTRIBUTE6 => P_ATTRIBUTE6 ,
X_ATTRIBUTE7 => P_ATTRIBUTE7 ,
X_ATTRIBUTE8 => P_ATTRIBUTE8 ,
X_ATTRIBUTE9 => P_ATTRIBUTE9 ,
X_ATTRIBUTE10 => P_ATTRIBUTE10 ,
X_ATTRIBUTE11 => P_ATTRIBUTE11 ,
X_ATTRIBUTE12 => P_ATTRIBUTE12 ,
X_ATTRIBUTE13 => P_ATTRIBUTE13 ,
X_ATTRIBUTE14 => P_ATTRIBUTE14 ,
X_ATTRIBUTE15 => P_ATTRIBUTE15 ,
X_TIMEZONE_ID => P_TIMEZONE_ID ,
X_USER_ENTERED_START_TIME => P_USER_ENTERED_START_TIME ,
X_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
X_REQUEST_ID => P_REQUEST_ID ,
X_VIEW_APPLICATION_ID => P_VIEW_APPLICATION_ID ,
X_LIST_USED_BY_ID => P_LIST_USED_BY_ID ,
X_ARC_LIST_USED_BY => P_ARC_LIST_USED_BY ,
X_LIST_TYPE => P_LIST_TYPE ,
X_STATUS_CODE => P_STATUS_CODE ,
X_STATUS_DATE => P_STATUS_DATE ,
X_GENERATION_TYPE => P_GENERATION_TYPE ,
X_REPEAT_EXCLUDE_TYPE => P_REPEAT_EXCLUDE_TYPE ,
X_ROW_SELECTION_TYPE => P_ROW_SELECTION_TYPE ,
X_LIST_NAME => P_LIST_NAME ,
X_DESCRIPTION => P_DESCRIPTION ,
X_CREATION_DATE => P_CREATION_DATE ,
X_CREATED_BY => P_CREATED_BY ,
X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY => P_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
X_NO_OF_ROWS_PREV_CONTACTED => P_NO_OF_ROWS_PREV_CONTACTED,
X_APPLY_TRAFFIC_COP => P_APPLY_TRAFFIC_COP );
FETCH c_obj_verno INTO l_obj_verno ,l_last_updated_by;
if (l_last_updated_by in (1,2,0) OR
NVL(p_custom_mode,'PRESERVE')='FORCE') THEN
AMS_LIST_HEADERS_ALL_PKG.UPDATE_ROW (
X_LIST_HEADER_ID => P_LIST_HEADER_ID ,
X_COUNTRY => P_COUNTRY ,
X_USER_STATUS_ID => P_USER_STATUS_ID ,
X_QUANTUM => P_QUANTUM ,
X_RELEASE_CONTROL_ALG_ID => P_RELEASE_CONTROL_ALG_ID ,
X_DIALING_METHOD => P_DIALING_METHOD ,
X_CALLING_CALENDAR_ID => P_CALLING_CALENDAR_ID ,
X_RELEASE_STRATEGY => P_RELEASE_STRATEGY ,
X_CALLBACK_PRIORITY_FLAG => P_CALLBACK_PRIORITY_FLAG ,
X_CALL_CENTER_READY_FLAG => P_CALL_CENTER_READY_FLAG ,
X_CUSTOM_SETUP_ID => P_CUSTOM_SETUP_ID ,
X_OWNER_USER_ID => P_OWNER_USER_ID ,
X_ACCESS_LEVEL => P_ACCESS_LEVEL ,
X_ENABLE_LOG_FLAG => P_ENABLE_LOG_FLAG ,
X_ENABLE_WORD_REPLACEMENT_FLAG => P_ENABLE_WORD_REPLACEMENT_FLAG ,
X_ENABLE_PARALLEL_DML_FLAG => P_ENABLE_PARALLEL_DML_FLAG ,
X_DEDUPE_DURING_GENERATION_FLA => P_DEDUPE_DURING_GENERATION_FLA ,
X_GENERATE_CONTROL_GROUP_FLAG => P_GENERATE_CONTROL_GROUP_FLAG ,
X_LAST_GENERATION_SUCCESS_FLAG => P_LAST_GENERATION_SUCCESS_FLAG ,
X_FORECASTED_START_DATE => P_FORECASTED_START_DATE ,
X_FORECASTED_END_DATE => P_FORECASTED_END_DATE ,
X_ACTUAL_END_DATE => P_ACTUAL_END_DATE ,
X_SENT_OUT_DATE => P_SENT_OUT_DATE ,
X_DEDUPE_START_DATE => P_DEDUPE_START_DATE ,
X_LAST_DEDUPE_DATE => P_LAST_DEDUPE_DATE ,
X_LAST_DEDUPED_BY_USER_ID => P_LAST_DEDUPED_BY_USER_ID ,
X_WORKFLOW_ITEM_KEY => P_WORKFLOW_ITEM_KEY ,
X_NO_OF_ROWS_DUPLICATES => P_NO_OF_ROWS_DUPLICATES ,
X_NO_OF_ROWS_MIN_REQUESTED => P_NO_OF_ROWS_MIN_REQUESTED ,
X_NO_OF_ROWS_MAX_REQUESTED => P_NO_OF_ROWS_MAX_REQUESTED ,
X_NO_OF_ROWS_IN_LIST => P_NO_OF_ROWS_IN_LIST ,
X_NO_OF_ROWS_IN_CTRL_GROUP => P_NO_OF_ROWS_IN_CTRL_GROUP ,
X_NO_OF_ROWS_ACTIVE => P_NO_OF_ROWS_ACTIVE ,
X_NO_OF_ROWS_INACTIVE => P_NO_OF_ROWS_INACTIVE ,
X_NO_OF_ROWS_MANUALLY_ENTERED => P_NO_OF_ROWS_MANUALLY_ENTERED ,
X_NO_OF_ROWS_DO_NOT_CALL => P_NO_OF_ROWS_DO_NOT_CALL ,
X_NO_OF_ROWS_DO_NOT_MAIL => P_NO_OF_ROWS_DO_NOT_MAIL ,
X_NO_OF_ROWS_RANDOM => P_NO_OF_ROWS_RANDOM ,
X_MAIN_GEN_START_TIME => P_MAIN_GEN_START_TIME ,
X_MAIN_GEN_END_TIME => P_MAIN_GEN_END_TIME ,
X_MAIN_RANDOM_NTH_ROW_SELECTIO => P_MAIN_RANDOM_NTH_ROW_SELECTIO ,
X_MAIN_RANDOM_PCT_ROW_SELECTIO => P_MAIN_RANDOM_PCT_ROW_SELECTIO ,
X_CTRL_RANDOM_NTH_ROW_SELECTIO => P_CTRL_RANDOM_NTH_ROW_SELECTIO ,
X_CTRL_RANDOM_PCT_ROW_SELECTIO => P_CTRL_RANDOM_PCT_ROW_SELECTIO ,
X_REPEAT_SOURCE_LIST_HEADER_ID => P_REPEAT_SOURCE_LIST_HEADER_ID ,
X_RESULT_TEXT => P_RESULT_TEXT ,
X_KEYWORDS => P_KEYWORDS ,
X_LIST_PRIORITY => P_LIST_PRIORITY ,
X_ASSIGN_PERSON_ID => P_ASSIGN_PERSON_ID ,
X_LIST_SOURCE => P_LIST_SOURCE ,
X_LIST_SOURCE_TYPE => P_LIST_SOURCE_TYPE ,
X_LIST_ONLINE_FLAG => P_LIST_ONLINE_FLAG ,
X_RANDOM_LIST_ID => P_RANDOM_LIST_ID ,
X_ENABLED_FLAG => P_ENABLED_FLAG ,
X_ASSIGNED_TO => P_ASSIGNED_TO ,
X_QUERY_ID => P_QUERY_ID ,
X_OWNER_PERSON_ID => P_OWNER_PERSON_ID ,
X_ARCHIVED_BY => P_ARCHIVED_BY ,
X_ARCHIVED_DATE => P_ARCHIVED_DATE ,
X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 => P_ATTRIBUTE1 ,
X_ATTRIBUTE2 => P_ATTRIBUTE2 ,
X_ATTRIBUTE3 => P_ATTRIBUTE3 ,
X_ATTRIBUTE4 => P_ATTRIBUTE4 ,
X_ATTRIBUTE5 => P_ATTRIBUTE5 ,
X_ATTRIBUTE6 => P_ATTRIBUTE6 ,
X_ATTRIBUTE7 => P_ATTRIBUTE7 ,
X_ATTRIBUTE8 => P_ATTRIBUTE8 ,
X_ATTRIBUTE9 => P_ATTRIBUTE9 ,
X_ATTRIBUTE10 => P_ATTRIBUTE10 ,
X_ATTRIBUTE11 => P_ATTRIBUTE11 ,
X_ATTRIBUTE12 => P_ATTRIBUTE12 ,
X_ATTRIBUTE13 => P_ATTRIBUTE13 ,
X_ATTRIBUTE14 => P_ATTRIBUTE14 ,
X_ATTRIBUTE15 => P_ATTRIBUTE15 ,
X_TIMEZONE_ID => P_TIMEZONE_ID ,
X_USER_ENTERED_START_TIME => P_USER_ENTERED_START_TIME ,
X_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
X_REQUEST_ID => P_REQUEST_ID ,
X_VIEW_APPLICATION_ID => P_VIEW_APPLICATION_ID ,
X_LIST_USED_BY_ID => P_LIST_USED_BY_ID ,
X_ARC_LIST_USED_BY => P_ARC_LIST_USED_BY ,
X_LIST_TYPE => P_LIST_TYPE ,
X_STATUS_CODE => P_STATUS_CODE ,
X_STATUS_DATE => P_STATUS_DATE ,
X_GENERATION_TYPE => P_GENERATION_TYPE ,
X_REPEAT_EXCLUDE_TYPE => P_REPEAT_EXCLUDE_TYPE ,
X_ROW_SELECTION_TYPE => P_ROW_SELECTION_TYPE ,
X_LIST_NAME => P_LIST_NAME ,
X_DESCRIPTION => P_DESCRIPTION ,
X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY => P_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN ,
X_NO_OF_ROWS_PREV_CONTACTED => P_NO_OF_ROWS_PREV_CONTACTED,
X_APPLY_TRAFFIC_COP => P_APPLY_TRAFFIC_COP
);
cursor c_last_update_by is
select last_update_by
from ams_list_headers_all_tl
where list_header_id = x_list_header_id
and userenv('LANG') = language;
l_last_update_by number;
open c_last_update_by;
fetch c_last_update_by into l_last_update_by;
close c_last_update_by;
if (l_last_update_by in (1,2,0) OR nvl(x_custom_mode,'PRESERVE')='FORCE') THEN
update ams_list_headers_all_tl
set list_name = nvl(x_list_name, list_name),
description = nvl(x_description,description),
source_lang = userenv('LANG'),
last_update_date = sysdate,
last_update_by = decode(x_owner, 'SEED', 1, 'ORACLE',2, 'SYSADMIN',0, -1),
last_update_login = 0
where list_header_id = x_list_header_id
and userenv('LANG') in (language, source_lang);