[Home] [Help]
PACKAGE: APPS.AMS_SCR_LEAD_PVT
Source
1 PACKAGE AMS_SCR_LEAD_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvslds.pls 115.2 2002/12/26 09:41:58 sodixit noship $ */
3 -- ===============================================================
4 -- Package name
5 -- AMS_SCR_LEAD_PVT
6 -- Purpose
7 -- This package contains APIs used for creating Sales Lead
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- ===============================================================
14
15 -- Default number of records fetch per call
16 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
17
18 TYPE scr_lead_rec_type IS RECORD
19 (
20 party_id NUMBER,
21 FIRST_NAME VARCHAR2(150),
22 LAST_NAME VARCHAR2(150),
23 ORGANIZATION VARCHAR2(255),
24 JOB_TITLE VARCHAR2(50),
25 EMAIL_ADDRESS VARCHAR2(240),
26 DAY_AREA_CODE VARCHAR2(10),
27 DAY_PHONE_NUMBER VARCHAR2(25),
28 DAY_EXTENSION VARCHAR2(20),
29 ADDRESS1 VARCHAR2(240),
30 ADDRESS2 VARCHAR2(240),
31 ADDRESS3 VARCHAR2(240),
32 ADDRESS4 VARCHAR2(240),
33 CITY VARCHAR2(60),
34 STATE VARCHAR2(60),
35 COUNTRY VARCHAR2(60),
36 POSTAL_CODE VARCHAR2(60),
37 INTEREST_TYPE NUMBER,
38 PURCHASING_TIME_FRAME Varchar2(30),
39 BUDGET_STATUS_CODE Varchar2(30),
40 BUDGET_AMOUNT NUMBER,
41 BUDGET_CURRENCY_CODE VARCHAR2(30),
42 CONTACT_ROLE_CODE Varchar2(30)
43 );
44
45 g_miss_lead_rec scr_lead_rec_type;
46
47 --===================================================================
48 -- API Name
49 -- CREATE_SALES_LEAD
50 -- Type
51 -- Private
52 -- Pre-Req
53 --
54 -- Parameters
55 --
56 -- IN
57 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
58 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
59 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
60 -- p_flow_component_id IN Number
61 --
62 -- OUT
63 -- x_return_status OUT VARCHAR2
64 -- x_msg_count OUT NUMBER
65 -- x_msg_data OUT VARCHAR2
66 -- ==============================================================================
67 --
68
69 PROCEDURE CREATE_SALES_LEAD(
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_party_type IN VARCHAR2,
74 p_scr_lead_rec IN scr_lead_rec_type := g_miss_lead_rec,
75 p_camp_sch_source_code IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_party_id IN NUMBER,
80 p_org_party_id IN NUMBER,
81 p_org_rel_party_id IN NUMBER
82 );
83
84 END AMS_SCR_LEAD_PVT;