Forms :: Change Property Of Item Dynamically In PL/SQL Coding

Mar 20, 2011

Can i change the property of item dynamically in pl sql coding. Actually i want that whenever the user press some button then that field(textbox) become non-database item of the database block. put some value in it and press another button to restore its property like before.

View 10 Replies


ADVERTISEMENT

Forms :: Oracle 10g Developer - Set Item Property

Jun 27, 2011

i am running oracle 10g developer release2. i want to set item property false/true in response to a specific action, like disabling text item when check box or radio button pressed.

View 1 Replies View Related

Forms :: Frm-41375 - Cannot Set Queryable Property Of Calculated Item

Jun 10, 2013

frm-41375: cannot set queryable property of calculated item :emp.sumsal.

View 8 Replies View Related

Forms :: Change Item_type Property At Runtime?

May 9, 2012

Is it possible to change the item_type property of an item at runtime.

I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.

How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.

View 2 Replies View Related

Forms :: Change Database Data Block Property At Runtime

Apr 4, 2011

I want to change Database Data Block Property at runtime.

View 4 Replies View Related

Forms :: Enable Property Of One Particular Text Item To False - Form Abruptly Closing

Sep 8, 2011

i have a form having 4 database data blocks and one non database data block(for Push Buttons like SAVE,CLEAR,EXIT..).

In the control Block i have 5 push buttons out of which one is used to Save the entries and one to clear the form. In the coding of SAVE button after writing "COMMIT_FORM;" i want to disable all other Data block on my form excluding the one containing Push buttons so that the data entered by end user stay appearing on the form till he Clears the form.

Now the problem is that when i set enabled property of one particular text_item to false , the form if closing down along with the application, it is totally disappearing from screen.This is happening for one particular text item.

what could be the possible reason for this and what needs to be done to overcome this problem.

View 5 Replies View Related

Forms :: How To ENABLE / DISABLE Item Dynamically During 6i Runtime

Mar 24, 2012

I have a master-detail form showing multiple records (tabular) in data-block. Now my problem is, based on certain column's value of a particular item in a particular row on the data-block to ENABLE/DISABLE during run-time .

For example, in a detail-block of 5 rows, if 3rd row's 'detail-block.item1' is equal to lets say, "X", then 'detail-block.item2' of that particular row ONLY must be 'disabled'. otherwise, it must 'enable' the 'detail-block.item2' of that particular item in that particular row on the data-block.

Even when, I query the form, it must enable/disable that particular item of that particular row from the data-block based on item1's value.

View 4 Replies View Related

Forms :: Dynamically Change Number Of Records Displayed?

Mar 31, 2011

I am currently on a project which has a requirement of changing the number of records dynamically. Oracle Forms version 10g.

View 2 Replies View Related

Application Express :: Possible To Avoid Hard-coding Item In Shared Select List Query

Sep 4, 2012

I created a "Select List" in the Shared Components area as follows:

My goal is to create a shared select list that can be used on any form for a particular Field.

