[Home] [Help]
PACKAGE: APPS.MRP_CL_REFRESH_SNAPSHOT
Source
1 PACKAGE MRP_CL_REFRESH_SNAPSHOT AS -- specification
2 /* $Header: MRPCLEAS.pls 120.6.12010000.2 2008/10/06 08:16:01 sbyerram ship $ */
3
4 TYPE SnapTblTyp IS TABLE OF VARCHAR2(30);
5 G_MSC_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_DEBUG'),'N');
6 v_explode_ato VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_EXPLODE_ATO'),'Y');
7 ----- CONSTANTS --------------------------------------------------------
8
9 SYS_YES CONSTANT NUMBER := 1;
10 SYS_NO CONSTANT NUMBER := 2;
11
12 G_SUCCESS CONSTANT NUMBER := 0;
13 G_WARNING CONSTANT NUMBER := 1;
14 G_ERROR CONSTANT NUMBER := 2;
15
16 SYS_INCR CONSTANT NUMBER := 3; -- incr refresh in continous collections
17 SYS_TGT CONSTANT NUMBER := 4; -- targeted refresh in continous collections
18
19 G_COLLECTIONS CONSTANT NUMBER := 1;
20 G_MANUAL CONSTANT NUMBER := 2;
21
22 G_NORMAL_COMPLETION CONSTANT NUMBER := 1;
23 G_PENDING_INACTIVE CONSTANT NUMBER := 2;
24 G_OTHERS CONSTANT NUMBER := 3;
25
26 ASL_YES_RETAIN_CP CONSTANT NUMBER :=3;
27
28 ----- PARAMETERS --------------------------------------------------------
29
30 v_debug BOOLEAN := FALSE;
31
32 v_cp_enabled NUMBER;
33
34 v_lrn NUMBER;
35 v_request_id NUMBER;
36 v_refresh_type VARCHAR2(1);
37 v_oh_sn_flag NUMBER;
38
39 v_refresh_number NUMBER:= 0;
40
41 -- ================= Procedures ====================
42
43 FUNCTION SETUP_SOURCE_OBJECTS RETURN BOOLEAN ;
44 PROCEDURE REFRESH_SNAPSHOT(
45 ERRBUF OUT NOCOPY VARCHAR2,
46 RETCODE OUT NOCOPY NUMBER,
47 p_user_name IN VARCHAR2,
48 p_resp_name IN VARCHAR2,
49 p_application_name IN VARCHAR2,
50 p_refresh_type IN VARCHAR2 := 'C',
51 o_request_id OUT NOCOPY NUMBER,
52 pInstance_ID IN NUMBER,
53 pInstance_Code IN VARCHAR2,
54 pa2m_dblink IN VARCHAR2);
55
56 PROCEDURE WAIT_FOR_REQUEST(
57 p_timeout IN NUMBER,
58 o_retcode OUT NOCOPY NUMBER);
59
60 PROCEDURE WAIT_FOR_REQUEST(
61 p_request_id in number,
62 p_timeout IN NUMBER,
63 o_retcode OUT NOCOPY NUMBER);
64
65 PROCEDURE check_MV_cont_ref_type(p_MV_name in varchar2,
66 p_entity_lrn in number,
67 entity_flag OUT NOCOPY number,
68 p_ad_table_name in varchar2,
69 p_org_str in varchar2,
70 p_coll_thresh in number,
71 p_last_tgt_cont_coll_time in date,
72 p_ret_code OUT NOCOPY number,
73 p_err_buf OUT NOCOPY varchar2);
74
75 PROCEDURE check_entity_cont_ref_type(p_entity_name in varchar2,
76 p_entity_lrn in number,
77 entity_flag OUT NOCOPY number,
78 p_org_str in varchar2,
79 p_coll_thresh in number,
80 p_last_tgt_cont_coll_time in date,
81 p_ret_code OUT NOCOPY number,
82 p_err_buf OUT NOCOPY varchar2);
83
84 PROCEDURE REFRESH_SINGLE_SNAPSHOT(
85 ERRBUF OUT NOCOPY VARCHAR2,
86 RETCODE OUT NOCOPY NUMBER,
87 pREFRESH_MODE IN NUMBER,
88 pSNAPSHOT_NAME IN VARCHAR2,
89 pDEGREE IN NUMBER,
90 pCURRENT_LRN IN NUMBER default -1,
91 p_NUMBER_OF_ROWS IN NUMBER default 0);
92
93 /* added this procedure for the new conc program defn of Refresh Snapshots */
94 PROCEDURE REFRESH_SNAPSHOT(
95 ERRBUF OUT NOCOPY VARCHAR2,
96 RETCODE OUT NOCOPY NUMBER,
97 pREFRESH_MODE IN NUMBER,
98 pSNAPSHOT_NAME IN VARCHAR2,
99 pNUMBER_OF_ROWS IN NUMBER,
100 pDEGREE IN NUMBER,
101 pCP_ENABLED IN NUMBER default MSC_UTIL.SYS_YES,
102 pREFRESH_TYPE IN VARCHAR2 default 'C',
103 pCALLING_MODULE IN NUMBER DEFAULT G_MANUAL,
104 pINSTANCE_ID IN NUMBER DEFAULT NULL,
105 pINSTANCE_CODE IN VARCHAR2 DEFAULT NULL,
106 pA2M_DBLINK IN VARCHAR2 DEFAULT NULL);
107
108 PROCEDURE DROP_SNAPSHOT(
109 ERRBUF OUT NOCOPY VARCHAR2,
110 RETCODE OUT NOCOPY NUMBER,
111 p_snapshot_str IN VARCHAR2);
112
113 PROCEDURE LOG_DEBUG( pBUFF IN VARCHAR2);
114
115 PROCEDURE LOG_ERROR( pBUFF IN VARCHAR2);
116
117
118 PROCEDURE PURGE_OBSOLETE_DATA;
119
120 /* -- Added this procedure to accept application_id instead of application_name */
121
122 PROCEDURE REFRESH_SNAPSHOT(
123 ERRBUF OUT NOCOPY VARCHAR2,
124 RETCODE OUT NOCOPY NUMBER,
125 p_user_name IN VARCHAR2,
126 p_resp_name IN VARCHAR2,
127 p_application_name IN VARCHAR2,
128 p_refresh_type IN VARCHAR2 := 'C',
129 o_request_id OUT NOCOPY NUMBER,
130 pInstance_ID IN NUMBER,
131 pInstance_Code IN VARCHAR2,
132 pa2m_dblink IN VARCHAR2,
133 p_application_id IN NUMBER);
134 /* bug 5959340*/
135 PROCEDURE CREATE_SOURCE_VIEWS(
136 ERRBUF OUT NOCOPY VARCHAR2,
137 RETCODE OUT NOCOPY NUMBER);
138
139 /* bug 5959340*/
140 PROCEDURE CREATE_SOURCE_TRIGGERS(
141 ERRBUF OUT NOCOPY VARCHAR2,
142 RETCODE OUT NOCOPY NUMBER);
143
144 END MRP_CL_REFRESH_SNAPSHOT;