PACKAGE: APPS.AMS_DM_SOURCE_PKG

Source

1 PACKAGE AMS_DM_SOURCE_PKG AUTHID CURRENT_USER as
2 /* $Header: amstdsrs.pls 115.9 2003/09/03 19:42:33 nyostos ship $ */
3 -- Start of Comments
4 -- Package name     : AMS_DM_SOURCE_PKG
5 -- Purpose          :
6 -- History          :
7 -- 30-jan-2001 choang   Changed p_tree_node to p_rule_id.
8 -- 07-Jan-2002 choang   Removed security group id
9 -- 28-Jul-2003 nyostos  Added PERCENTILE column.
10 -- NOTE             :
11 -- End of Comments
12 
13 PROCEDURE Insert_Row(
14           px_SOURCE_ID        IN OUT NOCOPY NUMBER,
15           p_LAST_UPDATE_DATE  DATE,
16           p_LAST_UPDATED_BY   NUMBER,
17           p_CREATION_DATE     DATE,
18           p_CREATED_BY        NUMBER,
19           p_LAST_UPDATE_LOGIN NUMBER,
20           px_OBJECT_VERSION_NUMBER  IN OUT NOCOPY NUMBER,
21           p_MODEL_TYPE        VARCHAR2,
22           p_ARC_USED_FOR_OBJECT     VARCHAR2,
23           p_USED_FOR_OBJECT_ID      NUMBER,
24           p_PARTY_ID          NUMBER,
25           p_SCORE_RESULT      VARCHAR2,
26           p_TARGET_VALUE      VARCHAR2,
27           p_CONFIDENCE        NUMBER,
28           p_CONTINUOUS_SCORE  NUMBER,
29           p_decile            NUMBER,
30           p_PERCENTILE        NUMBER);
31 
32 PROCEDURE Update_Row(
33           p_SOURCE_ID            NUMBER,
34           p_LAST_UPDATE_DATE     DATE,
35           p_LAST_UPDATED_BY      NUMBER,
36           p_LAST_UPDATE_LOGIN    NUMBER,
37           p_OBJECT_VERSION_NUMBER   NUMBER,
38           p_MODEL_TYPE           VARCHAR2,
39           p_ARC_USED_FOR_OBJECT  VARCHAR2,
40           p_USED_FOR_OBJECT_ID   NUMBER,
41           p_PARTY_ID             NUMBER,
42           p_SCORE_RESULT         VARCHAR2,
43           p_TARGET_VALUE         VARCHAR2,
44           p_CONFIDENCE           NUMBER,
45           p_CONTINUOUS_SCORE     NUMBER,
46           p_decile               NUMBER,
47           p_PERCENTILE           NUMBER);
48 
49 PROCEDURE Lock_Row(
50           p_SOURCE_ID            NUMBER,
51           p_LAST_UPDATE_DATE     DATE,
52           p_LAST_UPDATED_BY      NUMBER,
53           p_CREATION_DATE        DATE,
54           p_CREATED_BY           NUMBER,
55           p_LAST_UPDATE_LOGIN    NUMBER,
56           p_OBJECT_VERSION_NUMBER   NUMBER,
57           p_MODEL_TYPE           VARCHAR2,
58           p_ARC_USED_FOR_OBJECT  VARCHAR2,
59           p_USED_FOR_OBJECT_ID   NUMBER,
60           p_PARTY_ID             NUMBER,
61           p_SCORE_RESULT         VARCHAR2,
62           p_TARGET_VALUE         VARCHAR2,
63           p_CONFIDENCE           NUMBER,
64           p_CONTINUOUS_SCORE     NUMBER,
65           p_decile               NUMBER,
66           p_PERCENTILE           NUMBER);
67 
68 PROCEDURE Delete_Row(
69     p_SOURCE_ID  NUMBER);
70 End AMS_DM_SOURCE_PKG;