Forms :: Enable / Disable Menu Items For Different Users?
May 14, 2011Enable / Disable menu items for different users.
how to create different users give in demo files i am using 10gforms.
ADVERTISEMENT
Forms :: Enable Or Disable Current Item In Block?
Feb 1, 2011I have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.
i manage to turn all the records enabled or disabled.
I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.
The DB table for the same is:
CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,
[code]....
Forms :: How To ENABLE / DISABLE Item Dynamically During 6i Runtime
Mar 24, 2012I 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.
Forms :: Disable Menu - Code Not Working?
Nov 19, 2011i tried to disable menu but the code didnt work.My
Procedure Pu_Check_Open_Form_Prc(Pv_Menu_Code Varchar2) Is
vn_open_pvg Number(1) := 0;
vm_menu_id MenuItem;
Begin
Begin
[code]...
and my menu in the attached pic.
Forms :: Disabling Default Menu Items In Oracle 10g?
Aug 3, 2010How to disable the Default Menu Items like (Edit - copy,Paste) in oracle Forms 10g.
View 1 Replies View RelatedForms :: How To Use ALTER TABLE Command To Disable / Enable Constraints
Aug 11, 2010can you use alter table command to disable/enable constraints in a form if you can how, if you cant why
View 4 Replies View RelatedForms :: How To Enable / Disable Keyboard Shortcuts In Oracle Apps
May 12, 2010How do we need to enable or disable the keyboard shortcuts in Oracle Apps like Shift+F6 for duplicate record, also how do I change the functionality, I mean suppose I want Key-M to do the same function as shift+F6.
View 2 Replies View RelatedEnable / Disable Auditing From PHP
Dec 15, 2010In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
SQL> shutdown
SQL> startup
I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP?
I've found this code for connect to oracle as sysdba:
oci_connect("/", "", null, null, OCI_SYSDBA);
From the following link:
[URL]......
But, i still can't execute "shutdown", "startup";
SQL & PL/SQL :: How To Disable Or Enable All Constraints In A Table
Apr 8, 2010I knew, how to enable or disable a constraint on a table.
>alter table <table_name> disable constraint <constraint_name>;
But if we know all the data is correct, it's better to disable all constraints to improve the performance.
We are allowed to Disable or Enable only a single constraint.
Enable or Disable All Constraints.
Server Administration :: Enable / Disable Row Movement
Oct 20, 2011for defragment of a table,
after enable it:
alter table test enable row movement;
do i need to:
alter table test disable row movement; ??
Client Tools :: Disable And Enable Constraints?
Feb 7, 2011how to disable and enable all constraints pertaining to one table at once. I want to disable them at once and also enable them at once. I make use of TOAD.
View 14 Replies View RelatedProgram For Menu - Enter Value To Show Different Items
Jan 13, 2012I want plsql code for output as follows
menu
enter 1 for veg
enter 2 for non-veg
enter value:
after entering the number it have to show different items like
item1 cost $10
item2 cost $12
.
.
.
i tried this with case with substitution variables. it is asking variable first with out showing the menu. i want menu first then it should ask for entry. what can i do for this.
Enable / Disable Archive Mode From The Pfile In Oracle 10g?
Jul 12, 2012I am using oracle 10g. Is there any mechanism to / parameter to enable or disable archive log mode? can I enable arching directly from pfile without touching the startup process?
View 2 Replies View RelatedApplication Express :: Enable / Disable Of Button Based On LOV Not Working
Oct 10, 2012I have a Select list which when null should disable a button and when not null should enable it. For which I tried the Advanced DA. Strangely, in the final page where we select the item that is going to be controlled, the button is not listed! I can see other display items etc which I can select but not the button.
View 0 Replies View RelatedSecurity :: Enable Auditing For Users?
Oct 10, 2012i enable auditing on the database 10.2 for users,
once i query SQL> SELECT username,
extended_timestamp,
owner,
obj_name,
action_name
FROM dba_audit_trail
WHERE owner = <Username>
there are many many rows , my question is , are you enable to truncate it from time to time , if not ,is it effect on the performance of the database ?
Performance Tuning :: Disable Db_block_buffers Parameters In Order To Enable Sga_target?
Jun 15, 2012What value should i set for sga_target in my oracle 10g database?
Currently -
sga_max_size = 32GB
pga_aggregate_target = 6GB
RAM on server = 64 GB
I'll need to disable db_block_buffers parameters in order to enable sga_target. right?
How To Disable SYSTEM Access From Client Users
Oct 29, 2012My requirement is to disable access of sys user from all clients even they are providing correct password.
View 2 Replies View RelatedForms :: How To Bind Hierarchy Tree Items To Text And Other Items
Jan 31, 2012I have already done a hierarchy tree. Now I'd like to make it bind to text items. When i click a node, it should automatically be bound to text items.
My tree is about sections of students, now when i click a specific section to view its corresponding subjects it would be displayed on text items.
For example:
+Sections
+First Semester
+LM2
+LM3
+Second Semester
+LM4
+LM5
When i would click on LM2 node, its subjects should appear immediately.
How To Enable And Disable A Field Dependent On Another Field In Apex
May 9, 2013I am New to Apex. Im using Apex Version 4.2.
I have a tab named APPROPRIATIONS it has 10 fields. Among which is PROJECT NUMBER, AUTHORIZAION DATE (CALENDER TYPE POPUP), And FUNDS CHECK FLAG.
The Scenario is depending upon PROJECT NUMBER the Fields are Populated including FUNDS CHECK FLAG .
But the AUTHORIZAION DATE is a MANDATORY field has to be filled by User
The Requirement is to make AUTHORIZAION DATE as MANDATORY only when the FUNDS CHECK FLAG is *"BLANK "* or *“Y”*
If the FUNDS CHECK FLAG is *“N”* then the AUTHORIZAION DATE to be made OPTIONAL.
Forms :: How To Display Menu Instead Of Default Menu
Apr 19, 2013i have one form name is LOV.fmb and i have one menu name is summit_menu.mmb how to display menu instead of default menu.
View 2 Replies View RelatedForms :: How To Go Through All Items In The Form
Jul 6, 2010is there any way or loop to go through all items in a form and check them with a condition ???
View 5 Replies View RelatedForms :: How To Add Text Items At Runtime
Dec 24, 2012I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies View RelatedForms :: Items On Tab Page Getting Invisible?
Oct 12, 2010when i am selecting a record from a LOV which is associated with a button on a tab page of a tabbed canvas; all the items on the tab page getting invisible. But when i navigate to another tab page and then come back to the former tab page all items reappearing.
What could possibly be the reason for this and how to restrict items from disappearing?
Forms :: Populating List Items
Jun 7, 2010there are 3 radio buttons and 1 list item
i want different options to appear in the list item when choosing different radio buttons.
i've tried to compile the codes and there are no errors.
I dunno what went wrong.
B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME
the following is my
DECLARE
[Code]....
Forms :: 6i / Validating Text Items?
Nov 24, 2010I am working on form 6i.
i need to write validation on text fields like first name,last name,phone no,email id
i have to not allow special char.
Forms :: Dynamic List Items
Apr 21, 2011I want to create two list items. one is for deptno and another is for empno in a single form.
Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.
Code for Deptno List item
declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');
[Code]...
Code for Empno list item in when_list_changed trigger for deptno list item
declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;
Forms :: Numeric Listbox Items?
Apr 12, 2010I've got a colleague that is trying to populate a list box item with a group of numeric values that represent highway route numbers.
The database view defines the route as a "number".
How can we create a numeric list box? The built-in functions populate_group, and populate_list both expect to get varchar2 parameters.
Forms :: Queries On Long / Lob Items?
Feb 2, 2013how can I have queries on long/lob items in form.
View 1 Replies View RelatedForms :: Two Control Items With Dependent LOV?
Jun 28, 2011I have created two control items like organization and location and both items contains lovs.here i have to make location lov is dependent on organization.one org contains multiple locations. how to make this change?
View 1 Replies View RelatedForms :: Triggers In 6i / Which Is Applicable To All Items
Jan 24, 2012May i know the triggers in forms 6i, which is applicable to all items,blocks and form.
View 9 Replies View Related