1 package PV_REFERRAL_GENERAL_PUB AUTHID CURRENT_USER as
2 /* $Header: pvxvrfgs.pls 115.4 2004/03/05 19:22:51 pklin ship $*/
3
4 -- ============================================================================
5 --
6 -- Global Variables
7 --
8 -- ============================================================================
9
10 -- ============================================================================
11 --
12 -- Public Procedures
13 --
14 -- ============================================================================
15
16 -- ------------------------------------------------------------------------
17 -- Update_Referral_Status
18 --
19 -- This is to be called by a concurrent program, PV_UPDATE_REFERRAL_STATUS,
20 -- (PV - Update Referral Status)
21 -- to update the referral status to one of the following four statuses:
22 -- CLOSED_LOST_OPPTY, CLOSED_OPPTY_WON, CLOSED_DEAD_LEAD, EXPIRED.
23 -- ------------------------------------------------------------------------
24 PROCEDURE Update_Referral_Status (
25 ERRBUF OUT NOCOPY VARCHAR2,
26 RETCODE OUT NOCOPY VARCHAR2,
27 p_log_to_file IN VARCHAR2 := 'Y'
28 );
29
30
31 -- ------------------------------------------------------------------------
32 -- Create_Lead_Opportunity
33 --
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,
43 p_customer_party_site_id IN NUMBER := NULL,
44 p_customer_org_contact_id IN NUMBER := NULL,
45 p_customer_contact_party_id IN NUMBER := NULL,
46 p_get_from_db_flag IN VARCHAR2 := 'Y',
47 x_entity_type OUT NOCOPY VARCHAR2,
48 x_entity_id OUT NOCOPY NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
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'
63 p_entity_id IN NUMBER,
64 x_a_link_already_exists OUT NOCOPY VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71 END PV_REFERRAL_GENERAL_PUB;