325: PROCEDURE Validate_sales_lead(
326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: P_Validation_mode IN VARCHAR2,
329: P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
330: P_Referral_type IN VARCHAR2,
331: P_Referred_By IN NUMBER,
332: X_Return_Status OUT NOCOPY VARCHAR2,
333: X_Msg_Count OUT NOCOPY NUMBER,
351: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
352: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
353: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
354: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
355: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
352: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
353: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
354: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
355: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
353: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
354: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
355: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
354: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
355: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362: X_SALES_LEAD_LINE_OUT_Tbl OUT
355: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362: X_SALES_LEAD_LINE_OUT_Tbl OUT
363: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
356: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357: P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362: X_SALES_LEAD_LINE_OUT_Tbl OUT
363: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
364: X_SALES_LEAD_CNT_OUT_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_tbl_Type,
359: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362: X_SALES_LEAD_LINE_OUT_Tbl OUT
363: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
364: X_SALES_LEAD_CNT_OUT_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_tbl_Type,
365: X_Return_Status OUT NOCOPY VARCHAR2,
366: X_Msg_Count OUT NOCOPY NUMBER,
367: X_Msg_Data OUT NOCOPY VARCHAR2
360: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362: X_SALES_LEAD_LINE_OUT_Tbl OUT
363: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
364: X_SALES_LEAD_CNT_OUT_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_tbl_Type,
365: X_Return_Status OUT NOCOPY VARCHAR2,
366: X_Msg_Count OUT NOCOPY NUMBER,
367: X_Msg_Data OUT NOCOPY VARCHAR2
368: );
380: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
381: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
382: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
383: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
384: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
385: -- P_Calling_From_WF_Flag IN VARCHAR2 := 'N',
386: X_Return_Status OUT NOCOPY VARCHAR2,
387: X_Msg_Count OUT NOCOPY NUMBER,
388: X_Msg_Data OUT NOCOPY VARCHAR2
412: /*
413: This function is decomissioned
414:
415: FUNCTION IS_LEAD_QUALIFIED(
416: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
417: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
418: P_phone_id IN NUMBER := FND_API.G_MISS_NUM,
419: P_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
420: ) RETURN VARCHAR;
413: This function is decomissioned
414:
415: FUNCTION IS_LEAD_QUALIFIED(
416: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
417: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
418: P_phone_id IN NUMBER := FND_API.G_MISS_NUM,
419: P_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
420: ) RETURN VARCHAR;
421: */