1 PACKAGE M4R_7B5_OSFM_PKG AUTHID CURRENT_USER AS
2 /* $Header: M4R7B5OS.pls 120.0 2005/05/24 16:22:44 appldev noship $ */
3
4
5 -- Package
6 -- M4R_7B5_OSFM_PKG
7 --
8 -- Purpose
9 -- Spec of package M4R_7B5_OSFM_PKG. This package
10 -- is called from the Workflow 'M4R 7B5 OSFM Notify WO'.
11 --
12 -- History
13 -- Feb-26-2005 Sangeetha Created
14 -- May-02-2005 Sangeetha Added 'COMPARE_HEADERS' procedure.
15
16 -- Name
17 -- SET_WF_ATTRIBUTES
18
19 -- Purpose
20 -- This procedure is called from the Workflow. It checks whether the approved PO has any Outside Processing Items.
21
22 -- Arguments
23
24
25 PROCEDURE SET_WF_ATTRIBUTES(p_itemtype IN VARCHAR2,
26 p_itemkey IN VARCHAR2,
27 p_actid IN NUMBER,
28 p_funcmode IN VARCHAR2,
29 x_resultout IN OUT NOCOPY VARCHAR2);
30
31
32 -- Name
33 -- PROCESS_WO
34
35 -- Purpose
36 -- This procedure is called from the Workflow to process the Purchase Order to find whether it is a New/Change/Cancel request
37
38 -- Arguments
39
40 PROCEDURE PROCESS_WO(p_itemtype IN VARCHAR2,
41 p_itemkey IN VARCHAR2,
42 p_actid IN NUMBER,
43 p_funcmode IN VARCHAR2,
44 x_resultout IN OUT NOCOPY VARCHAR2);
45
46 -- Name
47 -- COMPARE_HEADERS
48
49 -- Purpose
50 -- This procedure is called from the PROCESS_WO procedure. It compares the headers of the Standard PO/Release to the previous
51 -- respective ones.
52
53 -- Arguments
54
55 PROCEDURE COMPARE_HEADERS(p_header_id IN NUMBER,
56 p_release_id IN NUMBER,
57 p_revision_num IN NUMBER,
58 x_header_change_flag OUT NOCOPY VARCHAR2);
59
60 END M4R_7B5_OSFM_PKG;