SQL & PL/SQL :: Deleting Master / Detail Record?

Oct 13, 2011

I want to delete Master / Detail Data through cursor between date 01-02-2010 till 10-02-2010. Problem is in Detail I dont have date column in detail. But I have to delete Master and Detail record with desire date. I have made a cursor but it delete only detail record i want to delete master record too.

Master Table
M_NO CHAR (12) NOT NULL,
REMARKS VARCHAR2 (200),
CANCEL_YN CHAR (1) NOT NULL,
M_DATE DATE NOT NULL,
PRIMARY KEY ( M_NO ) ) ;

Detail Structure

M_SNO NUMBER NOT NULL,
ACCOUNT_CODE CHAR (19) NOT NULL,
CANCEL_YN CHAR (1) NOT NULL,
M_DESC VARCHAR2 (200),
DB_AMT NUMBER,
CR_AMT NUMBER,
M_NO CHAR (12) NOT NULL,
PRIMARY KEY ( M_SNO, M_NO ) ) ;

create or replace procedure test as
cursor md_cur is
select m_No from master where m_Date
between '01-02-2010' and '10-02-2010';

[code]./....

View 9 Replies


ADVERTISEMENT

Application Express :: 4.0 - How To Save Detail Along With Master Record

Apr 16, 2013

I am using APEX 4.0. I have created a master detail page , the business logic is “ We can save master record only if there is at least one detail record exist.”

But current wizard developed page has functionality that I have to save master first then only I can add detail record. I want to save them together.

View 0 Replies View Related

Reports & Discoverer :: Master Detail Record Show One Page

Jun 30, 2011

When i create report in master detail. When detail record end on the page, the second record show on same page. Problem is that detail show on other page. I want that if record is completed on that page then ok. Otherwise it show on next page.

View 3 Replies View Related

Forms :: Master Detail Form - No Changes Occurred To Changed Record

Mar 4, 2012

MASTER-DETAIL FORM HAVING AN LOV IN THE MASTER .LOV SELECTS THE PRIMARY KEY FIELD FROM THE MASTER TABLE AND IN LOV PUSHBUTTON HAVING A TRIGGER WHEN BUTTON PRESSED

Declare
bool boolean;
begin
bool := show_LOV('PURCHASELOV');

[code]...

WHEN SELECTING THE ITEM THROUGH LOV IT EXECUTES ALL VALUES BUT AFTER CHANGING ANY DATAS THEN NEW RECORD IS CREATED IN THE MASTER TABLE AND NO CHANGES OCCURED TO THE CHANGED RECORD.

View 4 Replies View Related

Reports & Discoverer :: Master-detail Report ( 3 / 4 Columns Detail To Be Printed)

Jul 19, 2013

my report is based on two tables.master and detail. i am using GROUP ABOVE style.displaying master tables columns up and detail table columns down.

my problem is ...i want 3 columns from master table (i.e)RECEIVER ID,RECEIVER NAME and RECEIVE DATE to be printed at the bottom of the page.

and also i want only 4 records from detail table to be printed on each page.

View 1 Replies View Related

Forms :: Oracle - Date Field In Detail Part Of Master Detail?

Jul 13, 2011

I have to date field in detail part of master detail Form. In detail part i have field of From_date and To_date. I want when i go to next record in detail part ,,,from date is initiaze by previous to date+1....eg.like

1.record: From date=01-jan-2011, To_date=10-jan-2011
2.Record: From_date = 11-jan-2011;

I have Attached calender to two feild...and calender is the different block... In Detail block when_record_instance i handled the;; From date=previous to-date +1;

but when i double click the feild calender is open and when_new_record trigger is fired agian. calender called ...the when_new_record is not callled .....

View 4 Replies View Related

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Forms :: Master Detail Block

Feb 20, 2012

I have face a problem with master detail block,

we have two tabular block first one is master and sencond one is detail when we insert detail item it proper work and when when move next record in master block then it ask for save, I want to user enter all record and when he save with button then it save other wise no. but when he move any record in master block all realted record show in detail block.

View 1 Replies View Related

Forms :: Master Detail From One Table

Jun 9, 2011

Is there any way to design a form to act like Master Detail from one table which is not normalized?

View 2 Replies View Related

Forms :: Master Detail Form

Jan 25, 2012

I have a master detail form. I have one column in master, which is a free text field and one in detail block which is a LOV. When I enter data in the master block and select say A,B,C records in LOV in detail block and saved it. These A,B,C records in LOV shouldn't appear in the detail block when a new record is entered in the master Block.

View 3 Replies View Related

Form Trigger - Master And Detail Block

Dec 9, 2008

