APPS.MSC_UNDO dependencies on MSC_DEMANDS

Line 471: from msc_demands

467:
468: /*
469: cursor c_demand_mds (l_plan number, l_instance number, l_trx number) is
470: select origination_type
471: from msc_demands
472: where plan_id = l_plan
473: and sr_instance_id = l_instance
474: and demand_id = l_trx;
475: */

Line 509: --Msc_demands

505: where transaction_id = p_transaction_id
506: and plan_id = p_plan_id
507: and sr_instance_id = p_sr_instance_id ;
508: elsif ( p_table_changed = 2 ) then
509: --Msc_demands
510: /*
511: open c_demand_mds(p_plan_id,p_sr_instance_id, p_transaction_id);
512: fetch c_demand_mds into l_order_type;
513: close c_demand_mds;

Line 516: update msc_demands

512: fetch c_demand_mds into l_order_type;
513: close c_demand_mds;
514: if (l_order_type = 8 ) then
515: */
516: update msc_demands
517: set firm_quantity = 0,
518: status = 0,
519: applied = 2
520: where plan_id = p_plan_id

Line 525: Delete from msc_demands

521: and demand_id = p_transaction_id
522: and sr_instance_id = p_sr_instance_id;
523: /*
524: else
525: Delete from msc_demands
526: where demand_id = p_transaction_id
527: and plan_id = p_plan_id
528: and sr_instance_id = p_sr_instance_id ;
529: end if;

Line 715: update_str := 'UPDATE MSC_DEMANDS SET STATUS=0, APPLIED=2, ';

711: Execute immediate sql_string
712: using p_old_value, p_plan_id,
713: p_transaction_id, p_sr_instance_id ;
714: elsif (p_table_changed = 2) then
715: update_str := 'UPDATE MSC_DEMANDS SET STATUS=0, APPLIED=2, ';
716: if (p_column_type = 'DATE') then
717: set_str := p_column_changed
718: ||' = fnd_date.canonical_to_date(:p_old_value) ';
719: else