1 PACKAGE OKE_COMM_ACT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: OKEACTUS.pls 115.6 2003/10/13 05:27:16 yliou ship $ */
3
4
5 --
6 -- Name : Update_Text
7 -- Pre-reqs : None
8 -- Function : This procedure updates communication text
9 --
10 PROCEDURE Update_Text(
11 X_k_header_id NUMBER,
12 X_communication_num VARCHAR2,
13 X_text VARCHAR2
14 );
15
16
17 --
18 -- Name : Action_Workflow
19 -- Pre-reqs : None
20 -- Function : This procedure launch the workflow when
21 -- a communication was created
22 -- or the communication action was changed
23 --
24 PROCEDURE Action_Workflow
25 ( P_K_Header_ID IN NUMBER
26 , P_K_Line_ID IN NUMBER
27 , P_Deliverable_ID IN NUMBER
28 , P_Communication_Num IN VARCHAR2
29 , P_Type_Name IN VARCHAR2
30 , P_Reason_Name IN VARCHAR2
31 , P_Party_Name IN VARCHAR2
32 , P_Party_Location IN VARCHAR2
33 , P_Party_Role IN VARCHAR2
34 , P_Party_Contact IN VARCHAR2
35 , P_New_Action_Code IN VARCHAR2
36 , P_Owner IN NUMBER
37 , P_Priority_Name IN VARCHAR2
38 , P_Communication_Date IN DATE
39 , P_Communication_Text IN VARCHAR2
40 , P_Updated_By IN NUMBER
41 , P_Update_Date IN DATE
42 , P_Login_ID IN NUMBER
43 , P_WF_ITEM_KEY OUT NOCOPY VARCHAR2
44 );
45
46
47 --
48 -- Name : Status_Change
49 -- Pre-reqs : None
50 -- Function : This procedure performs utility functions when
51 -- a communication applied.
52 --
53 --
54 -- Parameters :
55 -- IN : None
56 -- OUT : None
57 --
58 -- Returns : None
59 --
60
61 PROCEDURE Comm_Action
62 ( P_K_Header_ID IN NUMBER
63 , P_K_Line_ID IN NUMBER
64 , P_Deliverable_ID IN NUMBER
65 , P_Communication_Num IN VARCHAR2
66 , P_Type IN VARCHAR2
67 , P_Reason_Code IN VARCHAR2
68 , P_K_Party_ID IN NUMBER
69 , P_Party_Location IN VARCHAR2
70 , P_Party_Role IN VARCHAR2
71 , P_Party_Contact IN VARCHAR2
72 , P_New_Action_Code IN VARCHAR2
73 , P_Owner IN NUMBER
74 , P_Priority_Code IN VARCHAR2
75 , P_Communication_Date IN DATE
76 , P_Communication_Text IN VARCHAR2
77 , P_Updated_By IN NUMBER
78 , P_Update_Date IN DATE
79 , P_Login_ID IN NUMBER
80 , P_WF_ITEM_KEY OUT NOCOPY VARCHAR2
81 );
82
83
84 END OKE_COMM_ACT_UTILS;