The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Sales_Lead_Insert_Row(
px_SALES_LEAD_ID IN OUT NOCOPY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_LEAD_NUMBER VARCHAR2,
p_STATUS_CODE VARCHAR2,
p_CUSTOMER_ID NUMBER,
p_ADDRESS_ID NUMBER,
p_SOURCE_PROMOTION_ID NUMBER,
p_INITIATING_CONTACT_ID NUMBER,
p_ORIG_SYSTEM_REFERENCE VARCHAR2,
p_CONTACT_ROLE_CODE VARCHAR2,
p_CHANNEL_CODE VARCHAR2,
p_BUDGET_AMOUNT NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_DECISION_TIMEFRAME_CODE VARCHAR2,
p_CLOSE_REASON VARCHAR2,
p_LEAD_RANK_ID NUMBER,
p_LEAD_RANK_CODE VARCHAR2,
p_PARENT_PROJECT VARCHAR2,
p_DESCRIPTION VARCHAR2,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_ASSIGN_TO_PERSON_ID NUMBER,
p_ASSIGN_TO_SALESFORCE_ID NUMBER,
p_ASSIGN_SALES_GROUP_ID NUMBER,
p_ASSIGN_DATE DATE,
p_BUDGET_STATUS_CODE VARCHAR2,
p_ACCEPT_FLAG VARCHAR2,
p_VEHICLE_RESPONSE_CODE VARCHAR2,
p_TOTAL_SCORE NUMBER,
p_SCORECARD_ID NUMBER,
p_KEEP_FLAG VARCHAR2,
p_URGENT_FLAG VARCHAR2,
p_IMPORT_FLAG VARCHAR2,
p_REJECT_REASON_CODE VARCHAR2,
p_DELETED_FLAG VARCHAR2,
p_OFFER_ID NUMBER,
p_QUALIFIED_FLAG VARCHAR2,
p_ORIG_SYSTEM_CODE VARCHAR2,
-- p_SECURITY_GROUP_ID NUMBER,
p_INC_PARTNER_PARTY_ID NUMBER,
p_INC_PARTNER_RESOURCE_ID NUMBER,
p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
p_PRM_SALES_LEAD_TYPE VARCHAR2,
p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
p_PRM_ASSIGNMENT_TYPE VARCHAR2,
p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
p_PRIMARY_CONTACT_PARTY_ID NUMBER,
-- bug 2098158
p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
p_PRIMARY_CONTACT_PHONE_ID NUMBER,
-- new columns for CAPRI lead referral
p_REFERRED_BY NUMBER,
p_REFERRAL_TYPE VARCHAR2,
p_REFERRAL_STATUS VARCHAR2,
p_REF_DECLINE_REASON VARCHAR2,
p_REF_COMM_LTR_STATUS VARCHAR2,
p_REF_ORDER_NUMBER NUMBER,
p_REF_ORDER_AMT NUMBER,
p_REF_COMM_AMT NUMBER,
-- bug No.2341515, 2368075
p_LEAD_DATE DATE ,
p_SOURCE_SYSTEM VARCHAR2,
p_COUNTRY VARCHAR2,
-- 11.5.9
p_TOTAL_AMOUNT NUMBER,
p_EXPIRATION_DATE DATE,
p_LEAD_RANK_IND VARCHAR2,
p_LEAD_ENGINE_RUN_DATE DATE,
p_CURRENT_REROUTES NUMBER
-- new columns for appsperf CRMAP denorm project bug 2928041
, p_STATUS_OPEN_FLAG VARCHAR2,
p_LEAD_RANK_SCORE NUMBER
-- 11.5.10 - ckapoor : new columns
, p_MARKETING_SCORE NUMBER
, p_INTERACTION_SCORE NUMBER
, p_SOURCE_PRIMARY_REFERENCE VARCHAR2
, p_SOURCE_SECONDARY_REFERENCE VARCHAR2
, p_SALES_METHODOLOGY_ID NUMBER
, p_SALES_STAGE_ID NUMBER
)
IS
CURSOR C2 IS SELECT AS_SALES_LEADS_S.nextval FROM sys.dual;
INSERT INTO AS_SALES_LEADS(
SALES_LEAD_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
LEAD_NUMBER,
STATUS_CODE,
CUSTOMER_ID,
ADDRESS_ID,
SOURCE_PROMOTION_ID,
INITIATING_CONTACT_ID,
ORIG_SYSTEM_REFERENCE,
CONTACT_ROLE_CODE,
CHANNEL_CODE,
BUDGET_AMOUNT,
CURRENCY_CODE,
DECISION_TIMEFRAME_CODE,
CLOSE_REASON,
LEAD_RANK_ID,
LEAD_RANK_CODE,
PARENT_PROJECT,
DESCRIPTION,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ASSIGN_TO_PERSON_ID,
ASSIGN_TO_SALESFORCE_ID,
ASSIGN_SALES_GROUP_ID,
ASSIGN_DATE,
BUDGET_STATUS_CODE,
ACCEPT_FLAG,
VEHICLE_RESPONSE_CODE,
TOTAL_SCORE,
SCORECARD_ID,
KEEP_FLAG,
URGENT_FLAG,
IMPORT_FLAG,
REJECT_REASON_CODE,
DELETED_FLAG,
OFFER_ID,
QUALIFIED_FLAG,
ORIG_SYSTEM_CODE,
-- SECURITY_GROUP_ID,
INCUMBENT_PARTNER_PARTY_ID,
INCUMBENT_PARTNER_RESOURCE_ID,
PRM_EXEC_SPONSOR_FLAG,
PRM_PRJ_LEAD_IN_PLACE_FLAG,
PRM_SALES_LEAD_TYPE,
PRM_IND_CLASSIFICATION_CODE,
PRM_ASSIGNMENT_TYPE,
AUTO_ASSIGNMENT_TYPE,
PRIMARY_CONTACT_PARTY_ID,
-- bug 2098158
PRIMARY_CNT_PERSON_PARTY_ID,
PRIMARY_CONTACT_PHONE_ID,
-- new columns for CAPRI lead referral
REFERRED_BY,
REFERRAL_TYPE,
REFERRAL_STATUS,
REF_DECLINE_REASON,
REF_COMM_LTR_STATUS,
REF_ORDER_NUMBER,
REF_ORDER_AMT,
REF_COMM_AMT,
TRUNC_CREATION_DATE,
-- bug No.2341515, 2368075
LEAD_DATE ,
SOURCE_SYSTEM ,
COUNTRY ,
-- 11.5.9
TOTAL_AMOUNT ,
EXPIRATION_DATE ,
LEAD_RANK_IND ,
LEAD_ENGINE_RUN_DATE,
CURRENT_REROUTES
-- new columns for appsperf CRMAP denorm project bug 2928041
,STATUS_OPEN_FLAG
, LEAD_RANK_SCORE
-- 11.5.10 - ckapoor : new columns
, MARKETING_SCORE
, INTERACTION_SCORE
, SOURCE_PRIMARY_REFERENCE
, SOURCE_SECONDARY_REFERENCE
, SALES_METHODOLOGY_ID
, SALES_STAGE_ID
)
VALUES (
px_SALES_LEAD_ID,
decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
p_PROGRAM_APPLICATION_ID),
decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
p_PROGRAM_UPDATE_DATE),
px_SALES_LEAD_ID,
decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
p_SOURCE_PROMOTION_ID),
decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
p_INITIATING_CONTACT_ID),
decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
p_ORIG_SYSTEM_REFERENCE),
decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
p_DECISION_TIMEFRAME_CODE),
decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
p_ATTRIBUTE_CATEGORY),
decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
p_ASSIGN_TO_PERSON_ID),
decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
p_ASSIGN_TO_SALESFORCE_ID),
decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,
p_ASSIGN_SALES_GROUP_ID),
decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
p_BUDGET_STATUS_CODE),
decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
p_VEHICLE_RESPONSE_CODE),
decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
p_REJECT_REASON_CODE),
decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
-- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
p_INC_PARTNER_PARTY_ID),
decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
p_INC_PARTNER_RESOURCE_ID),
decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,
p_PRM_EXEC_SPONSOR_FLAG),
decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,
p_PRM_SALES_LEAD_TYPE),
decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,
p_PRM_IND_CLASSIFICATION_CODE),
decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
p_PRM_ASSIGNMENT_TYPE),
decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
p_AUTO_ASSIGNMENT_TYPE),
decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
p_PRIMARY_CONTACT_PARTY_ID),
decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,
p_PRIMARY_CNT_PERSON_PARTY_ID),
decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,
p_PRIMARY_CONTACT_PHONE_ID),
decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,
p_REFERRED_BY),
decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,
p_REFERRAL_TYPE),
decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,
p_REFERRAL_STATUS),
decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,
p_REF_DECLINE_REASON),
decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,
p_REF_COMM_LTR_STATUS),
decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
p_REF_ORDER_NUMBER),
decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,
p_REF_ORDER_AMT),
decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
p_REF_COMM_AMT),
decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
-- new columns for appsperf CRMAP denorm project bug 2928041
, decode(p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_OPEN_FLAG)
, decode(p_LEAD_RANK_SCORE, FND_API.G_MISS_NUM, NULL,p_LEAD_RANK_SCORE)
-- 11.5.10 - ckapoor : new columns
, decode(p_MARKETING_SCORE, FND_API.G_MISS_NUM, NULL, p_MARKETING_SCORE)
, decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)
, decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)
, decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)
, decode(p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID)
, decode(p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL,p_SALES_STAGE_ID)
);
End Sales_Lead_Insert_Row;
PROCEDURE Sales_Lead_Update_Row(
p_SALES_LEAD_ID NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_LEAD_NUMBER VARCHAR2,
p_STATUS_CODE VARCHAR2,
p_CUSTOMER_ID NUMBER,
p_ADDRESS_ID NUMBER,
p_SOURCE_PROMOTION_ID NUMBER,
p_INITIATING_CONTACT_ID NUMBER,
p_ORIG_SYSTEM_REFERENCE VARCHAR2,
p_CONTACT_ROLE_CODE VARCHAR2,
p_CHANNEL_CODE VARCHAR2,
p_BUDGET_AMOUNT NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_DECISION_TIMEFRAME_CODE VARCHAR2,
p_CLOSE_REASON VARCHAR2,
p_LEAD_RANK_ID NUMBER,
p_LEAD_RANK_CODE VARCHAR2,
p_PARENT_PROJECT VARCHAR2,
p_DESCRIPTION VARCHAR2,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_ASSIGN_TO_PERSON_ID NUMBER,
p_ASSIGN_TO_SALESFORCE_ID NUMBER,
p_ASSIGN_SALES_GROUP_ID NUMBER,
p_ASSIGN_DATE DATE,
p_BUDGET_STATUS_CODE VARCHAR2,
p_ACCEPT_FLAG VARCHAR2,
p_VEHICLE_RESPONSE_CODE VARCHAR2,
p_TOTAL_SCORE NUMBER,
p_SCORECARD_ID NUMBER,
p_KEEP_FLAG VARCHAR2,
p_URGENT_FLAG VARCHAR2,
p_IMPORT_FLAG VARCHAR2,
p_REJECT_REASON_CODE VARCHAR2,
p_DELETED_FLAG VARCHAR2,
p_OFFER_ID NUMBER,
p_QUALIFIED_FLAG VARCHAR2,
p_ORIG_SYSTEM_CODE VARCHAR2,
-- p_SECURITY_GROUP_ID NUMBER,
p_INC_PARTNER_PARTY_ID NUMBER,
p_INC_PARTNER_RESOURCE_ID NUMBER,
p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
p_PRM_SALES_LEAD_TYPE VARCHAR2,
p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
p_PRM_ASSIGNMENT_TYPE VARCHAR2,
p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
p_PRIMARY_CONTACT_PARTY_ID NUMBER,
-- bug 2098158
p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
p_PRIMARY_CONTACT_PHONE_ID NUMBER,
-- new columns for CAPRI lead referral
p_REFERRED_BY NUMBER,
p_REFERRAL_TYPE VARCHAR2,
p_REFERRAL_STATUS VARCHAR2,
p_REF_DECLINE_REASON VARCHAR2,
p_REF_COMM_LTR_STATUS VARCHAR2,
p_REF_ORDER_NUMBER NUMBER,
p_REF_ORDER_AMT NUMBER,
p_REF_COMM_AMT NUMBER,
-- bug No.2341515, 2368075
p_LEAD_DATE DATE ,
p_SOURCE_SYSTEM VARCHAR2,
p_COUNTRY VARCHAR2,
-- 11.5.9
p_TOTAL_AMOUNT NUMBER ,
p_EXPIRATION_DATE DATE ,
p_LEAD_RANK_IND VARCHAR2,
p_LEAD_ENGINE_RUN_DATE DATE,
p_CURRENT_REROUTES NUMBER
-- new columns for appsperf CRMAP denorm project bug 2928041
, p_STATUS_OPEN_FLAG VARCHAR2,
p_LEAD_RANK_SCORE NUMBER
-- 11.5.10 - ckapoor : new columns
, p_MARKETING_SCORE NUMBER
, p_INTERACTION_SCORE NUMBER
, p_SOURCE_PRIMARY_REFERENCE VARCHAR2
, p_SOURCE_SECONDARY_REFERENCE VARCHAR2
, p_SALES_METHODOLOGY_ID NUMBER
, p_SALES_STAGE_ID NUMBER
)
IS
/*
l_obj_verno number;
select object_version_number
from as_sales_leads
where sales_lead_id = p_SALES_LEAD_ID;
Update AS_SALES_LEADS
SET
LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
LAST_UPDATED_BY, p_LAST_UPDATED_BY),
CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
CREATION_DATE, p_CREATION_DATE),
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
p_CREATED_BY),
LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
p_REQUEST_ID),
PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
FND_API.G_MISS_NUM,
PROGRAM_APPLICATION_ID,
p_PROGRAM_APPLICATION_ID),
PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
p_PROGRAM_ID),
PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE,
FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,
p_PROGRAM_UPDATE_DATE),
LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,
p_LEAD_NUMBER),
STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
p_STATUS_CODE),
CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
p_CUSTOMER_ID),
ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
p_ADDRESS_ID),
SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,
p_SOURCE_PROMOTION_ID),
INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID,
FND_API.G_MISS_NUM,
INITIATING_CONTACT_ID,
p_INITIATING_CONTACT_ID),
ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE,
FND_API.G_MISS_CHAR,
ORIG_SYSTEM_REFERENCE,
p_ORIG_SYSTEM_REFERENCE),
CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,
CHANNEL_CODE, p_CHANNEL_CODE),
BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
BUDGET_AMOUNT, p_BUDGET_AMOUNT),
CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,
CURRENCY_CODE, p_CURRENCY_CODE),
DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE,
FND_API.G_MISS_CHAR,
DECISION_TIMEFRAME_CODE,
p_DECISION_TIMEFRAME_CODE),
CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,
CLOSE_REASON, p_CLOSE_REASON),
LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,
LEAD_RANK_ID, p_LEAD_RANK_ID),
LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,
LEAD_RANK_CODE, p_LEAD_RANK_CODE),
PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,
PARENT_PROJECT, p_PARENT_PROJECT),
DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,
DESCRIPTION, p_DESCRIPTION),
ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
p_ATTRIBUTE1),
ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
p_ATTRIBUTE2),
ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
p_ATTRIBUTE3),
ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
p_ATTRIBUTE4),
ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
p_ATTRIBUTE5),
ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
p_ATTRIBUTE6),
ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
p_ATTRIBUTE7),
ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
p_ATTRIBUTE8),
ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
p_ATTRIBUTE9),
ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
p_ATTRIBUTE10),
ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
p_ATTRIBUTE11),
ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
p_ATTRIBUTE12),
ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
p_ATTRIBUTE13),
ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
p_ATTRIBUTE14),
ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
p_ATTRIBUTE15),
ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,
ASSIGN_TO_PERSON_ID,
p_ASSIGN_TO_PERSON_ID),
ASSIGN_TO_SALESFORCE_ID = decode( p_ASSIGN_TO_SALESFORCE_ID,
FND_API.G_MISS_NUM,
ASSIGN_TO_SALESFORCE_ID,
p_ASSIGN_TO_SALESFORCE_ID),
ASSIGN_SALES_GROUP_ID = decode( p_ASSIGN_SALES_GROUP_ID,
FND_API.G_MISS_NUM,
ASSIGN_SALES_GROUP_ID,
p_ASSIGN_SALES_GROUP_ID),
ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,
p_ASSIGN_DATE),
BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR,
BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,
p_ACCEPT_FLAG),
VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE,
FND_API.G_MISS_CHAR,
VEHICLE_RESPONSE_CODE,
p_VEHICLE_RESPONSE_CODE),
TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,
p_TOTAL_SCORE),
SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,
p_SCORECARD_ID),
KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,
p_KEEP_FLAG),
URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,
p_URGENT_FLAG),
IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,
p_IMPORT_FLAG),
REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,
REJECT_REASON_CODE, p_REJECT_REASON_CODE),
DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,
DELETED_FLAG, p_DELETED_FLAG),
OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
QUALIFIED_FLAG, p_QUALIFIED_FLAG),
ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,
ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
-- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
-- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
INCUMBENT_PARTNER_PARTY_ID = decode(p_INC_PARTNER_PARTY_ID,
FND_API.G_MISS_NUM,
INCUMBENT_PARTNER_PARTY_ID,
p_INC_PARTNER_PARTY_ID),
INCUMBENT_PARTNER_RESOURCE_ID = decode(p_INC_PARTNER_RESOURCE_ID,
FND_API.G_MISS_NUM,
INCUMBENT_PARTNER_RESOURCE_ID,
p_INC_PARTNER_RESOURCE_ID),
PRM_EXEC_SPONSOR_FLAG = decode(p_PRM_EXEC_SPONSOR_FLAG,
FND_API.G_MISS_CHAR,
PRM_EXEC_SPONSOR_FLAG,
p_PRM_EXEC_SPONSOR_FLAG),
PRM_PRJ_LEAD_IN_PLACE_FLAG = decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG,
FND_API.G_MISS_CHAR,
PRM_PRJ_LEAD_IN_PLACE_FLAG,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
PRM_SALES_LEAD_TYPE = decode(p_PRM_SALES_LEAD_TYPE,
FND_API.G_MISS_CHAR,
PRM_SALES_LEAD_TYPE,
p_PRM_SALES_LEAD_TYPE),
PRM_IND_CLASSIFICATION_CODE = decode(p_PRM_IND_CLASSIFICATION_CODE,
FND_API.G_MISS_CHAR,
PRM_IND_CLASSIFICATION_CODE,
p_PRM_IND_CLASSIFICATION_CODE),
PRM_ASSIGNMENT_TYPE = decode(p_PRM_ASSIGNMENT_TYPE,
FND_API.G_MISS_CHAR,
PRM_ASSIGNMENT_TYPE,
p_PRM_ASSIGNMENT_TYPE),
AUTO_ASSIGNMENT_TYPE = decode(p_AUTO_ASSIGNMENT_TYPE,
FND_API.G_MISS_CHAR,
AUTO_ASSIGNMENT_TYPE,
p_AUTO_ASSIGNMENT_TYPE),
PRIMARY_CONTACT_PARTY_ID = decode(p_PRIMARY_CONTACT_PARTY_ID,
FND_API.G_MISS_NUM,
PRIMARY_CONTACT_PARTY_ID,
p_PRIMARY_CONTACT_PARTY_ID),
PRIMARY_CNT_PERSON_PARTY_ID = decode(p_PRIMARY_CNT_PERSON_PARTY_ID,
FND_API.G_MISS_NUM,
PRIMARY_CNT_PERSON_PARTY_ID,
p_PRIMARY_CNT_PERSON_PARTY_ID),
PRIMARY_CONTACT_PHONE_ID = decode(p_PRIMARY_CONTACT_PHONE_ID,
FND_API.G_MISS_NUM,
PRIMARY_CONTACT_PHONE_ID,
p_PRIMARY_CONTACT_PHONE_ID),
REFERRED_BY = decode(p_REFERRED_BY,
FND_API.G_MISS_NUM,
REFERRED_BY,
p_REFERRED_BY),
REFERRAL_TYPE = decode(p_REFERRAL_TYPE,
FND_API.G_MISS_CHAR,
REFERRAL_TYPE,
p_REFERRAL_TYPE),
REFERRAL_STATUS = decode(p_REFERRAL_STATUS,
FND_API.G_MISS_CHAR,
REFERRAL_STATUS,
p_REFERRAL_STATUS),
REF_DECLINE_REASON = decode(p_REF_DECLINE_REASON,
FND_API.G_MISS_CHAR,
REF_DECLINE_REASON,
p_REF_DECLINE_REASON),
REF_COMM_LTR_STATUS = decode(p_REF_COMM_LTR_STATUS,
FND_API.G_MISS_CHAR,
REF_COMM_LTR_STATUS,
p_REF_COMM_LTR_STATUS),
REF_ORDER_NUMBER = decode(p_REF_ORDER_NUMBER,
FND_API.G_MISS_NUM,
REF_ORDER_NUMBER,
p_REF_ORDER_NUMBER),
REF_ORDER_AMT = decode(p_REF_ORDER_AMT,
FND_API.G_MISS_NUM,
REF_ORDER_AMT,
p_REF_ORDER_AMT),
REF_COMM_AMT = decode(p_REF_COMM_AMT,
FND_API.G_MISS_NUM,
REF_COMM_AMT,
p_REF_COMM_AMT),
TRUNC_CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
TRUNC_CREATION_DATE, TRUNC(p_CREATION_DATE)),
LEAD_DATE = decode( p_LEAD_DATE , FND_API.G_MISS_DATE,
LEAD_DATE , p_LEAD_DATE ),
SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM , FND_API.G_MISS_CHAR,
SOURCE_SYSTEM , p_SOURCE_SYSTEM ),
COUNTRY = decode( p_COUNTRY , FND_API.G_MISS_CHAR,
COUNTRY , p_COUNTRY ),
TOTAL_AMOUNT = decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM,TOTAL_AMOUNT,p_TOTAL_AMOUNT),
EXPIRATION_DATE = decode( p_EXPIRATION_DATE , FND_API.G_MISS_DATE,
EXPIRATION_DATE , p_EXPIRATION_DATE ),
LEAD_RANK_IND = decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR,LEAD_RANK_IND,p_LEAD_RANK_IND),
LEAD_ENGINE_RUN_DATE = decode( p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE,
LEAD_ENGINE_RUN_DATE , p_LEAD_ENGINE_RUN_DATE ),
CURRENT_REROUTES = decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM,CURRENT_REROUTES,p_CURRENT_REROUTES)
-- new columns for appsperf CRMAP denorm project bug 2928041
, STATUS_OPEN_FLAG = decode( p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR,
STATUS_OPEN_FLAG, p_STATUS_OPEN_FLAG)
, LEAD_RANK_SCORE = decode(p_LEAD_RANK_SCORE,
FND_API.G_MISS_NUM,
LEAD_RANK_SCORE,
p_LEAD_RANK_SCORE)
-- 11.5.10 - ckapoor : new columns
, MARKETING_SCORE = decode( p_MARKETING_SCORE, FND_API.G_MISS_NUM,
MARKETING_SCORE, p_MARKETING_SCORE)
, INTERACTION_SCORE = decode(p_INTERACTION_SCORE,
FND_API.G_MISS_NUM,
INTERACTION_SCORE,
p_INTERACTION_SCORE)
, SOURCE_PRIMARY_REFERENCE = decode( p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR,
SOURCE_PRIMARY_REFERENCE, p_SOURCE_PRIMARY_REFERENCE)
, SOURCE_SECONDARY_REFERENCE = decode(p_SOURCE_SECONDARY_REFERENCE,
FND_API.G_MISS_CHAR,
SOURCE_SECONDARY_REFERENCE,
p_SOURCE_SECONDARY_REFERENCE)
, SALES_METHODOLOGY_ID = decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM,
SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID)
, SALES_STAGE_ID = decode(p_SALES_STAGE_ID,
FND_API.G_MISS_NUM,
SALES_STAGE_ID,
p_SALES_STAGE_ID)
, object_version_number = decode(object_version_number, null, 1, object_version_number+1)
WHERE SALES_LEAD_ID = p_SALES_LEAD_ID;
update as_sales_leads
set object_version_number = decode(l_obj_verno, null, 1, l_obj_verno+1)
where sales_lead_id = p_SALES_LEAD_ID;
END Sales_Lead_Update_Row;
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_LEAD_NUMBER VARCHAR2,
p_STATUS_CODE VARCHAR2,
p_CUSTOMER_ID NUMBER,
p_ADDRESS_ID NUMBER,
p_SOURCE_PROMOTION_ID NUMBER,
p_INITIATING_CONTACT_ID NUMBER,
p_ORIG_SYSTEM_REFERENCE VARCHAR2,
p_CONTACT_ROLE_CODE VARCHAR2,
p_CHANNEL_CODE VARCHAR2,
p_BUDGET_AMOUNT NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_DECISION_TIMEFRAME_CODE VARCHAR2,
p_CLOSE_REASON VARCHAR2,
p_LEAD_RANK_ID NUMBER,
p_LEAD_RANK_CODE VARCHAR2,
p_PARENT_PROJECT VARCHAR2,
p_DESCRIPTION VARCHAR2,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_ASSIGN_TO_PERSON_ID NUMBER,
p_ASSIGN_TO_SALESFORCE_ID NUMBER,
p_ASSIGN_SALES_GROUP_ID NUMBER,
p_ASSIGN_DATE DATE,
p_BUDGET_STATUS_CODE VARCHAR2,
p_ACCEPT_FLAG VARCHAR2,
p_VEHICLE_RESPONSE_CODE VARCHAR2,
p_TOTAL_SCORE NUMBER,
p_SCORECARD_ID NUMBER,
p_KEEP_FLAG VARCHAR2,
p_URGENT_FLAG VARCHAR2,
p_IMPORT_FLAG VARCHAR2,
p_REJECT_REASON_CODE VARCHAR2,
p_DELETED_FLAG VARCHAR2,
p_OFFER_ID NUMBER,
p_QUALIFIED_FLAG VARCHAR2,
p_ORIG_SYSTEM_CODE VARCHAR2,
-- p_SECURITY_GROUP_ID NUMBER,
p_INC_PARTNER_PARTY_ID NUMBER,
p_INC_PARTNER_RESOURCE_ID NUMBER,
p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
p_PRM_SALES_LEAD_TYPE VARCHAR2,
p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
p_PRM_ASSIGNMENT_TYPE VARCHAR2,
p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
p_PRIMARY_CONTACT_PARTY_ID NUMBER,
-- bug 2098158
p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
p_PRIMARY_CONTACT_PHONE_ID NUMBER,
-- new columns for CAPRI lead referral
p_REFERRED_BY NUMBER,
p_REFERRAL_TYPE VARCHAR2,
p_REFERRAL_STATUS VARCHAR2,
p_REF_DECLINE_REASON VARCHAR2,
p_REF_COMM_LTR_STATUS VARCHAR2,
p_REF_ORDER_NUMBER NUMBER,
p_REF_ORDER_AMT NUMBER,
p_REF_COMM_AMT NUMBER,
-- bug No.2341515, 2368075
p_LEAD_DATE DATE ,
p_SOURCE_SYSTEM VARCHAR2,
p_COUNTRY VARCHAR2,
-- 11.5.9
p_TOTAL_AMOUNT NUMBER,
p_EXPIRATION_DATE DATE,
p_LEAD_RANK_IND VARCHAR2,
p_LEAD_ENGINE_RUN_DATE DATE,
p_CURRENT_REROUTES NUMBER
-- new columns for appsperf CRMAP denorm project bug 2928041
, p_STATUS_OPEN_FLAG VARCHAR2,
p_LEAD_RANK_SCORE NUMBER
-- 11.5.10 - ckapoor : new columns
, p_MARKETING_SCORE NUMBER
, p_INTERACTION_SCORE NUMBER
, p_SOURCE_PRIMARY_REFERENCE VARCHAR2
, p_SOURCE_SECONDARY_REFERENCE VARCHAR2
, p_SALES_METHODOLOGY_ID NUMBER
, p_SALES_STAGE_ID NUMBER
)
IS
CURSOR C IS
SELECT *
FROM AS_SALES_LEADS
WHERE SALES_LEAD_ID = p_SALES_LEAD_ID
FOR UPDATE of SALES_LEAD_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
OR ( ( Recinfo.CREATION_DATE IS NULL )
AND ( p_CREATION_DATE IS NULL )))
AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
OR ( ( Recinfo.CREATED_BY IS NULL )
AND ( p_CREATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( p_REQUEST_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( p_PROGRAM_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LEAD_NUMBER = p_LEAD_NUMBER)
OR ( ( Recinfo.LEAD_NUMBER IS NULL )
AND ( p_LEAD_NUMBER IS NULL )))
AND ( ( Recinfo.STATUS_CODE = p_STATUS_CODE)
OR ( ( Recinfo.STATUS_CODE IS NULL )
AND ( p_STATUS_CODE IS NULL )))
AND ( ( Recinfo.CUSTOMER_ID = p_CUSTOMER_ID)
OR ( ( Recinfo.CUSTOMER_ID IS NULL )
AND ( p_CUSTOMER_ID IS NULL )))
AND ( ( Recinfo.ADDRESS_ID = p_ADDRESS_ID)
OR ( ( Recinfo.ADDRESS_ID IS NULL )
AND ( p_ADDRESS_ID IS NULL )))
AND ( ( Recinfo.SOURCE_PROMOTION_ID = p_SOURCE_PROMOTION_ID)
OR ( ( Recinfo.SOURCE_PROMOTION_ID IS NULL )
AND ( p_SOURCE_PROMOTION_ID IS NULL )))
AND ( ( Recinfo.INITIATING_CONTACT_ID = p_INITIATING_CONTACT_ID)
OR ( ( Recinfo.INITIATING_CONTACT_ID IS NULL )
AND ( p_INITIATING_CONTACT_ID IS NULL )))
AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = p_ORIG_SYSTEM_REFERENCE)
OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
AND ( p_ORIG_SYSTEM_REFERENCE IS NULL )))
AND ( ( Recinfo.CONTACT_ROLE_CODE = p_CONTACT_ROLE_CODE)
OR ( ( Recinfo.CONTACT_ROLE_CODE IS NULL )
AND ( p_CONTACT_ROLE_CODE IS NULL )))
AND ( ( Recinfo.CHANNEL_CODE = p_CHANNEL_CODE)
OR ( ( Recinfo.CHANNEL_CODE IS NULL )
AND ( p_CHANNEL_CODE IS NULL )))
AND ( ( Recinfo.BUDGET_AMOUNT = p_BUDGET_AMOUNT)
OR ( ( Recinfo.BUDGET_AMOUNT IS NULL )
AND ( p_BUDGET_AMOUNT IS NULL )))
AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
OR ( ( Recinfo.CURRENCY_CODE IS NULL )
AND ( p_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.DECISION_TIMEFRAME_CODE = p_DECISION_TIMEFRAME_CODE)
OR ( ( Recinfo.DECISION_TIMEFRAME_CODE IS NULL )
AND ( p_DECISION_TIMEFRAME_CODE IS NULL )))
AND ( ( Recinfo.CLOSE_REASON = p_CLOSE_REASON)
OR ( ( Recinfo.CLOSE_REASON IS NULL )
AND ( p_CLOSE_REASON IS NULL )))
AND ( ( Recinfo.LEAD_RANK_ID = p_LEAD_RANK_ID)
OR ( ( Recinfo.LEAD_RANK_ID IS NULL )
AND ( p_LEAD_RANK_ID IS NULL )))
AND ( ( Recinfo.LEAD_RANK_CODE = p_LEAD_RANK_CODE)
OR ( ( Recinfo.LEAD_RANK_CODE IS NULL )
AND ( p_LEAD_RANK_CODE IS NULL )))
AND ( ( Recinfo.PARENT_PROJECT = p_PARENT_PROJECT)
OR ( ( Recinfo.PARENT_PROJECT IS NULL )
AND ( p_PARENT_PROJECT IS NULL )))
AND ( ( Recinfo.DESCRIPTION = p_DESCRIPTION)
OR ( ( Recinfo.DESCRIPTION IS NULL )
AND ( p_DESCRIPTION IS NULL )))
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( p_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( p_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( p_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( p_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( p_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( p_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( p_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( p_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( p_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( p_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( p_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( p_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( p_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( p_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( p_ATTRIBUTE15 IS NULL )))
AND ( ( Recinfo.ASSIGN_TO_PERSON_ID = p_ASSIGN_TO_PERSON_ID)
OR ( ( Recinfo.ASSIGN_TO_PERSON_ID IS NULL )
AND ( p_ASSIGN_TO_PERSON_ID IS NULL )))
AND ( ( Recinfo.ASSIGN_TO_SALESFORCE_ID = p_ASSIGN_TO_SALESFORCE_ID)
OR ( ( Recinfo.ASSIGN_TO_SALESFORCE_ID IS NULL )
AND ( p_ASSIGN_TO_SALESFORCE_ID IS NULL )))
AND ( ( Recinfo.ASSIGN_SALES_GROUP_ID = p_ASSIGN_SALES_GROUP_ID)
OR ( ( Recinfo.ASSIGN_SALES_GROUP_ID IS NULL )
AND ( p_ASSIGN_SALES_GROUP_ID IS NULL )))
AND ( ( Recinfo.ASSIGN_DATE = p_ASSIGN_DATE)
OR ( ( Recinfo.ASSIGN_DATE IS NULL )
AND ( p_ASSIGN_DATE IS NULL )))
AND ( ( Recinfo.BUDGET_STATUS_CODE = p_BUDGET_STATUS_CODE)
OR ( ( Recinfo.BUDGET_STATUS_CODE IS NULL )
AND ( p_BUDGET_STATUS_CODE IS NULL )))
AND ( ( Recinfo.ACCEPT_FLAG = p_ACCEPT_FLAG)
OR ( ( Recinfo.ACCEPT_FLAG IS NULL )
AND ( p_ACCEPT_FLAG IS NULL )))
AND ( ( Recinfo.VEHICLE_RESPONSE_CODE = p_VEHICLE_RESPONSE_CODE)
OR ( ( Recinfo.VEHICLE_RESPONSE_CODE IS NULL )
AND ( p_VEHICLE_RESPONSE_CODE IS NULL )))
AND ( ( Recinfo.TOTAL_SCORE = p_TOTAL_SCORE)
OR ( ( Recinfo.TOTAL_SCORE IS NULL )
AND ( p_TOTAL_SCORE IS NULL )))
AND ( ( Recinfo.SCORECARD_ID = p_SCORECARD_ID)
OR ( ( Recinfo.SCORECARD_ID IS NULL )
AND ( p_SCORECARD_ID IS NULL )))
AND ( ( Recinfo.KEEP_FLAG = p_KEEP_FLAG)
OR ( ( Recinfo.KEEP_FLAG IS NULL )
AND ( p_KEEP_FLAG IS NULL )))
AND ( ( Recinfo.URGENT_FLAG = p_URGENT_FLAG)
OR ( ( Recinfo.URGENT_FLAG IS NULL )
AND ( p_URGENT_FLAG IS NULL )))
AND ( ( Recinfo.IMPORT_FLAG = p_IMPORT_FLAG)
OR ( ( Recinfo.IMPORT_FLAG IS NULL )
AND ( p_IMPORT_FLAG IS NULL )))
AND ( ( Recinfo.REJECT_REASON_CODE = p_REJECT_REASON_CODE)
OR ( ( Recinfo.REJECT_REASON_CODE IS NULL )
AND ( p_REJECT_REASON_CODE IS NULL )))
AND ( ( Recinfo.DELETED_FLAG = p_DELETED_FLAG)
OR ( ( Recinfo.DELETED_FLAG IS NULL )
AND ( p_DELETED_FLAG IS NULL )))
AND ( ( Recinfo.OFFER_ID = p_OFFER_ID)
OR ( ( Recinfo.OFFER_ID IS NULL )
AND ( p_OFFER_ID IS NULL )))
AND ( ( Recinfo.QUALIFIED_FLAG = p_QUALIFIED_FLAG)
OR ( ( Recinfo.QUALIFIED_FLAG IS NULL )
AND ( p_QUALIFIED_FLAG IS NULL )))
AND ( ( Recinfo.ORIG_SYSTEM_CODE = p_ORIG_SYSTEM_CODE)
OR ( ( Recinfo.ORIG_SYSTEM_CODE IS NULL )
AND ( p_ORIG_SYSTEM_CODE IS NULL )))
-- AND ( ( Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
-- OR ( ( Recinfo.SECURITY_GROUP_ID IS NULL )
-- AND ( p_SECURITY_GROUP_ID IS NULL )))
AND ( (Recinfo.INCUMBENT_PARTNER_PARTY_ID=p_INC_PARTNER_PARTY_ID)
OR ( ( Recinfo.INCUMBENT_PARTNER_PARTY_ID IS NULL )
AND ( p_INC_PARTNER_PARTY_ID IS NULL )))
AND ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID =
p_INC_PARTNER_RESOURCE_ID)
OR ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID IS NULL )
AND ( p_INC_PARTNER_RESOURCE_ID IS NULL )))
AND ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG =
p_PRM_EXEC_SPONSOR_FLAG)
OR ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG IS NULL )
AND ( p_PRM_EXEC_SPONSOR_FLAG IS NULL )))
AND ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG =
p_PRM_PRJ_LEAD_IN_PLACE_FLAG)
OR ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )
AND ( p_PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )))
AND ( ( Recinfo.PRM_SALES_LEAD_TYPE =
p_PRM_SALES_LEAD_TYPE)
OR ( ( Recinfo.PRM_SALES_LEAD_TYPE IS NULL )
AND ( p_PRM_SALES_LEAD_TYPE IS NULL )))
AND ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE =
p_PRM_IND_CLASSIFICATION_CODE)
OR ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE IS NULL )
AND ( p_PRM_IND_CLASSIFICATION_CODE IS NULL )))
AND ( ( Recinfo.PRM_ASSIGNMENT_TYPE =
p_PRM_ASSIGNMENT_TYPE)
OR ( ( Recinfo.PRM_ASSIGNMENT_TYPE IS NULL )
AND ( p_PRM_ASSIGNMENT_TYPE IS NULL )))
AND ( ( Recinfo.AUTO_ASSIGNMENT_TYPE =
p_AUTO_ASSIGNMENT_TYPE)
OR ( ( Recinfo.AUTO_ASSIGNMENT_TYPE IS NULL )
AND ( p_AUTO_ASSIGNMENT_TYPE IS NULL )))
AND ( ( Recinfo.PRIMARY_CONTACT_PARTY_ID =
p_PRIMARY_CONTACT_PARTY_ID)
OR ( ( Recinfo.PRIMARY_CONTACT_PARTY_ID IS NULL )
AND ( p_PRIMARY_CONTACT_PARTY_ID IS NULL )))
AND ( ( Recinfo.PRIMARY_CNT_PERSON_PARTY_ID =
p_PRIMARY_CNT_PERSON_PARTY_ID)
OR ( ( Recinfo.PRIMARY_CNT_PERSON_PARTY_ID IS NULL )
AND ( p_PRIMARY_CNT_PERSON_PARTY_ID IS NULL )))
AND ( ( Recinfo.PRIMARY_CONTACT_PHONE_ID =
p_PRIMARY_CONTACT_PHONE_ID)
OR ( ( Recinfo.PRIMARY_CONTACT_PHONE_ID IS NULL )
AND ( p_PRIMARY_CONTACT_PHONE_ID IS NULL )))
AND ( ( Recinfo.REFERRED_BY =
p_REFERRED_BY)
OR ( ( Recinfo.REFERRED_BY IS NULL )
AND ( p_REFERRED_BY IS NULL )))
AND ( ( Recinfo.REFERRAL_TYPE =
p_REFERRAL_TYPE)
OR ( ( Recinfo.REFERRAL_TYPE IS NULL )
AND ( p_REFERRAL_TYPE IS NULL )))
AND ( ( Recinfo.REFERRAL_STATUS =
p_REFERRAL_STATUS)
OR ( ( Recinfo.REFERRAL_STATUS IS NULL )
AND ( p_REFERRAL_STATUS IS NULL )))
AND ( ( Recinfo.REF_DECLINE_REASON =
p_REF_DECLINE_REASON)
OR ( ( Recinfo.REF_DECLINE_REASON IS NULL )
AND ( p_REF_DECLINE_REASON IS NULL )))
AND ( ( Recinfo.REF_COMM_LTR_STATUS =
p_REF_COMM_LTR_STATUS)
OR ( ( Recinfo.REF_COMM_LTR_STATUS IS NULL )
AND ( p_REF_COMM_LTR_STATUS IS NULL )))
AND ( ( Recinfo.REF_ORDER_NUMBER =
p_REF_ORDER_NUMBER)
OR ( ( Recinfo.REF_ORDER_NUMBER IS NULL )
AND ( p_REF_ORDER_NUMBER IS NULL )))
AND ( ( Recinfo.REF_ORDER_AMT =
p_REF_ORDER_AMT)
OR ( ( Recinfo.REF_ORDER_AMT IS NULL )
AND ( p_REF_ORDER_AMT IS NULL )))
AND ( ( Recinfo.REF_COMM_AMT =
p_REF_COMM_AMT)
OR ( ( Recinfo.REF_COMM_AMT IS NULL )
AND ( p_REF_COMM_AMT IS NULL )))
AND ( ( Recinfo.LEAD_DATE =
p_LEAD_DATE)
OR ( ( Recinfo.LEAD_DATE IS NULL )
AND ( p_LEAD_DATE IS NULL )))
AND ( ( Recinfo.SOURCE_SYSTEM =
p_SOURCE_SYSTEM)
OR ( ( Recinfo.SOURCE_SYSTEM IS NULL )
AND ( p_SOURCE_SYSTEM IS NULL )))
AND ( ( Recinfo.COUNTRY =
p_COUNTRY)
OR ( ( Recinfo.COUNTRY IS NULL )
AND ( p_COUNTRY IS NULL )))
AND ( ( Recinfo.TOTAL_AMOUNT =
p_TOTAL_AMOUNT)
OR ( ( Recinfo.TOTAL_AMOUNT IS NULL )
AND ( p_TOTAL_AMOUNT IS NULL )))
AND ( ( Recinfo.EXPIRATION_DATE =
p_EXPIRATION_DATE)
OR ( ( Recinfo.EXPIRATION_DATE IS NULL )
AND ( p_EXPIRATION_DATE IS NULL )))
AND ( ( Recinfo.LEAD_RANK_IND =
p_LEAD_RANK_IND)
OR ( ( Recinfo.LEAD_RANK_IND IS NULL )
AND ( p_LEAD_RANK_IND IS NULL )))
AND ( ( Recinfo.LEAD_ENGINE_RUN_DATE =
p_LEAD_ENGINE_RUN_DATE)
OR ( ( Recinfo.LEAD_ENGINE_RUN_DATE IS NULL )
AND ( p_LEAD_ENGINE_RUN_DATE IS NULL )))
AND ( ( Recinfo.CURRENT_REROUTES =
p_CURRENT_REROUTES )
OR ( ( Recinfo.CURRENT_REROUTES IS NULL )
AND ( p_CURRENT_REROUTES IS NULL )))
-- new columns for appsperf CRMAP denorm project bug 2928041
AND ( ( Recinfo.STATUS_OPEN_FLAG = p_STATUS_OPEN_FLAG )
OR ( ( Recinfo.STATUS_OPEN_FLAG IS NULL )
AND ( p_STATUS_OPEN_FLAG IS NULL )))
AND ( ( Recinfo.LEAD_RANK_SCORE =
p_LEAD_RANK_SCORE )
OR ( ( Recinfo.LEAD_RANK_SCORE IS NULL )
AND ( p_LEAD_RANK_SCORE IS NULL )))
-- 11.5.10 - ckapoor : new columns
AND ( ( Recinfo.MARKETING_SCORE = p_MARKETING_SCORE )
OR ( ( Recinfo.MARKETING_SCORE IS NULL )
AND ( p_MARKETING_SCORE IS NULL )))
AND ( ( Recinfo.INTERACTION_SCORE =
p_INTERACTION_SCORE )
OR ( ( Recinfo.INTERACTION_SCORE IS NULL )
AND ( p_INTERACTION_SCORE IS NULL )))
AND ( ( Recinfo.SOURCE_PRIMARY_REFERENCE = p_SOURCE_PRIMARY_REFERENCE )
OR ( ( Recinfo.SOURCE_PRIMARY_REFERENCE IS NULL )
AND ( p_SOURCE_PRIMARY_REFERENCE IS NULL )))
AND ( ( Recinfo.SOURCE_SECONDARY_REFERENCE =
p_SOURCE_SECONDARY_REFERENCE )
OR ( ( Recinfo.SOURCE_SECONDARY_REFERENCE IS NULL )
AND ( p_SOURCE_SECONDARY_REFERENCE IS NULL )))
AND ( ( Recinfo.SALES_METHODOLOGY_ID = p_SALES_METHODOLOGY_ID )
OR ( ( Recinfo.SALES_METHODOLOGY_ID IS NULL )
AND ( p_SALES_METHODOLOGY_ID IS NULL )))
AND ( ( Recinfo.SALES_STAGE_ID =
p_SALES_STAGE_ID )
OR ( ( Recinfo.SALES_STAGE_ID IS NULL )
AND ( p_SALES_STAGE_ID IS NULL )))
) then
return;