IF :P10_FK_RSTA_CODE is NULL THEN
RETURN
'select col_description, col_code_pk
from CODE_TABLE
where col_active_ind = ''Y''';
[code].....

Which works great, but how can I make the select list work for the same column on a different form? Because :P10_FK_RSTA_CODE is hard-coded in the function, I can't reuse this Function from a different form. (I could rename the Field on every form to the same name, but I'm hoping there is a better way.)

Is there a way I can pass in a variable from the Field Item to make this dynamic where I can use it on any form?

View 1 Replies View Related

Forms :: To Get X-pos Of Item At Radio-change Trigger

Jun 22, 2013

i want to get the x-pos of item at the radio-change trigger but it return the error

declare
x_pos number;
lnum_x_pos number;
lnum_width number;
begin

if :radio_group = 'E' then
lnum_x_pos := Get_item_property('Remarks',x_pos);
Message('Position of x...'||lnum_x_pos);
lnum_width := get_item_property('Remarks',width);
Message('width of remarks field..'||lnum_width);

else
set_item_property('remarks',enabled,property_true);
set_item_property('remarks',visible,property_true);

end if;
end;

error is:::

argument to built in get_item_property/field char can not be null?

View 1 Replies View Related

Forms :: Detecting Item Field Change

Jul 26, 2011

I have a form that i need to be able to detect when a field is has been updated. I will then do the appropriate update to the table.

I can't use the standard oracle forms data block for handling updates because my data selection is controlled by me via the when-new-block-instance.

The problem is when i select a value from an LOV and place the new data in the field. I don't know how to detect if the field is updated or not. I am currently using a loop to cycle through all the records, I have an if/else in the key_commit trigger that basically determines if there is an update or insert to be done to the table. The problem is that it seems if i select a value for one record that record goes through the INSERT procedure, (which is correct), but all the other records(not touched/changed) are going through the UPDATE procedure.

Is there a way in forms to check the status of a field? I know of system.form_status but that does not work for me.

View 16 Replies View Related

Forms :: Change Color Of Text Item Using Timers

Feb 23, 2010

How can I change the color of a text item in Oracle forms using timer for every 500 milliseconds? The text must appear to be blinking.

View 3 Replies View Related

Forms :: Post-change Versus Validate Item

Oct 20, 2010

tell me excat diff. between when- validate -item vs. post-change in a simple way...

View 4 Replies View Related

Application Express :: How To make Item Mandatory Dynamically

Oct 24, 2013

How to  make an item as a  mandatory field dynamically with the change of another item in different regions

View 10 Replies View Related

PL/SQL :: Change Table Name Dynamically Based On Parameter

May 10, 2013

I am new to PL/SQL, worked mostly on SQL server, I have to change the table name dynamically based on the parameter.and used a ref_cursor to display the results in a report. when I execute it throws me an error.

create or replace procedure test1 (
p_eod_date IN VARCHAR2,
p_link IN NUMBER,
c_rec IN OUT SYS_REFCURSOR)
[code]....

View 10 Replies View Related

Reports & Discoverer :: Dynamically Page Size Change?

Jun 16, 2011

Is it possible to change size of page dynamically , if yes the how ?? How do you dynamically change the page size of D2k Reports

View 2 Replies View Related

Forms :: Hard Coding Application Server IP In Oracle

Apr 1, 2010

Is it possible to hard code application server ip in oracle forms using plsql code. I am trying to open one form in my application but its giving me error as no data found. the application is using windows authentication. Unfortunately i don't have access to source code of the forms.

But i think there might be a possibility that application server/ db server ip might have hard coded in that forms so its may not be pointing to actual app server/db server.

View 2 Replies View Related

Application Express :: How To Change Column Header Value Dynamically In IR Report

Oct 29, 2012

I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.

How can i achieve dynamic headers names by using *&G_ITEM(global items)*

View 1 Replies View Related

Application Express :: Dynamically Update A Number Field By Summing Of Page Item Values

Jun 28, 2012

I'm trying to update a number field on an apex page by summing up the values of multiple page items. I've tried to follow this tutorial

[URL]........

especially the "Create a Set Value Dynamic Action Using PL/SQL" part.

In the tutorial example they return an page item value P3_SAL multiplied by a multiplier they've determined by another page item's case. What I want to do is much simpler in that I just want to add up multiple page item values and then display them in a number field at the bottom of the page.

so the code I tried to use based on the tutorial is in the tab: Home >Application Builder>Application 103>Page 3>Edit Dynamic Action>Create / Edit Action

Set Type: PL/SQL Function Body

PL/SQL Function Body:

BEGIN
return :P3_ITEM1+P3_ITEM2+P3_ITEM3;
END;

Page Items to Submit: P3_ITEM1,P3_ITEM2,P3_ITEM3

But it gives me an error that I need to declare the identifiers, yet it works if I only use one item and I can perform any arithmetic.

i.e.

BEGIN
return :P3_ITEM1+1000;
END;

View 2 Replies View Related

Reports & Discoverer :: Graph - Repeating Frame (Change Dynamically Y And X Axis Title)

May 23, 2012

I'm presently creating a Graph on a repeating frame.

I made a query with a group that pointing to the repeating frame.

The problem : I want to change dynamically the Y and X axis Title.

The graph accept user parameter inside the XML file. But how to make it dynamically based on SQL query?

I try with formula, but can't make it work with a group. I have to put the formula at Report Level, but to make it dynamically for each group i have to make it work at the group Level.

View 1 Replies View Related

Forms :: Set Record Property

Aug 28, 2012

this from has multirecords and multiblocks for every date it shows employees' attendance record, there is a button that should disable selected records for that specific date

**part from the code**

LOOP
if :ATTENDANCE.SIGGNED = 'Y' AND GET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',STATUS) = 'CHANGED' THEN
:ATTENDANCE.LAST_UPDATED_BY:=fnd_global.user_id;
:ATTENDANCE.LAST_UPDATE_DATE:=sysdate;
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',ENABLED,PROPERTY_FALSE);

[Code]...

what happen that it is confirming that selected records are disabled AND it is NOT!!

**i can still change the records if i want **

but if I changed the date and go back "the date which i disabled its records" (reload that data) then it will be disabled

finding a way so it will be disabled immediately so i don't need to change dates to be disabled

**maybe if there is a code that will refresh records ?!

View 4 Replies View Related

Forms :: Use Of Validate From List Property

Jul 19, 2013

What is the uses of "Validate From List" Property(Yes/No) in LOV's Properties.

View 3 Replies View Related

Forms :: Property List Of Set_Custom_Property

May 1, 2010

I'm new with javabean I find this website URL.....

most of this examples use this built-in Set_Custom_Property..i need you to provide with syntax and the full list of property in this built-in

all or most of the examples there is (1) in second parameter what is this (1)

View 9 Replies View Related

Forms :: Set_menu_item Property Not Work

Jun 6, 2010

The code on menu item is UnVisible_Menuitem('ITEM193');

Menu procedure is

PROCEDURE UnVisible_Menuitem( menuitem_name VARCHAR2) IS
mi_id MenuItem;
ALT NUMBER;
BEGIN
mi_id := Find_Menu_Item( menuitem_name );
[code]...

i try it for the both visible and non-visible items but it dosnt work.

View 1 Replies View Related

Forms :: Canvas / Wait Property In 6i?

Nov 28, 2011

I am using Forms 6i in Oracle Applications, In the button click event i used set_canvas_proeprty() twice. First time it executes these two statements, second time it does not. If i use any message() statement before these two statements, it executes.

Do we have wait() statement in Forms ?in apps we have app_item_property.set_property(), can we use same command to set canvas property also.

View 1 Replies View Related

Replication :: Oracle Forms 10g Access Key Property For Button

Jan 22, 2013

just i want to ask about access key property for button..i'm using oracle forms 10g ,

suppose that i have 3 buttons in a module like the following:

1- buttonOne --access key property for this button is "1"
2- buttonTwo --access key property for this button is "2"
3- buttonThree --access key property for this button is "3"

when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?

View 6 Replies View Related

Forms :: GET APPLICATION PROPERTY Return Uppercase Password?

May 31, 2010

Our application is using GET_APPLICATION_PROPERTY to retrieve user name, password and connect string. Since we have started using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production the problem started with password case sensitivity. The function returns uppercase password whereas if the user has lower or mix case password they mismatch.

View 6 Replies View Related

Forms :: How To Make Button Visible Property False By Clicking On It

Apr 3, 2013

I want to show or hide some items on my form by using the SET_ITEM_PROPERTY to enable or disable VISIBLE. i have a button NEW, my need is when i click on this NEW button it should be hide and some other items should be show. but when i click on this its only showing other items but not hiding the NEW button. my NEW button is like this:

[b]set_item_property('select.new',visible,property_false);
set_item_property('select.new',enabled,property_false);
set_item_property('select.new',navigable,property_false);[/b]
------------------------------------------------------------------
set_item_property('control.section',visible,property_true);
set_item_property('control.section',enabled,property_true);
set_item_property('control.section',navigable,property_true);
set_item_property('control.year',visible,property_true);
set_item_property('control.year',enabled,property_true);
set_item_property('control.year',navigable,property_true);

View 3 Replies View Related

Forms :: Changing Current Visual Attribute Property For Entire Application?

Feb 18, 2013

I want to change the current visual attribute color of my form at the application level, reason being i don't want to generate all the forms again from scratch.I know that we can change this using visual attributes but is there a way to change this through some form setting?(Oracle 10g)

View 3 Replies View Related

Forms :: Setting Update_allowed Property Of Specific Record In A Block To False?

Oct 13, 2011

i have a block of multiple records where the user can edit the shipment totals of products being sent to branches.

some branches can't receive certain products and usually we just default the shipment value to zero but the user can still edit that value.

What i want to do is iterate through that block and check the branch and product and set the update property to false for only that record. is that possible.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved