Oracle Apps Technical Stuff

Tuesday, November 27, 2012

API to Update the Messages in FND_NEW_MESSAGES

›
DECLARE    CURSOR c1    IS       SELECT *         FROM fnd_new_messages        WHERE message_name = &MESSAGE_NAME; BEGIN    FOR ...

API to Delete message from FND_NEW_MESSAGES

›
DECLARE    CURSOR c1    IS       SELECT *         FROM fnd_new_messages; BEGIN    FOR z IN c1    LOOP       fnd_new_messages_pkg.de...

API to Create New Messages in FND_NEW_MESSAGE

›
DECLARE    CURSOR c1    IS       SELECT *         FROM xx_fnd_new_messages_stg; BEGIN    FOR z IN c1    LOOP       fnd_new_messages...
Friday, November 9, 2012

API to Create/Update/Delete the System Items and Item Attributes

›
DECLARE    l_item_tbl_typ                               ego_item_pub.item_tbl_type;    x_item_tbl_typ                               ego_...
7 comments:
Wednesday, November 7, 2012

How to Handle NULL for :$FLEX$.VALUE_SET In Oracle

›
WHERE  organization_id = NVL( :$ FLEX$.VALUE_SET :NULL , organization_id )
‹
›
Home
View web version

About Me

Vijaykumar G
View my complete profile
Powered by Blogger.