DBA Data[Home] [Help]

PACKAGE: APPS.CLN_PO_CHANGE_RESPONSE_PKG

Source


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;