APPS.AML_SALES_LEAD_TIMEFRAMES_PKG dependencies on AML_SALES_LEAD_TIMEFRAMES

Line 1: PACKAGE BODY AML_SALES_LEAD_TIMEFRAMES_PKG as

1: PACKAGE BODY AML_SALES_LEAD_TIMEFRAMES_PKG as
2: /* $Header: amlttfrb.pls 115.6 2003/01/03 23:45:26 ckapoor noship $ */
3: -- Start of Comments
4: -- Package name : AML_SALES_LEAD_TIMEFRAMES_PKG
5: -- Purpose :

Line 4: -- Package name : AML_SALES_LEAD_TIMEFRAMES_PKG

1: PACKAGE BODY AML_SALES_LEAD_TIMEFRAMES_PKG as
2: /* $Header: amlttfrb.pls 115.6 2003/01/03 23:45:26 ckapoor noship $ */
3: -- Start of Comments
4: -- Package name : AML_SALES_LEAD_TIMEFRAMES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_SALES_LEAD_TIMEFRAMES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_SALES_LEAD_TIMEFRAMES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlttfrb.pls';
13:
14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 31: CURSOR C2 IS SELECT AML_SALES_LEAD_TIMEFRAMES_S.nextval FROM sys.dual;

27: ,p_LAST_UPDATE_LOGIN in NUMBER
28: ,p_ENABLED_FLAG in VARCHAR2)
29:
30: IS
31: CURSOR C2 IS SELECT AML_SALES_LEAD_TIMEFRAMES_S.nextval FROM sys.dual;
32: BEGIN
33: If (px_TIMEFRAME_ID IS NULL) OR (px_TIMEFRAME_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_TIMEFRAME_ID;

Line 38: INSERT INTO AML_SALES_LEAD_TIMEFRAMES(

34: OPEN C2;
35: FETCH C2 INTO px_TIMEFRAME_ID;
36: CLOSE C2;
37: End If;
38: INSERT INTO AML_SALES_LEAD_TIMEFRAMES(
39: TIMEFRAME_ID
40: ,DECISION_TIMEFRAME_CODE
41: ,TIMEFRAME_DAYS
42: ,CREATION_DATE

Line 74: Update AML_SALES_LEAD_TIMEFRAMES

70: ,p_ENABLED_FLAG in VARCHAR2)
71:
72: IS
73: BEGIN
74: Update AML_SALES_LEAD_TIMEFRAMES
75: SET
76: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE)
77: ,TIMEFRAME_DAYS = decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, TIMEFRAME_DAYS, p_TIMEFRAME_DAYS)
78: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,CREATION_DATE,p_creation_date)

Line 97: DELETE FROM AML_SALES_LEAD_TIMEFRAMES

93: PROCEDURE Delete_Row(
94: p_TIMEFRAME_ID NUMBER)
95: IS
96: BEGIN
97: DELETE FROM AML_SALES_LEAD_TIMEFRAMES
98: WHERE TIMEFRAME_ID = p_TIMEFRAME_ID;
99: If (SQL%NOTFOUND) then
100: RAISE NO_DATA_FOUND;
101: End If;

Line 118: FROM AML_SALES_LEAD_TIMEFRAMES

114:
115: IS
116: CURSOR C IS
117: SELECT *
118: FROM AML_SALES_LEAD_TIMEFRAMES
119: WHERE TIMEFRAME_ID = p_TIMEFRAME_ID
120: FOR UPDATE of TIMEFRAME_ID NOWAIT;
121: Recinfo C%ROWTYPE;
122: BEGIN

Line 180: FROM AML_SALES_LEAD_TIMEFRAMES

176:
177:
178: CURSOR c_get_last_updated (c_rank_id NUMBER) IS
179: SELECT last_updated_by
180: FROM AML_SALES_LEAD_TIMEFRAMES
181: WHERE timeframe_id = x_timeframe_id;
182: l_last_updated_by NUMBER;
183:
184:

Line 233: End AML_SALES_LEAD_TIMEFRAMES_PKG;

229: END load_row;
230:
231:
232:
233: End AML_SALES_LEAD_TIMEFRAMES_PKG;