1 PACKAGE OKE_HOLD_UTILS AUTHID CURRENT_USER AS
2 /* $Header: OKEHLDUS.pls 115.4 2002/08/14 01:43:49 alaw ship $ */
3 --
4 -- Name : Status_Change
5 -- Pre-reqs : None
6 -- Function : This procedure performs utility functions during
7 -- a hold status change.
8 --
9 --
10 -- Parameters :
11 -- IN : None
12 -- OUT : None
13 --
14 -- Returns : None
15 --
16
17 PROCEDURE Status_Change
18 ( P_Hold_ID IN NUMBER
19 , P_K_Header_ID IN NUMBER
20 , P_K_Line_ID IN NUMBER
21 , P_DTS_ID IN NUMBER
22 , P_Hold_Type_Code IN VARCHAR2
23 , P_Hold_Reason_Code IN VARCHAR2
24 , P_Remove_Reason_Code IN VARCHAR2
25 , P_Old_Status_Code IN VARCHAR2
26 , P_New_Status_Code IN VARCHAR2
27 , P_Updated_By IN NUMBER
28 , P_Update_Date IN DATE
29 , P_Login_ID IN NUMBER
30 );
31
32
33 END OKE_HOLD_UTILS;