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.AST_RS_CAMPAIGNS_PKG dependencies on FND_API

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

29: CURSOR C2 IS SELECT AST_RS_CAMPAIGNS_S.nextval FROM sys.dual;
30: --
31: l_count number := 0;
32: BEGIN
33: If (px_RS_CAMPAIGN_ID IS NULL) OR (px_RS_CAMPAIGN_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_RS_CAMPAIGN_ID;
36: CLOSE C2;
37: End If;

Line 65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),

61: LAST_UPDATE_DATE,
62: LAST_UPDATE_LOGIN
63: ) VALUES (
64: px_RS_CAMPAIGN_ID,
65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),

Line 66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),

62: LAST_UPDATE_LOGIN
63: ) VALUES (
64: px_RS_CAMPAIGN_ID,
65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),

Line 67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),

63: ) VALUES (
64: px_RS_CAMPAIGN_ID,
65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),

64: px_RS_CAMPAIGN_ID,
65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

Line 69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),

65: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),

66: decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, NULL, p_CAMPAIGN_ID),
67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

Line 71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

67: decode( p_START_DATE, FND_API.G_MISS_DATE, NULL, p_START_DATE),
68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));

Line 72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

68: decode( p_END_DATE, FND_API.G_MISS_DATE, NULL, p_END_DATE),
69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));
76: End Insert_Row;

Line 73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

69: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));
76: End Insert_Row;
77:

Line 74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

70: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));
76: End Insert_Row;
77:
78: PROCEDURE Update_Row(

Line 75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));

71: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
72: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
73: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
74: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
75: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, NULL, p_LAST_UPDATE_LOGIN));
76: End Insert_Row;
77:
78: PROCEDURE Update_Row(
79: p_RS_CAMPAIGN_ID NUMBER,

Line 96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),

92: IS
93: BEGIN
94: Update AST_RS_CAMPAIGNS
95: SET
96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),

Line 97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),

93: BEGIN
94: Update AST_RS_CAMPAIGNS
95: SET
96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),

Line 98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

94: Update AST_RS_CAMPAIGNS
95: SET
96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),

95: SET
96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),

96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),

97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

99: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
107: where RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID;

Line 104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

100: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
107: where RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID;
108:

Line 105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

101: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
107: where RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID;
108:
109: If (SQL%NOTFOUND) then

Line 106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
104: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
105: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
106: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_CHAR, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
107: where RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID;
108:
109: If (SQL%NOTFOUND) then
110: RAISE NO_DATA_FOUND;