I have a Oracle Form which has 2 blocks, master and Detail.I have a pre-Insert Trigger on master block which has a sequence that acts as the id of the primary key column. Now, when I populate the master block and dont save then go to detail block and save(after populating detail block's data) it gives me an error that can not insert null into detail block foreign key column.I understand that his is happening because in the above scenario pre-insert is not firing for the master block.Am I writing the the sequence generation code in a wrong trigger?

View 1 Replies View Related

Forms :: Tab Canvas - Master / Detail Relationship

Feb 21, 2012

I have a form that contains a tab canvas. On the second canvas page I have two data blocks with a master detail relationship.The first block (master) is driven by a table (table_one) with the following fields:

sf_id (PK)
sf_code - VARCHAR2(40)
sf_desc - VARCHAR2(250)

The second block (detail) is a repeating block driven by a table (table_two) with the following fields:

error_code - VARCHAR2(40
error_code_desc - VARCHAR2(250)
is_major_error - VARCHAR2(1)
error_type - VARCHAR2(1)
error_is_active - VARCHAR2(1)
update_date - DATE
sf_id (FK - table_one.sf_id)

The second block only shows error_code and error_code_desc. The point of this canvas page is to add/remove master records and associate detail records with a master. I never want to actually insert or remove records from table two; merely updating the sf_id column in table two.What I am trying to achieve is the following:

1. Create a master record with detail records at the same time.
2. Delete a master record
3. Add and remove detail records

An insert into the detail block is nothing more than associating a master record with a detail record by updating the sf_id column in table two. A delete from the detail block is nothing more than setting the sf_id column to null in table two. I am not actually adding or removing records in table_two.

I have tried overriding the commit on the second block to perform updates instead of Oracle actually trying to insert NEW records into table_two.

View 2 Replies View Related

Forms :: Master-Detail Relationship In Oracle

Mar 27, 2010

I'm designing a canvas which will open up on the click of a push-button from a form A. Now this form A has a data block(ie. single underlying table A).

I want to display data from two tables - Table B and Table C in this canvas in the form of a multi-record grid structure - one below the other i.e. table B data above and table C data below.

Now table B and table C share a PK-FK relnship between them. What I want is when a user clicks on a record in the table B above then the corresponding records in the table C should get displayed below(now there can be multiple detail records in table C for a single record in table B - PK-FK reln)

i'd written code something like this in the When-button-pressed trigger:-

c_where_clause := ....(query from Form A)
set_block_property('block B',default,c_where_clause);
go_block('block B');
go_block('block C');
execute_query;
first_record;

(in addition to the above trigger, I have also included queries in the post-query trigger of the two tables B and C to get some data populated in the non-database fields in this canvas)

do i have to do add a piece of code to loop thru the records...like checking for last record,if not going to the next_record and so on for both the blocks?

View 1 Replies View Related

Forms :: Master Detail Form - Navigate From One Item To Another

Jan 20, 2013

I have a master-detail form, before filling up all the item in master cursor should not go to details, if user clicks in detail he should get a message.

When I am pressing ENTER to navigate from one item to another is asking'do u want to save the changes'.how to control this message and when pressedenter cursor should go to next item.

View 15 Replies View Related

SQL & PL/SQL :: How To Update Master And Detail Table In Single Query

Jan 18, 2012

I have two table master and detail i want to update both tables with update command in master i want to update voc_date and in detail i want to update item_code in one command but i am not understand how to control this query for example when i use this command

1). update master set voc_date=sysdate it works very well
2). update detail set item_code='12345' it also work very well but i want to update master,detail table in one query
pls guide me with some query example

View 2 Replies View Related

Application Express :: Master-Detail Primary Key Usage

Jan 19, 2013

I am using the Master-Detail wizard in APEX, but am not able to pass the existing Master KEY to be used in my Detail part. and I receive error:

Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process.

View 1 Replies View Related

PL/SQL :: Master Detail Form And Required Table Design

Feb 28, 2013

I have a contact table that will be used for more than one entity (Customers, Sites, Suppliers, etc.) Using APEX, when we define the master-detail, we need to add a FK to the Detail table -- otherwise the Master-Detail Forms can not be implemented.

I am looking for a way to defined/implemented tables so that I can utilize the same table (Contacts) for more than one Master-details relationship.

View 3 Replies View Related

Forms :: How To Programmatically Change Relationship In Master-detail Block

Dec 20, 2012

can we use set_block_property to program to switch multiple relationships. for example

if true then use relationshipA
else relationshipB
end if;

View 9 Replies View Related

Forms :: Master Detail Form Storing Multiple Records

Aug 13, 2013

I am new to the Oracle Forms.

I need a Master Detail oracle form for Oracle EBS.

The form should use only one table.

I need the form should look like User Form in EBS.

I created 2 data blocks and designed. When I run the form and key in some data, I notice multiple records stored.

like

Empno Ename Sal Comm
101 null null null
null John 2300 500

Empno is in Master Block.

And remaining are in Detail block. How to remove the duplicate records so that my required output should be like

Empno Ename Sal Comm
101 John 2300 500

View 5 Replies View Related

Forms :: Stop Responding When Pass From Master To Detail Block?

Jul 29, 2010

I have problem with the form when i pass from the master to detail block the form stop working and it stops responding even if i am in the next detail block and i press tab to change from one record to another the form will say working and it stops responding.

