DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on QA_WEB_TXN_API

Line 483: and decode(qpt.transaction_number,31,qa_web_txn_api.plan_applies(qpv.plan_id,qpt.transaction_number,to_char(p_organization_id),

479: Where qpt.plan_id=qpv.plan_id
480: and ml.lookup_code=qpt.mandatory_collection_flag
481: and ml.lookup_type='SYS_YES_NO'
482: and nvl(p_quality_flag,2)=decode(p_quality_flag,1,qpt.mandatory_collection_flag,2,p_quality_flag,2)
483: and decode(qpt.transaction_number,31,qa_web_txn_api.plan_applies(qpv.plan_id,qpt.transaction_number,to_char(p_organization_id),
484: p_asset_group,p_serial_number,p_asset_activity,p_wip_entity_name,'',p_instance_number,'','','','','EAM'),'N')='Y';
485:
486: --Cursor for Quality Plan Elements
487: cursor qplanelement_cursor(p_plan_id number) is