34: -- THis procedure is used for creating a lead/opportunity for a referral.
35: -- ------------------------------------------------------------------------
36: PROCEDURE Create_Lead_Opportunity (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41: p_referral_id IN NUMBER,
42: p_customer_party_id IN NUMBER := NULL,
35: -- ------------------------------------------------------------------------
36: PROCEDURE Create_Lead_Opportunity (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41: p_referral_id IN NUMBER,
42: p_customer_party_id IN NUMBER := NULL,
43: p_customer_party_site_id IN NUMBER := NULL,
36: PROCEDURE Create_Lead_Opportunity (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41: p_referral_id IN NUMBER,
42: p_customer_party_id IN NUMBER := NULL,
43: p_customer_party_site_id IN NUMBER := NULL,
44: p_customer_org_contact_id IN NUMBER := NULL,
54:
55:
56: PROCEDURE Link_Lead_Opportunity (
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_referral_id IN VARCHAR2,
62: p_entity_type IN VARCHAR2, -- 'LEAD', 'SALES_LEAD'
55:
56: PROCEDURE Link_Lead_Opportunity (
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_referral_id IN VARCHAR2,
62: p_entity_type IN VARCHAR2, -- 'LEAD', 'SALES_LEAD'
63: p_entity_id IN NUMBER,
56: PROCEDURE Link_Lead_Opportunity (
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_referral_id IN VARCHAR2,
62: p_entity_type IN VARCHAR2, -- 'LEAD', 'SALES_LEAD'
63: p_entity_id IN NUMBER,
64: x_a_link_already_exists OUT NOCOPY VARCHAR2,