13: l_last_update_date date;
14:
15: BEGIN
16:
17: l_created_by := FND_GLOBAL.USER_ID;
18: l_creation_date := sysdate;
19: l_last_update_login := FND_GLOBAL.LOGIN_ID;
20: l_last_update_date := sysdate;
21: l_last_updated_by := FND_GLOBAL.USER_ID;
15: BEGIN
16:
17: l_created_by := FND_GLOBAL.USER_ID;
18: l_creation_date := sysdate;
19: l_last_update_login := FND_GLOBAL.LOGIN_ID;
20: l_last_update_date := sysdate;
21: l_last_updated_by := FND_GLOBAL.USER_ID;
22:
23: /*-----------------------------+
17: l_created_by := FND_GLOBAL.USER_ID;
18: l_creation_date := sysdate;
19: l_last_update_login := FND_GLOBAL.LOGIN_ID;
20: l_last_update_date := sysdate;
21: l_last_updated_by := FND_GLOBAL.USER_ID;
22:
23: /*-----------------------------+
24: | get the unique identifier |
25: +-----------------------------*/
140: l_last_update_date date;
141:
142: BEGIN
143:
144: l_created_by := FND_GLOBAL.USER_ID;
145: l_creation_date := sysdate;
146: l_last_update_login := FND_GLOBAL.LOGIN_ID;
147: l_last_update_date := sysdate;
148: l_last_updated_by := FND_GLOBAL.USER_ID;
142: BEGIN
143:
144: l_created_by := FND_GLOBAL.USER_ID;
145: l_creation_date := sysdate;
146: l_last_update_login := FND_GLOBAL.LOGIN_ID;
147: l_last_update_date := sysdate;
148: l_last_updated_by := FND_GLOBAL.USER_ID;
149:
150:
144: l_created_by := FND_GLOBAL.USER_ID;
145: l_creation_date := sysdate;
146: l_last_update_login := FND_GLOBAL.LOGIN_ID;
147: l_last_update_date := sysdate;
148: l_last_updated_by := FND_GLOBAL.USER_ID;
149:
150:
151: /*------------------------------+
152: | get the unique id |
205: l_last_update_date date;
206:
207: BEGIN
208:
209: l_created_by := FND_GLOBAL.USER_ID;
210: l_creation_date := sysdate;
211: l_last_update_login := FND_GLOBAL.LOGIN_ID;
212: l_last_update_date := sysdate;
213: l_last_updated_by := FND_GLOBAL.USER_ID;
207: BEGIN
208:
209: l_created_by := FND_GLOBAL.USER_ID;
210: l_creation_date := sysdate;
211: l_last_update_login := FND_GLOBAL.LOGIN_ID;
212: l_last_update_date := sysdate;
213: l_last_updated_by := FND_GLOBAL.USER_ID;
214:
215:
209: l_created_by := FND_GLOBAL.USER_ID;
210: l_creation_date := sysdate;
211: l_last_update_login := FND_GLOBAL.LOGIN_ID;
212: l_last_update_date := sysdate;
213: l_last_updated_by := FND_GLOBAL.USER_ID;
214:
215:
216: /*-----------------------+
217: | get the unique id |
340: l_last_update_date date;
341:
342: BEGIN
343:
344: l_created_by := FND_GLOBAL.USER_ID;
345: l_creation_date := sysdate;
346: l_last_update_login := FND_GLOBAL.LOGIN_ID;
347: l_last_update_date := sysdate;
348: l_last_updated_by := FND_GLOBAL.USER_ID;
342: BEGIN
343:
344: l_created_by := FND_GLOBAL.USER_ID;
345: l_creation_date := sysdate;
346: l_last_update_login := FND_GLOBAL.LOGIN_ID;
347: l_last_update_date := sysdate;
348: l_last_updated_by := FND_GLOBAL.USER_ID;
349:
350: /*--------------------------+
344: l_created_by := FND_GLOBAL.USER_ID;
345: l_creation_date := sysdate;
346: l_last_update_login := FND_GLOBAL.LOGIN_ID;
347: l_last_update_date := sysdate;
348: l_last_updated_by := FND_GLOBAL.USER_ID;
349:
350: /*--------------------------+
351: | get unique identifier |
352: +--------------------------*/
405: l_last_update_date date;
406:
407: BEGIN
408:
409: l_created_by := FND_GLOBAL.USER_ID;
410: l_creation_date := sysdate;
411: l_last_update_login := FND_GLOBAL.LOGIN_ID;
412: l_last_update_date := sysdate;
413: l_last_updated_by := FND_GLOBAL.USER_ID;
407: BEGIN
408:
409: l_created_by := FND_GLOBAL.USER_ID;
410: l_creation_date := sysdate;
411: l_last_update_login := FND_GLOBAL.LOGIN_ID;
412: l_last_update_date := sysdate;
413: l_last_updated_by := FND_GLOBAL.USER_ID;
414:
415:
409: l_created_by := FND_GLOBAL.USER_ID;
410: l_creation_date := sysdate;
411: l_last_update_login := FND_GLOBAL.LOGIN_ID;
412: l_last_update_date := sysdate;
413: l_last_updated_by := FND_GLOBAL.USER_ID;
414:
415:
416: /*------------------------+
417: | insert the unique id |
463: l_last_update_date date;
464:
465: BEGIN
466:
467: l_last_update_login := FND_GLOBAL.LOGIN_ID;
468: l_last_update_date := sysdate;
469: l_last_updated_by := FND_GLOBAL.USER_ID;
470:
471:
465: BEGIN
466:
467: l_last_update_login := FND_GLOBAL.LOGIN_ID;
468: l_last_update_date := sysdate;
469: l_last_updated_by := FND_GLOBAL.USER_ID;
470:
471:
472: update ar_customer_calls
473: set status = p_call_rec.status,
497: l_last_update_date date;
498:
499: BEGIN
500:
501: l_last_update_login := FND_GLOBAL.LOGIN_ID;
502: l_last_update_date := sysdate;
503: l_last_updated_by := FND_GLOBAL.USER_ID;
504:
505: open c1;
499: BEGIN
500:
501: l_last_update_login := FND_GLOBAL.LOGIN_ID;
502: l_last_update_date := sysdate;
503: l_last_updated_by := FND_GLOBAL.USER_ID;
504:
505: open c1;
506:
507: update ar_customer_call_topics
541: l_last_update_date date;
542:
543: BEGIN
544:
545: l_last_update_login := FND_GLOBAL.LOGIN_ID;
546: l_last_update_date := sysdate;
547: l_last_updated_by := FND_GLOBAL.USER_ID;
548:
549: open c1;
543: BEGIN
544:
545: l_last_update_login := FND_GLOBAL.LOGIN_ID;
546: l_last_update_date := sysdate;
547: l_last_updated_by := FND_GLOBAL.USER_ID;
548:
549: open c1;
550: open c2;
551: