[Home] [Help]
PACKAGE: APPS.PN_EXP_TO_CAD_ITF
Source
1 package PN_EXP_TO_CAD_ITF AUTHID CURRENT_USER as
2 -- $Header: PNTXPCDS.pls 115.12 2003/01/25 22:01:50 kkhegde ship $
3
4 --------------------------------------------------------------------------
5 -- For Exporting to CAD Interface
6 -- ( Loading Locations/Space_Allocations Info into the Interface Tables )
7 -- ( Run as a Conc Process )
8 --------------------------------------------------------------------------
9 PROCEDURE exp_to_cad_itf (
10 errbuf out NOCOPY varchar2 ,
11 retcode out NOCOPY varchar2 ,
12 locn_or_spc_flag in varchar2 ,
13 p_batch_name in varchar2 ,
14 p_locn_type in varchar2 ,
15 p_locn_code_from in varchar2 ,
16 p_locn_code_to in varchar2 ,
17 p_last_update_from in varchar2 ,
18 p_last_update_to in varchar2 ,
19 p_as_of_date in varchar2 default NULL
20 );
21
22
23 -------------------------------------------------------------------
24 -- For loading Locations Info into the Interface Table ( for CAD )
25 -- ( Called from EXP_TO_CAD procedure above )
26 -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )
27 -------------------------------------------------------------------
28 PROCEDURE exp_loc_to_cad_itf (
29 p_batch_name in varchar2 ,
30 p_locn_type in varchar2 ,
31 p_locn_code_from in varchar2 ,
32 p_locn_code_to in varchar2 ,
33 p_last_update_from in varchar2 ,
34 p_last_update_to in varchar2 ,
35 p_as_of_date IN varchar2 default sysdate
36 );
37
38
39 ---------------------------------------------------------------------------
40 -- For loading Space Allocations Info into the Interface Table ( for CAD )
41 -- ( Called from EXP_TO_CAD procedure above )
42 -- ( PN_SPACE_ALLOCATIONS --> PN_SPACE_ALLOC_ITF )
43 ---------------------------------------------------------------------------
44 PROCEDURE exp_spc_to_cad_itf (
45 p_batch_name in varchar2 ,
46 p_locn_type in varchar2 ,
47 p_locn_code_from in varchar2 ,
48 p_locn_code_to in varchar2 ,
49 p_last_update_from in varchar2 ,
50 p_last_update_to in varchar2 ,
51 p_as_of_date in varchar2
52 );
53
54
55 END PN_EXP_TO_CAD_ITF;