1: PACKAGE MSC_CL_CONT_COLL_FW AUTHID CURRENT_USER 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
1: PACKAGE MSC_CL_CONT_COLL_FW AUTHID CURRENT_USER 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:
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:
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;
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 ;
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;
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;
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;
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:
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;
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;
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:
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,
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,
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,
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: