PACKAGE: APPS.IEX_DEL_STATUSES_PKG

Source

1 PACKAGE IEX_DEL_STATUSES_PKG AS
2 /* $Header: iextdlss.pls 120.0 2004/01/24 03:21:56 appldev noship $ */
3 /* Insert_Row procedure */
4 PROCEDURE Insert_Row(x_rowid	IN OUT NOCOPY VARCHAR2
5 	,p_DEL_STATUS_ID		NUMBER
6 	,p_OBJECT_VERSION_NUMBER		NUMBER
7 	,p_SCORE_VALUE_LOW		NUMBER
8 	,p_SCORE_VALUE_HIGH		NUMBER
9 	,p_DEL_STATUS		VARCHAR2
10 	,p_SCORE_ID		NUMBER
11 	,p_REQUEST_ID		NUMBER	DEFAULT NULL
12 	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
13 	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
14 	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
15 	,p_CREATED_BY		NUMBER
16 	,p_CREATION_DATE		DATE
17 	,p_LAST_UPDATED_BY		NUMBER
18 	,p_LAST_UPDATE_DATE		DATE
19 	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
20 );
21 
22 
23 PROCEDURE Insert_Row_With_Defaults
24 	(x_rowid		IN OUT NOCOPY VARCHAR2
25 	,p_SCORE_VALUE_LOW		NUMBER
26 	,p_SCORE_VALUE_HIGH		NUMBER
27 	,p_DEL_STATUS			VARCHAR2
28 	,p_SCORE_ID			NUMBER
29 	,Commit_flag			VARCHAR2
30 );
31 
32 
33 /* Update_Row procedure */
34 PROCEDURE Update_Row(x_rowid	VARCHAR2
35 	,p_DEL_STATUS_ID		NUMBER
36 	,p_OBJECT_VERSION_NUMBER		NUMBER
37 	,p_SCORE_VALUE_LOW		NUMBER
38 	,p_SCORE_VALUE_HIGH		NUMBER
39 	,p_DEL_STATUS		VARCHAR2
40 	,p_SCORE_ID		NUMBER
41 	,p_REQUEST_ID		NUMBER	DEFAULT NULL
42 	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
43 	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
44 	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
45 	,p_CREATED_BY		NUMBER
46 	,p_CREATION_DATE		DATE
47 	,p_LAST_UPDATED_BY		NUMBER
48 	,p_LAST_UPDATE_DATE		DATE
49 	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
50 );
51 
52 /* Delete_Row procedure */
53 PROCEDURE Delete_Row(x_rowid	VARCHAR2);
54 
55 PROCEDURE Delete_del_config(p_scoreId NUMBER)  ;
56 
57 /* Lock_Row procedure */
58 PROCEDURE Lock_Row(x_rowid	VARCHAR2
59 	,p_DEL_STATUS_ID		NUMBER
60 	,p_OBJECT_VERSION_NUMBER		NUMBER
61 	,p_SCORE_VALUE_LOW		NUMBER
62 	,p_SCORE_VALUE_HIGH		NUMBER
63 	,p_DEL_STATUS		VARCHAR2
64 	,p_SCORE_ID		NUMBER
65 	,p_REQUEST_ID		NUMBER	DEFAULT NULL
66 	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
67 	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
68 	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
69 	,p_CREATED_BY		NUMBER
70 	,p_CREATION_DATE		DATE
71 	,p_LAST_UPDATED_BY		NUMBER
72 	,p_LAST_UPDATE_DATE		DATE
73 	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
74 );
75 END;