OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » P

Home » Applications » Oracle Fusion Apps & E-Business Suite » P_MODE="USER" in Form Function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

P_MODE="USER" in Form Function [message #585581]

Tue, 28 May 2013 01:03

sumanthllr
Messages: 15
Registered: April 2013

Junior Member

P_MODE="USER" in the form function parameter.
What does it function exactly?

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585582 is a reply to message #585581]

Tue, 28 May 2013 01:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is taken out of its context so I can't tell what it might be. Therefore, post the whole function code.

The way it is written, it looks invalid. Double quotes most probably aren't used as these are meaningless. Equation sign misses colon (i.e. it shouldn't be just =, but := ).

If P_MODE is a variable, it would be

p_mode := 'USER';

which would put a string 'USER' into that variable. Or, if it was

p_mode := USER;

it would put current user (the one who is logged in) into that variable.

If P_MODE was a parameter, it would be

:parameter.p_mode := ...

but you didn't specify that.

So, if you could explain the question with some more details, it might be easier to answer.

P.S. I didn't realize that it was an Oracle Apps. question. If that's the case, *maybe*

P_MODE="USER"

actually does something, but you'll have to wait for someone else to answer that.

I guess that USER represents currently logged user (its username).

[Updated on: Tue, 28 May 2013 01:13]

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585583 is a reply to message #585582]

Tue, 28 May 2013 01:14

sumanthllr
Messages: 15
Registered: April 2013

Junior Member

Thanks for the reply,

P_MODE="USER" is the same I mean.
As if the function parameter is having P_MODE="USER" so, the form is protected against update.
Do, P_MODE="USER" and QUERY_ONLY="YES" functions same?

Here the requirement is I have to check whether the form is protected against update or not.
So, I find a form which is protected against update having the parameter P_MODE="USER".
If I remove the parameter, the form can be updated.

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585602 is a reply to message #585583]

Tue, 28 May 2013 04:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know; I think that it is in a close relation to Oracle Apps. (which I don't use) so - wait for someone else who knows what it means.

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585607 is a reply to message #585583]

Tue, 28 May 2013 05:28

a_kamalraj
Messages: 18
Registered: May 2013
Location: Bangalore

Junior Member

Hi,

P_MODE="USER" and QUERY_ONLY="YES" both are not same.

QUERY_ONLY="YES" is just telling this form which you are opening is only for querying records and not for anything else.

P_MODE="USER" i am not sure will let you know soon on this...

Cheers
Kamal(kamal.love@gmail.com)

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585616 is a reply to message #585607]

Tue, 28 May 2013 06:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

LOL! How do you know that P_MODE="USER" and QUERY_ONLY="YES" aren't same, as - obviously - you have no idea what P_MODE="USER" actually means?

Report message to a moderator

Re: P_MODE="USER" in Form Function [message #585643 is a reply to message #585616]

Tue, 28 May 2013 11:16

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

Do, P_MODE="USER" and QUERY_ONLY="YES" functions same?

Here the requirement is I have to check whether the form is protected against update or not.
So, I find a form which is protected against update having the parameter P_MODE="USER".
If I remove the parameter, the form can be updated.

In other words, these two are just parameters. Not functions.
Whichever form you are checking that will be treated as function in Apps.
Depending on these parameter the validations / restrictions would have been added.

These would have coded in when-form-instance / when-block-instance triggers either in the form or pll.
May be both have been used for same functionality or different.
If you can check the code, search for the parameters in the form to understand better.

By
Vamsi

Report message to a moderator

Previous Topic:	Item_Type_Code in Orderline table
Next Topic:	Logon and logoff time and responsibility used

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 12:31:54 CST 2025