APPS.AS_LEADS_LINES_LOG_PKG dependencies on AS_LEAD_LINES_LOG

Line 33: Insert into AS_LEAD_LINES_LOG (

29: IF l_debug THEN
30: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
31: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG Before Insert Statement');
32: END IF;
33: Insert into AS_LEAD_LINES_LOG (
34: log_id,
35: lead_id,
36: lead_line_id,
37: last_update_date,

Line 56: AS_LEAD_LINES_LOG_S.nextval,

52: org_id,
53: forecast_date,
54: rolling_forecast_flag,
55: endday_log_flag) VALUES (
56: AS_LEAD_LINES_LOG_S.nextval,
57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),

Line 124: Update AS_LEAD_LINES_LOG

120: IF l_debug THEN
121: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');
123: END IF;
124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

Line 144: from AS_LEAD_LINES_LOG

140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
143: WHERE LOG_ID = (SELECT max(log_id)
144: from AS_LEAD_LINES_LOG
145: where lead_line_id = old_lead_line_id);
146:
147: If (SQL%NOTFOUND) then
148: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG after Update statement : Data No found seems');

Line 174: Update AS_LEAD_LINES_LOG

170: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171:
172: BEGIN
173: /*
174: Update AS_LEAD_LINES_LOG
175: set object_version_number = nvl(object_version_number,0) + 1, log_mode = 'D'
176: where lead_line_id = old_lead_line_id and last_update_date = old_last_update_date;
177: */
178: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Delete_Row');

Line 187: Insert into AS_LEAD_LINES_LOG (

183: -- dbms_output.put_line('p_old_last_update_login:'|| p_old_last_update_login);
184: -- dbms_output.put_line('p_old_creation_date:'|| p_old_creation_date);
185: -- dbms_output.put_line('p_old_created_by:'|| p_old_created_by);
186:
187: Insert into AS_LEAD_LINES_LOG (
188: log_id,
189: lead_id,
190: lead_line_id,
191: last_update_date,

Line 199: AS_LEAD_LINES_LOG_S.nextval,

195: created_by,
196: log_mode,
197: endday_log_flag
198: ) VALUES (
199: AS_LEAD_LINES_LOG_S.nextval,
200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),