December 26, 2011

Set who Columns

Set who columns in pre-insert trigger in block level trigger

FND_STANDARD.SET_WHO;


The WHO columns are

CREATED BY,
CREATION_DATE,
LAST_UPDATE_BY,
LAST_UPDATED_DATE


at
Labels:

3 comments:

  1. AnonymousMarch 20, 2012 at 3:19 AM

    how to use this trigger

    ReplyDelete
    Replies
    1. MeeraMarch 20, 2012 at 3:37 AM

      Call it in Pre-Insert trigger,If your custom table has all the above mentioned WHO columns then it will be updated automatically.

      Delete
  2. MeeraMarch 20, 2012 at 3:36 AM

    This comment has been removed by the author.

    ReplyDelete

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • Interview FAQ's-Oracle Apps Technical and Oracle forms
    Oracle Applications Architecture -           Internet computing Architecture is a framework for 3-tired, distributed computing that ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...