1 PACKAGE AS_IMPORT_SL_CUHK AUTHID CURRENT_USER AS
2 /* $Header: asxcslis.pls 120.1.12020000.2 2013/05/22 10:18:32 snsarava ship $ */
3
4 -- Start of Comments
5 -- Package Name : AS_IMPORT_SL_CUHK
6 --
7 -- Purpose : While importing leads, the lead import program does not
8 -- verify whether such a lead exist in Oracle Sales or not.
9 -- i.e. it will create duplicate entities in Oracle Sales
10 -- if the lead already exist.
11 -- If user want to implement custom lead existence checking
12 -- logic, then write a package body for this spec.
13 --
14 -- NOTE : User's lead existence checking should check if lead
15 -- is duplicate or not and base on the returned value, Oracle
16 -- lead import program will either create a new lead or skip
17 -- that particular lead import record. If the record is
18 -- skipped then no lead will be created and load_status
19 -- of that lead import record will be set to 'DUPLICATE'.
20 --
21 -- Please do not 'commit' in the package body. Once the
22 -- transaction is completed, Oracle Application code will
23 -- issue a commit.
24 --
25 -- This user hook will be called in lead import program.
26 -- The calling package: AS_IMPORT_SL_PVT.Is_Duplicate_Lead
27 --
28 -- History :
29 -- 08/14/2001 SOLIN Created
30 -- End of Comments
31
32 /*-------------------------------------------------------------------------*
33 |
34 | PUBLIC CONSTANTS
35 |
36 *-------------------------------------------------------------------------*/
37
38 /*-------------------------------------------------------------------------*
39 |
40 | PUBLIC DATATYPES
41 |
42 *-------------------------------------------------------------------------*/
43
44 /*-------------------------------------------------------------------------*
45 |
46 | PUBLIC VARIABLES
47 |
48 *-------------------------------------------------------------------------*/
49
50 /*-------------------------------------------------------------------------*
51 |
52 | PUBLIC ROUTINES
53 |
54 *-------------------------------------------------------------------------*/
55
56 -- Start of Comments
57 --
58 -- API name : Is_Duplicate_Lead_Pre
59 -- Parameters :
60 -- IN :
61 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
62 -- p_init_msg_list : Initialize message stack or not. It's
63 -- FND_API.G_FALSE by default.
64 -- p_validation_level : Validation level for pass-in values.
65 -- It's FND_API.G_VALID_LEVEL_FULL by default.
66 -- p_commit : Whether commit the whole API at the end of API.
67 -- It's FND_API.G_FALSE by default.
68 --
69 -- The above four parameters are standard input.
70 -- p_import_interface_id:
71 -- This is the import interface identifier.
72 -- Pass into import_interface_id ofthe lead import
73 -- record for which you want to perform the lead
74 -- existence checking.
75 -- OUT :
76 -- x_duplicate_flag :
77 -- If this flag is 'Y', means this lead import
78 -- record is duplicate and do not import the lead;
79 -- 'N' means such a lead does not exist and lead
80 -- will be imported.
81 -- x_return_status :
82 -- The return status. If your code completes
83 -- successfully, then FND_API.G_RET_STS_SUCCESS
84 -- should be returned; if you get an expected error,
85 -- then return FND_API.G_RET_STS_ERROR; otherwise
86 -- return FND_API.G_RET_STS_UNEXP_ERROR.
87 -- x_msg_count :
88 -- The message count.
89 -- Call FND_MSG_PUB.Count_And_Get to get the message
90 -- count and messages.
91 -- x_msg_data :
92 -- The messages.
93 -- Call FND_MSG_PUB.Count_And_Get to get the message
94 -- count and messages.
95 --
96 -- The above three parameters are standard output
97 -- parameters.
98 --
99 --
100 PROCEDURE Is_Duplicate_Lead_Pre(
101 p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_import_interface_id IN NUMBER,
106 x_duplicate_flag OUT NOCOPY VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2);
110
111 END AS_IMPORT_SL_CUHK;
112