PACKAGE: APPS.IEX_SCORE_HISTORIES_PKG

Source

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