DBA Data[Home] [Help]

APPS.XDPCORE_FA dependencies on XDP_FULFILL_WORKLIST

Line 4465: from XDP_WORKITEMS XDW, XDP_FULFILL_WORKLIST XFW

4461: MappingProcFound := 'N';
4462: begin
4463: select XDW.FA_EXEC_MAP_PROC
4464: into MappingProc
4465: from XDP_WORKITEMS XDW, XDP_FULFILL_WORKLIST XFW
4466: where XFW.WORKITEM_INSTANCE_ID = WIInstanceID
4467: and XDW.FA_EXEC_MAP_PROC is not null
4468: and XFW.WORKITEM_ID = XDW.WORKITEM_ID;
4469:

Line 4488: from XDP_WI_FA_MAPPING XWF, XDP_FULFILL_WORKLIST XFW

4484: Procedure PopulateFAs (WIInstanceID in number)
4485: is
4486: cursor c_GetFaList (wi_id number) is
4487: select XWF.FULFILLMENT_ACTION_ID, XWF.PROVISIONING_SEQ
4488: from XDP_WI_FA_MAPPING XWF, XDP_FULFILL_WORKLIST XFW
4489: where XFW.WORKITEM_INSTANCE_ID = wi_id
4490: and XFW.WORKITEM_ID = XWF.WORKITEM_ID;
4491:
4492: l_FAInstanceID number;

Line 4797: XDP_FULFILL_WORKLIST

4793: for update;
4794:
4795: cursor c_GetWIState(p_WIInstanceID number) is
4796: select status_code from
4797: XDP_FULFILL_WORKLIST
4798: where workitem_instance_id = p_WIInstanceID
4799: for update;
4800:
4801: e_NoFAFoundException exception;