DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_CONTROLS

Line 978: update fun_interface_controls

974: );
975:
976: /*update control table with the request id */
977:
978: update fun_interface_controls
979: set request_id = v_request_id,
980: date_processed = sysdate
981: where source = p_source
982: and group_id = p_group_id;

Line 1081: Delete from fun_interface_controls where source = p_source

1077: where ftb.source = p_source
1078: and ftb.group_id = p_group_id);
1079:
1080: if l_count = 0 then
1081: Delete from fun_interface_controls where source = p_source
1082: and group_id = p_group_id;
1083: end if;
1084:
1085: EXCEPTION

Line 1433: DELETE FROM fun_interface_controls

1429: l_total_batch_count := l_total_batch_count + l_batch_count;
1430:
1431: IF (l_batch_count > 0) and(p_review_required='N') THEN
1432:
1433: DELETE FROM fun_interface_controls
1434: WHERE source = p_source
1435: AND group_id = rec.group_id;
1436: END IF;
1437: