1 PACKAGE AML_SALES_LEAD_TIMEFRAMES_PKG AUTHID CURRENT_USER as
2 /* $Header: amlttfrs.pls 115.5 2003/01/03 23:45:12 ckapoor noship $ */
3 -- Start of Comments
4 -- Package name : AML_SALES_LEAD_TIMEFRAMES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_TIMEFRAME_ID IN OUT NOCOPY NUMBER
12 ,p_DECISION_TIMEFRAME_CODE IN VARCHAR2
13 ,p_TIMEFRAME_DAYS IN NUMBER
14 ,p_CREATION_DATE in DATE
15 ,p_CREATED_BY in NUMBER
16 ,p_LAST_UPDATE_DATE in DATE
17 ,p_LAST_UPDATED_BY in NUMBER
18 ,p_LAST_UPDATE_LOGIN in NUMBER
19 ,p_ENABLED_FLAG in VARCHAR2
20
21 );
22
23 PROCEDURE Update_Row(
24 p_TIMEFRAME_ID NUMBER
25 ,p_DECISION_TIMEFRAME_CODE in VARCHAR2
26 ,p_TIMEFRAME_DAYS in NUMBER
27 ,p_CREATION_DATE in DATE
28 ,p_CREATED_BY in NUMBER
29 ,p_LAST_UPDATE_DATE in DATE
30 ,p_LAST_UPDATED_BY in NUMBER
31 ,p_LAST_UPDATE_LOGIN in NUMBER
32 ,p_ENABLED_FLAG in VARCHAR2
33 );
34
35 PROCEDURE Lock_Row(
36 p_TIMEFRAME_ID in NUMBER
37 ,p_DECISION_TIMEFRAME_CODE in VARCHAR2
38 ,p_TIMEFRAME_DAYS in NUMBER
39 ,p_CREATION_DATE in DATE
40 ,p_CREATED_BY in NUMBER
41 ,p_LAST_UPDATE_DATE in DATE
42 ,p_LAST_UPDATED_BY in NUMBER
43 ,p_LAST_UPDATE_LOGIN in NUMBER
44 , p_ENABLED_FLAG in VARCHAR2
45 );
46
47 PROCEDURE Delete_Row(
48 p_TIMEFRAME_ID in NUMBER);
49
50 PROCEDURE Load_Row(
51 X_TIMEFRAME_ID in OUT NOCOPY NUMBER,
52 X_DECISION_TIMEFRAME_CODE in VARCHAR2,
53 X_TIMEFRAME_DAYS in NUMBER,
54 X_OWNER in VARCHAR2,
55 X_ENABLED_FLAG in VARCHAR2);
56
57 End AML_SALES_LEAD_TIMEFRAMES_PKG;