FND API : Code for attaching request set to request group

Code for attaching request set to request group

BEGIN
-- Add Request Set to request group.
BEGIN
fnd_set.add_set_to_group (request_set => 'XXX_TEST_REQUEST_SET',
set_application => 'XXX', --REQUEST SET APPLICATION SHORT NAME
request_group => 'KNOWORACLE',---REQUEST GROUP NAME
group_application => 'XXX'--REQUEST GROUP APPLICATION SHORT NAME
);
DBMS_OUTPUT.PUT_LINE ('"XXX_TEST_REQUEST_SET" attached to request group Succesfully ');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Error in attaching "XXX_TEST_REQUEST_SET" to Request Group ' || SQLERRM);
END;

COMMIT;

END;
/

FND API :CODE FOR UPDATING USER PASSWORD IN ORACLE

FND API :CODE FOR UPDATING USER PASSWORD IN ORACLE

BEGIN
FND_USER_PKG.UPDATEUSER(x_user_name       => 'KNOWORACLE'
                                                        ,x_owner                => 'SEED'
                                                        ,x_unencrypted_password => 'knoworacle@351'
                                                        ,x_password_date        => SYSDATE + 90);

END;