Forms :: Populate Default Values In Line Level Based On Header
May 29, 2011I have two blocks.In header 2 columns are there same columns in line how to populate default values in line level based on header?
View 1 Replies
ADVERTISEMENT
Forms :: Design A Form With Header And Line Level?
May 23, 2011How can we design a form with header level and line level. here i need to place a button in header section.when we press that button, line level values should be populate.
View 1 Replies View RelatedForms :: How To Clear Line Records When F11 Is Pressed In Header Block
Sep 4, 2011I am working in form 6i, EBS 11i. I have below requirement to achieve.
I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.
Forms :: Oracle Report Excel Output Repeated Header In Each Line?
Nov 24, 2011After running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!
View 4 Replies View RelatedForms :: How To Display Tab Pages In Line Level
May 25, 2011how to display tab pages in line level?
View 1 Replies View RelatedForms :: How To Populate City Based On Selected State
May 14, 2010I'am having a query regarding population of a list item based on another selected list item that is whenever i select the state from the combo box all the city's under that state should be automatically populated.
View 4 Replies View RelatedPL/SQL :: How To Reset Line Number Value For Each Header
Jul 1, 2013I need to reset the line number for each header values.
create table header_table(header_value varchar2(100));
create table line_table(header_value varchar2(100), line_number number);
insert into header_table values('ALAOF');
[Code]....
But My line table output looks like below
LINE TABLE:
header value line_number
ALAOF 1
ALAOF 2
ALAOF 3
[Code].....
Application Express :: Default Value For Hidden Item And Populate Query?
May 8, 20131.-) i got a page that contains 2 regions, lets say :master (HTML text) and a detail (tabular form updateable report) in my tabular form i got a hidden item that should take the value from the master form. how do i do this ?
2.-) i am calling a form from another form, sending a couple of fields as a link parameters. the second form is called as expected, but i need that records on the second form that match the parameters get displayed. how do i achieve that ?
SQL & PL/SQL :: Default Values / Distinguishing Between Passed And Default Nulls
Nov 16, 2010I was looking for a way to see if a default value for a procedure was passed NULL or it got NULL by default. [URL]
View 11 Replies View RelatedForms :: How To Populate Combo Box Dynamically Based On Another Combo Box
Aug 25, 2006I have a combo box,If I select a value from this combo box it should populate another Combo box automatically.
Example:-
state
sno cno statename
1 1 newyork
2 1 boston
3 1 florida
1 2 brisbane
2 2 sydney
country
cno country name
1 usa
2 Aus
if i select usa in first combo box in next combo box i have to populate only states that belong to that country.
BY example above:
If in first combo box i select AUS
then in next combo box i.e., in
second combo== brisbane
sydney only must be there .
i need the exact code with trigger.
Workflow :: Custom AWE Line Level Approval?
Jul 25, 2013creating custom AWE Line Level Approval? I’m having trouble trying to get the method for line approval to fire. I have header level working so I decided to dig deeper. I added the line keys to the Xref table, Updated the Registry, Configured the Events, and created a new Process Definition using line level (very simple “Always True”). I have seen OnProcessLaunch fire so my routing has begun.
The graphics look good. But when my approver goes in and hits the Approve button, it saves and nothing happens to the approval. Tracing it shows that no methods are firing. How does the system know to fire the line level method vs the header level method?
Forms :: Create View Based On Values Selected In Forms
Jun 7, 2013I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.
Application Express :: Populate Text Field Based On LOV Selection With AJAX
Apr 24, 2013I would like to populate a text box based on selection from a LOV. If someone selects a LOV value and then tabs off off of that element, I would like the text box populated from a sql statement based on the LOV value in the predicate.Application Express 4.1.1.00.23
View 1 Replies View RelatedForms :: Performing Validation Based On Unique Values In A Form
Mar 10, 2013In my form i have a multi record block which is based on a table in which i am performing insertion, deletion, updation.
My requirement is as below,
While saving a records i want to check distinct value of specific item can not be greater than some value say 2. Then only my records should be saved. I am planning to populate those values in a collection table type and take the distinct values from it. How to populate record values in a collection table type.
Application Express :: Auto Populate Phone Number Based On Select List In Tabular Form
Dec 27, 2012Ive a requirement which ive overlooked for a while now as below,
On my tabular form i have fields: Empid as Select List and when the value is picked from this Select List EmpID i want the associated/corresponding phone# displayed in its TEXT FIELD in that same row,
apex 4.1.1/Oracle 11gR2,
also i tried the below as a workaround but it doesnt fulfill my requirement, [URL]....
Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)
Jul 24, 2010I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.
I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".
SQL & PL/SQL :: Perform SUM On Two Columns Based On Level?
Oct 21, 2011Below is the code that i tried to perform the sum operation.
CREATE TABLE TEST11
(
FISCAL_TIME_ID NUMBER,
data_id number,
M_VALUE NUMBER,
Y_VALUE NUMBER
);
[code].....
The result I got is
SQL> SELECT FISCAL_TIME_ID, DATA_ID, M_VALUE,
2 SUM(m_value) OVER (PARTITION BY fiscal_time_id, data_id
3 ORDER BY FISCAL_TIME_ID) AS YTD_VALUE
4 from test11;
[code].....
But what I am actually want to get is.
FISCAL_TIME_ID DATA_ID M_VALUE YTD_VALUE
-------------- ---------- ---------- ----------
20110500 3 2 2
20110700 3 50 52
20110800 3 52
20111000 3 250 352
20111100 3 300 652
That is, the YTD_Value column is nothing but sum of M_VALUE column + previous fiscal_month_id's ytd_value column.
Test case:
The YTD_VALUE for fiscal_time_id 20110700 is obtained as current M_VALUE + previous fiscal_time_id's ytd_value => 50 + 2
I tried with the SQL but i could not get the result.
Application Express :: Assign Values In Many Rows Based On Search Values?
Jul 25, 2013I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by.
View 4 Replies View RelatedApplication Express :: Default Value Of Radio Button Based On A Condition?
Oct 1, 2013i have used radio button under dynamic conditions for an interactive report.eg: radio button values are like a) front end b)middlware c)back end.so based on the selected value of the radio button, interactive report appears. and each fields in radio button have separate set of users. now my issue is,based on the user logging in, the default value should set up while the page is loaded...[i.e... if a front end user logs in, the default value of tat radio button shd be front end...]
View 5 Replies View RelatedSQL & PL/SQL :: Search New Line Values In Column?
Jun 11, 2012I have a column in a table say ename in emp table, which allows values with newlines and carriage return.
I need to find all the values (i.e ename's) which are having newline chars or carriage return.
Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item
May 22, 2010I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
Client Tools :: How To Have Optional Parameters And Default Values In SQL*Plus Script
Jun 16, 2012Just to let you know this new section in SQL*Plus FAQ wiki page: How to have optional parameters and default values in SQL*Plus_script.
View 1 Replies View RelatedApplication Express :: Update Default Column Values In Database From Form
Sep 14, 2012Application Express ver. 4.1
I have created a form. Some of the elements are hidden such as updated_by and update_date. I have provided the default values for these attributes as pl/sql expression in the "default section" (Application->page->edit page item). I am using the Process Row process that is automatically created when a form is created.
The problem is when I click the update button, the updated_by and update_date is passed as null values which throws an error from the database.
JDeveloper, Java & XML :: Document Encoding UTF-8-based But Default Input Encoding Is Not
Mar 19, 2012 Oracle procedure was working fine with other XML files. Today I got new XML file and when I try to load the XML,I am getting below error.
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00283: document encoding is UTF-8-based but default input encoding is not
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 295
ORA-06512: at line 1
XML header is same as previous ones. <?xml version="1.0" encoding="utf-8" ?>
Forms :: How To Set MS Word Document Header And Footer Using Forms 6i
Dec 10, 2010Now I want to use an existing MS Word file from file system (e.g d: est est1.doc) and add header & footer (e.g docname Page x of x) using Forms 6i.
View 3 Replies View RelatedForms :: Populate Record Using LOV Value?
Mar 2, 2011Create a form based on the following output use EMP Table
Create a non Database Block i.e Control Block----> Dept No
Create a Database Block -EMP
Create an LOV for the Dept no from dept table.
For the Current Dept No . Populate the Employee Records
Forms :: Populate POPLIST?
Apr 4, 2011-- Solution populate poplist
----------------------------
-- Name of block: block01
-- Name of poplist item: year
-- Name table: tb_years
-- Create on trigger when-new-form-instance
[code]...
Forms :: FMB - Populate Lov Is Not Working?
Oct 14, 2010.fmb file why this populate lov is not working
View 9 Replies View RelatedForms :: Populate Only Particular Employee LOV
Apr 1, 2013I want to populate only particular employee LOV ,when i am press "Populate LOV"..Button and i attached Form for testing and It is a 10g version..
View 5 Replies View RelatedForms :: Populate List Dynamically?
Mar 15, 2013i want to create the list item dynamically on the when new form instance this is the code....
group_id := create_group_from_query('lst','select (imt.item_id), to_char(imt.item_code, from items_mt imt');
v_num := Populate_group(group_id);
populate_list(v_num,group_id);
but the list is not the populate.