DBA Data[Home] [Help]

PACKAGE: APPS.AS_IMPORT_SL_PVT

Source


1 package as_import_sl_pvt as
2 /* $Header: asxslims.pls 120.1 2006/01/18 11:29:22 solin noship $ */
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;