DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on QA_WEB_TXN_API

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

497: Where qpt.plan_id=qpv.plan_id
498: and ml.lookup_code=qpt.mandatory_collection_flag
499: and ml.lookup_type='SYS_YES_NO'
500: and nvl(p_quality_flag,2)=decode(p_quality_flag,1,qpt.mandatory_collection_flag,2,p_quality_flag,2)
501: and decode(qpt.transaction_number,31,qa_web_txn_api.plan_applies(qpv.plan_id,qpt.transaction_number,to_char(p_organization_id),
502: p_asset_group,p_serial_number,p_asset_activity,p_wip_entity_name,'',p_instance_number,'','','','','EAM'),'N')='Y';
503:
504: --Cursor for Quality Plan Elements
505: cursor qplanelement_cursor(p_plan_id number) is