1 PACKAGE CLN_PO_CHANGE_RESPONSE_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNPOCHS.pls 115.3 2004/04/08 16:25:03 kkram noship $ */
3
4 -- Package
5 -- CLN_RESPONSE_POCHANGE_PKG
6 --
7 -- Purpose
8 -- Specs of package CLN_RESPONSE_POCHANGE_PKG.
9 --
10 -- History
11 -- June-17-2003 Rahul Krishan Created
12
13 -- Global variable holding the current change_request_group_id
14
15 g_change_request_group_id NUMBER := 0;
16
17
18 -- Name
19 -- SETATTRIBUTES
20 -- Purpose
21 -- The main purpose ofthis API is to set different attributes based
22 -- on the change request group id passed to it through workflow.
23 -- Arguments
24 --
25 -- Notes
26 -- No specific notes.
27
28 PROCEDURE SET_ATTRIBUTES_OF_WORKFLOW(
29 p_itemtype IN VARCHAR2,
30 p_itemkey IN VARCHAR2,
31 p_actid IN NUMBER,
32 p_funcmode IN VARCHAR2,
33 x_resultout IN OUT NOCOPY VARCHAR2 );
34
35
36 -- Function
37 -- GET_CHANGE_REQUEST_ID
38 -- Description
39 -- Returns the value of Change Request Group ID which can be used in view at runtime.
40 -- Return Value
41 -- Returns the value of Change Request Group ID.
42
43
44 FUNCTION GET_CHANGE_REQUEST_GROUP_ID RETURN NUMBER;
45
46
47 -- Name
48 -- SET_REQUEST_GRP_ID_AND_COLL_ID
49 -- Description
50 -- Sets the value of Change Request Group ID which can be used in view at runtime.
51 -- Return Value
52 --
53
54 PROCEDURE SET_REQUEST_GRP_ID_AND_COLL_ID(
55 p_itemtype IN VARCHAR2,
56 p_itemkey IN VARCHAR2,
57 p_actid IN NUMBER,
58 p_funcmode IN VARCHAR2,
59 x_resultout IN OUT NOCOPY VARCHAR2 );
60
61
62 -- Name
63 -- SET_ACKCODE_CONDITIONALLY
64 -- Description
65 -- return. x_ackcode based on the two reasons passed
66 -- Return Value
67 --
68 PROCEDURE CALC_ACKCODE_CONDITIONALLY(
69 p_reason IN VARCHAR2,
70 p_cons_reason IN VARCHAR2,
71 x_ackcode IN OUT NOCOPY VARCHAR2 );
72
73
74 -- Name
75 -- GET_ADDITIONAL_DATA
76 -- Description
77 -- This procedure should be used to obtain data
78 -- that is otherwise not possible to get from element mapping
79 -- in a XML Gateway message map
80 -- Return
81 -- x_data1: Supplier Document Reference
82 -- x_data2: For future use
83 -- x_data3: For future use
84 -- x_data4: For future use
85 -- x_data5: For future use
86
87 PROCEDURE GET_ADDITIONAL_DATA(
88 P_CHANGE_REQUEST_GROUP_ID IN VARCHAR2,
89 X_DATA1 IN OUT NOCOPY VARCHAR2,
90 X_DATA2 IN OUT NOCOPY VARCHAR2,
91 X_DATA3 IN OUT NOCOPY VARCHAR2,
92 X_DATA4 IN OUT NOCOPY VARCHAR2,
93 X_DATA5 IN OUT NOCOPY VARCHAR2);
94
95
96 END CLN_PO_CHANGE_RESPONSE_PKG;