[Home] [Help]
PACKAGE: APPS.M4R_7B1_WSM_IN
Source
1 PACKAGE M4R_7B1_WSM_IN AS
2 /* $Header: M4R7B1OS.pls 120.3 2005/10/27 02:19:00 smuthuav noship $ */
3
4
5 -- Package : M4R_7B1_WSM_IN
6
7 -- Purpose : Spec of package M4R_7B1_WSM_IN. This package is called from the Workflow 'M4R 7B1 OSFM Distribute WIP'.
8
9 g_debug_level NUMBER;
10 g_exception_tracking_msg VARCHAR2(200);
11 g_error_code NUMBER;
12 g_errmsg VARCHAR2(2000);
13 g_intrl_cntrl_num NUMBER;
14 g_tp_frm_code NUMBER;
15
16 PROCEDURE PROCESS_STAGING ( p_itemtype IN VARCHAR2,
17 p_itemkey IN VARCHAR2,
18 p_actid IN NUMBER,
19 p_funcmode IN VARCHAR2,
20 x_resultout IN OUT NOCOPY VARCHAR2);
21
22
23 PROCEDURE UPDATE_COLL_HIST ( p_int_ctrl_num IN NUMBER,
24 p_coll_hist_msg IN VARCHAR2,
25 x_resultout OUT NOCOPY VARCHAR2);
26
27
28 PROCEDURE ADD_MSG_COLL_HIST ( p_err_string IN VARCHAR2,
29 p_ref_id2 IN VARCHAR2,
30 p_ref_id3 IN VARCHAR2,
31 p_ref_id4 IN VARCHAR2,
32 p_ref_id5 IN VARCHAR2,
33 p_hdr_id IN NUMBER,
34 p_msg_id IN NUMBER);
35
36
37 PROCEDURE GET_TP_DETAILS ( p_tp_hdr_id IN NUMBER,
38 x_party_id OUT NOCOPY NUMBER,
39 x_party_site_id OUT NOCOPY NUMBER);
40
41
42 PROCEDURE PROCESS_NOTIFICATION ( p_itemtype IN VARCHAR2,
43 p_itemkey IN VARCHAR2,
44 p_actid IN NUMBER,
45 p_funcmode IN VARCHAR2,
46 x_resultout IN OUT NOCOPY VARCHAR2);
47
48
49 PROCEDURE CHECK_VALID_RECORDS ( p_itemtype IN VARCHAR2,
50 p_itemkey IN VARCHAR2,
51 p_actid IN NUMBER,
52 p_funcmode IN VARCHAR2,
53 x_resultout IN OUT NOCOPY VARCHAR2);
54
55
56 PROCEDURE CHECK_CP_IMPORT_STATUS ( p_itemtype IN VARCHAR2,
57 p_itemkey IN VARCHAR2,
58 p_actid IN NUMBER,
59 p_funcmode IN VARCHAR2,
60 x_resultout IN OUT NOCOPY VARCHAR2) ;
61
62
63 END M4R_7B1_WSM_IN;