DBA Data[Home] [Help]

PACKAGE: APPS.MSC_CL_CONT_COLL_FW

Source


1 PACKAGE MSC_CL_CONT_COLL_FW AS -- specification
2 /* $Header: MSCCONTS.pls 120.1 2007/04/12 06:33:10 vpalla noship $ */
3 
4  --  SYS_YES                       NUMBER := MSC_UTIL.SYS_YES;
5  --  SYS_NO                        NUMBER := MSC_UTIL.SYS_NO   ;
6 
7  --  SYS_INCR                      NUMBER := MSC_UTIL.SYS_INCR; -- incr refresh
8  --  SYS_TGT                       NUMBER := MSC_UTIL.SYS_TGT; -- targeted refresh
9 
10  --  G_CONT                       CONSTANT NUMBER := MSC_UTIL.G_CONT       ;
11 
12 --   G_SUCCESS                     NUMBER := MSC_UTIL.G_SUCCESS;
13 --   G_WARNING                     NUMBER := MSC_UTIL.G_WARNING;
14 --   G_ERROR                       NUMBER := MSC_UTIL.G_ERROR  ;
15 
16 --   G_APPS107                     NUMBER := MSC_UTIL.G_APPS107;
17 --   G_APPS110                     NUMBER := MSC_UTIL.G_APPS110;
18 --   G_APPS115                     NUMBER := MSC_UTIL.G_APPS115;
19 --   G_APPS120                     NUMBER := MSC_UTIL.G_APPS120;
20 
21  --  G_ALL_ORGANIZATIONS     CONSTANT NUMBER := MSC_UTIL.G_ALL_ORGANIZATIONS;
22   -- v_process_org_present        NUMBER ;--:= MSC_UTIL.SYS_NO;
23 
24 PROCEDURE init_entity_refresh_type(p_coll_thresh              in  number,
25                                    p_coll_freq                in  number,
26                                    p_last_tgt_cont_coll_time  in  date,
27                                    p_dblink                   in  varchar2,
28                                    p_instance_id              in  number,
29                                    prec                       in  MSC_UTIL.CollParamREC,
30 				   p_org_group                in varchar2,
31                                    p_bom_sn_flag              out NOCOPY number,
32                                    p_bor_sn_flag              out NOCOPY number,
33                                    p_item_sn_flag             out NOCOPY number,
34                                    p_oh_sn_flag               out NOCOPY number,
35                                    p_usup_sn_flag             out NOCOPY number,
36                                    p_udmd_sn_flag             out NOCOPY number,
37                                    p_so_sn_flag               out NOCOPY number,
38                                    p_fcst_sn_flag             out NOCOPY number,
39                                    p_wip_sn_flag              out NOCOPY number,
40                                    p_supcap_sn_flag           out NOCOPY number,
41                                    p_po_sn_flag               out NOCOPY number,
42                                    p_mds_sn_flag              out NOCOPY number,
43                                    p_mps_sn_flag              out NOCOPY number,
44                                    p_nosnap_flag              out NOCOPY number,
45                                    p_suprep_sn_flag           in out NOCOPY number,
46                                    p_trip_sn_flag             out NOCOPY number);
47 
48    FUNCTION set_cont_refresh_type (p_instance_id in NUMBER,
49                                    p_task_num    in NUMBER,
50                                    prec          in MSC_UTIL.CollParamREC,
51                                    p_lrnn        in number,
52                                    p_cont_lrnn   out NOCOPY number)
53    RETURN BOOLEAN;
54 
55 -- Entry point for continuous collections
56 
57 
58 
59     FUNCTION set_cont_refresh_type_ODS(p_task_num               in  NUMBER,
60                                   prec                     in  MSC_CL_EXCHANGE_PARTTBL.CollParamRec,
61                                   p_is_incremental_refresh out NOCOPY boolean,
62                                   p_is_partial_refresh     out NOCOPY boolean,
63 				  p_exchange_mode          OUT  NOCOPY number)
64         return boolean;
65 
66 
67 END MSC_CL_CONT_COLL_FW;