1 PACKAGE AML_SALES_LEADS_V2_PUB AUTHID CURRENT_USER as
2 /* $Header: amlpasls.pls 120.1 2005/11/07 16:09:32 solin noship $*/
3 /*#
4 * This package provides consolidated methods to create leads and supported
5 * entities for Oracle Leads Management.
6 * @rep:scope public
7 * @rep:product AMS
8 * @rep:lifecycle active
9 * @rep:displayname Oracle Leads Management Public Wrapper API
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY AMS_LEAD
12 */
13
14
15 -- Start of Comments
16 -- Package name : AML_SALES_LEADS_V2_PUB
17 -- Purpose : Sales Leads Management
18 -- NOTE :
19 -- History :
20 -- 08/27/2003 AANJARIA Created.
21 -- End of Comments
22
23
24 -- Main procedure to create lead, process it and create other related
25 -- entities like interest and notes
26
27 /*#
28 * This procedure creates a lead and supported entities. The details of lead,
29 * product interest, and contact will be passed in p_sales_lead_rec, p_sales_lead_line_tbl,
30 * and p_sales_lead_contact_tbl, respectively. Check x_return_status output to see if creation
31 * was successful. If successful, a unique identifier for the lead object will be passed back
32 * to the x_sales_lead_id output parameter.
33 * @param p_api_version_number API version
34 * @param p_init_msg_list Initialize message list
35 * @param p_commit Commit after update
36 * @param p_validation_level Validation level for the record details
37 * @param p_check_access_flag Check access flag
38 * @param p_admin_flag Admin flag to denote admin responsibility
39 * @param p_admin_group_id Admin group id
40 * @param p_identity_salesforce_id Salesforce_id of the lead creator
41 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
42 * @param p_sales_lead_rec Record containing leads attributes
43 * @param p_sales_lead_line_tbl Table containing lead lines records
44 * @param p_sales_lead_contact_tbl Table containing contacts for the lead
45 * @param p_lead_note Lead note
46 * @param p_note_type Lead note type
47 * @param x_sales_lead_id Generated Sales Lead Id
48 * @param x_sales_lead_line_out_tbl Generated Sales Lead Line Id
49 * @param x_sales_lead_cnt_out_tbl Generated Sales Lead Contact Id
50 * @param x_note_id Generate lead note id
51 * @param x_return_status Status of the create operation
52 * @param x_msg_count Number of the error messages returned
53 * @param x_msg_data Error messages
54 * @rep:scope public
55 * @rep:lifecycle active
56 * @rep:displayname Create Sales Lead
57 */
58 PROCEDURE Create_sales_lead (
59 P_Api_Version_Number IN NUMBER,
60 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
61 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
62 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
66 P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
67 P_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,
68 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
69 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
70 P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
71 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
72 P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
73 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
74 P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
75 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
76 P_Lead_note IN VARCHAR2 DEFAULT NULL,
77 P_Note_type IN VARCHAR2 DEFAULT NULL,
78 X_SALES_LEAD_ID OUT NOCOPY NUMBER,
79 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
80 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
81 X_note_id OUT NOCOPY NUMBER,
82 X_Return_Status OUT NOCOPY VARCHAR2,
83 X_Msg_Count OUT NOCOPY NUMBER,
84 X_Msg_Data OUT NOCOPY VARCHAR2
85 );
86
87 END AML_SALES_LEADS_V2_PUB;