DBA Data[Home] [Help]

APPS.FLM_SEQ_READER_WRITER dependencies on WIP_FLOW_SCHEDULES

Line 132: WIP_FLOW_SCHEDULES

128: CURSOR max_seq_cursor IS
129: SELECT
130: max(BUILD_SEQUENCE)
131: FROM
132: WIP_FLOW_SCHEDULES
133: WHERE
134: ORGANIZATION_ID = p_organization_id AND
135: LINE_ID = p_line_id AND
136: SCHEDULED_COMPLETION_DATE <= l_date1;

Line 142: WIP_FLOW_SCHEDULES

138: CURSOR min_seq_cursor IS
139: SELECT
140: min(BUILD_SEQUENCE)
141: FROM
142: WIP_FLOW_SCHEDULES
143: WHERE
144: ORGANIZATION_ID = p_organization_id AND
145: LINE_ID = p_line_id AND
146: SCHEDULED_COMPLETION_DATE > l_date2;

Line 1131: insert into wip_flow_schedules

1127:
1128: if(i_schedules_tbl.COUNT > 0) then
1129: l_index := i_schedules_tbl.FIRST;
1130: LOOP
1131: insert into wip_flow_schedules
1132: (
1133: scheduled_flag,
1134: wip_entity_id,
1135: organization_id,