[Home] [Help]
PACKAGE: APPS.AS_IMPORT_SL_PVT
Source
1 package as_import_sl_pvt AUTHID CURRENT_USER as
2 /* $Header: asxslims.pls 120.1.12020000.2 2013/05/21 05:57:58 snsarava ship $ */
3
4 log_fpt constant number := 1; -- log file pointer
5 output_fpt constant number := 2; -- output file pointer
6 G_LOAD_STATUS_SUCC CONSTANT VARCHAR2(20) := 'SUCCESS';
7 G_LOAD_STATUS_ERR CONSTANT VARCHAR2(20) := 'ERROR';
8 G_LOAD_STATUS_UNEXP_ERR CONSTANT VARCHAR2(20) := 'UNEXP_ERROR';
9 G_api_version CONSTANT NUMBER := 1.0;
10 G_as_api_version CONSTANT NUMBER := 2.0; -- crm apis are of version 2
11 G_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS; -- default is success
12 G_mesg_count NUMBER := 0;
13 G_msg_data VARCHAR2(2000) := Null;
14 G_DEBUGFLAG VARCHAR2(1) := 'N'; -- Y - Yes, N - No
15
16 l_status boolean:=false;
17 l_ignore boolean:=false;
18
19 procedure main(
20 errbuf varchar2,
21 errcode varchar2,
22 p_source_system in varchar2,
23 --p_creation_date in date, -- bugfix : 2044447
24 p_debug_msg_flag in varchar2 := 'N',--bugfix : 2047689
25 p_batch_id in number,
26 p_purge_error_flag in varchar2 := 'N',
27 p_parent_request_id in number := NULL,
28 p_child_request_id in number := NULL,
29 p_resource_id in number := NULL, -- SOLIN, bug 4702335
30 p_group_id in number := NULL -- SOLIN, bug 4702335
31
32 );
33
34 procedure do_lead_import(
35 -- errbuf varchar2,
36 -- errcode varchar2,
37 p_source_system in varchar2,
38 p_debug_msg_flag in varchar2 := 'N',--bugfix : 2047689
39 p_parent_request_id in number,
40 p_child_request_id in number,
41 p_resource_id in number, -- SOLIN, bug 4702335
42 p_group_id in number -- SOLIN, bug 4702335
43
44 );
45
46 end as_import_sl_pvt;