DBA Data[Home] [Help]

APPS.MSC_RP_RELEASE_PUB dependencies on MSC_DEMANDS

Line 99: -- FROM msc_demands md

95: and ms.applied =2;
96:
97: CURSOR cur_demand_order IS
98: -- SELECT 1
99: -- FROM msc_demands md
100: -- where md.plan_id = p_plan_id
101: -- and md.release_errors is null
102: -- and md.load_type =30
103: -- and MD.ORIGINATION_TYPE = 30

Line 111: FROM msc_demands md

107: -- and md.applied =2;
108:
109: select 1 from dual
110: where exists ( SELECT /*+ first_rows */ 1
111: FROM msc_demands md
112: where md.plan_id = p_plan_id
113: and md.release_errors is null
114: and md.load_type =30
115: and MD.ORIGINATION_TYPE = 30

Line 874: if (p_source_table ='MSC_DEMANDS' and p_order_type=30) then

870:
871:
872:
873: /* not able to release sales order */
874: if (p_source_table ='MSC_DEMANDS' and p_order_type=30) then
875: p_rel_error := msc_rel_wf.verify_so_release(p_plan_id,p_transaction_id,p_inst_id);
876: if (p_rel_error is not null) then
877: return p_rel_error;
878: end if;