APPS.AML_TIMEFRAME_PVT dependencies on AML_SALES_LEAD_TIMEFRAMES

Line 49: SELECT 'X' FROM AML_SALES_LEAD_TIMEFRAMES

45: l_dummy CHAR(1);
46:
47:
48: CURSOR c1 IS
49: SELECT 'X' FROM AML_SALES_LEAD_TIMEFRAMES
50: WHERE decision_timeframe_code = p_timeframe_rec.decision_timeframe_code
51: AND enabled_flag = 'Y';
52:
53:

Line 157: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row)

153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
154: 'Private API: Calling create table handler');
155: END IF;
156:
157: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row)
158: AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row(
159: px_TIMEFRAME_ID => x_TIMEFRAME_ID
160: ,p_DECISION_TIMEFRAME_CODE => l_timeframe_rec.DECISION_TIMEFRAME_CODE
161: ,p_TIMEFRAME_DAYS => l_timeframe_rec.TIMEFRAME_DAYS

Line 158: AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row(

154: 'Private API: Calling create table handler');
155: END IF;
156:
157: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row)
158: AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row(
159: px_TIMEFRAME_ID => x_TIMEFRAME_ID
160: ,p_DECISION_TIMEFRAME_CODE => l_timeframe_rec.DECISION_TIMEFRAME_CODE
161: ,p_TIMEFRAME_DAYS => l_timeframe_rec.TIMEFRAME_DAYS
162: ,p_CREATION_DATE => sysdate --l_timeframe_rec.CREATION_DATE

Line 262: From AML_SALES_LEAD_TIMEFRAMES

258: Select rowid,
259: TIMEFRAME_ID,
260: DECISION_TIMEFRAME_CODE,
261: TIMEFRAME_DAYS
262: From AML_SALES_LEAD_TIMEFRAMES
263: -- Hint: Developer need to provide Where clause
264: For Update NOWAIT;
265: */
266: l_api_name CONSTANT VARCHAR2(30) := 'Update_timeframe';

Line 277: SELECT 'X' FROM AML_SALES_LEAD_TIMEFRAMES

273: l_dummy CHAR(1);
274:
275:
276: CURSOR c1 IS
277: SELECT 'X' FROM AML_SALES_LEAD_TIMEFRAMES
278: WHERE decision_timeframe_code = p_timeframe_rec.decision_timeframe_code
279: and timeframe_id <> p_timeframe_rec.timeframe_id
280: AND enabled_flag = 'Y';
281:

Line 430: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row)

426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
427: 'Private API: Calling update table handler');
428: END IF;
429:
430: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row)
431: AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row(
432: p_TIMEFRAME_ID => p_timeframe_rec.TIMEFRAME_ID
433: ,p_DECISION_TIMEFRAME_CODE => p_timeframe_rec.DECISION_TIMEFRAME_CODE
434: ,p_TIMEFRAME_DAYS => p_timeframe_rec.TIMEFRAME_DAYS

Line 431: AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row(

427: 'Private API: Calling update table handler');
428: END IF;
429:
430: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row)
431: AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row(
432: p_TIMEFRAME_ID => p_timeframe_rec.TIMEFRAME_ID
433: ,p_DECISION_TIMEFRAME_CODE => p_timeframe_rec.DECISION_TIMEFRAME_CODE
434: ,p_TIMEFRAME_DAYS => p_timeframe_rec.TIMEFRAME_DAYS
435: ,p_CREATION_DATE => p_timeframe_rec.CREATION_DATE

Line 588: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row)

584: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row)
589: AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row(
590: p_TIMEFRAME_ID => p_timeframe_rec.TIMEFRAME_ID);
591: --
592: -- End of API body

Line 589: AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row(

585: 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row)
589: AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row(
590: p_TIMEFRAME_ID => p_timeframe_rec.TIMEFRAME_ID);
591: --
592: -- End of API body
593: --