DBA Data[Home] [Help]

APPS.AML_SALES_LEADS_V2_PUB dependencies on FND_GLOBAL

Line 138: OPEN C_Get_SLAESFORCE(fnd_global.user_id);

134: l_salesforce_id := P_Identity_Salesforce_Id;
135:
136: IF l_salesforce_id IS NULL OR l_salesforce_id = FND_API.G_MISS_NUM
137: THEN
138: OPEN C_Get_SLAESFORCE(fnd_global.user_id);
139: FETCH C_Get_SLAESFORCE
140: INTO l_salesforce_id;
141: CLOSE C_Get_SLAESFORCE;
142:

Line 264: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

260: --Assign values to context rec type
261: l_note_context_rec.NOTE_CONTEXT_TYPE := 'LEAD';
262: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := l_sales_lead_id;
263: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
264: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
265: l_note_context_rec.CREATION_DATE := SYSDATE;
266: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
267: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
268:

Line 266: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;

262: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := l_sales_lead_id;
263: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
264: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
265: l_note_context_rec.CREATION_DATE := SYSDATE;
266: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
267: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
268:
269: l_note_context_rec_tbl(1) := l_note_context_rec;
270:

Line 267: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;

263: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
264: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
265: l_note_context_rec.CREATION_DATE := SYSDATE;
266: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
267: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
268:
269: l_note_context_rec_tbl(1) := l_note_context_rec;
270:
271: l_note_context_rec.NOTE_CONTEXT_TYPE := 'PARTY_ORGANIZATION';

Line 274: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

270:
271: l_note_context_rec.NOTE_CONTEXT_TYPE := 'PARTY_ORGANIZATION';
272: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := p_sales_lead_rec.customer_id;
273: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
274: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
275: l_note_context_rec.CREATION_DATE := SYSDATE;
276: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
277: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
278:

Line 276: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;

272: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := p_sales_lead_rec.customer_id;
273: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
274: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
275: l_note_context_rec.CREATION_DATE := SYSDATE;
276: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
277: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
278:
279: l_note_context_rec_tbl(2) := l_note_context_rec;
280:

Line 277: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;

273: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
274: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
275: l_note_context_rec.CREATION_DATE := SYSDATE;
276: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
277: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
278:
279: l_note_context_rec_tbl(2) := l_note_context_rec;
280:
281: -- Call Jtf_notes_pub.create_note()

Line 299: , p_entered_by => FND_GLOBAL.USER_ID

295: , p_source_object_code => 'LEAD'
296: , p_notes => p_lead_note
297: , p_notes_detail => NULL --EMPTY_CLOB()
298: , p_note_status => NULL
299: , p_entered_by => FND_GLOBAL.USER_ID
300: , p_entered_date => SYSDATE
301: , x_jtf_note_id => x_note_id
302: , p_last_update_date => SYSDATE
303: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 303: , p_last_updated_by => FND_GLOBAL.USER_ID

299: , p_entered_by => FND_GLOBAL.USER_ID
300: , p_entered_date => SYSDATE
301: , x_jtf_note_id => x_note_id
302: , p_last_update_date => SYSDATE
303: , p_last_updated_by => FND_GLOBAL.USER_ID
304: , p_creation_date => SYSDATE
305: , p_created_by => FND_GLOBAL.USER_ID
306: , p_last_update_login => FND_GLOBAL.USER_ID
307: , p_attribute1 => NULL

Line 305: , p_created_by => FND_GLOBAL.USER_ID

301: , x_jtf_note_id => x_note_id
302: , p_last_update_date => SYSDATE
303: , p_last_updated_by => FND_GLOBAL.USER_ID
304: , p_creation_date => SYSDATE
305: , p_created_by => FND_GLOBAL.USER_ID
306: , p_last_update_login => FND_GLOBAL.USER_ID
307: , p_attribute1 => NULL
308: , p_attribute2 => NULL
309: , p_attribute3 => NULL

Line 306: , p_last_update_login => FND_GLOBAL.USER_ID

302: , p_last_update_date => SYSDATE
303: , p_last_updated_by => FND_GLOBAL.USER_ID
304: , p_creation_date => SYSDATE
305: , p_created_by => FND_GLOBAL.USER_ID
306: , p_last_update_login => FND_GLOBAL.USER_ID
307: , p_attribute1 => NULL
308: , p_attribute2 => NULL
309: , p_attribute3 => NULL
310: , p_attribute4 => NULL