DBA Data[Home] [Help]

APPS.FLM_SEQ_UI dependencies on WIP_FLOW_SCHEDULES

Line 834: * To get min wip_entity_id from WIP_FLOW_SCHEDULES PL/SQL table. *

830:
831: END delete_line_constraints;
832:
833: /******************************************************************
834: * To get min wip_entity_id from WIP_FLOW_SCHEDULES PL/SQL table. *
835: ******************************************************************/
836: PROCEDURE get_min_wip_entity_id(p_start_date IN DATE,
837: p_org_id IN NUMBER,
838: p_init_msg_list IN VARCHAR2,

Line 857: FROM WIP_FLOW_SCHEDULES

853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854:
855: SELECT min(wip_entity_id)
856: INTO x_wip_entity_id
857: FROM WIP_FLOW_SCHEDULES
858: WHERE scheduled_completion_date >= flm_timezone.client00_in_server(p_start_date) --fix bug#3170105
859: AND organization_id = p_org_id;
860:
861: l_debug_line := 20;