eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AML_SALES_LEAD_TIMEFRAMES_PKG dependencies on FND_API

Line 33: If (px_TIMEFRAME_ID IS NULL) OR (px_TIMEFRAME_ID = FND_API.G_MISS_NUM) then

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;
36: CLOSE C2;
37: End If;

Line 50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)

46: ,LAST_UPDATE_LOGIN
47: , ENABLED_FLAG
48: ) VALUES (
49: px_TIMEFRAME_ID
50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

Line 51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)

47: , ENABLED_FLAG
48: ) VALUES (
49: px_TIMEFRAME_ID
50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

Line 52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

48: ) VALUES (
49: px_TIMEFRAME_ID
50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

Line 53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

49: px_TIMEFRAME_ID
50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));

Line 54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

50: ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));
58:

Line 55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

51: ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));
58:
59: End Insert_Row;

Line 56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

52: , DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));
58:
59: End Insert_Row;
60:

Line 57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));

53: , DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
54: , DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
55: , DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
56: , DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
57: , DECODE(p_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));
58:
59: End Insert_Row;
60:
61: PROCEDURE Update_Row(

Line 76: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)

Line 77: ,TIMEFRAME_DAYS = decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, TIMEFRAME_DAYS, p_TIMEFRAME_DAYS)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)

Line 78: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,CREATION_DATE,p_creation_date)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)

Line 79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)
83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)

Line 80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)
83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)
84:

Line 81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)

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)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)
83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)
84:
85:

Line 82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)

78: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,CREATION_DATE,p_creation_date)
79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)
83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)
84:
85:
86: where TIMEFRAME_ID = p_TIMEFRAME_ID;

Line 83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)

79: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,CREATED_BY,p_created_by)
80: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_last_update_date)
81: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,LAST_UPDATED_BY,p_last_updated_by)
82: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,p_last_update_login)
83: , enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)
84:
85:
86: where TIMEFRAME_ID = p_TIMEFRAME_ID;
87:

Line 202: p_CREATION_DATE => FND_API.G_MISS_DATE,

198:
199: Update_Row(p_TIMEFRAME_ID => x_TIMEFRAME_ID,
200: p_DECISION_TIMEFRAME_CODE => x_DECISION_TIMEFRAME_CODE,
201: p_TIMEFRAME_DAYS => x_TIMEFRAME_DAYS,
202: p_CREATION_DATE => FND_API.G_MISS_DATE,
203: p_CREATED_BY => FND_API.G_MISS_NUM,
204: p_LAST_UPDATE_DATE => sysdate,
205: p_LAST_UPDATED_BY => user_id,
206: p_LAST_UPDATE_LOGIN => 0,

Line 203: p_CREATED_BY => FND_API.G_MISS_NUM,

199: Update_Row(p_TIMEFRAME_ID => x_TIMEFRAME_ID,
200: p_DECISION_TIMEFRAME_CODE => x_DECISION_TIMEFRAME_CODE,
201: p_TIMEFRAME_DAYS => x_TIMEFRAME_DAYS,
202: p_CREATION_DATE => FND_API.G_MISS_DATE,
203: p_CREATED_BY => FND_API.G_MISS_NUM,
204: p_LAST_UPDATE_DATE => sysdate,
205: p_LAST_UPDATED_BY => user_id,
206: p_LAST_UPDATE_LOGIN => 0,
207: p_ENABLED_FLAG => x_ENABLED_FLAG