PACKAGE: APPS.AMS_DM_LIFT_PKG

Source

1 PACKAGE AMS_DM_LIFT_PKG AS
2 /* $Header: amstdlfs.pls 120.1 2005/06/15 23:57:58 appldev  $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_DM_LIFT_PKG
7 -- Purpose
8 --
9 -- History
10 -- 07-Jan-2002 choang   Removed security group id
11 -- 16-Jan-2002 choang   Fixed syntax problems from security group id
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 
18 PROCEDURE Insert_Row(
19           px_LIFT_ID   IN OUT NOCOPY NUMBER,
20           p_LAST_UPDATE_DATE    DATE,
21           p_LAST_UPDATED_BY    NUMBER,
22           p_CREATION_DATE    DATE,
23           p_CREATED_BY    NUMBER,
24           p_LAST_UPDATE_LOGIN    NUMBER,
25           px_OBJECT_VERSION_NUMBER   IN OUT NOCOPY NUMBER,
26           p_MODEL_ID    NUMBER,
27           p_QUANTILE    NUMBER,
28           p_LIFT    NUMBER,
29           p_TARGETS    NUMBER,
30           p_NON_TARGETS    NUMBER,
31           p_TARGETS_CUMM    NUMBER,
32           p_TARGET_DENSITY_CUMM    NUMBER,
33           p_TARGET_DENSITY    NUMBER,
34           p_MARGIN    NUMBER,
35           p_ROI    NUMBER,
36           p_TARGET_CONFIDENCE    NUMBER,
37           p_NON_TARGET_CONFIDENCE    NUMBER
38    );
39 
40 PROCEDURE Update_Row(
41           p_LIFT_ID    NUMBER,
42           p_LAST_UPDATE_DATE    DATE,
43           p_LAST_UPDATED_BY    NUMBER,
44           p_LAST_UPDATE_LOGIN    NUMBER,
45           p_OBJECT_VERSION_NUMBER    NUMBER,
46           p_MODEL_ID    NUMBER,
47           p_QUANTILE    NUMBER,
48           p_LIFT    NUMBER,
49           p_TARGETS    NUMBER,
50           p_NON_TARGETS    NUMBER,
51           p_TARGETS_CUMM    NUMBER,
52           p_TARGET_DENSITY_CUMM    NUMBER,
53           p_TARGET_DENSITY    NUMBER,
54           p_MARGIN    NUMBER,
55           p_ROI    NUMBER,
56           p_TARGET_CONFIDENCE    NUMBER,
57           p_NON_TARGET_CONFIDENCE    NUMBER
58    );
59 
60 PROCEDURE Lock_Row(
61           p_LIFT_ID    NUMBER,
62           p_LAST_UPDATE_DATE    DATE,
63           p_LAST_UPDATED_BY    NUMBER,
64           p_CREATION_DATE    DATE,
65           p_CREATED_BY    NUMBER,
66           p_LAST_UPDATE_LOGIN    NUMBER,
67           p_OBJECT_VERSION_NUMBER    NUMBER,
68           p_MODEL_ID    NUMBER,
69           p_QUANTILE    NUMBER,
70           p_LIFT    NUMBER,
71           p_TARGETS    NUMBER,
72           p_NON_TARGETS    NUMBER,
73           p_TARGETS_CUMM    NUMBER,
74           p_TARGET_DENSITY_CUMM    NUMBER,
75           p_TARGET_DENSITY    NUMBER,
76           p_MARGIN    NUMBER,
77           p_ROI    NUMBER,
78           p_TARGET_CONFIDENCE    NUMBER,
79           p_NON_TARGET_CONFIDENCE    NUMBER
80    );
81 PROCEDURE Delete_Row(
82     p_LIFT_ID  NUMBER);
83 END AMS_DM_LIFT_PKG;