View 2 Replies View Related

Forms :: Display Data In Master-Detail Block Structure

May 11, 2010

I have a master - details block relation where I have to display all the records in the details block based on the selection criteria made in the master block. Earlier we didn't have any selection criteria and hence used to do a execute_query behind the detail block to just retrieve all the records.

But now the master block contains fields where I can input the selection criteria and once I hit the find button it will retrieve the records based on those criteria and display in the detail block.

View 8 Replies View Related

Application Express :: Master / Detail Form With Two Or More Detailregions On One Page?

Jul 18, 2012

I'd like to know, if there is a capability to create a Master/Detail Form with two ore more Detailregions on one page. I use APEX 4.1.

View 1 Replies View Related

Application Express :: Master-Detail Manual Tabular Updatable

Jan 8, 2013

I have master and detail table , in detail table i want to build tabular form manual , i want to insert , delete and update in detail manual tabular.

tables i use :
CREATE TABLE  "DISTRB_PLAN"
   (     "PLAN_ID" NUMBER NOT NULL ENABLE,
     "PLAN_NAME" VARCHAR2(200),
     "PLAN_DESC" VARCHAR2(2000),
     "PLAN_NOTES" VARCHAR2(2000), 
      CONSTRAINT "DISTRB_PLAN_PK" PRIMARY KEY ("PLAN_ID") ENABLE
[code]....

View 6 Replies View Related

Server Utilities :: How To Associate Header Record To Its Corresponding Detail Record

May 16, 2012

I am loading data file using SQL Loader in TOAD 10.5.1.3 in Oracle 10g using the control file below and loading data into 2 tables post1.thead and post1.tdetl. THEAD contains item level transaction and TDETL is detail level when a transaction has a discount or promo attached to for that item. When the

LOAD DATA
APPEND
INTO TABLE post1.thead
WHEN (1:5) = 'THEAD'
TRAILING NULLCOLS
(file_type POSITION(1:5)CHAR,

[code]....

A particular THEAD value may have 0, 1 or many TDETL corresponding values.below is a sample data file. When the position 21 in the TTAIL has a value of 1 or 2, then we know that there is a promo or discount applicable to the ITEM (THEAD).

THEAD0000000002201109142011091400000000000002091 1 0 -1
TTAIL0000000003000000
THEAD0000000012201109142011091400000000000002091 1 0 -1 20110914-1
TDETL0000000013CMPSPL1004 0 000000010000P0000000000000019990000000000000000200000
TTAIL0000000014000001
THEAD0000000021201109142011091400000000000002091 1 0 -1
TDETL0000000022EMPDSC1005 0 000
TDETL0000000023SCOUP 1006 0 973452 000
TTAIL0000000024000002

What I want to acheive is to accurately reflect a TDETL to its corresponding THEAD, as both THEAD and TDETL are loaded into separate tables. How can we have the 2 records correlated?

View 11 Replies View Related

Forms :: Calling From Other Data Block Into Current Master / Detail Form

Jun 10, 2013

I got the following scenario.

- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-

Begin

go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......

When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.

View 1 Replies View Related

Forms :: Master / Detail Relation / Why Populate-details Trigger Not Being Fired

Mar 14, 2013

On a form I have 2 blocks, shown on different tabs. Relation created by forms wizard. The relation works great when navigating through the blocks, the details for the master are shown fine.

Example for this form is master block is a type of food. Detail block is list of ingredients.When creating a new type of food, if it's = CAKE we insert records based on a select on another table into the ingredients table.Else, the user has to manually create the ingredients.

Upon commit of the form on master block (must be saved to enable detail block tab), the ingredients are not displayed but are there. If I execute query by hitting F8, the records are present.

Why is the populate-details trigger not being fired or what am I missing?

View 4 Replies View Related

Application Express :: How To Make Report Column Non-editable In Master-detail Form

Jun 20, 2013

I have created a master-detail form. The detail columns are created as report columns instead of getting created as Items. I need to make a column non-editable.

View 1 Replies View Related

Application Express :: Dynamic Action In Report Region In Master Detail Form

Nov 7, 2013

I have created a master detail form , in which many validation etc is done ,the MASTER is a FORM  and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:

,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where

Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---

i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed  ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ). 

In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items (  here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..

View 1 Replies View Related

Forms :: ORA-00000 Normal Successful Completion Error While Populating Data From Master Block To Detail

May 21, 2012

ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.

View 6 Replies View Related

Forms :: Alert While Deleting The Record

Mar 20, 2013

I want to create one alert while deleting the record from the custom form. So i have written the below code in the when-remove-record trigger.

DECLARE
alert_button NUMBER;
BEGIN
IF :XXWIPRELFRM.PRINTED = 'Yes' THEN
alert_button := SHOW_ALERT ('DELETE_ALERT');

[Code]..

When i click on the delete(X) symbol in the form, it is showing alert but when i click on "No" also its removing the record..what i need to write.

View 7 Replies View Related







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